Data Architect

Rodan-Energy-Solution; Mississauga; Hybrid; CAD 115,000 - 140,000; Full time

Benefits offered by this job

Profit Sharing Plan

Comprehensive health benefits package

Group RRSP with employer matching

Job summary

Rodan Energy Solutions is seeking a hands-on Data Engineer to shape the technical direction of a modern data platform. You will own bronze/silver/gold data layers, extend ingestion pipelines, and work with Databricks, PySpark, and SQL to deliver analytics-ready data for energy markets.

You will collaborate with leadership, external data providers, and data teams to implement scalable data architectures, governance, and best practices while driving cost-efficient transformations and data quality.

Qualifications

• 5+ years of data engineering with leadership experience
• Hands-on data warehouse/lakehouse project experience
• Deep Databricks experience
• Medallion architecture understanding
• Strong Python and SQL for end-to-end pipelines
• Clear ability to communicate with business stakeholders

Responsibilities

• Extend existing automated ingestion pipelines to meet growing data needs
• Own and expand bronze/silver/gold data pipelines across core sources
• Work in Databricks using PySpark, Delta Lake, and serverless compute
• Establish ingestion patterns and monitor data flows with alerts
• Implement automated data quality checks for reports and models
• Collaborate on governance, schemas, and data ownership
• Guide platform scalability as new data sources are added

Skills

Data leadership

Databricks

Python/SQL

ETL/ELT pipelines

Communication

Tools

Databricks

Python

SQL

Delta Lake

MLflow

Job description

About Us:

At Rodan Energy, our mission is Making Sustainable, Attainable. As a leading North American energy services company, we provide innovative energy solutions that help clients reduce energy costs and GHG emissions, support electrification, and enhance grid efficiency. With over 20 years of expertise, we’re trusted by North America’s largest energy users, power producers, and utilities.

Why Join Rodan:

• Thriving Industry: Join a rapidly growing sector at the forefront of innovation and sustainability, shaping the future of energy management.
• Product Market Fit: With a 98% client retention rate and consistent YOY growth, Rodan has built a reputation for delivering trusted, long-term partnerships with industry leaders.
• Top Talent & Strong Culture: Collaborate with high-performing, passionate individuals who are committed to excellence and sustainability.

What Makes This Role Great:

• Hands-On Technical Leadership: Set the technical direction for Rodan's Databricks data platform while staying hands-on with the pipelines, building on the ingestion foundation already in place.
• Built for Growth: Rodan is building out its central data platform to support a goal of 10x revenue growth in 5 years, centered on energy market optimization across IESO, AESO, PJM, NYISO, MISO, and ERCOT.
• Real Ownership and Visibility: Own the architecture, standards, and governance that the business relies on, and show senior leadership what new products and capabilities the platform can unlock.
• Modern Data Stack: Work in Databricks (Unity Catalog, Delta Lake, serverless compute, Lakeflow Connect/Auto Loader, MLflow, Genie) with Python/PySpark and SQL, deployed via Asset Bundles.
• Complex, Interesting Data: Multi-market electricity data covering demand response, coincident peaks, settlements, and asset optimization, plus a growing set of vendor feeds.

Key Responsibilities:

Hands-On Build

• Get up to speed on the existing automated ingestion pipelines and extend them to meet growing requests for new data
• Take ownership of our existing automated ingestion pipelines and expand them to meet growing demand for new data sources
• Build and maintain bronze/silver ingestion and transformation pipelines across core sources: market data, facility data, and a growing set of vendor feeds (weather, forward curves, broker statements)
• Work directly in Databricks using PySpark notebooks, Delta Lake, Databricks Jobs/Asset Bundles, and serverless compute
• Establish and apply ingestion patterns (Auto Loader, sliding-window MERGE, versioned-forecast handling) as new sources are onboarded
• Monitor data flows so data arrives on time, with alerting that notifies downstream teams such as Energy Markets when there are interruptions
• Implement automated data quality checks on incoming data so reports and models can be trusted
• Make data transformations more efficient to reduce platform processing costs

Architecture, Governance & Standards

• Own bronze/silver/gold architecture decisions, including schema conventions, naming standards, and the table ownership model
• Establish a governance model where every dataset has a clear owner, keeping curated data in the silver and gold layers and raw data out of business reporting
• Manage access controls so people only see the data they should, while keeping data easy to find and trusted
• Plan how platform data and dashboards can be integrated with other systems and securely shared with customers
• Scope and cost-estimate the onboarding of new data sources (SFTP, API, vendor CSV drops)
• Review cross-source data quality and lineage as the platform grows

Collaboration & Communication

• Work with external data providers and vendors, representing Rodan in those conversations
• Demonstrate and explain what the platform makes possible to senior leadership and other non-technical audiences
• Explore and introduce new Databricks capabilities, such as AI agents, that create new value from Rodan's data
• Set the technical bar and share best practices on notebook and pipeline conventions

Required Skills and Qualifications:

• 5+ years of data engineering experience, including a track record of technical leadership such as architecture decisions, standards-setting, or mentoring other engineers
• Hands-on experience delivering a data warehouse, data lake, or lakehouse project that centralized data from many sources for reporting, analytics, or machine learning
• Deep hands-on experience with Databricks (strong experience with a comparable platform such as Snowflake may be considered)
• Solid understanding of medallion (bronze/silver/gold) architecture patterns
• Strong Python and SQL skills, with experience owning ETL/ELT pipelines end-to-end, from raw ingestion (API, SFTP, file drops) through to modelled, analytics-ready tables
• Experience designing schema and table conventions and data models that other teams build on, with an eye to how the platform scales as new sources are added
• Confidence being the most senior technical voice in the room from day one, while staying genuinely hands-on with code
• Excellent communication skills, with the ability to explain technical concepts clearly to business stakeholders, senior leaders, and external vendors

Preferred Qualifications:

• Databricks certification, such as the Databricks Azure Platform Architect accreditation or Data Engineer Professional
• Experience with energy markets, trading, or utility data (not required; the domain is learnable)
• Leadership qualities and an interest in growing into a leadership role, such as leading projects or mentoring engineers

Rodan Role, Compensation & Benefits Include:

• Hybrid: 3 days in office, Mississauga, Ontario
• Profit Sharing Plan
• Comprehensive health benefits package
• Group RRSP with employer matching
• Base salary range of CAD $115,000 to $140,000

Life at Rodan - Our Culture:

• Celebrations Throughout the Year: We mark occasions and holidays all year long with team events including holiday parties, team dinners, bowling nights, go-karting, Annual Summer BBQ, golf tournaments, and more.
• Learning & Growth: Lunch and learns, crossword challenges, and education-funding programs to keep you sharp and growing in your career.
• Giving Back: Our Employee Initiatives Committee (EIC) organizes food drives and fundraising for local charities throughout the year - and everyone is welcome to get involved.

Apply Now:

If you’re a hands-on data engineer ready to shape the technical direction of a modern data platform, we want to hear from you!

Hiring Process

Rodan Energy's hiring process is designed to identify candidates who are the right fit: technically, culturally, and professionally. As part of our process, candidates should be aware of the following:

• Background Check: As part of our hiring process, the successful candidate will be required to complete a background check, which may include a criminal record check, credential verification, and a driver’s abstract (if applicable). Professional references will also be collected as part of the process.
• Assignment: Shortlisted candidates may be asked to complete a practical technical assignment. This is an opportunity to demonstrate how you approach data architecture design, pipeline trade-offs, and scaling a platform as new sources are added.

We respect your time and will provide clear instructions and reasonable timelines for any assignments requested.

Referral Bonus:

Do you know someone who would be a great fit for our team? We are offering a CAD $2,500 referral bonus for successful referrals that lead to a hire for this role, effective until further notice. Please connect with Jenny Dong at [e-mail].

Artificial Intelligence Disclosure

Rodan Energy may use artificial intelligence tools to support the screening, assessment, or selection of applicants during the recruitment process.

Vacancy Status:

This posting is for an existing vacancy.

Rodan Energy Solutions is committed to an inclusive, accessible recruitment and employment experience in compliance with the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). Accommodation is available upon request throughout the hiring process and, if hired, during employment. If you require an accommodation, please contact [e-mail] so we can work with you to meet your needs in a manner that respects dignity, independence, integration, and equal opportunity.