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.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 dataTake ownership of our existing automated ingestion pipelines and expand them to meet growing demand for new data sourcesBuild 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 computeEstablish and apply ingestion patterns (Auto Loader, sliding-window MERGE, versioned-forecast handling) as new sources are onboardedMonitor data flows so data arrives on time, with alerting that notifies downstream teams such as Energy Markets when there are interruptionsImplement automated data quality checks on incoming data so reports and models can be trustedMake data transformations more efficient to reduce platform processing costsArchitecture, Governance & Standards
Own bronze/silver/gold architecture decisions, including schema conventions, naming standards, and the table ownership modelEstablish 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 reportingManage access controls so people only see the data they should, while keeping data easy to find and trustedPlan how platform data and dashboards can be integrated with other systems and securely shared with customersScope and cost-estimate the onboarding of new data sources (SFTP, API, vendor CSV drops)Review cross-source data quality and lineage as the platform growsCollaboration & Communication
Work with external data providers and vendors, representing Rodan in those conversationsDemonstrate and explain what the platform makes possible to senior leadership and other non-technical audiencesExplore and introduce new Databricks capabilities, such as AI agents, that create new value from Rodan's dataSet the technical bar and share best practices on notebook and pipeline conventionsRequired 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 engineersHands-on experience delivering a data warehouse, data lake, or lakehouse project that centralized data from many sources for reporting, analytics, or machine learningDeep 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 patternsStrong 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 tablesExperience 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 addedConfidence being the most senior technical voice in the room from day one, while staying genuinely hands-on with codeExcellent communication skills, with the ability to explain technical concepts clearly to business stakeholders, senior leaders, and external vendorsPreferred Qualifications:
Databricks certification, such as the Databricks Azure Platform Architect accreditation or Data Engineer ProfessionalExperience 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 engineersRodan Role, Compensation & Benefits Include:
Hybrid: 3 days in office, Mississauga, OntarioProfit Sharing PlanComprehensive health benefits packageGroup RRSP with employer matchingBase salary range of CAD $115,000 to $140,000Life 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 View email address on ca.hrm.tc 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 View email address on ca.hrm.tc so we can work with you to meet your needs in a manner that respects dignity, independence, integration, and equal opportunity.
#J-18808-Ljbffr