Note: The job is a remote job and is open to candidates in USA. On-Demand Group is recruiting for a Data Engineer to support business intelligence systems and internal and external insight needs. The role develops and maintains data warehouse ETL processes, data structures, analytical models, reports, and ERP data routines, while providing operational support and working with business partners on requirements and projects.
Responsibilities
- Maintains daily operations of automated BI distribution and is accountable for timely execution and delivery of existing report packages
- Responsible for the daily monitoring, accuracy, and consistency of system processes including data warehouse ETL procedures
- Provides level two support and monitors all BI Help Desk requests, using discretion to determine the difficulty level, resources, and prioritization of each request while completing or reassigning to the appropriate resource
- Follows SOX Policies and Procedures in production system deployment of approved code changes
- Maintains and supports financial interface processes using PL/SQL and Oracle Concurrent Programs to process financial month-end transactional processes
- Provides training to junior team members on both business and technical logic
- Designs and constructs ad hoc and standardized reports based on ERP System Data, including Oracle e-Business Suite
- Assists in troubleshooting and debugging application and/or data issues
- Follows and supports overall policies and goals for Information Technology, including maintaining established Sarbanes Oxley (SOX) and other regulatory IT general controls over the production environment
- Responsible for the design, development, and maintenance of ETL processes, data structures, and analytical data models within the data warehouses
- Designs and develops programming routines for the maintenance and movement of data within the ERP system
- Designs, develops, codes, tests, debugs, and documents PL/SQL applications to satisfy transactional data needs
- Works with Business Intelligence Analysts, users, and IT management to identify and specify complex business requirements and processes to develop, support, and modify existing systems
- Researches and evaluates alternative solutions and makes recommendations
- Researches complex data-oriented problems to discover inconsistencies in data
- Attends technical and professional training to improve knowledge and skills so that the individual is growing with the IT systems and processes
- Assists in technical consultation to business unit and IT management and staff
- Implements additions and modifications to the data warehouse data model
Skills
- Bachelor's Degree required
- Bachelor's Degree required and 1-3 years of relevant IT experience
- Database and transactional knowledge of Enterprise Resource Planning Systems, such as Oracle Applications e-Business Suite, with 1+ years of experience
- Technical competency in Database, Data Warehouse, and ETL processes, with 1-3 years of experience
- Experience in developing reports, dashboards, and information distribution techniques, with 1-3 years of experience
- Thorough knowledge of existing BI data models, deliverables, and processes
- Strong analytical, conceptual, and problem-solving abilities
- Oracle PL/SQL
- SSIS
- SSRS
- SSAS
- Excel
- .NET
- Visual Studio and Microsoft Development Tools
- Must be able to prioritize and perform in a fast-paced multi-task environment
- Must be able to perform duties with moderate to low supervision
Benefits
- Healthcare insurance
- Dental insurance
- Vision insurance
Company Overview