Senior Data Analyst

We are seeking a seasoned Senior Data Analyst to support a customer in their data transformation journey The customer is transitioning from an on premises SQL Server SSIS based Enterprise Data Warehouse to a Databricks platform on AWS This role involves close collaboration with business stakeholders to analyze legacy Excel based reports and help modernize reporting capabilities within the new cloud based data framework

Key Responsibilities

Engage with business stakeholders to understand existing reporting needs primarily driven by Excel based legacy mechanisms

Perform detailed discovery and gap analysis to identify reporting logic data sources and transformation rules

Translate business requirements into functional and technical specifications for integration into the new reporting framework

Collaborate with data engineers and developers to enhance and extend the reporting platform using tools like SSIS and MS SQL Server while supporting migration to Databricks on AWS

Support the design and validation of enriched data pipelines and reporting outputs aligned with business expectations

Understand and interpret complex SQL queries and stored procedures to support data analysis and transformation

Write complex source to target mapping requirements and own the mapping document for the modules assigned

Participate in Agile Scrum ceremonies and contribute to sprint planning backlog grooming and user story creation

Document data mappings business rules and reporting logic to ensure traceability and maintainability

Required Skills And Qualifications

10 plus years of experience as a Data Analyst

Experience working with Excel based legacy reports and translating them into scalable automated reporting solutions

Proficiency in SSIS MS SQL Server and SQL for data analysis and ETL support

Strong ability to understand and work with complex SQL queries and stored procedures

Experience in writing and managing source to target mapping documents

Familiarity with Agile Scrum methodologies and tools like Jira

Excellent communication and stakeholder engagement skills especially in ambiguous or evolving requirement scenarios