Senior ETL Developer/Data Engineer

Tasks

• Maintain and enhance data architecture across existing and new systems, including Data Warehouses.
• Improve data quality, reliability, and database performance.
• Develop ETL pipelines and data integrations using various tools.
• Design data solutions supporting data scientists and business stakeholders.
• Perform ETL testing and data transformation testing.
• Develop data models for data mining and analytics.
• Maintain source-to-target and process flow documentation.
• Perform SQL Server DBA activities, including job scheduling, error handling, troubleshooting, and monitoring.
• Proactively monitor ETL processes and data pipelines.

Requirements

• 10+ Years
• Azure Data Factory (ADF): 3+ years, including API source integration experience.
• SQL Server / SQL: 4+ years of advanced SQL and relational database experience.
• Working knowledge of Microsoft Azure.
• Data Testing
• Data Warehouse Testing
• Python: Pandas, NumPy, and DataFrame operations.
• C#
• Microsoft Fabric
• Azure Logic Apps and Azure Functions development using C#.
• Azure Managed SQL Server, including indexing, database security, and backups.
• Data analysis, business rules validation, and source-to-target mapping.
• Strong understanding of Data Warehouse and ODS concepts.
• Experience with data duality and source systems analysis.
• Commercial Real Estat

Schedule

• Hybrid for local candidates, based on business requirements
• W2 / C2C
• USC / GC / EAD / H1B
• C2C: EAD / H1B Only

Location

• Hudson, MA (Highly Preferred) | Houston, TX | Boston, MA | Remote