Hoffmann Brothers · 5 hours ago
Associate Analytics Engineer
Maryland Heights, MO
Full-time
Onsite
Entry Level
$61K/yr - $78K/yr
1+ years expHoffmann Brothers is a premier HVAC, Plumbing, Electrical, and Appliance Repair service provider in the St Louis area, seeking to expand its team. The Associate Analytics Engineer will help build and scale the company's data ecosystem, focusing on data ingestion, transformation, and reporting while collaborating with cross-functional stakeholders to deliver scalable data solutions.
Construction
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
Qualification
Required
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
Preferred
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
Company
Hoffmann Brothers
Hoffmann Brothers is a Mechanical, Electrical, and Plumbing (MEP) contractor serving customers in St Louis and Nashville.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Chris Hoffmann
President & CEO
Kathryn Amsbury, CPA
Chief Financial Officer
Recent News
2023-03-02
Globe Newswire
2023-01-15
Company data provided by crunchbase