Data Engineer III

Company Overview

We are committed to understanding the needs of the homes and businesses we serve. We're always looking for driven, collaborative people to join our team. Because we believe that offering our customers the best service means bringing together the best people. We find the best by hiring those who share our values of safety, inclusion and integrity, and demonstrate the competencies that bring the Spire vision, mission and culture to life.

• Adaptability:
  We embrace change, continuously seeking opportunities for improvement while remaining open-minded and flexible in response to evolving conditions and customer, stakeholder and company needs.
• Collaboration:
  
  We achieve more together through a foundation of respect, embracing healthy conflict, actively seeking and providing actionable feedback and fostering an environment where everyone’s input is welcomed.
• Ownership:
  We see things through, demonstrate accountability, honor commitments, take responsibility for outcomes and demonstrate initiative.

Spire is seeking to fill a Data Engineer III position. This role is a primary contributor and designer of the overall Spire data warehouse, data ETL processes and analytics data model and architecture. This role is also responsible for the delivery of insight through data and analytics support throughout the Spire organization. Additionally, this role will be responsible for the implementation of data governance strategies and data quality standards to ensure data related projects and analytical products deliver high data quality, expected data pipeline services, and overall analytical support to end-users.

• Implement and maintain business intelligence and analytics tools (OBIEE, Tableau, Alteryx, Power
  
  BI)
• Develop, deploy, and maintain financial and operational analytics, BI reports, and dashboards
• Perform detailed analysis, design, and development of the logical and physical data models for data storage and warehousing
• Work with business users to translate functional requirements into technical specifications for analytical and report development
• Collaborate with Advanced Analytics team to help architect and develop operational data stores, data marts and extracts used in Tableau and Power
  
  BI visualizations based on functional requirements from various business units
• Identify data requirements and understand data models from Spire Enterprise Applications
• Build ELT processes to deliver data from source applications to target warehouse environments through Oracle Data Integrator interfaces and Azure Data Pipelines
• Analyze performance statistics and perform required tuning activities with system, software, and data applications, Data Stewards, and other ITS teams to understand functionality, scalability, performance, security, and integration requirements for translation into a functional system
• Work with stakeholders including data, design, application product and business teams and assist them with data-related technical and infrastructure issues
• Provide best practice knowledge to support optimal design and operation of all Azure Data related services
• Identify best practices for cloud services monitoring and management and promote these best practices across Spire
• Monitor and maintain data pipelines proactively to ensure high service availability
• Work with Enterprise Architecture team to ensure data governance policies and data quality standards are implemented in enterprise warehouse data models
• Collaborate with Data Scientists and other Data Engineers to understand ML models data requirements and optimize related data solutions accordingly
• Collaborate with IT Infrastructure teams to ensure service level adherence for data loading and information delivery services
• All other duties as assigned

• Ability to demonstrate the core and job category competencies: customer-focused, results-driven, teamwork, communications, adaptability, initiative, problem solving and quality
• Ability to lead by example in support of the Company’s essential characteristics and values: strong ethics and integrity, dedication to a safe work environment, commitment to a diverse…