> Markdown version of [/jobs/ext/1920300-data-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/1920300-data-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analytics Engineer - **Company:** D'Addario & Company - **Location:** Farmingdale, NY, United States - **Experience:** Experienced - **Salary:** $115,000.0 - $130,000.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Automation of Tests, Microsoft Azure, Information Engineering, Data Governance, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Mart, Data Transformation, Data Warehousing, Data Intelligence, Python (Programming Language), Power BI, Cloud Services, Standard Sql, DataOps, Azure Data Lake, Data Processing, Data Ingestion, Sql Optimization, Microsoft Fabric, Pyspark, Information Technology, Data Analytics, Star Schema, Azure Synapse Analytics, Software Version Control, Data Pipelines, Api Management, Web Api - **Published:** August 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=22a13e309ae6cd42 ## About the Role This is an ideal opportunity for an engineer who thrives at bringing data into order, enjoys solving complex data challenges, and is passionate about enabling organizational data intelligence., * 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) * 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 Knowledge, skills, & abilities: * Strong programming in Python and PySpark for data processing and transformation * Advanced SQL and dimensional data modeling (e.g., 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, and comfortable operating in a fast-paced, evolving environment * Passion for innovation and leveraging data to create business impact ## Description * Build & Optimize Pipelines: Design, implement, and maintain robust, high-performance ELT/ETL data pipelines within Microsoft Fabric and our broader data environment. * Data Integration: Connect and harmonize new data sources-including ERP, e-commerce platforms, and external APIs-into a centralized data platform. * Analytics Data Modeling: Transform raw data into clean, well-structured dimensional models, data marts, and reusable datasets (star schemas) that are analysis-ready for reporting and self-service BI. * Semantic Layer & Metrics: Build and maintain semantic models and standardized metric definitions in Power BI and Microsoft Fabric so the business works from a single, trusted source of truth. * Data Quality & Testing: Implement automated testing, validation, and monitoring to ensure pipelines and datasets are accurate, reliable, and well-documented. * Collaboration: Partner with analysts and stakeholders across Sales, Marketing, Operations, and Product to translate business requirements into reliable data products. * Continuous Improvement: Follow and help improve team standards for coding, documentation, version control, and DataOps across our data engineering and analytics workflows. ## Related Videos - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Web APIs you might not know about](https://www.wearedevelopers.com/videos/281-web-apis-you-might-not-know-about) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)