Job title: WGL- Customer Data Intelligence Analyst
Company: AltaGas
Job description: Job DescriptionPosition SummaryLeverage advanced data analysis, reporting tools (SAP IDE, SQL Server Management Studio, SAP HANA, Power BI, Tableau), and ETL processes to support the Customer Group functions at Washington Gas. Responsible for comprehensive data reporting, in-depth analysis, dynamic dashboard creation, and efficient data integration to provide actionable insights for Billing, Collections, Marketing, and Customer Service Operations. Collaborate closely with corporate IT and other BI teams to ensure seamless data extraction, transformation, and loading, driving informed decision-making and operational efficiency under the guidance of senior leadership.Tasks and Responsibilities
- Develop complex queries, reports, and dashboards using SQL, Tableau, Power BI, and other available tools to support business needs.
- Handle data requests from various business units for executive, operational, or regulatory needs, utilizing SAP and other systems.
- Develop requirements for the customer group and information solutions to include functional enhancements for internal developers as needed by the business to support data extractions and reports for operational activities.
- Support the Customer Group in the design, functionality, and data content of data models.
- Assist programmers and users with data integrity investigations, data analysis, and data modifications as needed.
- Understand various operational business processes and leverage this knowledge to support the development and delivery of improvements and recommendations.
- Collaborate with Finance, Consumer Services, Rates and Regulatory Affairs Departments, and the Office of the General Counsel to evaluate functionality and data to solve business problems.
- Proactively analyzes customer information, billing, financial, and general ledger data to ensure data integrity using BPQA and other SAP transactions and tools.
Qualifications, Skills and Abilities
- Bachelor’s Degree in business, engineering, statistics, or a related data analysis discipline required
- 5+ years of related experience in statistical analysis or data analysis required
- Intermediate to advanced proficiency in MS Excel, Tableau, Power BI, SAP HANA, Business Objects, and SQL required
- Strong working knowledge of statistical and optimization tools, including measurement systems analysis, capability analysis, hypothesis testing, analysis of variance, correlation, and regression analysis
- Proven ability to complete analytical, data-intensive projects and clearly communicate results to a broad audience
- Proven ability to achieve process efficiency improvements through data analysis
We offer a competitive salary range of $91,500 to $125,625 per year, commensurate with experience, education, and skills. In addition, we provide a comprehensive benefits package including health insurance, retirement plans, and paid time off.The Company values diversity in its workforce and encourages United States military veterans and service members who meet the qualifications to applyWhy 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, 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.7 million customers’ homes and businesses through regulated natural gas distribution utilities across four 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: WGL/SEMCO/AltaGas offers a total rewards package that includes competitive pay, incentive bonus plans, holiday pay, 401K matching and a wide array of benefits. These benefits including medical, dental and vision coverage are designed to help you and your family stay healthy. We also have paid time off (PTO) to balance the demands of your work and personal life. Available benefits vary depending upon the specifics of the role.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.
Expected salary: $91500 – 125625 per year
Location: Calgary, AB
Job date: Sat, 16 Nov 2024 04:38:08 GMT
Apply for the job now!