Senior Data and Analytics Developer

About the role

The Data and Analytics organization at NiSource is the newly established advanced analytics arm of the company. We are building a talented team that leverages best-in-class tools and techniques to solve our company's highest value analytics use cases.

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.
• 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 predictive solutions with embedded BI functions and begins to introduce data science concepts to analytics solutions that require coding or scripting.

Requirements

• Bachelor's Degree or equivalent work experience
• 3+ years of experience with data acquisition methods and tools (Tableau Prep, SQL, Python)
• 3+ years of experience with data visualization and analysis software (Tableau, Excel, Cognos Analytics, PowerBI)
• 3+ years of 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

Skills

• Experience with complex SQL and Python functions
• Experience with Tableau, Excel, Cognos Analytics, PowerBI
• Experience with relational databases
• Experience with statistical modeling
• Experience as a data steward and knowledge of data governance

Benefits

Relocation assistance provided

Pay

Salary Range: $96,600.00 - $144,900.00

Schedule

Hybrid - 3 days on location