Senior Data Modeler – Azure & Investment Data Architecture

Recrute Action; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A recruitment agency is seeking a Data Modeler in Toronto to support data strategy and manage data assets. The role involves creating and optimizing data models, collaborating with business stakeholders, and ensuring data quality. Ideal candidates have at least 5 years of IT experience and expertise in data modeling related tools. This full-time job offers a hybrid work schedule and competitive salary of $75-$85 per hour.

Qualifications

• Solid experience with BI and data warehousing technologies.
• Minimum 5-8 years of IT experience, with at least 4 years in data model design.
• Expertise with Big Data technologies and analytics.

Responsibilities

• Understand and translate business needs into data models.
• Interact with partners to design data models and schemas.
• Collaborate with teams to implement data strategies.

Skills

Databases

Data Analytics

SQL

Power BI

Data Management

Data Analysis

Analytics

Education

Bachelor's degree in computer science or related field

Tools

Power Designer

Erwin Data Modeling tools

Job description

Our client is seeking a Data Modeler reporting to the Director of Information Architecture. Located in Toronto, Canada, the role focuses on supporting the data strategy for the Investment Data Lake and building out its data assets.

What is in it for you :

• Salaried: $75-85 per hour.
• Incorporated Business Rate: $91-101 per hour.
• 6-month job assignment.
• Full-time position: 37.50 hours per week.
• Weekday schedule from 9 am to 5 pm.
• Hybrid work: in-office Tuesday to Thursday.
• Opportunity to work in a dynamic and professional environment.
• Join a passionate and inclusive team of professionals.

Responsibilities :

• Understand and translate business needs into data models supporting long-term solutions.
• Interact with business partners, stakeholders, functional experts, business analysts, contractors, and developers to understand system requirements and design data models and database schemas.
• Collaborate with the Application Development team to implement data strategies, build data flows, and develop conceptual data models.
• Create logical and physical data models using standard methodologies to ensure high data quality and reduce redundancy.
• Optimize and update data models to support projects.
• Maintain data models and metadata.
• Develop standard methodologies for naming conventions and coding practices.
• Communicate effectively during project execution regarding data models.
• Understand and articulate data model interdependencies and constraints.
• Recommend opportunities for reuse of data models.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and databases for discrepancies.
• Have understanding of OLAP reporting and analytics principles.
• Own data definitions and maintain data lineage.
• Validate business data objects for accuracy and completeness.
• Analyze system integration challenges and propose solutions.
• Develop data models according to company standards.
• Guide system analysts, engineers, programmers, and others on project limitations and capabilities.

What you will need to succeed :

• Bachelor's degree in computer science, information systems, or related field.
• Solid experience with BI and data warehousing technologies, RDBMS, Hadoop, and analytics environments.
• Minimum 5-8 years of IT experience, with at least 4 years in data model design.
• Expertise with Big Data technologies, Data Bricks, BI, and data warehousing.
• Strong data analysis and modeling skills, with hands-on ownership.
• Experience with Azure solutions and SQL.
• Proficiency with Power Designer / Erwin Data Modeling tools.
• Familiarity with Capital Markets data.
• Excellent verbal and written communication skills.
• Results-oriented with a strong work ethic, attention to detail, and accuracy.

Why Recruit Action :

Recruit Action (agency permit: AP-2504511) offers recruitment services with personalized support. Only candidates matching the criteria will be contacted.

Key Skills :

• Databases, Data Analytics, Microsoft Access, SQL, Power BI, R, Tableau, Data Management, Data Mining, SAS, Data Analysis, Analytics.

Employment Type : Full Time

Experience : 5+ years

Vacancy : 1

Monthly Salary: $75 - $85