Senior Production Support Engineer - Remote / Telecommute

The candidate will serve as an Associate Data Architect, ETL Developer, and Data Integration Professional responsible for reporting development, ETL processes, and data integration solutions. The role involves designing, developing, and maintaining ETL processes, optimizing complex SQL scripts, building SSRS reports and dashboards, and collaborating with business stakeholders to deliver accurate data-driven solutions. ETL Development & Data Integration:

• 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.

• 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.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently and manage multiple priorities in a fast-paced environment., * Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• Experience in healthcare, insurance, finance, or other data-intensive industries.
• Knowledge of Azure Data Factory, Power BI, or cloud-based data integration platforms.
• 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.