Data Modeler

Accuro; Mississauga; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading company in the Information Services industry is seeking a mid-senior level Data Modeler to design and implement comprehensive data solutions. This role involves creating and optimizing data models using both traditional and NoSQL databases to directly support enterprise information management. Candidates should possess substantial hands-on experience with data technologies like RDBMS and Bigdata-Hadoop along with strong team management and communication skills in a hybrid work environment.

Qualifications

• 10+ years of hands-on experience with data platform technologies.
• Working experience with data warehousing and enterprise big data platforms.
• Ability to work in a fast-paced environment.

Responsibilities

• Develop and implement data models and data architecture solutions.
• Oversee data architecture, ensuring high data quality.
• Work with teams to translate business needs into data models.

Skills

Data modeling

Communication

Team management

Presentation

Organizational skills

Education

Bachelor's or Master's degree in computer/data science

Tools

RDBMS-MS SQL Server

ERWIN

Visio

Bigdata-Hadoop

NoSQL-Hive

Job description

Direct message the job poster from Accuro

Staffing Expert/ConsultantUSA Resources Provider | Service Provider| Business Development | Business Relationship Management | Client Relationship…

Role: Data Modeler

Location: Mississauga (Hybrid/3 days onsite)

Job Type: Full Time Permanent

Job Description:

The data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL-Hive databases. These solutions support enterprise information management, business intelligence and other business interests.

The successful candidate will:

• Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS-MS SQL Server, data marts, and data lakes on target platforms (SQL/NoSQL).
• Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and as part of a team.

Responsibilities

• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational-MSSQL Server, dimensional, and NoSQL-Hive) and data tools (reporting, visualization, analytics).
• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
• Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
• Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
• Understand and translate business needs into data models supporting long-term solutions.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Recommend opportunities for reuse of data models in new environments.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Review modifications to existing scripts to improve efficiency and performance.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.

Qualification/Skills

• Bachelor’s or master’s degree in computer/data science technical or related experience.
• 10+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS-MS SQL Server, dimensional, NoSQL-Hive) data platform technologies, and ETL and data ingestion protocols).
• Working experience with Data modeler tool- ERWIN, Visio
• Experience with data warehouse, data lake, and enterprise bigdata platforms required.
• Working experience with MS SQL server and Bigdata-Hadoop required.
• Good knowledge of metadata management, data modeling, and related tools required.
• Experience in team management, communication, and presentation.
• Ability to work in a fast-paced environment.
• Excellent presentation, communication, and organizational skill.

Have exposure working with agile development methodology

Thanks & Regards,

Beauty Rani |ACCURO GROUP|

Direct: 919-676-8033

EMAIL [e-mail]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Information Services

Referrals increase your chances of interviewing at Accuro by 2x

Sign in to set job alerts for “Data Modeler” roles.

Data Labeling Associate - 6 Month Contract

Data Quality Analyst (Fraud Investigation)

Toronto, Ontario, Canada CA$40.00-CA$43.00 23 hours ago

Part-time Data Quality Analyst (Fraud Investigation)

Toronto, Ontario, Canada CA$104,000.00-CA$114,000.00 13 hours ago

Sr. Meter Data Management Analyst (1-Year Contract)

Freelance Data Analyst (Python) - AI Trainer

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.