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. 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 Sr. Data and Analytics Developer is responsible for developing and supporting data and analytics solutions that drive value. The Sr Developer partners with business teams to fully understand the problem that needs to be solved, extracts and preps data, builds analytic models, visualizations and front-end tools needed to infuse insights into our business process. As the Sr. Data and Analytics Developer you will contribute to the development of analytics best practices, data governance policies, data stewardship procedures, and assists in the ongoing sustainability of solutions by both adhering to and promoting process and technology standards. You will need experience in the full development lifecycle of analytics products and understand solution architecture, data modeling, and awareness of data science and the types of challenges that can be solved.

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.

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

Nice-to-haves

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

Benefits

• 8% annual bonus
• Relocation assistance provided