What are the responsibilities and job description for the Business Systems Analyst / FPA position at Upwork?
Company Description
Our client is a top-tier enterprise client in the commercial doors and electronic access control arena.
They are looking for a Business Systems Analyst or Financial Planning Analyst.
Job Description
A typical day includes :
Learning how to use ERP screens and reports and do their own investigations and
looking for the data needed to create mappings between the ERP data and what is needed for the data warehouse.
Articulate with actual samples any difficulties in reconciling the ERP data to what is required for the data warehouse and suggest alternative options.
Run queries on the Datawarehouse and PowerBI to verify their mapping work and provide the data needed for reporting.
Create mapping instructions containing :
o The worked example from ERP screens and reports
o One of more queries that reproduce their worked example, but maps column for the column to the target table in the existing data warehouse
o Provide an example of the results set to prove the target results match the worked example
o Advise of any caveats and limitations of use of their work.
QA the results end-to-end, not only to the data warehouse, but to the Power BI datasets too, and provide remediation instructions, or explain limitations of use to the FPA team
This project is not a fit for those :
Cannot deliver unless they are allowed to re-architect the data warehouse
Expect someone else to QA their results.
Not willing to learn the screens and basic reporting features of the source ERP to a sufficient level to do their own QA.
I am not willing to engage with an offshore team where the overlap is only 7-10 am and work with subject experts throughout the eastern US work day.
If there is ambiguity they cannot work with, is uncomfortable asking pointed questions to understand the Acceptance criterion and make explicit what is vital versus nice-to-have.
Not comfortable explaining their work to others or unscheduled walkthroughs of their deliverables at short notice.
Qualifications
Experienced in exploring ERP system's order-to-cash screens, running reports, and relating what they see on the screen to where it may appear in the application's database.
Must have a natural aptitude for analyzing, reconciling, and finding anomalies in that data and seeking out edge cases outside the normal transaction flows.
Should be capable of exploring databases with SQL, Power BI, and Excel.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Business Systems Analyst / FPA?
Sign up to receive alerts about other jobs on the Business Systems Analyst / FPA career path by checking the boxes next to the positions that interest you.
