ExecRecruitment

ETL Reports Developer

Raleigh, NC
Full Time
Experienced

The NC Department of Health and Human Services seeks a contractor to assist with implementation and maintenance of data extracts, ETL batch jobs, and reports, for NC Families Accessing Services through Technology (NC FAST) using Cúram Software product and Oracle. The selected candidate will analyze and identify reporting requirements for NC FAST Case Management System reports and implement recommendations to effectively report data of mid to high level complexity. This is related to varied business metrics and for designing, coding, testing, debugging, and documenting data interfaces and reporting solutions, while enhancing existing data extracts and reports to ensure that solutions continue to meet business needs.

Selected candidate must understand the underlying data sources (databases) and interpret requirements provided by the business to analyze operational issues and develop appropriate diagnostic and/or tracking data via reports and dashboards. Duties include but are not limited to gathering and documenting requirements for new as well as changes to existing data extracts and report, developing complex queries against big tables storing CLOBS/XML, necessary supporting data structures, and report layouts, and writing effective SQL queries that perform well even against large tables. This role will also analyze existing queries and report and query data to fix issues and extract data and develop and analyze operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies. This position will have responsibility for 24x7 On Call support/rotation.

Skill Matrix:

  • Experience in using Oracle, Oracle Utilities, ETL tools Required 5 Years
  • Experience with PL/SQL scripting and Relational Database modeling. Required 5 Years
  • Experience with structured system development methodologies Required 5 Years
  • Ability to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options. Required 5 Years
  • Ability to organize, prioritize, and follow complex and/or detailed technical procedures. Required 5 Years
  • Experience with Business Intelligence tools such as Business Objects or BIRT Required 5 Years
  • Experience with Agile (Scrum, Kanban, or SAFe) development Required 2 Years
  • Data Warehouse experience Required 2 Years
  • Experience with developing dashboards with Power BI and Azure Synapse Highly desired 2 Years
  • Familiarity with Amazon RedShift & Tableau Desired 2 Years

Benefits at IntelliBee

  • Long-Term Stability: Join us on a multi-year opportunities with room to grow.
  • Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
  • Future Planning: Enroll in our 401(k) program and invest in your financial security.
  • GC Assistance: We support immediate Green Card processing, if required.
Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Human Check*