




DATA ANALYTICS ANALYST
SUMMARY
The position is responsible for quantitative analysis on structured pricing products and developing tools and models for forecast and valuation. This role maintains the existing quantitative models and provides detailed report on model results timely and accurately. The position is accountable for continuously improving models, analysis and databases across different markets. The candidate must be able to develop and implement advanced modeling methodologies to foster company-wide business decision making. This position also requires establishing close working relationships with other teams across the enterprise.
This position may be filled as a Data Analytics Analyst (GSE04), Data Analytics Analyst Senior (GSE05) or Data Analytics Analyst Staff (GSE06). Individuals who demonstrate advanced skills in terms of work experience, education, and certifications may be eligible for the more advanced position.
This position follows a hybrid work schedule. Employees are required to be in the office four (4) days per week, one (1) day remote.
JOB REQUIREMENTS
Functional Expertise:
- Analyze and organize key customer data for use in pricing and planning.
- Manage, improve, and validate existing predicative models, including the running of monthly reports that summarize key forecasting results to be used throughout the organization.
- Develop new statistical models to support special project analysis as requested.
- Leveraging innovative technologies such as machine learning and AI techniques to foster data analytical capability and support company growth strategy
Business Acumen:
- Understand the importance of Data Analytics to the profitability of the company
- Constantly looking for ways to improve the current models in multiple markets to mitigate potential model risks and enhance profitability
- Thorough knowledge of quantitative methods, statistical models, and optimization concepts and the ability to apply them to business situations
- Understand how data can be used and how data quality can be improved to discover and mitigate risks inherent in our business
Engagement:
- Exhibit high level of personal responsibility to data analysis.
- Support internal and external auditing on models and analytics tools
- Collaborate with other teams to develop modeling tools and analysis reports and communicate projects results/status to appropriate audience
- Partner with management in decision making processes and influence the actions of others to ensure the achievement of business goals
Driving Results:
- Collect, organize, and process complex data and information from multiple sources, verify its accuracy, and effectively build analytical models based on the data to enhance business profitability.
- Drive efficiencies through continuous process improvement without implementing undue complexity.
- May direct the work of other lower-level professionals.
DATA ANALYTICS ANALYST (GSE04)
Education Certification/Licenses
Required:
- Bachelor's Degree in Mathematics, Economics, Engineering, Business Administration or Similar Discipline.
Preferred:
- Graduate degree in Quantitative Discipline
Related Work Experience
Required:
- 3 – 5 years of experience in Data Analytics and Database Management
Preferred:
- Utility, Natural Gas or Other Energy Industry Experience
Specific Skills & Knowledge
Required:
- Advanced proficiency in MS Office Suite such as Excel and Access
- Knowledge of database management systems such as Oracle, SQL Server or MySQL
- Proven record of experience working with large databases and use of statistical models for valuation and prediction.
- Ability to manage multiple projects at once with several departments and stakeholders in a timely fashion with measurable results.
Working Conditions/Physical Requirements
- The Incumbent works in an office environment
DATA ANALYTICS ANALYST SENIOR (GSE05)
Education Certification/Licenses
Required:
- Bachelor's Degree in Mathematics, Economics, Engineering, Business Administration or Similar Discipline.
Preferred:
- Graduate degree in Quantitative Discipline
Related Work Experience
Required:
- 5-9 years’ experience in data gathering, analytics and reporting*
- Proven track record of model creation and management in a business environment.
- Extensive experience in manipulating large databases using SQL, Hadoop, Spark, Azure or AWS
Preferred:
- Utility, natural gas or other energy industry experience
Specific Skills & Knowledge
Required:
- Advanced proficiency in MS Office Suite such as Excel and Access
- Knowledge of database management systems such as Oracle, SQL Server or MySQL.
- Proven record of experience working with large databases and use of statistical models for valuation and prediction.
- Ability to manage multiple projects at once with several departments and stakeholders in a timely fashion with measurable results.
- Experience with data visualization in Power BI, Tableau, SSRS, or other comparable tools
- Demonstrate quantitative skills and ability to apply complex financial and statistical principles
- Hands-on programming skills using SPSS, SAS, Python or R
Working Conditions/Physical Requirements
- The Incumbent works in an office environment
DATA ANALYTICS ANALYST STAFF (GSE06)
Education, Certifications/ Licenses
Required:
- Bachelor’s Degree in Mathematics, Economics, Engineering, Business Administration or Similar Discipline.
Preferred:
- Graduate degree, Ph.D. in Quantitative Discipline
Related Work Experience
Required:
- 9+ years’ experience in data gathering, analytics and reporting*
- Proven track record of model creation and management in a business environment.
- Extensive experience in manipulating large databases using SQL, Hadoop, Spark, Azure or AWS
- Hands on experience on Machine Learning, Artificial Intelligence, and/or Big Data
Preferred:
- Utility, natural gas or other energy industry experience
Specific Skills & Knowledge
Required:
- Advanced proficiency in MS Office Suite such as Excel and Access
- Knowledge of database management systems such as Oracle, SQL Server or MySQL.
- Proven record of experience working with large databases and use of statistical models for valuation and prediction.
- Ability to manage multiple projects at once with several departments and stakeholders in a timely fashion with measurable results.
- Experience with data visualization in Power BI, Tableau, SSRS, or other comparable tools
- Demonstrate quantitative skills and ability to apply complex financial and statistical principles
- Technical leadership experience and programming skills using SPSS, SAS, Python or R
Working Conditions/Physical Requirements
- The Incumbent works in an office environment