Senior ETL Developer

Job Description

Job Title: Senior Data Engineer / ETL Developer Location: US, from India Department: IT / Data & Analytics Reports To: Director of Data & Analytics Employment Type: Contract, 12 months Pay: $30-38 per hour payrolled or self-employed About the Role We are seeking a skilled and motivated Senior Data Engineer / ETL Developer to lead the design and implementation of end-to-end data integration solutions powering this new platform. You will work closely with IT, business stakeholders, and BI developers to build scalable data pipelines, robust data models, and a high-performance reporting environment centered around Power BI. This role is a key contributor in shaping our data infrastructure and delivering timely, accurate insights across the organization—from the shop floor to the boardroom. Key Responsibilities Data Engineering & Integration Design, build, and maintain scalable ETL/ELT pipelines to extract, transform, and load data from diverse manufacturing systems (ERP, MES, IoT sensors, SQL databases, flat files, APIs). Develop and manage data workflows using tools such as Azure Data Factory, SQL Server Integration Services (SSIS), or other modern data orchestration platforms. Platform & Architecture Support Contribute to the design and architecture of the new internal analytics platform, ensuring flexibility, scalability, and cost-efficiency. Design and optimize data lake and data warehouse solutions using cloud-native tools (preferably Microsoft Azure). Power BI Enablement Build and optimize semantic data models, dataflows, and datasets for use in Power BI. Collaborate with Power BI developers and business analysts to ensure data models meet reporting requirements, including DAX performance tuning and efficient data structure design. Data Governance & Quality Implement data validation, cleansing, and monitoring processes to ensure data quality, reliability, and accuracy. Contribute to data governance policies, including documentation, lineage tracking, and security controls. Collaboration & Mentorship Work closely with cross-functional teams (IT, production, quality, finance, supply chain) to gather data requirements and deliver meaningful solutions. Provide technical leadership and mentor junior developers or analysts in best practices for data engineering and analytics. Required Qualifications Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field. 5+ years of experience in data engineering, ETL development, or database architecture roles. Proven experience with ETL tools such as Azure Data Factory, SSIS, or Informatica. Advanced SQL skills, including performance tuning, stored procedures, and query optimization. Strong experience with Power BI, including DAX, data modeling, and dataset optimization. Experience with data warehousing (e.g., Azure Synapse, SQL Server, Snowflake) and cloud platforms (preferably Azure). Understanding of manufacturing systems and data (e.g., ERP, MES, shop floor data, SCADA, historians). Preferred Skills Experience with Python or other scripting languages for automation and data manipulation. Familiarity with time-series data and integration from IoT or edge devices. Knowledge of DevOps practices, CI/CD for data pipelines, and version control using Git. Exposure to data governance frameworks and tools like Purview, Alation, or Collibra. Power BI Service administration experience and integration with Power Platform (e.g., Power Automate, Power Apps) Key Competencies Strong analytical and problem-solving skills with attention to detail. Excellent communication skills, with the ability to bridge technical and business domains. Self-starter with the ability to lead initiatives and work independently or collaboratively. A passion for continuous improvement and innovation in a manufacturing setting.