Title : Business Intelligence Architect / Developer
Location : Golden Colorado 80401
Client : JeffersonCounty
Note : Position is open only to Colorado residents. Interviews will bedone virtually but work will be hybrid. We have a flexible workweek.
2 days onsite and 3 daysremote
JobDescription
Weare looking for an experienced Analytics Engineer to help designand implement effective data architecture to support businessintelligence and analytics reporting across Jefferson CountyColorado.
The ideal candidate will have experience working withdirectly with stakeholders to deliver advanced analytics andreportingsolutions.
Thisposition will work with the Business Intelligence team within theBusiness Innovation & Technology department at JeffersonCounty.
We are an awardwinning nationally recognized team thatbrings new and improved services to the community. The businessintelligence solutions we build allow county staff to makedatadriven decisions about their operations andservices.
EssentialDuties :
- Createchampion and implement data modeling and architecture standards tosupport advanced analytics andreporting
- Collaboratewith analysts and stakeholders to understand data requirements anddeliver robust datamodels
- Designdevelop and maintain scalable data pipelines and ETL / ELT processesusing Azure Data Factory Azure Synapse Analytics Fabric and otherAzureservices.
- Optimizeand manage data storage solutions including Azure SQL Database andAzure BlobStorage
- Developand maintain documentation for data processes architectures andworkflows.
- Monitorand troubleshoot data pipelines and workflows to ensure optimalperformance.
RequiredKnowledge andSkills :
- Provenexperience as an Analytics Engineer or similar role with a strongfocus on Azure and PowerBI
- Experiencedeveloping and implementing data architecture within a cloudbasedsolution (ex Azure Snowflake AWSGCP)
- Experiencewith Microsoft Azure including Azure SQL Database and Azure SynapseAnalytics
- Experiencewith SQL SQL Server andDAX
- Stronganalytical and problemsolving skills balanced with a creativemindset
PreferredKnowledge andSkills :
- Experiencein data lake or lake housedevelopment
- Experiencewith implementing solutions in MicrosoftFabric
- Experiencein Power BI or other BI tools (ex Tableau Lookeretc)
- Experienceusing Python in developing analyticssolutions
- MicrosoftAzure or Power BICertifications
Qualifications :
Bachelors degree and a minimum of five years experience in a fulltime dataanalytics role or equivalent using Microsoft technologies.
Prefer amajor in computer science informationsystems
Ifyou are : bright motivated skilled a differencemaker able to getthings done work with minimum direction enthusiastic a thinker ableto juggle and multitask communicate effectively and lead then wewould like to hear from you.
We need exceptionally capable peoplefor this role for our client so get back to us and tell us why youthink you are afit.
AboutUs :
Since2000 TriForce Consulting Services ( ) has been an MBE / SDBcertified IT Consulting firm in the Philadelphia region. TriForcespecializes in IT staffing software development (web and mobileapps) systems integration data analytics system automationcybersecurity and cloud technology solutions for government andcommercial clients.
TriForce works with clients to overcomeobstacles such as increasing productivity increasing efficienciesthrough automation and lowering costs.
Our clients benefit from ourthree distinguishing core values : integrity diligence andtechnological excellence. TriForce is a sixtime winner among thefastestgrowing companies in Philadelphia and a fourtime winner onthe Inc.
5000 list of the nations fastestgrowingcompanies.
Provenexperience as an Analytics Engineer or similar role, with a strongfocus on Azure and Power BI Experience developing and implementingdata architecture within a cloud-based solution (ex Azure,Snowflake, AWS, GCP) Experience with Microsoft Azure includingAzure SQL Database and Azure Synapse Analytics Experience with SQL,SQL Server, and DAX