Finance Data Services Business Analyst

Business Analyst - Finance Data Solutions

Seattle, WA (Hourly W2; Hybrid)

Applicants must be currently authorized to work in the United States on a full-time basis. The employer will not sponsor applicants for work visas. The employer may not have resources available to support STEM OPT training requirements.

Why clients choose Pivotal Consulting :

We are a technology management consulting firm helping Fortune 500 companies improve their performance - we specialize in making People, Process, and Technology work together! Our clients count on us to deliver excellence and seek our guidance on business and technology strategy, technology modernization, and cloud transformation initiatives. Simply put; by listening to our clients closely and focusing on delivering quality, we bring them peace of mind.

After guiding and helping numerous clients from global enterprises to mid-market firms to non-profit organizations, we are now experiencing breakthrough growth!

What we are looking for :

Our financial services client is undertaking a Lending Platform Project (LPP) and Mortgage Lending Origination System (LOS) modernization effort. These initiatives will introduce new solutions, data paths, and ETL tools that impact how data flows into and across client systems. The Finance Data Mart (FDM) relies on this data for regulatory and financial reporting , requiring continued data integrity and accessibility during and after these platform transitions.

The Business Analyst - Finance Data Solutions plays a critical role in supporting the continuity of FDM data flows, ensuring all data sourcing, mapping, and transformation processes align with the new cloud-based systems. This role will serve as a bridge between Finance, IT, and project teams , gathering requirements, validating data, and ensuring that all end-use reporting needs are met.

What you will do :

• Partner with IT and business stakeholders to analyze and document data requirements for FDM continuity during the Lending Platform and LOS implementations.
• Support the development of ETL processes from new cloud platforms into the on-premise Finance Data Mart (FDM).
• Create and maintain data mapping, data flow diagrams, and documentation to support regulatory and financial reporting use cases.
• Conduct and coordinate User Acceptance Testing (UAT) for FDM data validation and reporting continuity.
• Review technical and process documentation and ensure alignment with overall program goals and compliance requirements.
• Collaborate with Data Engineers to validate data quality, transformation logic, and business rule application.
• Advocate for the Finance Data Solutions team's needs within the LPP and LOS programs.
• Support data automation strategies, integration design, and performance tuning for reporting datasets.
• Participate in design sessions to ensure technical solutions align with business requirements and FDM standards.
• Assist with change management, ensuring impacted business units are prepared for data and process transitions.
• Maintain detailed records and version control for data interfaces and transformations.

What makes you a good fit :

Snowflake - Cloud data warehousing and analytics

Why our employees love working at Pivotal :

We believe our strength comes from our differences, and as a Certified Minority-Owned Business (MBE) and a majority women-led firm, we are committed to fostering and promoting a culture of diversity and inclusion. We believe our team and our community are our greatest assets and we strive to promote both daily.

From providing our employees the time to pursue company -sponsored certifications, to supporting and partnering with multiple non-profit organizations brought forth by our employees (such as Food Lifeline, United Way, and the Seattle Humane Society), we are proud to support both our fellow Pivotalites and the causes close to their hearts.

As we grow, we are anchored and driven by our Four Core Values :

Compensation, Diversity and Benefit Information :

The pay range for this position in Washington is $50-$55 / hr. W2 plus benefits; however, base pay offered may vary depending on job-related knowledge, skills, candidate location, and experience.

Applicants must be currently authorized to work in the United States on a full-time basis. The employer will not sponsor applicants for work visas. The employer may not have resources available to support STEM OPT training requirements.

Pivotal Consulting is committed to creating and supporting a diverse and inclusive team and serving all communities. All qualified applicants will be considered for employment regardless of race, gender, gender identity or expression, sexual orientation, religion, national origin, disability, age, or veteran status.

Pivotal Consulting offers a comprehensive benefit package, including medical, dental and vision insurance, and 401k.