Job Title *: * Sr Forecasting & Modeling Analyst

*Job Code: * 107960

FLSA Determination:   Exempt

Date Description Created:   REVISED August 25, 2023

Work Location(s): Hybrid

Reports To: Manager Forecasting and Modeling

Direct Reports : N/A

Job Summary

The Sr Forecasting & Modeling Analyst is responsible for developing and supporting data and analytics solutions that drive value. The Sr Analyst partners with business teams to fully understand the problem being solved, extracts & preps data, builds analytic models, visualizations & front-end tools needed to infuse insights into our business process.  The Sr Analyst contributes to the development of analytics best practices, data governance policies and data stewardship procedures, and assists in the ongoing sustainability of solutions by both adhering to and promoting process and technology standards. The Sr Analyst has experience in the full development lifecycle of analytics products and understands solution architecture and data modeling, has an awareness of data science and the types of challenges that can be solved, works independently with limited supervision, coaches & reviews the work of colleagues with less experience​, and solves complex problems while taking a new perspective on existing solutions.

Principal Duties and Responsibilities

• Acts in the capacity of subject matter and business intelligence expert in the enterprise analytical technologies and drives adoption of self-service analytics capabilities to achieve value objectives within the business.

• Develops and implements analytics solutions (including data models, data sets, reports, dashboards, and integrated analytics) to solve business needs, accelerate insights and inform actions and adhere to data governance and BI policies and standards.  

• Consults with Data Product Owner on the design of the Enterprise Data Warehouse (EDW) and Data Lake environments to maximize the quality, accessibility, and re-usability of data. 

• Establishes, promotes, and monitors adherence to policies and standards for business intelligence products. 

• Partners with IT to ensure the technical stability and performance of user facing technology and establish upgrade strategies and roadmaps.  

• Develops a strong understanding of business processes, company enterprise platform, and table structures/relationships to extract and report correct data

• Develops interactive dashboards and promote their use with internal stakeholders

• Develops and manages personal deliverables, timelines and milestones related to assigned projects.

• Leverages complex SQL and Python functions to extract and shape data

• Automates the monitoring of datasets for completeness and data quality

• Incorporates predicative solutions with imbedded BI functions and begins to introduce data science concepts to analytics solutions that require coding or scripting.

Required Qualifications for Position

• Bachelor’s Degree in Information technology, computer science, data science, mathematics, statistics, economics, engineering, or a related business or quantitative discipline or equivalent work experience in data-related discipline 

• 3+ years of experience

• Experience with data acquisition methods and tools (Tableau Prep, SQL, Python) 

• Experience with data visualization and analysis software (Tableau, Excel, Cognos Analytics, PowerBI)  

• Experience working with relational databases  

• Experience in at least one coding language for shaping and extracting data (Python, R, SQL, Prep Tools)

• Demonstrated communication and collaboration skills 

• Proficiency in the Microsoft Office suite

Preferred Qualifications for Position

• Related experience in the utility industry

• Strong business acumen

• Specific domain knowledge and experience

• Experience with statistical modeling

• Experience as a data steward and knowledge of data governance

Disclaimer

The preceding description is not designed to be a complete list of all duties and responsibilities required of the position

Inclusion and Diversity: 

• Value inclusion within your day to day responsibilities by respecting others' perspectives/convictions, engaging others' opinions, creating a safe environment where people, ideas, and opinions are valued within your Team/Customers and external partners. 

• Respect and take into consideration diversity within your Team/Customers and external work partners by valuing different world views, challenges, and cultures that represent all walks of life and all backgrounds. 

• Treat others with respect and consideration.  Actively participate in creating and contributing to a positive work environment. 

   

Safety

• Promote a safe work environment by actively participating in all aspects of our employee safety program.   

• Report any unsafe conditions and take actions to prevent personal injuries.   

• Support our interdependent safety culture by ensuring the safety of your co-workers.   

• Stay focused on the task at hand and promote productivity through good work habits. 

   

Inclusion & Diversity

Value inclusion within your day to day responsibilities by respecting others perspectives/convictions, engaging others opinions, creating a safe environment where people, ideas, and opinions are valued within your Team/Customers and external partners.

Respect and take into consideration diversity within your Team/Customers and external work partners by valuing different world views, challenges, and cultures that represent all walks of life and all backgrounds.

Treat others with respect and consideration. Actively participate in creating and contributing to a positive work environment.

Equal Employment Opportunity

NiSource is committed to providing equal employment opportunities in each of its companies to all employees and applicants for employment without regard to race, color, religion, national origin or ancestry, veteran status, disability, gender, age, marital status, sexual orientation, gender identity, genetic information, or any protected group status as defined by law. Each employee is expected to abide by this principle.

By applying, you may be considered for other job opportunities.

Safety Statement

Promote a safe work environment by actively participating in all aspects of our employee safety program. Report any unsafe conditions and take actions to prevent personal injuries. Support our interdependent safety culture by ensuring the safety of your co-workers. Stay focused on the task at hand and promote productivity through good work habits.

Salary Range:

$77,400.00 - $116,200.00

Posting Start Date:

2024-05-13

Posting End Date (if applicable):

2024-05-28

Please note that the job posting will close on the day before the posting end date.

At NiSource, you'll be part of the team serving nearly four million customers throughout the Midwest and Mid-Atlantic, who count on us to energize their homes and businesses. Whether speaking with customers by phone, analyzing financial data or installing new gas lines in a neighborhood, you’ll meet exciting challenges each day and make the most of your skills and talents. And you’ll be part of a company that was named by Forbes magazine as one of America’s Best Large Employers.

We're looking for talent from all backgrounds. We invite candidates of all abilities to come as they are and do what they love. Through our years of successful growth, we’ve stayed true to our roots by making a difference in the lives of millions of our customers. If you’re interested in joining an inclusive, innovative company that fosters opportunity for growth, NiSource might be the place for you.