Job Description :
Title – Data Warehouse Systems Analyst (Finance)
Location – San Francisco, CA or San Jose, CA
Duration – 6 Months + renewals every 6 months (long term)
Job Description:
We are currently seeking an experienced, and highly-skilled Data Warehouse Business Systems Analyst (Finance) to join our Data Technologies team. In this role, you will participate in the full project lifecycle from definition through post-deployment for cloud-based data solutions. You will elicit and detail business and functional requirements, assess project progress and monitor the effectiveness of deployed initiatives. Key to this role is expertise in data mapping, data and reporting reverse engineering and process modeling.
Responsibilities:
Work on Finance data projects (SAP ERP, FP&A, Tax & Accounting) related to analyzing, migrating and transforming data from legacy sources to Enterprise Data Warehouse (Snowflake Role will be focused on data mapping and translating business requirements into data transformation rules (ETL) and analytics reports (Tableau
Acts as the liaison between IT and business stakeholders during data analysis, requirements definition and design activities for new solutions/projects.
Collaborates with business stakeholders to facilitate and document business requirements, use cases and functional specifications. Provides strategic advice for business processes and solutions.
Interacts with and directs technical partners (Data Engineers, BI Engineers, ERP analysts) to develop solution alternatives.
Generate use cases and participate in unit, regression and user acceptance testing.
Communicate complex data processes clearly and concisely both orally and in writing to technical and non-technical audiences.
Required Qualifications:
Bachelor’s degree in a technical field (e.g., computer science, information systems, engineering, statistics, math or related discipline
5+ years’ experience in Finance domain (SAP ERP, FP&A, Tax & Accounting)
5+ years’ experience working as a Business Systems Analyst on medium to large sized projects.
Good understanding of ETL concepts of data flow, data enrichment and transformation.
Significant experience with data modeling, data mapping and ability to mine and analyze complex financial data processes.
Proficient in SQL and writing database queries.
Proven experience creating business requirements documents and functional specifications and other BSA artifacts.
Must be highly detail oriented, meticulous, and self-directed.
Exceptional organizational, presentation and communication skills.