Data Business Analyst (Remote)

First American; Michigan; Remote; USD 57,000 - 76,000; Full time

Job summary

Join a forward-thinking company as a Regulatory Data Analyst, where you'll leverage your expertise in data mining and SQL to develop insightful reports and solutions. This role is pivotal in interpreting regulatory requirements and collaborating across business units to ensure accuracy and compliance. With a commitment to innovation and a people-first culture, this organization offers a dynamic environment that values diversity and inclusion. If you're passionate about data and looking to make a significant impact in the mortgage servicing industry, this opportunity is perfect for you.

Qualifications

• 1-5 years of experience as a data analyst in finance or banking.
• Strong proficiency in SQL and Microsoft Office Suite.

Responsibilities

• Develop operational and management reports using T-SQL.
• Collaborate with business units to define requirements.

Skills

Data Mining

SQL

Data Analysis

Reporting

Communication Skills

Education

SQL Certification

Bachelor's Degree in Finance or Related Field

Tools

Microsoft T-SQL

Microsoft Excel

Job description

Who We Are

ServiceMac is a new sub-servicing entity backed by some of the leading practitioners of the mortgage servicing industry. ServiceMac focuses on providing superior technology, products, and services for the mortgage and real estate industries, supported by highly personalized service and support. Through continuous innovation and acquisition, our offerings include personalized solutions that span the mortgage continuum, enhancing security, compliance, customer satisfaction, and profitability. Our inclusive, people-first culture has earned numerous accolades, including being named to the Fortune 100 Best Companies to Work For list for ten consecutive years. We have also received awards as a best place to work for women, diversity, and LGBTQ+ employees, and have been included on more than 50 regional best places to work lists. First American strives to be a great place to work for all.

What We Do

The Regulatory Data Analyst will be responsible for the day-to-day production, maintenance, and development of regulatory reports and data solutions at ServiceMac. This role involves understanding business processes and data, interpreting customer requirements and specifications, and developing meaningful analysis and reports for ServiceMac and its clients' regulatory requests. Qualified candidates will have a proven background in data mining, analysis, and reporting.

What You'll Do:

1. Develop operational, management, and exception reports using T-SQL in a controlled, production environment.
2. Create ad-hoc reports for individual regulatory requests and stored procedures for production reporting.
3. Interpret regulatory requirements into actionable specifications.
4. Mine, analyze, and interpret data from multiple sources.
5. Collaborate with multiple business units to define requirements and validate report results.
6. Perform tests for validity, reasonableness, and accuracy using standard methods and subject-area knowledge.
7. Maintain and test production reports regularly.
8. Assist in developing documentation for existing reports, data dictionaries, and reference documents.

What You'll Bring:

1. One to five years of recent experience as a data analyst or related role in a financial or banking environment.
2. Formal SQL query language training or certification.
3. Strong proficiency in SQL, preferably Microsoft T-SQL.
4. Expertise with the Microsoft Office Suite, especially Excel.
5. Effective communication skills with internal and external customers, peers, and management.
6. Experience with Mortgage Servicing and familiarity with MSP as a mortgage servicing platform is preferred.

Salary Range: $57,000 - $75,975 Annually

This range is an estimate of the base pay at the time of posting. Pay depends on factors such as knowledge, skills, experience, business needs, and location.