Data Analyst

Senior Data Analyst with PythonCGI is seeking an experienced Senior Data Analyst with Python skills to support data quality, production data analysis, and automation initiatives within a large scale financial services environment. This role combines hands on data analysis with Python development. The successful candidate will investigate complex data variances and production failures, perform root cause analysis, develop data correction solutions, and improve data quality processes. The role will also contribute to automation and applied machine learning initiatives focused on anomaly detection, pattern recognition, and reducing manual effort. You will work with business and technical teams to understand source to target mappings (STTMs), data lineage, and data warehouse structures; analyze data across multiple sources; and implement and validate solutions in production. The environment includes enterprise data platforms and AWS based technologies, so experience working with data solutions in AWS environments is highly valuable. Key responsibilities include: investigating data variances, production failures, and data quality issues and identify root causes; analyzing STTMs, data lineage, business rules, and source to target data flows; writing advanced SQL and Python scripts for data analysis, data correction, validation, and automation; developing and enhancing automated solutions that reduce manual data analysis and operational tasks; applying machine learning and statistical techniques to data quality use cases, including anomaly detection and unusual pattern identification; taking analytical or ML use cases from hypothesis and exploratory analysis through implementation, testing, validation, and production deployment; verifying production changes and certifying data following implementation of data corrections; working with technical leads, systems analysts, and business stakeholders to translate requirements into practical technology solutions; documenting data requirements, findings, data mappings, and implemented solutions; communicating findings and recommendations clearly to technical and business stakeholders; and managing multiple priorities and delivering assignments with minimal supervision in an Agile environment.Required qualifications to be successful in this role include: 5+ years of Business Analysis, Data Analysis, or related data focused experience; strong hands-on Python development experience, particularly for data processing, automation, and analytical solutions; advanced SQL skills with the ability to investigate complex datasets and develop data correction scripts; strong data analysis and troubleshooting skills, including root cause analysis of production data issues; experience with data quality, data validation, anomaly detection, and data reconciliation; working knowledge of machine learning and statistical techniques, particularly pattern recognition and anomaly detection; experience moving Python or ML solutions from exploratory analysis through testing, validation, and production implementation; strong understanding of data warehouses, data marts, data lineage, and source to target mappings (STTMs); experience working with enterprise data solutions in AWS environments is strongly preferred; experience comparing and reconciling information across multiple data sources; working experience with Oracle and Toad; strong Excel skills for data analysis and reconciliation; experience with Jira and Confluence; strong understanding of Agile/Scrum delivery practices; strong analytical thinking and problem solving skills with the ability to work independently; clear written and verbal communication skills and experience working across technical and business teams; ability to manage competing priorities in a high visibility environment; multifamily or Single Family mortgage industry experience is preferred.