Data Analyst

Data Analyst
Remote, Ottawa, Ontario, Canada
Contract
Canadian Federal Government Security clearance is required

The Data Analysis service provider leads the design and implementation of data and technology solutions for the enterprise data platform. The selected candidate will be responsible for analyzing information requirements, recommending options for business and technology solutions, deliver blueprints for design, and implement them so they are aligned with client’s information strategies and governance standards.

Primary Responsibilities
•         Collects, documents, and analyzes information management and data requirements
•         Designs and implements data solutions using client’s data platform technologies
•         Creates, reviews and validates conceptual, logical, and physical data models of applications to determine compatibility and fit with architectural principles and optimal solution design.
•         Designs, creates and optimizes data flows for migration methods of existing data.
•         Works collaboratively with information governance analysts and data architects to ensure that data models and structures are compliant with governance standards.
•         Communicates requirements, issues, and options for resolutions to various stakeholders and tailors’ messages to the audience.

Specific Project Requirements
•         Understand existing applications, data stores and structures, data flows and elements.
•         Reverse engineer legacy ETL to modernize it for the enterprise data platform
•         Design and implement future state architectures and data solutions
•         Over 7 years of demonstrated experience in SQL programming and refactoring

Added Skills
Top Skills Required:
•         Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
•         Experience with reverse engineering legacy ETL builds (Data Manager) and source-to-target mappings to design and build future data assets
•         Well-rounded hands-on experience in the following data management domains: dimensional and relational data modeling, SQL programming and ETL development.
•         Experience in IBM Data Manager
•         Ability to understand, interpret, develop and maintain requirements and design documents
•         Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.

Assets:
•         Experience with ERWIN or similar data modelling tool
•         Experience with Denodo data virtualization
•         Experience with Power BI report development
•         Experience working in an Agile environment/team
•         Bilingualism in both official languages (English and French)

Please send your resume to jim.nickolson@noramtec.com.
Only candidates selected to be moved forward in the recruitment process will be contacted.