Microsoft Dynamics 365 SR BSA

Job Description

D365 F&O SR. BSA role, starting immediate. Min. 1 year full time contract 9am to 5pm EST.

Job Description:

Role and Responsibilities

• Work with business data owners to understand their data and map it to D365 data entities

• Use D365 F&O Data Management module to review, import, and/or export data entities

• Assemble mapping workbooks for business data owners to map legacy data

• Write SQL queries to extract data from multiple legacy systems

• Analyse data to confirm accuracy and completeness

• Coordinate data cleansing activities data owners and develop intermediate cleansing rules/scripts

• Develop transformation techniques/scripts including applying business rules to data

• Transform legacy data as necessary to meet target data mapping requirements

• Load import files for D365 F&O

Qualifications and Education Requirements

• Familiarity with retail industry and sporting goods an asset

• Prior experience with other data migration efforts an asset

• Experience with D365 F&O an asset

Preferred Skills

• MS Excel

• MS SQL Server + SQL Server Management Studio

• Data modelling skills an asset

• Facilitation skills – ability to lead data discussions to arrive at specific outcomes

• Working knowledge of data structure best practices – hierarchies, attributes, properties, etc.

• T-SQL ,Transact

• Analytical skills

Experience in below modules:

System Administration

Organization Administration

General Ledger

Accounts Payable

Accounts Receivable

Cash and Bank Management

Fixed Asset

Budgeting

Cost Management

Tax Management

Cash Flow Forecasting

Travel and Expense

Time and Expense mobile apps

Sales and Marketing

Retail

Procurement and Sourcing

Product Information Management

Inventory Management

Mobile Inventory App