Senior Specialist Data Modeler

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Company: Independent Electricity System Operator

INDEPENDENT ELECTRICITY SYSTEM OPERATOR (IESO)

Requisition ID:  19793

Location:  Mississauga, ON (Hybrid)

Status:  Regular

Business Unit:  Information & Technology Services

You’ve got great skills. And you want to use them in an organization where you know what you do every day matters. We get that. 

We also know that ensuring Ontarians have access to affordable and reliable power doesn’t happen by accident. So we give you the tools, flexibility and support you need to achieve your goals, and development opportunities to help you grow. You’ll thrive in a collaborative, team-based environment that values your unique skills and experiences – and recognizes that when you do better, we become even better too.

Who we are 

The Independent Electricity System Operator (IESO) works at the centre of the province’s power system, ensuring Ontarians have access to reliable and cost-effective electricity when and where they need it. We operate the province’s electricity grid 24/7, design, run and oversee the wholesale electricity markets, and plan and prepare to meet Ontario’s electricity needs – now and into the future.

The opportunity

The primary function of the Senior Specialist, Data Modeler, is to translate complex business data into useable computer systems. This is primarily accomplished through analysis, assessments, and building conceptual, logical, and physical data models, and by partnering and collaborating with business users. This role will also be responsible for helping to develop any data governance requirements and defining standards/privacy requirements related to data modeling and the broader field of data management.

What you'll be doing

Data Modeling:

• Design, develop, and maintain conceptual, logical, and physical data models tailored to the unique needs of the electricity industry, ensuring scalability, performance, and data integrity for databases, operational data store, data warehouse, data marts, and data lakes on target platforms, in collaboration with business groups.
• Optimize data models for performance, scalability, and efficiency, utilizing techniques such as indexing, partitioning, and denormalization, as necessary.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Ensure data models adhere to industry standards, privacy and regulatory requirements.

Analysis:

• Conduct thorough analysis of business requirements, data sources, and existing systems to identify opportunities for data model optimization and enhancement.
• Identify and assess various data associated problems such as system configuration and integration on multiple platforms.
• Conduct data analysis to identify trends, patterns, and insights.
• Work with business units to identify relevant data components for business solutions.

Data Governance:

• Support operationalizing data governance policies and procedures to ensure compliance with regulatory requirements and industry standards, including data privacy and security regulations.
• Research, design, and establish data modeling standards to ensure consistency, reusability, and maintainability across projects and teams.
• Establish and steward the processes and procedures required to maintain traceability between all data sources and business interactions.
• Facilitate the creation of data quality requirements to be applied to all data sources.
• Establish procedures and controls to ensure the defined data quality requirements are applied to all data sources across the enterprise.
• Define methodologies and approaches for implementation of data modeling to enable effective use of the enterprise’s information assets for business intelligence, predictive/reactive analytics, business rules, data warehouse and data mart solutions, data migration, ETLs, backup and archiving.
• Provide expertise and guidance on best practices for data modeling, metadata management, and governance within the electricity industry.
• Implement metadata management strategies to ensure data quality, consistency, and lineage across systems and processes.

Documentation:

• Create comprehensive documentation for data models, including entity-relationship diagrams, data dictionaries, and metadata, to facilitate understanding and promote knowledge sharing.
• Design, establish, maintain, and report on key performance metrics internally as appropriate.
• Prepare and maintain all documentation related to data modeling, including processes, procedures, standards, frameworks, instructions, etc.
• Collaborate with Solution Architects, Information Architects, business process stewards, and IT solution stewards to create, deliver, and maintain necessary documentation.

Collaboration and Communication:

• Work closely with cross-functional teams including data engineers, analysts, and business partners to understand data requirements and develop models that align with corporate and business objectives.
• Foster a culture that “values data as an asset” within the IESO.
• Partner with other organizational IT architects (Solutions, Enterprise, etc.) to provide expertise, guidance, and content to address data requirements and ensure alignment within the enterprise data management strategy and standards.
• Act as a mentor to associates to advance their learning and facilitate their problem-solving skills within their respective areas of expertise.

Emerging Technologies:

• Stay abreast of industry trends and emerging technologies in data modeling, database management, and analytics to continuously improve processes and methodologies.
• Stay informed about advancements in data modeling techniques and technologies relevant to the electricity industry.

Perform other duties as required.

What You Need to Succeed

Education:

• This knowledge is normally acquired either through the successful completion of a four-year university degree in the appropriate field/discipline (Computer Science, Data Science, Information Systems) or by having the equivalent experience.
• Requires knowledge of applied mathematics, computer science and the like to conduct data modeling assessments and provide recommendations.
• Requires knowledge of technical writing to prepare effective reports.
• Knowledge of the mathematical foundations of statistical inference and forecasting such as time series analysis, multivariate analysis, cluster analysis, and optimization
• Good knowledge of metadata management, data modeling, and related tools

Experience:

• The minimum level of experience for the incumbent to perform at a satisfactory level of proficiency is generally 8-10 years.
• Proven experience in data modeling, with a focus on the electricity industry or related domains.
• Requires significant exposure to the application of database systems and technology to the areas of big data modeling, development of physical data bases, development of stored procedures and other databases, data base administration.
• Experience and advanced understanding of enterprise data modeling & architecture concepts, methodologies, and standards.
• Experience with data issue identification, analysis, and remediation.
• Experience with complex technology systems implementations that involve data persistence, transformation, distribution, and consumption.
• Required areas of expertise to include Information/Data Management, Data Analysis, Data Warehousing, Business Intelligence, Design and Implementation of Relational Databases and Reporting Solutions, translation of business requirements into system requirements.
• Advanced skills with SQL and database systems such as Oracle, SQL Server, Mongo, and MySQL.
• Ability to relate architectural decisions and recommendations to business needs.
• Expertise in data modeling principles/methods including conceptual, logical & physical Data Models.
• Experience in translating/mapping relational data models into XML and Schemas.
• Hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
• Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
• Experience with Anaconda/Python, Informatica, and Tableau an asset.

What’s in it for you

• A comprehensive total rewards program, including best-in-class benefits and a flexible workplace 
• A challenging, fast-paced and collaborative team environment, where your perspectives and experiences matter 
• Leaders who support your growth and success through regular feedback and coaching 
• The opportunity to work with some of the brightest minds in the industry 
   

Deadline: June 17, 2024 at 11:59PM

For future reference, please ensure to save a copy of the job description as it will no longer be available once the posting closes.

At the IESO, we know that achieving great results depends on embracing diversity by attracting, developing and retaining people from a wide variety of backgrounds. We do this by ensuring our recruitment and advancement policies are fair and equitable, and by creating an accessible and inclusive environment – one that values every team member’s unique skills and experiences and ensures they have the support they need to achieve their potential. If you require accommodation during the recruitment process, please let us know. 

We thank you for your interest in a career at the IESO, but we will only contact those candidates selected for an interview. 

Note: The successful candidate must be eligible to work in Canada and will be subject to a background check.

The IESO offers a hybrid work model program to most of our employees, based on business needs. Individuals participating in the program can work an average of three days per week remotely within Ontario. It also offers three flex weeks when individuals can work remotely within Ontario . When working in the office, you will be located at our Mississauga, ON location.

Join our talent community

Sign up for talent community; stay in touch, find out about new opportunities – and discover how you can make a difference. Discover how we use our expertise and commitment to deliver reliable and affordable electricity to Ontario’s businesses and communities, and how we’re innovating to secure a stronger energy future for all Ontarians. Visit Careers at IESO  and be sure to follow us on LinkedIn .

Find out why we were selected as Greater Toronto’s Top 2024 Employers , and what we offer.