ETL Developer

Compunnel, Inc.; Brecksville, Northern (OH, KY); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Compunnel, Inc. is seeking an ETL Developer to design, build, and support enterprise data integration solutions that drive BI and analytics.

The role focuses on T-SQL, SSIS, data warehousing, and performance optimization across cloud and on‑prem environments. Responsibilities include developing scalable ETL pipelines, maintaining SSIS packages, optimizing SQL queries, and collaborating with data architects, AI teams, and stakeholders to deliver high‑quality datasets and reports.

Qualifications

• Bachelor’s degree or equivalent experience.
• 5+ years ETL/db development or BI.
• Strong MS SQL Server, T-SQL proficiency.
• Extensive SSIS package development.
• SSRS reporting development and optimization.
• Experience with cloud/on-prem data integrations (Azure, Snowflake).

Responsibilities

• Design, develop, and implement scalable ETL solutions and data pipelines to load data into data warehouses.
• Collaborate with stakeholders and cross-functional teams to translate business needs into technical solutions.
• Develop, optimize, and maintain T-SQL scripts, procedures, functions, and triggers.
• Build, enhance, and support SSIS packages for ETL processes.
• Integrate data from cloud platforms and on-premises sources.
• Prepare data for analytics, reporting, and AI/ML initiatives.
• Collaborate with AI/analytics teams on data mapping and datasets.
• Develop, maintain, and troubleshoot SSRS reports and reporting solutions.
• Diagnose production issues, data integration failures, and performance bottlenecks.
• Monitor ETL workflows and ensure successful data processing.
• Analyze and optimize query performance and database efficiency.
• Work with DBAs to resolve locking and performance issues.
• Review and improve existing ETL processes and lead implementations.
• Conduct peer code reviews for quality and stability.
• Support, maintain, and improve BI and data integration solutions.
• Create and maintain technical/process documentation and procedures.
• Ensure data governance, security, and quality standards.

Skills

T-SQL

ETL development

Data warehousing concepts

SQL Server

SSIS

SSRS

Data integration

Performance tuning

Azure

Snowflake

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

SSRS

Azure

Snowflake

SQL Server Management Studio

Job description

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.