[Hiring] ETL and Reports Developer @DMS Vision

Role Description

The NC FAST requires the services of a senior ETL and reports developer to provide business and systems analysis, modeling, design, and programming for FNS/SNAP reports development and maintenance operations using ORACLE and PL/SQL programming technologies.

The selected candidate will:

• 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.
• Analyze and identify reporting requirements for NC FAST Case Management System reports.
• Implement recommendations to effectively report data of mid to high level complexity related to varied business metrics.
• Design, code, test, debug, and document data interfaces and reporting solutions.
• Enhance existing data extracts and reports to ensure that solutions continue to meet business needs.
• Understand underlying data sources (databases) and interpret requirements provided by the business.
• Analyze operational issues and develop appropriate diagnostic and/or tracking data via reports and dashboards.
• Gather and document requirements for new as well as changes to existing data extracts and reports.
• Develop complex queries against big tables storing CLOBS/XML and necessary supporting data structures.
• Write effective SQL queries that perform well even against large tables.
• Analyze existing queries and report data to fix issues and extract data.
• Develop and analyze operational performance metrics and reports to ensure the quality and integrity of extracts through validation and audit strategies.
• Be responsible for 24x7 On Call support/rotation.

Qualifications

• Build data analytics solutions using Azure Synapse serverless SQL pools.
• Perform data engineering with Azure Synapse Apache Spark Pools.
• Experience configuring, designing, developing, and testing dashboards using Power BI.
• Experience in using Oracle, Oracle Utilities, ETL tools.
• Experience with PL/SQL scripting and Relational Database modeling.
• Experience with structured system development methodologies.
• Ability to develop relationships/partnerships with customers by responding to needs and exhibiting a sense of urgency.
• Ability to organize, prioritize, and follow complex and/or detailed technical procedures.
• Experience with Business Intelligence tools such as Business Objects or BIRT.
• Experience with Agile (Scrum, Kanban, or SAFe) development.
• Data Warehouse experience.
• Ability to lead and mentor the team and take ownership.
• Familiarity with Amazon RedShift & Tableau.
• Experience with Dell Boomi.

Requirements

• List all certifications candidate has around ORACLE, Power BI, Synapse, Agile, and others.
• Explain experience leading and mentoring a team of technical reporting resources, including the number of resources in the team.

Company Description