Junior Data Modeler Jobs

Experience with Kubernetes for container orchestration and management.

Experience in Kafka for real-time data streaming and event-driven architecture.

Knowledge of programming languages such as Python, Java, or Scala.

Familiarity with data warehousing concepts and tools.

Understanding of SQL and NoSQL databases.

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

Work with clients to provide process improvements to enhance data management and ensure quality assurance of project and donor data.

We offer a Health Spending Account so you can cover the cost of your healthcare needs in a flexible way.

You'll get many opportunities to grow your experience so that you can build your resume in a fun & exciting way.

You have training or experience (formal or informal) in data programming or coding.

Develop and run scripts in Python or a similar language to prepare Fundraising metrics to help clients understand their fundraising data.

Company Values matter a lot to you, and for us, they're the most important factor in hiring and firing.

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

Mapping and transforming data using various techniques (ex. XSLT, MapForce, scripting, etc.) based on customer input and requirements

Experience in working on data transformation or development projects

Experience in working with SQL/TSQL

Experience in working with XML and related tools (ex. XSL/XPath)

Experience in working with a scripting language (ex. Bash/JavaScript/Python/Perl/etc.)

1. Technical knowledge in SQL/TSQL,MSSQL, Oracle, MySQL, etc

• 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.

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

Follows all project and institutional protocols regarding the handling of research data, including confidentiality protocols and appropriate data management and storage.

Demonstrates a commitment to enhancing one’s own awareness, knowledge, and skills related to equity, diversity, and inclusion

Checks and validates the new data entry modules for errors.

Programs and maintains electronic data capture projects in REDCap.

Writes reports in REDCap and Excel (e.g., retention reports, data quality, study visits) for PIs, project coordinators, and statisticians.

Performs regular data cleaning and quality checks to ensure accuracy of visit and scheduling data for longitudinal cohorts.

Experience creating and maintaining data integration workflows between different systems, databases, and applications

Experience developing and maintaining data pipelines to extract, transform, and load (ETL) data from various sources into centralised data storage systems

Experience performing data cleaning, preprocessing, and transformation tasks to ensure data quality and consistency

Experience in data visualisation or analysis

Experience working with user data, with student (13-18) data being beneficial

Experience working across multiple stacks, include LAMP

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.