Power Markets Data Engineer (U.S.)

Power Markets Data Engineer (U.S.)
Oakville, ON, CA, L6J 2X1Concord, NH, US, 03301Noel, MO, US, 64854Hayhurst, TX, US, 79770BM, HM 07Rio Rico, AZ, US, 85648Kirksville, MO, US, 63501Columbus, OH, US, 43004Lebanon, NH, US, 03766-2637Litchfield Park, AZ, US, 85340Tahoe Vista, CA, US, 96148Tyrone, PA, US, 16686Ash Grove, MO, US, 65604Seneca, MO, US, 64865Henrietta, MO, US, 64036Clinton, MO, US, 64735Quincy, OH, US, 43343Malden, MO, US, 63863Sardinia, OH, US, 45171Gainesville, GA, US, 30501Pine Bluff, AR, US, 71601Fall River, MA, US, 02724Maryville, MO, US, 64468Webb City, MO, US, 64870St-Damase, Quebec, CA, G0J 2J0Goodyear, AZ, US, 85338Asbury, MO, US, 64832Ste. Catherine, Quebec, CA, J5C 1L9Downey, CA, US, 90241Columbus, KS, US, 66725Saint John, New Brunswick, CA, E2K 2Y6South Lake Tahoe, CA, US, 96150Mountain Lake, MN, US, 56159Red Deer, AB, CA, T4G 0K1Rice Lake, WI, US, 54868Pierce City, MO, US, 65723Londonderry, NH, US, 03053Merrick, NY, US, 11566Vandalia, IL, US, 62471White Hall, AR, US, 71602Gloucester, VA, US, 23061Hawkins, TX, US, 75765Hooksett, NH, US, 03010Deerfield, MI, US, 48445Carefree, AZ, US, 85377Mayer, AZ, US, 86333Surprise, AZ, US, 85387Fredericton, New Brunswick, CA, E3B 7G5Taft, CA, US, 93268Neosho, MO, US, 64850Harrisburg, IL, US, 62946Joplin, MO, US, 64801Paw Paw, IL, US, 61353Concord, NH, US, 03301Baxter Springs, KS, US, 66713Windsor Locks, CT, US, 06096-2335Alma Center, WI, US, 54611Stockton, MO, US, 65785Fall River, MA, US, 02721Tilton, NH, US, 03276Princess Anne, MD, US, 21853Westover, MD, US, 21871Tinker, New Brunswick, CA, E7H 5A8Sea Cliff, NY, US, 11579-1926Bryson, TX, US, 76427Riverton, KS, US, 66770Anderson, MO, US, 64851Joplin, MO, US, 64801Nevada, MO, US, 64772Donnacona, Quebec, CA, G3M 1B5Metropolis, IL, US, 62960Gold Canyon, AZ, US, 85118Sheridan, IL, US, 60551Butler, MO, US, 64730-0209Hollister, MO, US, 65672Dorchester, WI, US, 54225Pine Bluff, AR, US, 71601Manchester, NH, US, 03101Columbus, GA, US, 31901Nixa, MO, US, 65714-7969Ozark, MO, US, 65721Joplin, MO, US, 64801Bolivar, MO, US, 65613Caribou, ME, US, 04736Gravette, AR, US, 72736Ste. Brigitte des Saults, Quebec, CA, J0C 1E0Minonk, IL, US, 61760LaRussell, MO, US, 64862Joplin, MO, US, 64804Nashua, NH, US, 03060Saint-Gdon, Quebec, CA, G0W 2P0Oakville, ON, CA, L6J 2X1Reeds, MO, US, 65737Ozark, MO, US, 65721Cornwall, ON, CA, K6H 5R6Concord, NH, US, 03301Rawdon, Quebec, CA, J0K 1S0Goodyear, AZ, US, 85395Billings, MO, US, 65610Sierra Vista, AZ, US, 85635Republic, MO, US, 65738Salem, NH, US, 03079Keene, NH, US, 03431Humansville, MO, US, 65674Jackson, MO, US, 63755-0268Cochrane, ON, CA, P0L 1C0Herbert, SK, CA, S0H 2A0Hannibal, MO, US, 63401Tyler, TX, US, 75703Fall River, MA, US, 02720Strafford, MO, US, 65757Apple Valley, CA, US, 92308Ozark, MO, US, 65721Willard, MO, US, 65781Hewlett, NY, US, 11557Aurora, MO, US, 65605Baxter Springs, KS, US, 66713Charlestown, NH, US, 03603Branson, MO, US, 65616Ashland, KY, US, 41101Commerce, OK, US, 74339St. Raphael, Quebec, CA, G0R 4C0Londonderry, NH, US, 03053Girard, IL, US, 62640Lynch Station, VA, US, 24571Caruthersville, MO, US, 63830-1133Sikeston, MO, US, 63801Laforce, Quebec, CA, J0Z 2J0Blackstone, MA, US, 01504-2215St. Hyacinthe, Quebec, CA, J2S 5N8Moncton, New Brunswick, CA, E1E 3R8Riviere-du-Loup, Quebec, CA, G5R 5B7Chillicothe, MO, US, 64601Buffalo, MO, US, 65622Sedalia, MO, US, 65301Joplin, MO, US, 64804Massena, NY, US, 13662Platte City, MO, US, 64079Keokuk, IA, US, 52632Bolivar, MO, US, 65613Gold Canyon, AZ, US, 85118Newburgh, NY, US, 12550Massena, NY, US, 13662Marshall, MO, US, 65340Granby, MO, US, 64844St. Leon, MB, CA, R0G 2E0Salem, NH, US, 03079Sanger, CA, US, 93657-0397Mont-Laurier, Quebec, CA, J9L 2A2Ogdensburg, NY, US, 13669Fall River, MA, US, 02721Greenfield, MO, US, 65661Elk Mound, WI, US, 54739Forsyth, MO, US, 65653
At Algonquin-Liberty, we hire passionate people who care about doing the right thing for our customers. We are entrepreneurial, creative, and outcome-focused. Here, your natural talent and achievements will flourish in an inclusive environment of teamwork, trust and continuous learning. We are always pursuing excellence to exceed our ambitions goals, rewarding both the goal outcome and how we achieve it.
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: i) Portfolio Management (Trading/Hedging) ii) Client & Asset Support iii) 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 LPCos profitability, competitiveness, and growth opportunities. The Data Engineer will support and provide expertise in data ingestion, wrangling, cleansing, 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
Build efficient data pipelines for market, transactional and generation data. 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.
Organize, implement, and enforce correct data collection policies and methods. Ensure the proper functioning of data collection software and applications at all times. Make sure that data collection procedures are in line with all relevant rules and guidelines
Gather fundamental power market, transactional and generation data from multiple sources/systems and implement in a database seemlessly. Create and integrate API's.
Responsible for data wrangling, extraction, data security, discovery and control. Demonstrate Best Practices in data science / software development such as use of repositories, scheme and data flow diagrams.
Collaborate with and across teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies
Perform unit tests and conducting reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performance
Support development of short, medium and long term energy marketing analytical tools.
Support the development and automization of standardized reports (position, MtM, etc,)
Ensure output of data is accurate and in a useful format for end-use customer (Traders, Executives etc.)
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 snowflakes infrastructure and advanced skills in Python and Excel is a must.
Strong data structure, data modelling and analysis skills including in-depth knowledge of SQL, R, 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.
As the successful candidate
Our Mission
We provide safe, secure, reliable, cost-effective and sustainable energy and water solutions. Our mission is how we create value as an organizationit 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 animpact. 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
We are focused on building a diverse and inclusive workforce. If you are excited about this role and are not confident you meet all the qualification requirements, we encourage you to apply to investigate the opportunity further.
We are an equal opportunity employer and value each person's unique background, diversity, experiences, perspectives and talents.
Full participation of all employees in a safe, healthy and respectful environment is key to individual and company success. We are committed to fully utilizing the abilities of all our employees and expect each of our employees to honour this commitment in their daily responsibilities.