Power Markets Data Engineer

1 month ago

Cornwall Ontario KC, Stormont, Dundas and Glengarry, Canada Liberty Utilities Full time

Purpose
The mandate of the Energy Services (ES) team is to maximize the company's risk adjusted asset return by providing portfolio management (hedging/optimization) and market advisory services. The ES team consists of three pillars:

  1. Portfolio Management (Trading/Hedging)
  2. Client & Asset Support
  3. Market Analytics

Reporting to the leader of Market Analytics, the Data Engineer will contribute to the architecture, engineering, development and adoption of LPCo's “Big Data” ecosystem. This data and analytical platform serves the needs of various lines of businesses spanning economic, risk and financial analysis as they relate to LPCo’s profitability, competitiveness, and growth opportunities. The Data Engineer will support and provide expertise in data ingestion, wrangling, cleansing, and technologies. In this role, they will work with relational and unstructured data formats to create analytics-ready datasets for analytic solutions. Our data infrastructure runs on Azure built with Python microservices in Snowflake for business analytics.

Accountabilities

  1. Build efficient data pipelines for market, transactional and generation data.
  2. Responsible for transforming raw data into a format usable by downstream applications that serve both analytical and operational use cases. This entails in-depth knowledge of distributed systems and computer science.
  3. Organize, implement, and enforce correct data collection policies and methods.
  4. Ensure the proper functioning of data collection software and applications at all times.
  5. Make sure that data collection procedures are in line with all relevant rules and guidelines.
  6. Gather fundamental power market, transactional and generation data from multiple sources/systems and implement in a database seamlessly.
  7. Create and integrate APIs.
  8. Responsible for data wrangling, extraction, data security, discovery, and control.
  9. Demonstrate Best Practices in data science/software development such as use of repositories, schema, and data flow diagrams.
  10. Collaborate with and across teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies.
  11. Perform unit tests and conduct reviews with other team members to ensure your code is rigorously designed, elegantly coded, and effectively tuned for performance.
  12. Support development of short, medium, and long-term energy marketing analytical tools.
  13. Support the development and automation of standardized reports (position, MtM, etc.).
  14. Ensure output of data is accurate and in a useful format for end-use customers (Traders, Executives, etc.).
  15. Responsible for scripting, reporting, and data visualization.

Education and Experience
Preferable Masters Degree in Data Analytics, Computer Science, Engineering, or a related field.
3-5 years in a data engineer or data analyst role.
Ability to quickly understand and conceptualize business requirements and deliver insightful, fact-based solutions to meet those requirements and build out tools in Python.
Advanced Programming knowledge is a requirement.
Experience with Snowflake's infrastructure and advanced skills in Python and Excel is a must.
Strong data structure, data modeling, and analysis skills including in-depth knowledge of SQL, R, and Python coding.
Knowledge of Power Market Fundamentals (supply, demand, reserve margins, forward/settled prices) is preferred but not a requirement.
High degree of motivation and flexibility, ability to manage competing priorities and meet tight deadlines.

Years of Experience
3-5 years of experiences.

Our purpose is sustaining energy and water for life, and it is demonstrated in everything we do as a business and as an employee team.

Our Mission
We provide safe, secure, reliable, cost-effective, and sustainable energy and water solutions. Our mission is how we create value as an organization—it is what drives us every day to fulfill our purpose.

Our Vision
We better the lives of our customers and communities. Our vision is what we see as possible. It's where we aspire to be, what we want to achieve, and how we'll make an impact. It guides and keeps us on the right path as we work towards fulfilling our purposes.

Our Guiding Principles

  • Customer Centric
  • Integrity
  • Entrepreneurial
  • Teamwork
  • Owner mindset
  • Outcome focused
  • Continuous learning

What we offer

  • Collaborative environment with a genuine flexible working policy
  • 401k Plan with matching
  • Company funded Pension program
  • Share purchase/match plan
  • Leadership Development Program
  • Volunteer paid days off
  • Employee Assistance Program
  • Achievement fund
  • Free parking
  • Variety of Health & Wellness programs
  • Discount and Perks program
#J-18808-Ljbffr

  • Apprentice Infrastructure Engineer

    1 month ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Breath HR Full time

    Can you envisage yourself working with South West’s leading managed service provider? How about a company that puts people before technology and allows you to shape your own work environment? If you have the passion, motivation, and dedication to provide first-class customer service, you may be what we’re looking for. Join a team that is committed to...

  • NOC Engineer

    1 month ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Breath HR Full time

    The Network Operations Centre (NOC) Engineer has three main roles: · To ensure maximum possible service availability and performance. · To provision customer equipment and new services. · To provide support services for the service delivery (helpdesk) and project teams. These result in a highly diverse range of duties for the NOC - our engineers are...

  • Project Engineer, Land Development and Municipal Engineering

    3 weeks ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada WSP in Canada Full time

    The Opportunity WSP is currently seeking an Engineer to join our Land Development and Municipal Engineering Team, located at our Kingston office. Reporting to a Senior Engineer, this position will be responsible for the execution and review of a variety of storm, water and wastewater design tasks, such as site servicing and feasibility studies, stormwater...

  • Water Wastewater Process Engineer

    1 month ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada WSP Canada Full time

    WSP is currently seeking a Water Wastewater Process Engineer to join our Vertical - Water-Wastewater Treatment Infrastructure department, located at our Cornwall office. Under the mentorship of senior members of the team, you will work on a wide variety of Linear, Vertical Work specializing in water-wastewater treatment, pumping station and reservoir design,...

  • Director of Fire Protection Engineering

    4 weeks ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Ignis Global - Fire & Sustainability Engineering Full time

    We're seeking a Director of Fire Protection Engineering to spearhead technical leadership and strategic direction in fire protection engineering. As a Director of Fire Protection Engineering, you will lead the technical aspects of fire protection engineering, focusing on innovation and technical excellence. You will provide expert guidance on complex...

  • Site Inspector, Land Development and Municipal Engineering

    3 weeks ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada WSP in Canada Full time

    Job DescriptionThe OpportunityWSP is currently seeking a Site Inspector to join our Land Development and Municipal Engineering Team, located at our Kingston office. Reporting to a Senior Technical Engineer, this position will be responsible for the field review of construction projects to ensure Quality Assurance is obtained for municipal engineering and...

  • Sales Merchandiser

    1 month ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Brand Momentum Full time

    About the PositionWe’re seeking a creative and motivated Merchandiser to join our team. As a Merchandiser, you’ll be responsible for forecasting sales figures, creating displays that draw customers’ attention, and regularly analyzing data to see how our store is doing. This is a territory route within the area of Cornwall, Casselman, Embrun and...

  • (PTL Canada) Licensed Diesel Truck Technician/Mechanic I

    1 month ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Penske Full time

    Position Summary:A Penske Technician I will diagnose, overhaul, adjust, and repair all series of motor truck and trailer equipment. This position demands a specialist in the field that will perform duties with little or no supervision and in a timely and efficient manner. Other exciting projects and tasks may be assigned by supervisor.Major...

  • Sales Merchandiser

    1 month ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Senseability Full time

    Brand Momentum Sales Merchandiser Cornwall, OntarioWe're seeking a creative and motivated Merchandiser to join our team. As a Merchandiser, you'll be responsible for forecasting sales figures, creating displays that draw customers' attention, and regularly analyzing data to see how our store is doing. This is a territory route within the area of...

  • Junior Inspector

    1 month ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Morrison Hershfield Full time

    Grow with the best. Join a smart, creative, and inspired team that works to support innovation. The Stantec community unites more than 28,000 employees working in over 400 locations across 6 continents.Here at Morrison Hershfield, now Stantec, we are committed to providing flexible work arrangements to assist employees in fulfilling their multiple...

  • Transportation Supervisor

    4 weeks ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Ryder System Full time

    Summary The Supervisor Transportation is responsible for client initiatives related to cost and service improvement and organic sales. The Sr. Analyst will manage and develop client facing Analysts. Works on problems of diverse scope where analysis of situation or data requires evaluation of identifiable factors. The position will require a high degree of...

  • Clinical Homecare Nurse

    4 weeks ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Corsham Science Full time

    The Pharmaxo Group is an award winning, market leading pharmaceutical and healthcare business that serves customers, patients and medical professionals across the UK. The Pharmaxo Group comprises of: Bath ASU which produces thousands of aseptically (sterile) compounded injectable pharmaceutical products each day for hospitals and patients who are...

  • Transportation Supervisor

    1 month ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Ryder System Full time

    Summary The Supervisor Transportation is responsible for client initiatives related to cost and service improvement and organic sales. The Sr. Analyst will manage and develop client facing Analysts. Works on problems of diverse scope where analysis of situation or data requires evaluation of identifiable factors. The position will require a high degree of...

  • Business Development Manager

    4 weeks ago

    Cornwall, Ontario, K0C, Stormont, Dundas and Glengarry, Canada Caravan Guard Limited Full time

    Leisuredays Business Development ManagerFull time positionWe are looking to add to our team of dedicated Business Development Managers (who look after over 1,000 caravan & lodge parks) with an experienced and passionate person based in the South. Ideal location would be the South West, to cover regions such as Somerset, Dorset, Cornwall, Devon, and South...

  • Product Manager

    4 weeks ago

    North Dundas, Ontario, Stormont, Dundas and Glengarry, Canada MF Group AG Full time

    MF Group is a Swiss market leader in the Buy Now Pay Later universe, with a monthly transaction volume of more than 50 million Swiss Francs.Our services allow 14 million customers to pay for goods and services using MF Group payment methods. More than 3000 merchants in Europe benefit from our partnership.Our systems must support:500,000...

  • Financial Planner, Kingston

    4 weeks ago

    Kingston, Ontario, A7K, Lennox and Addington, Canada Scotiabank - Global Banking and Markets Full time

    Requisition ID: 201153Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.As a Financial Planner, you will focus on developing and deepening client relationships by providing high quality advice and service within the mass affluent market. Most importantly, you realize that your clients are your greatest...

  • Transportation Engineer or Certified Engineering Technologist

    4 weeks ago

    Kingston, Ontario, A7K, Lennox and Addington, Canada Dillon Consulting Full time

    ```html Responsibilities What your day will look like: Design and Project Coordination Contribute to the preparation of technical reports and studies to support the development of transportation engineering designs, including EA documentation Design of transportation projects including: Preliminary and Detailed Design Engineering studies Technical...

  • Project Engineer, Land Development and Municipal Engineering

    4 weeks ago

    Kingston, Ontario, A7K, Lennox and Addington, Canada WSP Full time

    The Opportunity WSP is currently seeking an Engineer to join our Land Development and Municipal Engineering Team, located at our Kingston office. Reporting to a Senior Engineer, this position will be responsible for the execution and review of a variety of storm, water and wastewater design tasks, such as site servicing and feasibility studies, stormwater...

  • Outreach Marketing Consultant

    3 weeks ago

    Kingston, Ontario, A7K, Lennox and Addington, Canada PeakMade Real Estate Full time

    The Outreach Marketing Consultant is a key contributor to motivating the onsite leasing team and will help the Property Manager and Leasing Manager to develop and create marketing campaigns, programs, and initiatives to drive prospect traffic to the property, providing a positive community experience to residents and effectively market and lease apartments...

  • Engineering Manager, Mechanical Design

    3 weeks ago

    Brockville, Ontario, K0E, Leeds and Grenville, Canada Newterra Full time

    JOB DESCRIPTION Job Title: Engineering – Manager, Mechanical Design Department: Engineering Reports To: VP of Engineering Status: Exempt Location: Accepting applications for all Newterra Office Locations. Virtual option if not within a reasonable commutable distance to a local Newterra office. Date Issued: July 2024 SUMMARY: The Engineering Manager,...