IT Business Implementation Analyst 3

Job Description

*Assists with analyzing complex business problems to be solved with automated systems.As part of a software project implementation team, provides technical expertise in identifying, evaluating and developing systems and procedures that are cost effective and meet user needs. Configures system settings and options; plans and executes unit, integration and acceptance testing; and creates specifications for systems to meet business specifications. Designs details of automated systems. May provide consultation to users in the area of automated systems. May lead cross-functional linked teams to address business or systems issues.Job duties are varied and complex; independent judgment needed. May have project lead role. Prefer 5 years relevant experience and BA/BS degree., *Implementation Engineer Oracle Utilities Analytics Insights (OUAI) Client SuccessAs an Implementation Engineer at Oracle Utilities Analytics Insights (OUAI), you will work with a team to implement SaaS-based energy efficiency and customer engagement programs on behalf of our utility partners. You will collaborate with a diverse group, including a Project Manager, a Senior Implementation Engineer, as well as members of the Product Engineering, Product Management, and QA teams. Setting up new programs for our utility clients is the lifeblood of Oracle Utilities Analytics Insights (OUAI), and we rely on Implementation Engineers input and expertise for our overall success.Our Implementation Engineers rely on a diversified technical skill-set, including: data manipulation via complex SQL queries, Extraction-transformation and Loading (ETL) for custom interface development, experience on the Linux command line, shell scripting, and software development using high-level programming languages such as Python or Java. We do not expect you to immediately be masters of the full spectrum of technologies used, but through on the job training and coaching, you will gain the necessary skills required to launch energy efficiency programs for new utility clients.Responsibilities

• Analyze data and develop interfaces to extract, transform, and load utility data from the utility clients using sql/plsql to meet Oracle Utilities Analytics Insights (OUAI) s data standards
• Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.
• Adapt ETL code to accommodate changes in source data and new business requirements.
• Spearheads development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
• Ensures data quality throughout entire ETL process.
• Code development with Python, Shell scripting in UNIX/LINUX environments.
• Manages automation of file processing as well as all ETL processes within a job workflow.
• Ensures compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation
• Monitor production jobs and tasks
• Build and maintain a deep understanding of our products with the ability to explain them to others; think about how client customization and delivery can be speed up and improved
• Collaborate with cross functional teams to operationalize new Oracle Oracle Utilities Analytics Insights (OUAI) s products and features

• Bachelor s/Master s degree in computer science or related field
• 3-5 years of experience working on ETL using specific tools or pl/sql
• Self-starter with the ability to work independently and take initiative. Ability to translate ideas and business requirements into fully functioning ETL workflows.
• You are able to write SQL for large data sets and have recent experience with relational databases, Oracle preferred
• knowledge of database administration (table/partition, DML, DDL, procedure and packages)
• You have experience in Linux and are not afraid of the command line
• You demonstrate some programming knowledge (Java, Python, shell scripting)
• You have experience in business intelligence, reporting and visualization tools
• You are a smart, talented engineer, looking for an exciting, fast-paced company to expand your toolbox and develop your skills.
• Strong verbal and written communication skills

Keyskills :
project managementcustomer relationsdocumentationquality controltroubleshootingon thetrainingsql queriesdata qualitynew businesscost effectivework processes