Oracle BI & ETL Reports Developer

BuzzClan; Raleigh (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

BuzzClan is seeking a report developer to provide business and systems analysis, modeling, and programming for NC FAST reports using Oracle and PL/SQL. The role includes designing, coding, testing, and documenting data interfaces and reporting solutions with 24x7 on-call support.

The candidate will work with data extracts, ETL batch jobs, and dashboards, interpreting business requirements to deliver high-quality reporting for complex data sets and performance metrics.

Qualifications

• Experience with Oracle, Oracle Utilities, ETL tools.
• Experience with PL/SQL scripting and relational DB modeling.
• Experience with structured system development methodologies.
• Ability to develop relationships with customers and respond to needs with urgency.
• Experience with BI tools such as Business Objects or BIRT, and Agile development.
• Data Warehouse experience and dashboard development with Power BI/Azure Synapse.

Responsibilities

• Gather and document reporting requirements for NC FAST Case Management System reports.
• Develop data extracts, ETL batch jobs, and reports using Oracle technologies.
• Analyze queries and design dashboards to meet business metrics and performance targets.
• Provide 24x7 On-Call support/rotation and issue resolution.
• Collaborate with stakeholders to implement robust reporting solutions.

Skills

Oracle reporting

PL/SQL scripting

Relational DB modeling

BI tools (Power BI/Tableau)

Agile development

Data warehouse

Dashboard development

ETL batch jobs

Tools

Power BI

Azure Synapse

Oracle

Job description

BuzzClan is seeking a report developer to provide business and systems analysis, modeling, and programming for NC FAST reports using Oracle and PL/SQL. The role includes designing, coding, testing, and documenting data interfaces and reporting solutions with 24x7 on-call support.

The candidate will work with data extracts, ETL batch jobs, and dashboards, interpreting business requirements to deliver high-quality reporting for complex data sets and performance metrics.