Data Engineer II

Spire; St. Louis (MO); On-site; USD 95,000 - 130,000; Full time

Job summary

Spire is seeking a Data Engineer II to design and maintain the data warehouse, ETL processes, and analytics data models. You will deliver insights across the organization and implement data governance and quality standards to support reliable analytical products.

You will collaborate with the Advanced Analytics and IT teams to ensure high data availability, robust data pipelines, and effective data delivery to end-users across Spire's enterprise.

Qualifications

• 7+ years of BI/Analytics development experience.
• Expert experience with PL/SQL programming.
• 7+ years of Oracle ODI/ETL/ELT and Azure Data Factory Pipeline experience.
• Experience with Agile development methodologies and DevOps lifecycles.

Responsibilities

• Implement and maintain BI tools (OBIEE, Tableau, Alteryx, PowerBI).
• Develop, deploy, and maintain financial and operational analytics, BI reports and dashboards.
• Design data models for data storage and warehousing.
• Translate functional requirements into technical specs for analytics/reporting.
• Collaborate to architect data stores, data marts, and extracts for visualizations.

Skills

PL/SQL

Oracle database

BI/Analytics development

Agile/DevOps

Data modeling

Education

Bachelor's degree

Tools

Oracle ODI/ETL

Azure Data Factory

OBIEE

Tableau

Power BI

Alteryx

Job description

Summary

Spire is seeking to fill a Data Engineer II 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.

Company Overview

We are committed to understanding the needs of the homes and businesses we serve. That's why 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.

And 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.

By living our values and competencies, we strive to create an environment where employees feel welcome, respected and valued.

Duties and Responsibilities

• Implement and maintain business intelligence and analytics tools (OBIEE, Tableau, Alteryx, PowerBI).
• 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 datastores, data marts and extracts used in OBIEE, Tableau and PowerBI 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 in conjunction 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.
• Provide best practice knowledge to support optimal design and operation of all Data and Analytical related services.
• Identify best practices for data services monitoring and management and promote these best practices across Spire.
• Work with Enterprise Architecture team to ensure data governance policies and data quality standards are implemented in enterprise warehouse data models.
• Monitor and maintain data interfaces, loads and pipelines to proactively ensure high service availability.
• Collaborate with IT Infrastructure teams to ensure service level adherence for data loading and information delivery services.
• Works in conjunction with the Advanced Analytics Team.
• All other duties as assigned.

Essential Characteristics

• 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 workforce that recognizes and respects every individual's unique skill and perspective.
• Ability to work independently and manage time effectively in order to meet individual goals and deadlines.

Required Education (certifications, licenses)

• Bachelor's degree and 7+ years of related experience, or an equivalent combination of education and experience. Graduate degree preferred.

Required knowledge, skill and abilities

• Has working knowledge or Oracle database technology and supporting applications.
• Preferably 7+ years of BI Business/Data Analysis development experience.
• Expert experience with PL/SQL programming.
• Preferably 7+ years of Oracle ODI ETL/ELT, Azure Data Factory Pipeline (or similar) experience.
• Experience working within Agile development methodologies and DevOps development lifecycles.

Physical demands, environment and schedule

• Normal work environment.
• Travel - 15%

Posting Requirements

Disclaimer: The above statements are intended to describe the general nature of the level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified. To perform this job successfully, an individual must be able to perform each duty and responsibility satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Spire Inc., and its subsidiaries are affirmative Action and Equal Employment Opportunity Employer.

Locations

Saint Louis, MO, US, 63101; Birmingham, AL, US, 35203

Job Location

St Louis

Job Segment

ERP, Information Technology, IT Architecture, Oracle, Database, Technology