Data Engineer - Business Analytics

Primoris Services Corporation is a premier specialty contractor providing critical infrastructure services to the utility, energy, and renewables markets throughout the United States and Canada. They are seeking a dynamic and detail-oriented Data Engineer – Business Analytics to design, build, and optimize analytics-ready datasets within a modern data platform leveraging Databricks. The role involves collaborating with business stakeholders and data architects to create trusted datasets that enable enterprise reporting and self-service analytics.

Responsibilities:

• Design, build, and maintain scalable data pipelines and curated datasets within the Databricks Lakehouse (Silver and Gold layers)
• Develop and manage analytics-ready data models and semantic structures in Databricks, aligned to enterprise reporting needs
• Transform raw data into business-consumable datasets that reflect standardized definitions, KPIs, and metrics
• Apply dimensional modeling and other data modeling techniques within a distributed data environment
• Own the semantic layer within Databricks, ensuring consistent definitions across reporting and analytics use cases
• Enable downstream consumption by visualization and analytics tools (e.g., Power BI) without reliance on embedded semantic modeling
• Partner with business analysts and reporting teams to optimize datasets for usability, performance, and scalability
• Optimize datasets and data models for performance, including query efficiency and scalability for enterprise reporting workloads
• Ensure data quality, integrity, and consistency across the full data lifecycle
• Implement and enforce data governance standards, including data security, masking, access controls and cost controls
• Work closely with business leaders and stakeholders to translate business requirements into scalable data solutions
• Align data structures to enterprise data dictionary and KPI definitions
• Communicate data model designs and dataset structures clearly to both technical and non-technical stakeholders
• Support the evolution of the enterprise analytics platform within Azure and Databricks
• Contribute to best practices for CI/CD, deployment automation, and data engineering standards
• Assist in advancing data capabilities, including support for AI/ML use cases where applicable

Requirements:

• Bachelor's degree in Information Technology, Computer Science, Business Analytics, or a related field
• 6+ years of experience in data engineering, data modeling, or analytics engineering roles
• Strong expertise in Databricks Unity Catalog, SQL, and Python for data transformation and pipeline development
• Proven experience designing and implementing data models within modern data platforms (e.g., Lakehouse architecture)
• Experience working with medallion architecture (Bronze/Silver/Gold layers)
• Understanding of BI tools (e.g., Power BI), with emphasis on dataset consumption rather than semantic layer ownership
• Experience with CI/CD pipelines, version control, and deployment processes
• Familiarity with Agile/Scrum delivery methodologies
• Strong data modeling and analytical thinking skills
• Ability to translate business requirements into scalable data solutions
• Deep understanding of data transformation, optimization, and performance tuning
• Excellent communication and stakeholder management skills
• High attention to detail with a focus on data accuracy and quality
• Ability to lead initiatives and influence cross-functional teams
• Adaptability in a fast-paced, evolving data environment