Job description

Extraordinary commitment runs deep at Zachry. Here, dedicated men and women have the opportunity to work on challenging projects alongside those who value innovation and support team efforts in all our endeavors. We take care of our team members as family, within a culture of service where we do the right thing because it is the right thing to do. Our core values are at the center of every decision we make: Every Person Matters® Together We Can Do Great Things® This Is More Than a Job® Job Summary We are seeking a highly skilled and motivated Analytics Engineer to join our growing data team. As part of a team still in its early stages, you will play a critical role in shaping the foundation, strategy, and future direction of our enterprise data and analytics capabilities. This is a high-impact position with the opportunity to help build a modern, scalable foundation for future analytics and business insights across all of our core business units. In this hybrid role, you will work across the full data lifecycle - ingesting complex data from a variety of cloud and on-premises sources, transforming it into clean and trusted datasets, and diving deep into analysis to uncover insights that drive better decisions across the business. Essential Functions • Design, build, and optimize scalable ETL/ELT pipelines and curated datasets in cloud environments, leveraging T-SQL, PySpark, and SparkSQL for data transformations, with an eye toward incorporating Change Data Capture (CDC) techniques where appropriate for incremental data processing. • Contribute to the integration of data from diverse sources into a scalable and governed lakehouse architecture built on Databricks Unity Catalog, following best practices for storage, transformation, and orchestration. • Work with SAP systems to integrate business-critical data into Azure-based analytics and reporting workflows. • Support the modernization of legacy SSIS ETL processes, including evaluating and implementing more scalable, maintainable alternatives. • Contribute to the design and implementation of pipelines to capture and integrate IoT data streams into the enterprise data ecosystem. • Design, refactor, and optimize data models and curated datasets to improve performance, scalability, and maintainability across analytics and reporting use cases. • Perform exploratory analysis to uncover trends, patterns, and key insights that drive better business decisions across departments. • Assist team in deploying machine learning models into production data pipelines (Databricks MLflow, Azure ML). • Use GitHub for source control, versioning, and collaborative code review across data workflows. • Understand and apply Azure and Databricks security best practices, with familiarity in configuring access controls, permissions models (RBAC, ACLs), and governance tools like Unity Catalog. • Collaborate with cloud infrastructure and security teams to ensure data assets are protected in line with organizational standards. This job summary is intended to describe the general nature and level of work performed by individuals assigned to this position. The job summary is not intended to be an exhaustive list of responsibilities, duties, and skills required. Required Skills & Experience • 5+ years of experience in the data space as an analyst, engineer or equivalent technical role. • Proven experience with Azure Data Lake Gen2, Azure Data Factory, and Databricks, including migrating data into modern cloud lakehouse architectures. • Expertise in T-SQL for SQL Server-based transformations, and PySpark/SparkSQL for building distributed data pipelines in Databricks. • Proficiency in Python for data processing and transformation tasks. • Familiarity with SAP data and its integration into analytics and reporting workflows is strongly preferred. • Experience ingesting, storing, and managing IoT/streaming data into a cloud-based architecture. • Highly skilled in designing and developing Power BI semantic models and dashboards. • Strong understanding of data modeling (dimensional models, star schema, SCDs). • Exposure to building and deploying predictive models integrated into production pipelines. • Familiarity with Azure and Databricks security models, including RBAC, access controls, and Unity Catalog governance frameworks. • Hands-on experience using GitHub for version control and team collaboration. Benefits and EOE Zachry offers an industry-leading benefits package for our employees and their families. • Medical, Dental, Vision, and Life insurance • 401k, Paid leave, and Bonus Program • Company-paid short-term and long-term disability insurance • Employee assistance program • For additional company information, please visit www.zachrycorp.com Zachry Construction Corporation performs heavy civil work throughout the United States, and relocation is sometimes required for continuous employment opportunities. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status. Applicants must be immediately authorized to work for any employer in the U.S. We do not sponsor or transfer sponsorship of an employment visa at this time. We do not interview or hire students in F-1 or J-1 status and will not sponsor them for work visas. Notice to Staffing Agencies Zachry Federal Construction Corporation and its subsidiaries (Zachry) will not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to Zachry Federal, including unsolicited resumes sent to a Zachry Federal mailing address or email address, directly to Zachry Federal employees, or to Zachry Federal's resume database will be considered Zachry Federal property. Zachry Federal will not pay a fee for any placement resulting from the receipt of an unsolicited resume. Zachry Federal will consider any candidate for whom an Agency has submitted an unsolicited resume to have been referred by the Agency free of any charges or fees. Agencies must obtain advance written approval from Zachry's recruiting function to submit resumes, and then only in conjunction with a valid, fully executed contract for service and in response to a specific job opening. Zachry will not pay a fee to any Agency that does not have such agreement in place. Agency agreements will only be valid if in writing and signed by Zachry's Human Resources Representative or his/her designee. No other Zachry employee is authorized to bind Zachry to any agreement regarding placement of candidates by Agency. Accessibility: If you need an accommodation as part of the employment process please contact Human Resources at Phone: 877-884-9247 Equal Opportunity Employer, including disabled and veterans. If you want to view the Know Your Rights: Workplace Discrimination is Illegal poster, please choose your language: English - Spanish - Arabic - Chinese English - Spanish - Chinese If you want to view the Pay Transparency Policy Statement, please click the link: English

Requirements