Extract Transfer Load Manager Jobs (NOW HIRING)

JOB SUMMARY
The ETL Developer will be responsible for designing, developing, implementing, and supporting enterprise data integration solutions that enable business intelligence, analytics, and data-driven decision-making. This role combines advanced ETL development, database development, data integration, and business intelligence support while collaborating with cross-functional teams, data architects, AI teams, and business stakeholders. The ideal candidate will possess strong expertise in T-SQL, SSIS, ETL development, performance optimization, and data warehousing concepts, with experience integrating data across cloud and on-premises environments.
KEY RESPONSIBILITIES
• Design, develop, and implement scalable, high-performance ETL solutions and data pipelines to load data into enterprise repositories and data warehouses.
• Collaborate with business stakeholders and technical teams to gather requirements and translate business needs into effective technical solutions.
• Develop, optimize, and maintain complex T-SQL scripts, stored procedures, functions, triggers, and database objects.
• Build, enhance, and support SSIS packages for data extraction, transformation, and loading processes.
• Extract and integrate data from cloud platforms, including Azure, Snowflake, and other enterprise data sources.
• Stage and prepare data for downstream analytics, reporting, and AI/ML initiatives.
• Collaborate with AI and analytics teams to understand data requirements, perform data mapping, and provide high-quality datasets.
• Develop, maintain, and troubleshoot SSRS reports and reporting solutions.
• Diagnose and resolve production support issues, data integration failures, and performance bottlenecks.
• Monitor scheduled jobs, manage ETL workflows, and ensure successful execution of data processing activities.
• Analyze and optimize query performance, identify inefficiencies, and implement performance improvements.
• Partner with Database Administrators to resolve database locking, blocking, and performance-related issues.
• Review existing system integrations and ETL processes, recommend enhancements, and lead implementation efforts.
• Conduct peer code reviews to ensure code quality, maintainability, and production stability.
• Support, maintain, and continuously improve business intelligence and data integration solutions.
• Create and maintain technical documentation, process documentation, and operational procedures.
• Ensure adherence to data governance, security, and data quality standards.
REQUIRED QUALIFICATIONS
• Bachelor's degree in Computer Science, Information Systems, Information Technology, Engineering, or a related field, or equivalent work experience.
• 5+ years of experience in ETL development, database development, data integration, or business intelligence solutions.
• Strong hands-on experience with Microsoft SQL Server.
• Advanced proficiency in T-SQL, including stored procedures, views, functions, triggers, and performance tuning.
• Extensive experience developing and maintaining SSIS packages.
• Experience with SSRS report development, troubleshooting, and optimization.
• Strong understanding of ETL processes, data warehousing concepts, and data modeling techniques.
• Experience integrating data from multiple sources, including cloud and on-premises systems.
• Proficiency in troubleshooting production issues and resolving complex data-related problems.
• Experience optimizing SQL queries and improving database performance.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent verbal and written communication skills.
• Ability to work independently while collaborating effectively with cross-functional teams.
• Experience supporting enterprise-scale data integration environments.
PREFERRED QUALIFICATIONS
• Experience working with Azure data services and cloud-based data platforms.
• Experience with Snowflake data warehousing solutions.
• Knowledge of AI/ML data preparation and dataset management.
• Experience with data governance, data quality, and master data management practices.
• Familiarity with Power BI or other business intelligence visualization tools.
• Experience working in Agile development environments.
• Knowledge of DevOps, CI/CD, and automated deployment processes.
• Experience supporting large-scale enterprise reporting and analytics environments.
CERTIFICATIONS
• Microsoft Certified: Azure Data Engineer Associate.
• Microsoft Certified: Azure Database Administrator Associate.
• Snowflake SnowPro Certification.
• Microsoft SQL Server certifications or equivalent data platform certifications preferred.
KEY COMPETENCIES
• ETL Development
• T-SQL Programming
• SSIS Development
• SSRS Reporting
• SQL Performance Tuning
• Data Integration
• Data Warehousing
• Azure Data Services
• Snowflake
• Business Intelligence
• Production Support
• Root Cause Analysis
• Data Quality Management
• Technical Documentation
• Cross-Functional Collaboration
• Problem Solving & Troubleshooting