Data Modeler Designer Jobs

Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required

Previous experience in Wealth management and/or banking systems highly desirable

Communicate with Data Analysts, interfacing application teams & Business stakeholders and understand data requirements for consuming applications.

Experience with data hub, data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required

Expert knowledge of relational databases and data architecture computer systems, including SQL

Ideally 5+ years' experience in technical system analysis, data mapping and translating/mapping relational data models into XML and Schemas

Experience with dependency management, change management, continuous integration testing tools, and audit/compliance requirements

Demonstrated leadership and management skills

Job Title: Data Modeler with Strong hands-on SQL experience.

8+ years of relevant experience in Data modeling, RDBMS, SQL (Oracle SQL, PL/SQL)

3+ years of hands-on experience in developing ETL solutions

Experience in Data warehousing, data analysis, database design, and ETL concepts

Work with business users to obtain data requirements and analyze source systems data.

Manage data integrity and data quality.

Ability to translate business needs into technical solutions. Strong analytical skills.

Strong SQL and Erwin (modeling) skills.

Knowledge of data architectural approaches, patterns, and emerging technologies.

Experience creating architecture and strategy artifacts.

• Ability to translate business needs into technical solutions. Strong analytical skills.

• Strong SQL and Erwin (modeling) skills

• Knowledge of data architectural approaches, patterns and emerging technologies

• Experience creating architecture and strategy artifacts

· Experience of xml, json and Hive (Hadoop)

· Experience working in Agile environment

Experience with metadata management and related tools

4+ years Data Modelling experience on cloud data warehousing platforms

Expert knowledge with data mapping, transformation, SQL and implementing physical and relational data models

Experience with MSSQL or Oracle database

Flexible health benefits and wellness program

Training programs to build new and transferable skills

• Experienced with Workflow Management Tools: Airflow, Crontab, CA Workload Automation

• Previous work experience in the financial sector (insurance or benefits industry)

• Experienced with working on Structured and Semi-Structured datasets

• Experienced in creating data pipelines & developing complex and optimized queries

• Experience with implementing CI / CD pipeline on GitHub, Jenkins / JGP

• Experience writing complex SQL and NoSQL jobs to analyze data in traditional DBMS (MS-SQL, Oracle) environments

·Understanding and experience working with corporate finance and accounting data models for banks and financial institutions

Data Architect for designing finance data platform.

·Document the nonfunctional requirements for data platform

·Data Architecture experience in choosing tools and technology stack

·Prior experience in designing data platform

·Nice to have - Experience across wide range of tools and technologies for data platforms

·Create data model for a finance data platform for a bank

·Standardize corporate finance dimension hierarchy across countries – US, Canada etc.

·Significant experience in data modeling for data platforms

·Experience with data modeling tools like ERWIN, SAP Power Designer etc.

Location: anywhere is USA/Canada - need to work from any nearest BMO office.

·Needed - Understanding of FIBO

- Advanced knowledge of SQL, knowledge of Base SAS (data step), some knowledge of Python and R

- Must demonstrate proficiency and show experience in the above

- Experience working with databases

-Knowledge of statistical modeling and machine learning tools

-Past experience in P&CB or Business Retail Banking would be an asset

Analyze large data sets and representing client behavior

Data remediation - remediate data management gaps

Good understanding of data management concepts and practices, such as data quality, metadata management, data lineage, data integration, data governance, etc.

Create and maintain data dictionaries, data lineage, metadata and other documentation related to data models and data management processes.

Excellent analytical and problem-solving skills, with the ability to identify and resolve complex data modeling issues and challenges.

Built data models front to back, designing it into a database or in a tool

Help the client understand what the data logical model will be

Client: Big Five Bank, Enterprise Data Management Office

Good understanding of data management concepts and practices, such as data quality, metadata management, data lineage, data integration, data governance, etc.

Excellent analytical and problem-solving skills, with the ability to identify and resolve complex data modeling issues and challenges.

Terms: 6-month Contract to Hire. Must convert full-time.

Location: Hybrid, 1-2 days in office per week.

Strong proficiency in data modeling techniques and tools, such as ERwin, Purview, PowerDesigner, etc.

Strong organizational, time management and project management skills

Demonstrated conflict resolution skills, problem solving abilities and professional judgement

Inventor certified with thorough knowledge of building systems assemblies, libraries, I-logic, I-Features and Content Center

5 years of experience in using Autodesk Inventor software

In depth knowledge of an Inventor supported manufacturing process

Excellent interpersonal, communication and presentation skills

Knowledge of database management systems such as Oracle, SQL Server, etc.

Collaborate with cross-functional teams to gather and analyze data requirements

5+ years of experience in data modeling

Strong knowledge of Logical and physical data modeling

Experience using data modeling tools like Erwin

Strong analytical and problem-solving skills

Advanced knowledge and hands-on experience working with SQL (pulling and processing data)

Knowledge and hands-on experience with Base SAS (data step)

3-5 years of experience (will look at candidates more senior if we can find them)

• 2-4 years experience in related digital product development or data mining role

• Advanced knowledge of R, Python, SQL or SAS

• Knowledge of web and mobile development processes

Demonstrable experience with data modelling tool – Erwin.

Strong analysis and SQL skills for querying data.

Understanding of modeling strategies (Relational, Dimensional, Unstructured)

SQL And Erwin is required.

• Understand clients’ business planning & performance management processes and related business requirements.

Vancouver, Canada (Remote is good too)

• Anaplan certification of L1,L2 & L3 and Solution Architect (Mandatory)

Job Title – Anaplan Modeler

Hire Type: Fulltime/ Permanent Hire

Should be able to optimize Anaplan models using best practices such as PLANUAL 2.0 and DISCO approach.

A desire to grow professionally through training and certifications.

An Interest in energy efficiency and sustainable development.

Familiarity with LEED®, Zero Carbon Building and/or Passive House.

A Degree in Mechanical or Electrical Engineering or Diploma in Engineering Technology is required for this position.

Preference will be given to individuals who have:

M&R Engineering is an equal opportunity employer, committed to equity, diversity and inclusion.