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 frameworkKey ResponsibilitiesEngage with business stakeholders to understand existing reporting needs primarily driven by Excel based legacy mechanismsPerform detailed discovery and gap analysis to identify reporting logic data sources and transformation rulesTranslate business requirements into functional and technical specifications for integration into the new reporting frameworkCollaborate 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 AWSSupport the design and validation of enriched data pipelines and reporting outputs aligned with business expectationsUnderstand and interpret complex SQL queries and stored procedures to support data analysis and transformationWrite complex source to target mapping requirements and own the mapping document for the modules assignedParticipate in Agile Scrum ceremonies and contribute to sprint planning backlog grooming and user story creationDocument data mappings business rules and reporting logic to ensure traceability and maintainabilityRequired Skills and Qualifications10 plus years of experience as a Data AnalystExperience working with Excel based legacy reports and translating them into scalable automated reporting solutionsProficiency in SSIS MS SQL Server and SQL for data analysis and ETL supportStrong ability to understand and work with complex SQL queries and stored proceduresExperience in writing and managing source to target mapping documentsFamiliarity with Agile Scrum methodologies and tools like JiraExcellent communication and stakeholder engagement skills especially in ambiguous or evolving requirement scenarios
Required Experience:
Senior IC