Data Analytics Engineer

D’Addario & Company offers a hands-on, impact-focused role on the Business Intelligence team, building and optimizing the global data infrastructure that powers reporting and self-service analytics. This hybrid position in Farmingdale, NY combines production-grade engineering with collaboration across Sales, Marketing, Operations, and Product, supported by a benefits package designed for your health, family, growth, and wellbeing.

What you’ll do

• Design, implement, and maintain robust, high-performance ELT/ETL data pipelines in Microsoft Fabric and the broader data environment.
• Connect and harmonize new data sources, including ERP, e-commerce platforms, and external APIs, into a centralized data platform.
• Transform raw data into clean, analysis-ready assets such as dimensional models, data marts, and reusable star schemas.
• Build and maintain semantic models and standardized metric definitions in Power BI and Microsoft Fabric to support a single, trusted source of truth.
• Implement automated testing, validation, and monitoring so pipelines and datasets are accurate, reliable, and well-documented.
• Partner with analysts and stakeholders across Sales, Marketing, Operations, and Product to translate business requirements into reliable data products.
• Help improve team standards for coding, documentation, version control, and DataOps across data engineering and analytics workflows.

What you bring

• 3+ years of hands-on experience as a Data Engineer, Analytics Engineer, or equivalent.
• Experience building and maintaining production-grade data pipelines and analytics data models.
• Proficiency in Python, PySpark, and SQL.
• Bachelor’s degree in Computer Science, Engineering, Data Science, or related field (or equivalent professional experience).

Tools you’ll work with

Microsoft Fabric, ELT, ETL, ERP, Power BI, Python, PySpark, SQL, Azure Synapse, Azure Data Lake, Azure, dbt, star schema, Kimball, and DataOps.

Compensation

The base salary range is $115,000 to $130,000 per year, commensurate with experience, skills, and qualifications. The position is eligible for a discretionary annual bonus, in accordance with company policy.

Benefits

• 401(k) Retirement Plan: employer Safe Harbor contribution of 3% of total annual earnings, with the opportunity to earn up to an additional 7% in employer Discretionary contributions, regardless of employee contribution level.
• Health, vision, and dental insurance.
• 12 weeks of fully paid parental leave.
• Fertility and family-building benefits.
• Annual performance and compensation reviews.
• Career pathing and professional development via LinkedIn Learning.
• Generous PTO days, plus a flexible sick day policy and 12 paid holidays.
• Life and AD&D insurance, enhanced short-term disability insurance, and an Employee Assistance Program (EAP).
• Tuition reimbursement.
• Discounts on D’Addario products and merchandise.
• Company jam nights, artist performances, holiday parties, and special events.
• A passionate, talented team that loves what they do.

Additional knowledge, skills, and abilities

• Strong programming in Python and PySpark for data processing and transformation.
• Advanced SQL and dimensional data modeling (star schema / Kimball) for analytical performance and scalability.
• Experience building and maintaining ELT/ETL pipelines and transformation layers, including automated testing and validation of analysis-ready datasets.
• Strong understanding of cloud data platforms (Azure preferred).
• Excellent communication skills with the ability to simplify complex technical concepts.
• Familiarity with semantic modeling and BI tools such as Power BI and Microsoft Fabric.
• Self-directed, highly organized approach and comfort working in a fast-paced, evolving environment.
• Passion for innovation and leveraging data to create business impact.

Preferred qualifications

• Preferred experience with Microsoft Fabric, Azure Synapse, or Azure Data Lake.
• Preferred experience implementing DataOps best practices and building transformation models with dbt or similar frameworks.
• Familiarity with API integrations and third-party data ingestion.
• Knowledge of data governance and data quality frameworks.
• Musician or passion for music a plus.