Business Intelligence Architect/Developer
Apply on
BI Architect/Developer Golden, Colorado 80401 (Hybrid 2/3 days per week) 3 Months 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, Google Cloud Platform)
- 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.
About Us: Established in 2004, SPECTRAFORCE is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of human connection, defined by our branding attitude of NEWJOBPHORIA , which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at:
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act ( CPRA ) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting .
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position s starting pay is: $60.00/hr.
