Job Description
We are seeking an experienced Senior Data Analyst – Master Data Management (MDM) to support enterprise-wide data management initiatives within the Multifamily Mortgage business. This role is responsible for driving Master Data Management (MDM) strategies that enhance data quality, governance, consistency, and enterprise reporting. The ideal candidate must possess strong expertise in SQL, ETL, AWS cloud technologies, enterprise data management, and data governance, along with the ability to collaborate across business and technical teams. This position requires exceptional analytical, problem-solving, and stakeholder management skills in a fast-paced, highly regulated financial services environment.
Key Responsibilities
- Lead enterprise Master Data Management (MDM) initiatives across the Multifamily Mortgage business.
- Collaborate with business stakeholders, data stewards, architects, and engineering teams to define and govern critical master data domains.
- Analyze business processes and translate complex business requirements into scalable MDM and data governance solutions.
- Design, develop, and optimize advanced SQL queries for data analysis, reporting, and performance optimization.
- Develop, maintain, and optimize ETL processes and enterprise data integration pipelines.
- Create and implement enterprise data quality rules, validation processes, and monitoring frameworks.
- Develop MDM implementation roadmaps, including project milestones, risks, dependencies, and success metrics.
- Support enterprise data governance initiatives including metadata management, data lineage, business glossary, and reference data management.
- Collaborate with cloud engineering teams to build scalable and secure AWS-based data integration solutions.
- Present analytical findings and strategic recommendations to both technical and non-technical stakeholders.
- Mentor junior analysts and promote best practices in data governance, analytics, and master data management.
- Ensure compliance with enterprise data governance standards and regulatory requirements.
Required Qualifications
- Bachelor's degree in computer science, Information Systems, Data Analytics, Engineering, Finance, or a related field.
- 7+ years of experience in Data Analytics, Data Management, Data Engineering, or Master Data Management.
- Strong expertise in advanced SQL, including complex query development, performance tuning, and data analysis.
- Hands-on experience designing, developing, and supporting enterprise ETL processes and data integration solutions.
- Strong understanding of Master Data Management (MDM), Enterprise Data Governance, Data Quality Management, Metadata Management, Reference Data Management, and Data Lineage.
- Experience building enterprise data quality frameworks and validation processes.
- Experience developing implementation roadmaps for enterprise data initiatives.
- Working knowledge of AWS cloud technologies, including Amazon S3, AWS Glue, Amazon Redshift, Amazon Athena, AWS Lambda, Amazon EMR, and Amazon RDS.
- Strong analytical, problem-solving, and critical-thinking skills.
- Excellent communication and stakeholder management abilities.
- Experience working within mortgage, banking, financial services, or other regulated industries.
Preferred Qualifications
- Experience supporting Multifamily Mortgage business processes, including Loan Origination, Underwriting, Loan Servicing, Asset Management, and Securitization.
- Hands-on experience with enterprise Master Data Management (MDM) platforms, including Informatica MDM, Reltio, Semarchy, Profisee, and SAP MDG.
- Familiarity with enterprise data governance frameworks such as DAMA-DMBOK or DCAM.
- Experience with Snowflake or other modern cloud-based data platforms.
- AWS or other cloud-related certifications.
- Experience working in Agile/Scrum environments supporting cross-functional product and engineering teams.
- Experience mentoring junior analysts and leading enterprise-wide data initiatives.