Job Summary
Are you passionate about shaping the foundation of data-driven decision-making? We are seeking a skilled Expert Data Modeler to join our talented team.
The role oftheExpert Data Modeleris to lead the collection of business requirements to be translated into efficient data structures, while ensuring data integrity and usability.
A core responsibility of this role is to design, implement, and maintain data models that serve as the backbone of our organization's data infrastructure.
You will also be a key contributor of a center of excellence to set data design standards for the practice. TheExpert Data Modelerbrings technical expertise to ensure data integrity, quality and accuracy.
Main Responsibilities
- Understand and translate complex business data and analytics requirements to lead the hands-on creation of conceptual, logical and physical data models
- Lead the definition of source to target mappings to describe data transformations
- Assess and produce data analytics artefacts including data model, mapping, data flows, data lineage, metadata documentation and transformations, ensuring the integration in the technical architecture and the alignment with data quality and governance guidelines
- Perform profiling and data analysis using advance SQL / Python techniques on multiple platforms, including Databricks, Netezza, SQL-Server, Oracle, etc.
- Participate in the delivery and support of data quality, data consolidation and data migration initiatives
- Perform design reviews and improve the effectiveness of data design and management
- Lead the data analytics design practice by defining and maintaining standards and best practices
- Provide guidance, onboarding and mentorship to new data designers
- Lead the troubleshooting of data issues within the business and present solutions and recommendations
- Collaborate with various stakeholders including Architecture, Data Engineers, Product Management, DBAs, Infrastructure and Data Governance teams
Requirements
Education and experience
- Bachelor’s degree specializing in Mathematics and Statistics / Computer Science / Business Analytics / or other quantitative field, related degree or equivalent experience
- 10 years and more overall work experience
- Minimum 5 years of data design and data modeling experience
- Strong experience in requirements gathering, process analysis and workflow modeling
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
- Experience in leading and participating in business workshops and business presentations
Skills and Competencies
- Experience with data design tools (Erwin Data Modeler or similar version)
- Experience with dimensional modeling and relational database modeling techniques
- Advanced SQL skills to support data profiling, unit testing and data extraction
- Experience in a Data Lake, Data Warehouse / Business Intelligence or relevant data environment
- Proficiency working with Azure Data Lake (ADLS), Azure Data Factory and Databricks
- Experience working with DevOps CI / CD, Azure DevOps or GitHub
- Exposure to data modeling and data architecture best practices
- Expert ability to identify data gaps and assess end-to-end data requirements
- Ability to learn quickly, problem solve / troubleshoot, work independently or in a team
- Excellent verbal and written communication skills and the ability to interact professionally with a diverse group
Assets
- Experience in real time data streaming and loading
- Experience modelling data for data science projects
- Experience working with Scale Agile Methodology (SAFe)
- Experience with semi-structured and unstructured data
- Familiar with Data Lakehouse architecture
This position is posted as a grade LEVEL 7. For internal candidates, note that the grade level of the position may adjust based on the employee's experience.