ETL Developer / SQL SSRS Developer

Role: ETL Developer / Data Integration Reporting Developer

Location: Remote

Duration: 12+ Months

 

Must Have:

• 5+ Years of exp in ETL
• 3+ Years of Exp in SSRS reports, dashboards, and data extracts

Responsibilities:

• Design, develop, implement, and maintain ETL processes to extract, transform, and load data from multiple source systems into target databases and data warehouses.
• Develop and optimize complex SQL queries, stored procedures, functions, and scripts to support data integration and reporting requirements.
• Perform data mapping, transformation, validation, and reconciliation to ensure data accuracy and consistency across systems.
• Troubleshoot and resolve ETL job failures, performance bottlenecks, and data quality issues.
• Support large-scale data migration, conversion, and integration initiatives. Reporting & Analytics
• Develop, deploy, and maintain SSRS reports, dashboards, and data extracts.
• Work closely with business users to understand reporting requirements and provide actionable data-driven solutions.
• Validate report outputs and ensure alignment with business rules and data definitions.
• Support ad hoc reporting and analytics requests. Requirements Analysis & Collaboration
• Collaborate with Business Analysts, Data Architects, Project Managers, and stakeholders to gather and analyze business requirements.
• Translate business requirements into technical design documents and ETL specifications.
• Participate in design reviews, code reviews, and project planning activities.
• Provide technical guidance and recommendations regarding data integration strategies and solutions. Documentation & Support
• Create and maintain technical documentation, including ETL workflows, data mappings, process flows, and operational procedures.
• Support production deployments, issue resolution, and post-implementation validation activities.
• Ensure compliance with organizational standards, security policies, and development best practices.
• Participate in on-call support and troubleshooting as required.

Requirements:

• Strong experience in ETL development and data integration.
• Advanced SQL Server development and performance tuning skills.
• Hands-on experience with Microsoft SSIS, SSRS, and Visual Studio.
• Experience with data warehousing concepts, dimensional modeling, and ETL architecture.
• Strong understanding of data mapping, data transformation, and data validation techniques.
• Experience troubleshooting complex data integration and reporting issues.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work independently and manage multiple priorities in a fast-paced environment.
• Experience in healthcare, insurance, finance, or other data-intensive industries.
• Experience with Agile development methodologies.
• Familiarity with source control and DevOps practices. Experience
• 5+ years of experience in ETL development and data integration.
• 5+ years of SQL Server database development and administration experience.
• Proven experience with SSIS, SSRS, and SQL Server performance optimization.
• Experience supporting enterprise reporting and data warehouse environments.

In compliance with the salary transparency law, the expected pay range for this role is $50. Actual compensation depends on experience and interview evaluation.