Data Analytics Engineer

Job Posting Title : Data Analytics Engineer

CDM Smith is seeking an Analytics Engineer to join our Business Technology team. This individual will be part of the Data & AI Technology group, helping to support Architecture, Engineering and Construction (AEC), and Digital Engineering Solutions initiatives using modern data technologies and analytics to deliver actionable business insights and robust solutions for AEC professionals and client outcomes.

The Data & AI Technology group helps lead the firm in AEC-focused Business Intelligence and data services by developing scalable analytics platforms, reliable data models, and intuitive analytics solutions that enable self-service BI and analytics across the organization. The Data & AI Technology group utilizes advanced analytics, data science, and AI/ML to give our business and our products a competitive advantage.

Key Responsibilities :

- Design and implement data models, transformation workflows, and analytics layers to support self-service AI/BI and analytics.

- Design, develop, test, and maintain analytics-ready datasets, semantic models, and reusable data products.

- Build and maintain scalable analytics solutions using Databricks, SQL, Python, notebooks, jobs, and governed enterprise data assets.

- Develop and maintain reusable semantic layers, business definitions, dimensions, KPIs, and metrics that ensure consistency across analytics platforms.

- Apply data quality, validation, governance, lineage, and documentation standards to analytics assets and reporting solutions.

- Create and maintain dashboards, reports, visualizations, and interactive analytics applications using Power BI, Databricks AI/BI, Streamlit, Plotly Dash, or similar technologies.

- Design, develop, and consume REST APIs to integrate analytics solutions with enterprise systems, cloud platforms, and external services.

- Monitor analytics solutions and troubleshoot technical issues while supporting ongoing improvements.

- Provide support to business users in utilizing self-service AI/BI and analytics platforms effectively.

- Collaborate with stakeholders to gather requirements and develop analytics applications and visualizations that address business needs.

- Partner with data engineers, data scientists, AI/ML specialists, and solution architects to deliver end-to-end business solutions.

Skills and Abilities :

- Strong Python programming skills for data processing, automation, API development, and application development.

- Strong SQL skills for data transformation, validation, optimization, and building analytics-ready datasets.

- Experience with Databricks or a comparable cloud-based analytics and data platform.

- Experience creating dashboards and visualizations using Power BI, Databricks AI/BI, or similar BI platforms.

- Experience developing data models, dimensional models, semantic layers, and reusable business metrics.

- Experience building or integrating REST APIs and enterprise data services.

- Understanding of lakehouse architecture and modern analytics platform concepts.

- Familiarity with software engineering practices including Git, testing, documentation, modular code development, and CI/CD concepts.

Minimum Qualifications :

- Bachelor's degree.

- 3 - 5 years of related experience.

- Equivalent additional directly related experience will be considered in lieu of a degree.

Skills

Python, SQL, Databricks, Power BI, Data Analytics