We’re looking for a Business Systems Analyst or Financial Planning Analyst.

• The person shall be very experienced exploring an 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.
• They must have a natural aptitude for analyzing, reconciling, and finding anomalies in the data and seeking out edge-cases outside the normal transaction flows.
• They shall be capable of exploring databases with SQL and Power BI and Excel to explore databases and reconcile what is in the database with what appears on the ERP screens.

A typical day includes:

• Learning how to use ERP screens and reports and do their own investigations and
• looking for the data need 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 suggesting alternative options.
• Run queries on the Datawarehouse and PowerBI to verify their mapping work and providing the data needed for reporting.
• Create mapping instructions containing:
  • The worked example from ERP screens and reports
  • One of more queries that reproduce their worked example, but map column for column to the target table in the existing data warehouse
  • Provide an example of the results set to prove the target results match the worked example
  • 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:

• Who cannot deliver unless they are allowed to re-architect the data warehouse.
• Who expects someone else to QA their results.
• Who is not willing to learn the screens and basic reporting features of the source ERP to a sufficient level to do their own QA.
• Who is not willing to engage with an offshore team  where the overlap is only 7-10 am and work with subject experts throughout the us eastern work day.
• Who 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.
• Who isn’t comfortable explaining their work to others or unscheduled walkthroughs of their deliverables at short notice.

During the interview process, the person shall:

• Fluently describe the order-to-cash, procure-to-pay, build-to-order life cycle in terms of the processes involved on a transaction-by-transaction basis.
• Be comfortable describing how wholesalers and resellers typically create value and how they make money.
• Be willing to participate in a practical assignment during the interview.

Budget: $20/hour

Experience: 5+ years

Shift Timings: Need EST overlapping