Data Analyst

Description:

The department has a requirement for an experienced data analyst to participate as part of a team for our ONE Education data migration activities. This will involve data migration from legacy systems, assisting with the go-live, and sustainment. Salesforce Service Cloud or Public Sector Cloud knowledge and experience are highly desirable.

Responsibilities of the role will include, but not be limited to:

• Develop an expert understanding of the data model, including validations, for the new Salesforce solution build by performing knowledge transfer from the build team.

• Assist the data migration team with the preparation of the data migration mapping from the legacy SQL databases to the Salesforce data model.

• Assist the data migration team with merging, cleansing and validating of the SQL database data.

Essential criteria:

To fulfil the responsibilities of the role, the following criteria are considered essential:

• A strong understanding of entity-relationship database design concepts and demonstrated experience designing enterprise-level databases.

• Demonstrated experience designing complex queries for SQL Server.

• Experience validating and cleansing data.

• Experience migrating data between SQL Server databases.

• Ability to work with a dynamic team in a fast-paced environment.

• Experience with data migration patterns, processes, and/or tools.