Associate Analytics Engineer

Hoffmann Brothers • Maryland Heights, MO

5h

About The Position

For over 40 years, Hoffmann Brothers has served as the premier HVAC, Plumbing, Electrical, and Appliance Repair service and installation contractor in the St Louis area. Pursuing an aggressive expansion campaign, Hoffmann Brothers is looking to expand our reach through both acquisitions and executing our proven “green field” market entry strategy.
Over the last 6 years, Hoffmann has grown from a small family business of 50 employees to a nearly 450-team member multi-market organization with significant aspirations for further growth. We recognize the quality of our people enables this growth and now is your chance to join our team.
We’re hiring an Associate Analytics Engineer to help build and scale our data ecosystem - from raw data ingestion and transformation to relational data modeling and curated business-ready reporting. This is a highly collaborative role that partners closely with the Director of Business Intelligence & Technology and cross-functional stakeholders to define analytical needs, translate business requirements into technical specifications, and deliver scalable data solutions.
You will be deeply hands-on – developing ingestion pipelines with Python, writing SQL transformations, building curated datasets, and creating standardized and customized reporting and analytical outputs. In addition to technical execution, you will play a critical role in communicating findings, documenting data logic, and ensuring alignment between business objectives and technical implementation. Your work will directly influence how performance is measured, monitored, and acted upon across the organization.

Requirements

• Bachelor’s degree in Computer Information Systems, MIS, Data Analytics, or related field.
• 1 - 3 years of hands-on experience working with Python, SQL, and modern data analytics tools in a professional environment.
• Experience building dashboards and reports in Power BI and advanced proficiency in Excel.
• Exposure to API-based data ingestion or integrating data from external systems.
• Foundational knowledge of data modeling and data warehousing concepts, including relational structures and transformation best practices.
• Experience working with ETL/ELT workflows and structured data transformation processes.
• Strong analytical skills with experience developing and tracking KPI-based business metrics.
• Ability to translate business requirements into technical solutions and communicate data insights clearly to both technical and non-technical stakeholders.
• Experience with process automation using Python scripts or tools such as Power Automate.
• Strong documentation habits, problem-solving skills, and attention to detail.
• Interest in continuing to grow technical depth in data engineering, analytics engineering, or business intelligence.

Nice To Haves

• Experience working with Microsoft Fabric or similar lakehouse / cloud data platforms (e.g., Azure, Databricks, Snowflake).
• Familiarity with medallion architecture concepts (bronze, silver, gold) or layered data environments.
• Experience supporting operational or service-based business KPIs (e.g., revenue, job performance, margin, productivity metrics).
• Experience working with Service Titan or similar CRM system
• Basic understanding of version control, code organization, or collaborative development practices.

Responsibilities

• Design, develop, and maintain data ingestion pipelines in Python to load and validate raw data within the lakehouse environment.
• Write efficient, well-documented SQL transformations to structure and model data into relational tables optimized for analytics and reporting.
• Build and maintain curated, business-ready datasets to support KPI tracking and cross-functional reporting needs.
• Develop standardized dashboards and ad hoc analytical outputs in Power BI and Excel to monitor operational and financial performance.
• Use Python for data exploration, analysis, visualization, and automation of recurring business processes.
• Partner with the Director of Business Intelligence & Technology and cross-functional stakeholders to gather requirements, define specifications, and deliver scalable data solutions.
• Document data logic, transformations, and reporting definitions to ensure clarity, governance, and long-term maintainability.
• Monitor data quality, troubleshoot inconsistencies, and continuously improve performance and reliability across the analytics environment.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level