Sr Data & 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. The Sr. Data and Analytics Developer is responsible for developing and supporting data and analytics solutions that drive value.

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 the use of interactive dashboards 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 introduces 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

• Strong understanding of business processes, company enterprise platform, and table structures/relationships
• Experience with complex SQL and Python functions
• Ability to develop and manage personal deliverables, timelines and milestones related to assigned projects
• Experience with Tableau, Excel, Cognos Analytics, PowerBI, and other data visualization and analysis software
• Experience with relational databases
• Experience with statistical modeling
• Experience as a data steward and knowledge of data governance

Benefits

Relocation assistance provided

Pay

$96,600.00 - $144,900.00, plus 8% annual bonus

Schedule

Hybrid - 3 days on location