Job Summary
The Data Analyst will analyze large-scale, complex enterprise data environments and translate business requirements into data mappings, transformation rules, data models, and analytical solutions. This role requires advanced SQL development, hands-on Snowflake experience, data profiling, reconciliation, root cause analysis, and data lineage analysis. The analyst will collaborate with business and technology stakeholders to support reporting modernization, cloud data initiatives, and enterprise analytics solutions while producing complete, documented, and auditable design artifacts.
Key Responsibilities
• Translate business requirements into documented data requirements, transformation rules, and analytical solutions.
• Perform source-to-target data mapping across multiple applications, source systems, platforms, and business domains.
• Design and document conceptual, logical, and physical data models.
• Create Snowflake-based structures, including temporary tables, staging structures, prototypes, and analytical datasets, to support solution design.
• Conduct data profiling, reconciliation, lineage analysis, and data quality assessments to validate business and technical requirements.
• Perform root cause analysis to investigate data discrepancies, quality issues, and inconsistencies.
• Analyze end-to-end data flows and lineage from source systems through downstream consumption.
• Document transformation logic, business rules, data definitions, data dictionaries, source-to-target mappings, and functional specifications.
• Develop and optimize complex SQL queries involving joins, aggregations, large-scale data validation, and performance tuning.
• Partner with business and technology teams to support reporting modernization, cloud data initiatives, and enterprise analytics projects.
• Communicate complex data findings and recommendations to business and technical stakeholders.
• Produce complete and auditable design artifacts to support implementation, traceability, and operational handoff.
• Collaborate with Agile delivery teams to support requirements analysis, solution design, and delivery activities.
Required Qualifications
• Bachelor's degree in Computer Science, Information Systems, Business, Mathematics, or equivalent experience.
• 7+ years of experience analyzing large-scale, complex enterprise data environments.
• Advanced SQL development skills, including complex joins, aggregations, performance optimization, and large-scale data validation.
• Strong hands-on experience with Snowflake data analysis, including temporary tables, staging structures, prototypes, and analytical datasets.
• Expertise in translating business requirements into data mappings, transformation rules, data models, and analytical solutions.
• Experience designing conceptual, logical, and physical data models.
• Proven ability to map and reconcile data across multiple source systems, platforms, and business domains.
• Strong understanding of data lineage, metadata, and end-to-end data flows.
• Experience performing data profiling, root cause analysis, reconciliation, and data quality assessments.
• Experience documenting source-to-target mappings, business rules, data dictionaries, and functional specifications.
• Experience supporting reporting modernization, cloud data initiatives, and enterprise analytics solutions.
• Strong stakeholder communication skills, including the ability to present complex data findings to business and technical audiences.
• Experience working in Agile delivery environments.
Preferred Qualifications
• Knowledge of mainframe data structures and architecture.
• Experience in financial services, brokerage, trading, operations, or enterprise reporting environments.
