SENIOR ETL DEVELOPER & SYSTEM ANALYST

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 4 years of relevant experience in ETL development, data integration, and system analysis, with strong expertise in SSIS and T-SQL.
• Advanced skills in data profiling, data modeling, and data migration strategies; exposure to cloud ETL tools (AWS Glue, Azure Data Factory, Google Cloud Dataflow) is a plus.
• Proficiency in Python (with Pandas) for scripting and automation; familiarity with C# for SSIS scripting is desirable.
• Strong knowledge of data warehousing principles, performance tuning, and database concepts.
• Experience with data visualization tools (Power BI, SSRS, Tableau, Excel) for reporting and analytics.
• Excellent analytical, problem-solving, and communication skills; ability to manage multiple tasks and work effectively under pressure.

Duties and responsibilities:

• Collaborate with business stakeholders to gather, analyze, and document complex data requirements, translating them into technical specifications and data mapping documents.
• Conduct comprehensive data profiling and analysis on source systems to assess data structures, content, quality, and integration challenges.
• Validate ETL outputs through detailed data analysis, ensuring compliance with business rules and data quality standards.
• Design scalable and efficient ETL architectures and data models (conceptual, logical, physical) to support reporting, analytics, and data migration initiatives.
• Prepare and maintain IT documentation, including design specifications and data flow diagrams throughout the project lifecycle.
• Develop, implement, and optimize ETL processes using SQL Server Integration Services (SSIS) or similar tools, ensuring data integrity and performance.
• Write and optimize complex T-SQL queries, stored procedures, and functions for data extraction, transformation, and loading.
• Perform unit testing and support integration and user acceptance testing (UAT) for ETL solutions.
• Monitor, troubleshoot, and resolve ETL job failures, data discrepancies, and performance issues; conduct root cause analysis and recommend sustainable solutions.
• Create and maintain data integration tools, utilities, and scripts to automate workflows.
• Provide production support for ETL jobs related to Risk and Credit systems, ensuring timely and accurate data delivery for regulatory reporting and financial models.
• Manage incident response and resolution in production environments.
• Design and develop data visualizations, reports, and dashboards using Power BI, SSRS, or Excel to deliver actionable insights.
• Apply best practices in data visualization for clarity and impact.
• Ensure proper data management, including database permissions, backup/recovery strategies, security protocols, and performance monitoring.
• Act as a subject matter expert in data integration and analysis, providing technical guidance to development teams and business users.
• Participate in workshops and meetings to gather requirements, present technical solutions, and share data insights.
• Collaborate effectively within a team environment, promoting knowledge sharing and best practice