Tri-Force Consulting Services, Inc.
Business Intelligence Architect/Developer
Tri-Force Consulting Services, Inc., Golden, Colorado, United States, 80401
Job DescriptionTitle : Business Intelligence Architect/Developer
Location : Golden, Colorado 80401
Client: Jefferson County
Note: Position is open only to Colorado residents. Interviews will be done virtually, but work will be hybrid. We have a flexible work week. 2 days onsite and 3 days remote
Job Description
We are looking for an experienced Analytics Engineer to help design and implement effective data architecture to support business intelligence and analytics reporting across Jefferson County, Colorado. The ideal candidate will have experience working with directly with stakeholders to deliver advanced analytics and reporting solutions.This position will work with the Business Intelligence team within the Business Innovation & Technology department at Jefferson County. We are an award-winning, nationally recognized team that brings new and improved services to the community. The business intelligence solutions we build allow county staff to make data-driven decisions about their operations and services.Essential Duties:
Create, champion and implement data modeling and architecture standards to support advanced analytics and reportingCollaborate with analysts and stakeholders to understand data requirements and deliver robust data modelsDesign, develop, and maintain scalable data pipelines and ETL/ELT processes using Azure Data Factory, Azure Synapse Analytics, Fabric and other Azure services.Optimize and manage data storage solutions including Azure SQL Database and Azure Blob StorageDevelop and maintain documentation for data processes, architectures, and workflows.Monitor and troubleshoot data pipelines and workflows to ensure optimal performance.Required Knowledge and Skills:
Proven experience as an Analytics Engineer or similar role, with a strong focus on Azure and Power BIExperience developing and implementing data architecture within a cloud-based solution (ex Azure, Snowflake, AWS, GCP)Experience with Microsoft Azure including Azure SQL Database and Azure Synapse AnalyticsExperience with SQL, SQL Server, and DAXStrong analytical and problem-solving skills balanced with a creative mindsetPreferred Knowledge and Skills:
Experience in data lake or lake house developmentExperience with implementing solutions in Microsoft FabricExperience in Power BI or other BI tools (ex Tableau, Looker, etc)Experience using Python in developing analytics solutionsMicrosoft Azure or Power BI CertificationsQualifications:
Bachelor's degree and a minimum of five years' experience in a full-time data analytics role or equivalent using Microsoft technologies. Prefer a major in computer science, information systems,
If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit.
About Us:
Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.
Location : Golden, Colorado 80401
Client: Jefferson County
Note: Position is open only to Colorado residents. Interviews will be done virtually, but work will be hybrid. We have a flexible work week. 2 days onsite and 3 days remote
Job Description
We are looking for an experienced Analytics Engineer to help design and implement effective data architecture to support business intelligence and analytics reporting across Jefferson County, Colorado. The ideal candidate will have experience working with directly with stakeholders to deliver advanced analytics and reporting solutions.This position will work with the Business Intelligence team within the Business Innovation & Technology department at Jefferson County. We are an award-winning, nationally recognized team that brings new and improved services to the community. The business intelligence solutions we build allow county staff to make data-driven decisions about their operations and services.Essential Duties:
Create, champion and implement data modeling and architecture standards to support advanced analytics and reportingCollaborate with analysts and stakeholders to understand data requirements and deliver robust data modelsDesign, develop, and maintain scalable data pipelines and ETL/ELT processes using Azure Data Factory, Azure Synapse Analytics, Fabric and other Azure services.Optimize and manage data storage solutions including Azure SQL Database and Azure Blob StorageDevelop and maintain documentation for data processes, architectures, and workflows.Monitor and troubleshoot data pipelines and workflows to ensure optimal performance.Required Knowledge and Skills:
Proven experience as an Analytics Engineer or similar role, with a strong focus on Azure and Power BIExperience developing and implementing data architecture within a cloud-based solution (ex Azure, Snowflake, AWS, GCP)Experience with Microsoft Azure including Azure SQL Database and Azure Synapse AnalyticsExperience with SQL, SQL Server, and DAXStrong analytical and problem-solving skills balanced with a creative mindsetPreferred Knowledge and Skills:
Experience in data lake or lake house developmentExperience with implementing solutions in Microsoft FabricExperience in Power BI or other BI tools (ex Tableau, Looker, etc)Experience using Python in developing analytics solutionsMicrosoft Azure or Power BI CertificationsQualifications:
Bachelor's degree and a minimum of five years' experience in a full-time data analytics role or equivalent using Microsoft technologies. Prefer a major in computer science, information systems,
If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit.
About Us:
Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.