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:

Bachelor’s degree in a technical, analytical, or related discipline, or equivalent work experience.
5+ years of experience as a Business Analyst or Data Analyst working with business applications and data integration projects.
Strong understanding of ETL concepts, data flow design, and relational database structures.
Working knowledge of SQL for querying and validating data.
Experience with project methodologies including Waterfall and Agile.
Proven ability to translate business requirements into functional and technical specifications.
Strong analytical, problem-solving, and documentation skills.
Excellent verbal and written communication skills, with the ability to communicate effectively with both technical and non-technical stakeholders.
Demonstrated ability to manage multiple priorities and complex projects in a fast-paced environment.
Familiarity with data governance, data lineage, and regulatory reporting requirements preferred.
Availability for occasional after-hours support and on-call response as needed.
Experience or familiarity with the following is highly preferred:
- Snowflake – Cloud data warehousing and analytics
- Azure Data Factory (ADF) – Data pipeline orchestration
- Python – Data processing and automation
- SSIS (SQL Server Integration Services) – Legacy ETL processes
- SQL Server – Data querying, transformation, and validation

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:

Be Engaged – We are present, committed, and accountable to our clients and to each other.
Consistently Deliver – We are dedicated and reliable by consistently delivering excellence.
Always Better – We continuously evolve, inspired to drive beyond the everyday norm.
Do Happy – Be passionate and bring fun and creativity into everything you do.

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.