Job Summary
The Associate Data Architect I - ETL Developer / Data Integration Professional will design, develop, implement, and maintain ETL processes, data integration solutions, and reporting applications. This role focuses on extracting, transforming, and loading data from multiple source systems into target databases and data warehouses, developing and optimizing SQL queries, and supporting enterprise reporting requirements. The professional will collaborate with business and technical stakeholders to translate requirements into technical solutions, ensure data accuracy and consistency, troubleshoot integration issues, and maintain reliable data pipelines and reporting environments.
Key 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.
• Develop, deploy, and maintain SSRS reports, dashboards, and data extracts.
• Collaborate with business users to understand reporting requirements and provide data-driven solutions.
• Validate report outputs and ensure alignment with business rules and data definitions.
• Support ad hoc reporting and analytics requests.
• Collaborate with Business Analysts, Data Architects, Project Managers, and other 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 on data integration strategies and solutions.
• 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.
Required Qualifications
• 5+ years of experience in ETL development and data integration.
• 5+ years of SQL Server database development and administration experience.
• 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.
• Proven experience with SSIS, SSRS, and SQL Server performance optimization.
• 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.
• Experience supporting enterprise reporting and data warehouse environments.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work independently and manage multiple priorities in a fast-paced environment.
Preferred Qualifications
• 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.
Notes:
Mandatory Areas
Must Have Skills - ETL
Skill 1 - 5 + Years of exp in ETL
Skill 2 - 3 + Years of Exp in SSRS reports, dashboards, and data extracts
Good To have Skills -
Skill 1 - Yrs of Exp -N/A
Skill 2 - Yrs of Exp -N/A
Skill 3 - Yrs of Exp -N/A
Skill 4 - Yrs of Exp -N/A
Mandatory if Applicable
Domain Experience (If any ) - N/A
Must have Certifications -N/A
Location - Remote
Onsite Requirement - Y/N-
Number of days onsite -
If Onsite - Office Address -
