Data Engineer (contract to hire)

Job Title: Data Engineer Job Type: Contract To Hire Job Location: Remote EST/CST time zones only Position Summary Works as a member of the BI team to develop tools and resources to support internal and external insight needs. This includes internal data structures for various cross-functional partner use. Partners with the Business Intelligence Analytics team and internal customers to better understand needed data sets. Is also responsible for scripts to manage the distribution of standardized reports and ad-hoc report development. Responsible for the daily operational aspects of the Business Intelligence Systems, including monitoring and resolving support requests, designing procedures, developing and maintaining system components. Works with business partners to provide BI support and expertise on project work. Duties 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. Education Bachelor's Degree required. Required Experience 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. Technical Skills Intermediate proficiency with: Oracle PL/SQL. SSIS. SSRS. SSAS. Excel. .NET. Visual Studio and Microsoft Development Tools. Additional Qualifications 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. The projected hourly range for this position is $65 to $75. On-Demand Group (ODG) provides employee benefits which includes healthcare, dental, and vision insurance. ODG is an equal opportunity employer that does not discriminate on the basis of race, color, religion, gender, sexual orientation, age, national origin, disability, or any other characteristic protected by law.