Data Architect

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.

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

• 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

• 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

• 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

• 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

• 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

• 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

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

• 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 jenny.dong@rodanenergy.com.

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 Asmin.Shadir@rodanenergy.com so we can work with you to meet your needs in a manner that respects dignity, independence, integration, and equal opportunity.