Lead Data and Analytics Developer – Customer Analytics

About the position

The Data and Analytics organization at NiSource is the recently established advanced analytics arm of the company. We are building a talented team that is leveraging best-in-class tools and techniques to solve our company's highest value analytics use cases. This position will be on the customer analytics team, which supports all the possible interactions the business has with customers (billing, communications, site visits, etc.). With a strong team culture and commitment to innovative problem solving, the solutions that we build will be a competitive advantage for our company for many years to come. The Lead Data and Analytics Developer designs, develops, and supports customer-focused data and analytics solutions that deliver measurable business value. In this role, you will partner closely with business stakeholders to understand complex challenges, prepare and transform data, and develop analytics, visualizations, dashboards, and self-service tools that drive informed decision-making and improve business outcomes. As a technical leader, you will help establish and promote data engineering, analytics, governance, and stewardship best practices while ensuring solutions are sustainable, scalable, and aligned with enterprise standards. You will lead the development of complex data products and visualizations, mentor and coach team members, review and delegate work, and provide guidance on technical design and implementation. Success in this role requires strong problem-solving skills, the ability to navigate ambiguity, and a broad perspective to identify innovative solutions that meet both business and technical needs.

Responsibilities

  • Acts in the capacity of subject matter and business intelligence expert for customer analytical technologies and drives adoption of self-service analytics capabilities to achieve value objectives within the business
  • Develops and implements analytics solutions (including but not limited to 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 Data Lake 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 customer business processes, company enterprise platform, and table structures/relationships to extract and report correct data
  • Creates a strategy to develop interactive dashboards and promote their adoption/use with stakeholders at all levels of the organization
  • Develops and manages personal and team deliverables, timelines and milestones related to assigned projects
  • Is an expert in at least one coding language for shaping and extracting data and has a working knowledge of others (Python, SQL)
  • Understands advanced approaches for data quality monitoring and the impact of quality issues on the effectiveness of analytics
  • Understands how data science can be applied to improve insights and lead to predictive and prescriptive solutions
  • Acts as an internal consultant and partner for business teams to advance analytics maturity across the enterprise to include 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

Nice-to-haves

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

Benefits

  • Relocation Assistance Provided
  • 10% annual bonus
Back to blog

Other Jobs To Apply

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...