Data Analyst

In 2021 our client embarked on a digital transformation journey to become a more customer focused digital organization. Key to achieving the digital transformation is the data and analytics strategy.In 2021 our client embarked on a digital transformation journey to become a more customer focused digital organization. Key to achieving the digital transformation is the data and analytics strategy.

Over the last year, to enable the Digital transformation and data analytics strategy, our client has invested in developing a consolidated enterprise data platform on Azure cloud.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. The individual is experienced in information requirements collection and analysis, data modeling, and data integration.

The data analysis service provider needs to quickly come up to speed on current state information architecture and familiarize themselves with client's information management context.Primary ResponsibilitiesCollects, documents, and analyzes information management and data requirementsDesigns and implements data solutions using client's data platform technologiesCreates, 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 RequirementsUnderstand existing applications, data stores and structures, data flows and elements.Reverse engineer legacy ETL to modernize it for the enterprise data platformDesign and implement future state architectures and data solutionsOver 7 years of demonstrated experience in SQL programming and refactoringTop Skills RequiredStrong 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 assetsWell-rounded hands-on experience in the following data management domains: dimensional and relational data modeling, SQL programming and ETL development.Other Skills RequiredExperience implementing medallion architecture in DatabricksProgramming experience in SQL, Python and Apache SparkValidation/ testing of developed data solutions by comparing to existing or proxy datasetsExperience with Microsoft Azure or other public cloud offeringsExperience in Agile deliveryExperience in IBM Data ManagerAbility to understand, interpret, develop and maintain requirements and design documentsExcellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.AssetsExperience with ERWIN or similar data modelling toolExperience with Denodo data virtualizationExperience with Power BI report developmentExperience working in an Agile environment/teamBilingualism in both official languages (English and French)