Senior Data Engineer

at  UTILASSIST

WHO WE ARE

Util-Assist is a leading consulting and services company to electric, water, and gas utilities, with customers throughout Canada and the United States. Utilities today are undergoing an exciting digital transformation; the widespread deployment of smart grid technologies and renewable energy sources is colliding with customer demand for electric vehicles, energy savings, and better customer experiences to produce a dramatic shift in how utilities do business. Util-Assist is at the forefront of that shift.
Our vision is to be the trusted partner in driving digital innovation that reshapes the utility landscape. To bring that vision to life, Util-Assist is leading the way in helping utilities take advantage of the latest developments in utility IT, with growing practices for data analytics and customer experience consulting building on our well-established smart grid procurement and implementation management services. Our managed services division leverages advancements in utility IT systems to deliver a variety of services to utility customers, including outage communications management, managed billing, and AI-enabled substation security monitoring.
Teamwork is key to the success of the Util-Assist family; mutual respect, cooperation, and honesty are hallmarks of our principles. We offer a range of energizing, multi-disciplinary careers in a high-tech industry, with great potential for development and advancement as both the industry and our company continue to grow. Util-Assist’s flexible work environment allows you to choose the work arrangements that make the most sense for you. We will give you the tools and support to succeed in our business, wherever you are.
At Util-Assist, we pride ourselves on cultivating a welcoming, positive, and inclusive workplace. Thanks to our outstanding culture, we are the proud recipients of several national and local awards, including certification as a Great Place to Work (three years running) by Great Place to Work Institute® Canada, the Employee Recommended Workplace Award (three years in a row), the York Region Business of the Year award, and the Newmarket Large Business of the Year Award.
Util-Assist is an equal opportunity employer. We are dedicated to providing a barrier-free work environment and ensuring all qualified applicants receive consideration for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Our commitment to diversity and inclusion is demonstrated through our policies and practices, aligning with the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). Join us to be a part of a team that values and celebrates diversity, and where your unique contributions can make a significant impact.
We’re excited to meet you! Learn more about Util-Assist at www.util-assist.com.

WHAT WE NEED:

We are seeking a talented Senior Data Engineer to join our team. The ideal candidate will be responsible for designing, building, and maintaining ELT (Extract, Load, Transform) pipelines for our utility customers. They will work closely with project managers, business analysts, and testers to deliver best-in-class data analytics solutions.

SKILLS

• Proficiency in SQL and data modeling
• Strong analytical and problem-solving skills
• Experience with data build tool (dbt) and Snowflake (or similar)
• Familiarity with BI tools (Tableau, Power BI)
• Understanding of data governance and security best practices

KNOWLEDGE/EDUCATION

• Knowledge of ETL/ELT tools and processes
• Deep knowledge of the modern analytics stack
• Experience with cloud platforms such as AWS and Azure
• Experience with a modern cloud data warehouse
• Familiarity with Agile methodologies is preferred

EXPERIENCE

• Bachelor’s degree in Computer Science, Information Technology, or a related field
• 5-10+ years of experience in similar role
• Experience working in a software development environment

• Mentor and provide guidance to junior data engineers
• Lead the design, development, and maintenance of ELT pipelines on Snowflake
• Collaborates with different stakeholders to understand business requirements
• Implement data engineering best practices within your designated agile pod
• Creates a library of reusable templates in dbt
• Acts as a subject matter expert for data analytics best practices
• Provides documentation for various audiences
• Participates in discovery and requirements gathering discussions as a technical subject matter expert
• Ad-hoc tasks as required.