Data Engineer II

Data Engineer IISpire 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.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 dashboardsPerform detailed analysis, design, and development of the logical and physical data models for data storage and warehousingWork with business users to translate functional requirements into technical specifications for Analytical and Report developmentCollaborate 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 unitsIdentify data requirements and understand data models from Spire Enterprise ApplicationsBuild ELT processes to deliver data from source applications to target warehouse environments through Oracle Data Integrator interfaces and Azure Data PipelinesAnalyze performance statistics and performs 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 servicesIdentify best practices for data services monitoring and management and promote these best practices across SpireWork with Enterprise Architecture team to ensure data governance policies and data quality standards are implemented in enterprise warehouse data modelsMonitor and maintain data interfaces, loads and pipelines to proactively to ensure high service availability.Collaborate with IT Infrastructure teams to ensure service level adherence for data loading and information delivery servicesWorks in conjunction with the Advanced Analytics TeamAll other duties as assignedEssential Characteristics:Ability to demonstrate the core and job category competencies: customer-focused, results-driven, teamwork, communications, adaptability, initiative, problem solving and qualityAbility 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 skills and perspectivesAbility to work independently and manage time effectively in order to meet individual goals and deadlines.Required Education (certifications, licenses):Bachelor's degree and / or approximately 7+ years of related work experience; or a graduate degree and approximately 7+ years of related work experienceRequired knowledge, skill and abilities:Has working knowledge or Oracle database technology and supporting applicationsPreferably 7+ years of BI Business/Data Analysis development experienceExpert experience with PL/SQL programmingPreferably 7+ years of Oracle ODI ETL/ELT, Azure Data Factory Pipeline (or similar) experienceExperience working within Agile development methodologies and DevOps development lifecyclesPhysical demands, environment and schedule:Normal work environmentTravel – 15%Posting Requirements:We accept online applications through our career site at jobs.spireenergy.comDisclaimer: 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 accommodations may be made to enable individuals with disabilities to perform the essential functions. Spire Inc., and its subsidiaries are an Affirmative Action and Equal Employment Opportunity employer. Job Req ID: 11728