Senior Data Analyst
MCAP at a Glance
Joining
MCAP means you will be a part of our diverse workforce of highly talented
individuals who are recognized for their expertise and success! At MCAP, your
professional expertise, commitment to teamwork and passion for service
excellence are recognized and rewarded with competitive total rewards offering,
a career with continuous learning and development (formal & informal
training), and exciting opportunities in a dynamic, entrepreneurial
environment.
The Role
The Sr. Data Analyst is responsible for acting as Single Family Operations’ primary data analyst and report developer for Single Family Operations. This role involves collaborating closely with Single Family Operations’ business units, utilizing advanced SQL and Excel skills to extract and manipulate data from multiple sources, and leveraging visualization tools to transform raw data into meaningful reports and dynamic dashboards that address specific business needs. The Sr. Data Analyst (SF Ops) is a key contributor to enhancing operational efficiency and strategic decision-making through accurate and timely reporting.
This role provides timely and thorough analysis, as well as sound and prudent feedback on major projects and business opportunities identified by Single Family Operations’ senior leadership team. It ensures all relevant business requirements are met, risks are mitigated, alternative options are explored, and costs are managed. This role works together with business units, and internal technology teams to document processes and solutions, present and explore new methods to enhance operations, test and validate results, implement appropriate process and technology solutions, and provide information and support to the training team.
Provide subject matter expertise and impact analysis on projects and business opportunities.
- Develop, maintain and automate reporting to improve efficiency and data accessibility
- Translate business needs into clear reporting and system requirements, ensuring proper documentation
- Collaborate with business units and IT to develop solutions, resolve issues, and assess impacts
- Extract, integrate, and analyze data from multiple sources using SQL while ensuring accuracy and data integrity
- Develop automated reporting solutions (e.g., SSIS, SSRS) and support data optimization initiatives
- Review and validate analysis outputs, providing feedback and supporting sign-off processes
- Build and maintain effective cross-functional relationships across the organization while handling sensitive informat