WGL - Research & Data Analyst (DIMP Analyst or Sr DIMP Analyst)
WGL/Washington Gas has an immediate opening for a Research & Data Analyst to join our Distribution Integrity Management Program (DIMP) group.
Create reproducible research and is prepared to defend conclusions
Connect to databases, writes SQL queries, joins data, ‘wrangles data’, and creates data visualizations (charts, graphs) that illustrate relevant points
Support database management
Use statistical methods to measure the correlative relationship between datasets
Use statistical methods to evaluate predictive model performance (back-testing, benchmarking, sensitivity testing, etc.)
Build charts, graphs, dashboards, summary tables, and other graphical representations to illustrate key findings in data
Search for industry papers in academic and professional journals compiles papers and refers to key research with citation
Intentionally dedicates effort to employ inductive and deductive reasoning to frame complex problems
Understand decision heuristics and the importance of variable weighting
Develop mathematic models or algorithms to forecast outcomes using historical data
Meet with company engineering staff and subject matter engineers to elicit opinion, direction, support, and coordination
Present findings of research to internal company panels and outlines proposed solutions
Work closely with various staff (e.g. Analysis & Reporting, Replacements, System Planning, Mapping, IT, Operations, Construction, etc.) to develop knowledge of their systems’ data and needs.
Bachelor's Degree Computer Science, Information Technology, GIS, or other Data Engineering field
3+ Years of experience in Computer Science, Information Technology, GIS, or another related field
Ability to systematically debug code, reduce I/O strain on ETL processes, and troubleshoot SQL for performance gains.
Knowledge of data engineering best practices across the development lifecycle – including agile methodologies, sustainable coding standards, code reviews, source code management, testing, and maintaining code.
Experience administering ESRI, Open Source, or Spatial Databases (GIS)
Intermediate knowledge of SQL for data management in a relational database
Intermediate knowledge of scripting languages such as Python or Node.js
Knowledge of Safe Software FME for extract, transforming, and load data operations
Experience with programmatically automating the extraction of data from public or vendor data APIs
Automating server-side scripting for backend data update pipelines
Working knowledge of the energy industry
Working knowledge of Power BI, Magik, and cloud architectures such as Amazon AWS or Microsoft Azure
Experience in Data Engineering and/or Data Architecture
Why work at AltaGas?
AltaGas is a North American energy infrastructure company with a focus on owning and operating assets that provide clean and affordable energy to our customers. AltaGas assets include Washington Gas/WGL, SEMCO, ENSTAR, and Petrogas. Our talented team, nearly 3,000 strong, leverages the strength of our assets and expertise along the energy value chain to connect customers with premier energy solutions – from the well sites of upstream producers to the doorsteps of homes and businesses to new markets around the world.
We deliver clean and affordable natural gas to approximately 1.6 million customers’ homes and businesses through regulated natural gas distribution utilities across five jurisdictions in the United States and two regulated natural gas storage utilities in the United States. Learn more about our team, vision, and strategy.
To learn more about our mission:
For Canadian hires: AltaGas hires personnel on the basis of job-related qualifications. All qualified applicants will receive consideration without regard to a person's ancestry, place of origin, colour, ethnic origin, citizenship, creed, sex, sexual orientation, gender identity or expression, age, record of offences, marital status, family status or disability or any other characteristic protected by applicable law.
For U.S. hires: U.S. affiliates of AltaGas are committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, ethnicity, religion, gender, age, national origin, marital status, sexual orientation, gender identity, family responsibilities, matriculation, physical or mental disabilities, political affiliation, genetic information, status as a protected veteran or any other characteristic protected by federal, state, or local law.