Note: The job is a remote job and is open to candidates in USA. Primoris Services Corporation is a specialty contractor providing infrastructure services to the utility, energy, and renewables markets across the United States and Canada. The company is seeking a Data Engineer – Business Analytics to build and optimize Databricks-based data pipelines, curated datasets, and semantic structures that support enterprise reporting and self-service analytics. The role partners with business and technical stakeholders to ensure data quality, governance, performance, and alignment with business KPIs.
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
Skills
- 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
Benefits
- 401k w/employer match
- Health/Dental/Vision insurance plans
- Paid time off
- 10 paid holidays
- Stock purchase plan
- Fully remote and may be performed from anywhere within the United States.
Company Overview
Company H1B Sponsorship