Senior Oracle Reports Developer - BI/ETL & Dashboards (Hybrid)
eSystems, Inc.
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Benefits offered by this job
Job summary
eSystems, Inc. is seeking a Reports Developer to support NC FAST reporting and data extraction using Oracle and PL/SQL. The contract role requires 5+ years of experience and will involve designing, coding, testing, and maintaining data extracts and dashboards for the NC Department of Health and Human Services.
The position is hybrid in Raleigh, NC with a 12-month term and potential extension. The ideal candidate should have strong SQL skills, experience with ETL tools, and familiarity with BI
Qualifications
- Experience with Oracle, Oracle Utilities, and ETL tools.
- PL/SQL scripting and relational database modeling experience.
- Knowledge of structured system development methodologies.
- Ability to build strong customer relationships and respond with urgency.
- Ability to organize, prioritize and follow complex technical procedures.
- Experience with BI tools such as Business Objects or BIRT.
- Experience with Agile (Scrum, Kanban, or SAFe).
- Data Warehouse experience.
- Experience building dashboards with Power BI and Azure Synapse.
- Familiarity with Amazon RedShift and Tableau.
Responsibilities
- Analyze reporting requirements for NC FAST Case Management System reports and data interfaces.
- Develop data extracts, ETL batch jobs and reports using Oracle technologies.
- Design, code, test, debug, and document data interfaces and reporting solutions.
- Write efficient SQL queries on large tables storing CLOBS/XML; optimize performance.
- Provide 24x7 on-call support and on-call rotation.
Skills
Tools
Job description
eSystems, Inc. is seeking a Reports Developer to support NC FAST reporting and data extraction using Oracle and PL/SQL. The contract role requires 5+ years of experience and will involve designing, coding, testing, and maintaining data extracts and dashboards for the NC Department of Health and Human Services.
The position is hybrid in Raleigh, NC with a 12-month term and potential extension. The ideal candidate should have strong SQL skills, experience with ETL tools, and familiarity with BI
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
