Job Description
CDM Smith is seeking a Senior Analytics Engineer to join our Digital Engineering Solutions team. This individual will be part of the Data Technology group within the Digital Engineering Solutions team, helping to drive strategic Architecture, Engineering and Construction (AEC) initiatives using cutting-edge data technologies and analytics to deliver actionable business insights and robust solutions for AEC professionals and client outcomes. The Data Technology group will lead the firm in AEC-focused Business Intelligence and data services by providing architectural guidance, technological vision, and solution development. The Data Technology group will specifically utilize advanced analytics, data science, and AI/ML to give our business and our products a competitive advantage. It includes understanding and managing the data, how it interconnects, and architecting & engineering data for self-serve BI and BA opportunities. This position is for a person who has demonstrated excellence in analytics engineering capabilities, experienced with data technology and processes, and enjoys framing a problem, shaping and creating solutions, and helping to lead and champion implementation. As a member of the Digital Engineering Solutions team, the Data Technology group will also engage in research and development and provide guidance and oversight to the AEC practices at CDM Smith, engaging in new product research, testing, and the incubation of data technology-related ideas that arise from around the company.
Key Responsibilities:
• Design and implement data models, transformation workflows, and analytics layers to support self-service BI and analytics.
• Implement and maintain scalable analytics solutions by combining advanced data visualization and software development techniques.
• Create dynamic and interactive dashboards, reports, data visualizations, and applications to provide end-users with intuitive access to insights.
• Collaborate with stakeholders to gather requirements and design tailored analytics applications and visualizations.
• Ensure data accuracy, consistency, and quality across all analytics deliverables.
• Build analytics-ready data models and semantic layers using Microsoft Power BI and other Microsoft ecosystem tools.
• Provide support to business users for utilizing self-service BI and analytics platforms effectively.
• Create APIs and workflows for seamless integration of analytics with external systems or custom applications.
• Monitor analytics systems and troubleshoot technical issues, providing support and improvements as needed.
• Stay abreast of the latest developments and advancements, including new and emerging technologies & best practices and new tools & software applications and how they could impact CDM Smith.
• Assist with the development of documentation, standards, best practices, and workflows for data technology hardware/software in use across the business.
• Perform other duties as required.
Skills and Abilities:
• Proficiency in Business Intelligence tools such as Power BI, with hands-on experience integrating R or Python-based solutions and creating complex, interactive visualizations.
• Expertise in developing custom interactive applications and dashboards using tools like R Shiny, Dash, or Streamlit, focusing on building intuitive, data-driven user interfaces for real-time analysis and decision-making.
• Advanced SQL skills for data manipulation, query optimization, and building analytics-ready datasets.
• Familiarity with cloud-based analytics solutions, particularly Microsoft Azure and Databricks.
• Strong understanding of analytics performance optimization techniques, such as query tuning and indexing.
• Knowledge of software engineering principles, including modular code design, version control (e.g., Git), and CI/CD pipelines.
• Experience in API development and integration, including RESTful APIs.
• Proficiency in data visualization libraries like ggplot2, Plotly, or equivalent tools to support custom visualization needs.
• Strong programming skills in Python or R for data manipulation, analysis, and integration.
• Excellent problem-solving and critical thinking skills to identify and address technical challenges effectively.
• Excellent interpersonal and presentation skills to build strategic relationships with colleagues, stakeholders, and partners.
• Strong critical thinking skills to generate innovative solutions and improve business processes.
• Ability to effectively communicate complex technical concepts to both technical and non-technical audiences.
• Detail oriented with the ability to assist with executing highly complex or specialized projects.
Minimum Qualifications
• Bachelor’s degree.
• 6 years of related experience.
• Equivalent additional directly related experience will be considered in lieu of a degree
