Lead Data and Analytics Developer – Customer Analytics

About the role

NiSource is one of the largest fully regulated utility companies in the U.S., serving millions of customers across six states. The Data and Analytics organization is the recently established advanced analytics arm of the company, building a talented team leveraging best‑in‑class tools to solve high‑value analytics use cases. This position is on the customer analytics team, supporting all possible interactions the business has with customers (billing, communications, site visits, etc.). The team culture emphasizes collaboration, innovative problem solving, and delivering solutions that provide a competitive advantage.

Responsibilities

• Act as subject matter and business intelligence expert for customer analytical technologies and drive adoption of self‑service analytics capabilities to achieve value objectives.
• Develop and implement analytics solutions (data models, data sets, reports, dashboards, integrated analytics) to solve business needs, accelerate insights, inform actions, and adhere to data governance and BI policies.
• Consult with Data Product Owner on the design of the Data Lake to maximize quality, accessibility, and re‑usability of data.
• Establish, promote, and monitor adherence to policies and standards for business intelligence products.
• Partner with IT to ensure technical stability and performance of user‑facing technology and establish upgrade strategies and roadmaps.
• Develop a strong understanding of customer business processes, company enterprise platform, and table structures/relationships to extract and report correct data.
• Create a strategy to develop interactive dashboards and promote their adoption/use with stakeholders at all levels.
• Develop and manage personal and team deliverables, timelines, and milestones related to assigned projects.
• Be an expert in at least one coding language for shaping and extracting data (Python, SQL) with working knowledge of others.
• Understand advanced approaches for data quality monitoring and the impact of quality issues on analytics effectiveness.
• Understand how data science can be applied to improve insights and lead to predictive and prescriptive solutions.
• Act as an internal consultant and partner for business teams to advance analytics maturity across the enterprise, providing strategic insights, identifying opportunities, developing strategies, and mentoring staff.

Requirements

• Bachelor’s Degree or equivalent work experience.
• 5+ years of experience in fields related to data engineering, business intelligence (visualization/dashboard/reporting), or data science.
• 5+ years of experience with data acquisition methods and tools (Tableau Prep, SQL, Python, PowerBI).
• 5+ years of experience with data visualization or analysis software (Tableau, Excel, Cognos Analytics, PowerBI).
• 5+ years of experience coding for shaping and extracting data (Python, R, SQL, Prep Tools).
• 2+ years of experience leading analytics developers or projects.
• Experience working with relational databases.

Qualifications

• Related experience in the utility industry.
• Experience with statistical modeling.
• Experience as a data steward and knowledge of data governance.
• Strong business acumen.

Skills

• Proficiency in Python and SQL (expert in at least one).
• Experience with Tableau Prep, PowerBI, Tableau, Excel, Cognos Analytics.
• Data modeling, ETL, data lake design.
• Dashboard and visualization development.
• Data quality monitoring and governance.
• Mentoring and technical leadership.

Benefits

• Relocation assistance provided.
• Opportunity for professional development and growth.
• Inclusive workplace supporting veterans, transitioning service members, and military spouses.

Pay

Salary range: $113,500 – $170,300, plus 10% annual bonus.

Schedule

Full‑time permanent position; hybrid schedule – 3 days on location.