Data Engineer - Business Analytics

Primoris Services Corporation is hiring a Data Engineer focused on Business Analytics, supporting an enterprise analytics platform built around Azure and Databricks. In this role, you will design and optimize analytics-ready datasets using a modern Lakehouse approach, delivering curated Silver and Gold assets with the semantic layer implemented in Databricks.

What you’ll do

• 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 based on enterprise reporting needs.
• Transform raw data into business-consumable datasets using standardized definitions, KPIs, and metrics.
• Apply dimensional modeling and other data modeling techniques within a distributed data environment.
• Own and deliver the semantic layer in Databricks to support consistent definitions across reporting and analytics use cases.
• Enable downstream consumption by visualization and analytics tools such as Power BI, without relying on embedded semantic modeling.
• Partner with business analysts and reporting teams to improve dataset usability, performance, and scalability.
• Optimize datasets and models for performance, including query efficiency and scalability for enterprise reporting workloads.
• Ensure data quality, integrity, and consistency across the data lifecycle.
• Implement and enforce data governance standards, including security, masking, access controls, and cost controls.
• Translate business requirements into scalable data solutions in collaboration with business leaders and stakeholders.
• Align data structures to enterprise data dictionary and KPI definitions.
• Communicate dataset and data model designs clearly to technical and non-technical stakeholders.
• Support platform evolution within Azure and Databricks.
• Contribute to best practices for CI/CD, deployment automation, and data engineering standards.
• Support the expansion of data capabilities, including assistance with AI/ML use cases where applicable.

What you bring

• 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 transformations and pipeline development.
• Proven experience designing and implementing data models within modern data platforms such as Lakehouse architecture.
• Experience with medallion architecture (Bronze/Silver/Gold layers).
• Knowledge of BI tools such as Power BI, with emphasis on dataset consumption rather than ownership of the semantic layer.
• Experience with CI/CD pipelines, version control, and deployment processes.
• Familiarity with Agile/Scrum delivery methodologies.

Tools and technologies

• Databricks, Databricks Lakehouse, Databricks Unity Catalog
• SQL, Python
• Azure
• Power BI
• CI/CD pipelines
• Agile/Scrum

Pay and benefits

• Salary: USD 135,000 - 155,000 per year
• Pay equity compensation range: $135,000 - $155,000
• 401k with employer match
• Health/Dental/Vision insurance plans
• Paid time off
• 10 paid holidays
• Stock purchase plan

Location and work conditions

• Location: Texas (remote)
• Occasional travel may be required
• Flexible work hours may be necessary to meet project deadlines

Salary note: Pay equity compensation range is USD $135,000 - $155,000.