Company:
Ampcus Incorporated
Location: Golden
Closing Date: 28/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Business Intelligence Architect/Developer
Description:
Position is open only to Colorado residents. Interviews will be done virtually, but work will be hybrid. We have a flexible work week (ex. four 10s, five 8s).
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 reporting
Collaborate with analysts and stakeholders to understand data requirements and deliver robust data models
Design, 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 Storage
Develop 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 BI
Experience 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 Analytics
Experience with SQL, SQL Server, and DAX
Strong analytical and problem-solving skills balanced with a creative mindset
Preferred Knowledge and Skills:
Experience in data lake or lakehouse development
Experience with implementing solutions in Microsoft Fabric
Experience in Power BI or other BI tools (ex Tableau, Looker, etc)
Experience using Python in developing analytics solutions
Microsoft Azure or Power BI Certifications
Qualifications:
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, information technology, software engineering, or related field of study.
For more information please contact Priya Jagtap at (phone number removed) or (url removed)
Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.
Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.
Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.
iTech Solutions, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.
Description:
Position is open only to Colorado residents. Interviews will be done virtually, but work will be hybrid. We have a flexible work week (ex. four 10s, five 8s).
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 reporting
Collaborate with analysts and stakeholders to understand data requirements and deliver robust data models
Design, 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 Storage
Develop 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 BI
Experience 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 Analytics
Experience with SQL, SQL Server, and DAX
Strong analytical and problem-solving skills balanced with a creative mindset
Preferred Knowledge and Skills:
Experience in data lake or lakehouse development
Experience with implementing solutions in Microsoft Fabric
Experience in Power BI or other BI tools (ex Tableau, Looker, etc)
Experience using Python in developing analytics solutions
Microsoft Azure or Power BI Certifications
Qualifications:
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, information technology, software engineering, or related field of study.
For more information please contact Priya Jagtap at (phone number removed) or (url removed)
Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.
Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.
Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.
iTech Solutions, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.
Share this job