Cette offre d'emploi n'est plus disponible
Associate Analytics Engineer
Hoffmann Brothers
- United States
- United States
À propos
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. Key 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. 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. Preferred/Bonus: 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.
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre a été publiée par l’un de nos partenaires. Vous pouvez consulter l’offre originale ici.