Eng II, Data

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 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 services
• Work with Enterprise Architecture team to ensure data governance policies and data quality standards are implemented in enterprise warehouse data models
• 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

Qualifications

• 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