Data Analytics Engineer
Analytics
Azure Data Lake
Azure Platform
Azure Synapse Analytics
Big Data
Bigdata
Business Analytics
Business Intelligence
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Dataops
Dbt
Digital Marketing
Dimensional Modeling
Engineer
ETL
Informatica
Information Technology (IT)
Integration
Kimball
Microsoft
Microsoft Fabric
Power BI
Power Platform
Pyspark
Reporting and Analytics
SQL
Visual Design
Job Description
D’Addario & Company is hiring a hands-on Data Analytics Engineer to strengthen its Business Intelligence team and support the build-out of a production-ready global data infrastructure. This hybrid role in Farmingdale, NY focuses on designing and operating ELT/ETL pipelines and analytics-ready data models that power reporting and self-service BI.
What you’ll do
- Design, implement, and maintain robust, high-performance ELT/ETL data pipelines within 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, well-structured dimensional models, data marts, and reusable datasets (such as star schemas) for analysis-ready reporting and self-service analytics.
- Build and maintain semantic models and standardized metric definitions in Power BI and Microsoft Fabric so teams work from a single, trusted source of truth.
- Implement automated testing, validation, and monitoring to ensure accuracy, reliability, and documentation for pipelines and datasets.
- Partner with analysts and stakeholders across Sales, Marketing, Operations, and Product to translate business needs into dependable data products.
- Contribute to improving 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.
- A Bachelor’s degree in Computer Science, Engineering, Data Science, or a related field (or equivalent professional experience).
Technologies you’ll work with
- Microsoft Fabric, ELT, ETL, ERP, Power BI
- Python, PySpark, SQL
- Azure Synapse, Azure Data Lake, Azure
- dbt, Star schema, Kimball, DataOps
Compensation
- Base salary range: $115,000 - $130,000 per year, commensurate with experience, skills, and qualifications.
- Discretionary annual bonus eligibility, in accordance with company policy.
Benefits
- 401(k) Retirement Plan: employer Safe Harbor contribution of 3% of total annual earnings, with 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 allotment of PTO days.
- Flexible sick day policy.
- 12 paid holidays.
- Life and AD&D insurance.
- Enhanced short-term disability insurance.
- 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!