The client 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 Cu 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.
Writing effective SQL queries that perform well even against large tables.
Analyzing existing queries and report and query data to fix issues.
Extracting data and developing and analyzing operational performance metrics and reports.
Ensuring the quality and integrity of extracts through the use of validation and audit strategies.
Responsibility for 24x7 On Call support/rotation.
Required Skills:
Experience in using Oracle, Oracle Utilities, ETL tools 5 Years
Experience with PL/SQL scripting and Relational Database modeling 5 Years
Experience with structured system development methodologies 5 Years
Ability to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options 5 Years
Ability to organize, prioritize, and follow complex and/or detailed technical procedures 5 Years
Experience with Business Intelligence tools such as Business Objects or BIRT 5 Years
Experience with Agile (Scrum, Kanban, or SAFe) development 2 Years
Data Warehouse experience 2 Years
Experience with developing dashboards with Power BI and Azure Synapse 2 Years
Familiarity with Amazon RedShift & Tableau 2 Years
Numbers & Facts
Location
Raleigh, NC
Industry
Computer/IT Services
Company Size
20 to 49 employees
Year Founded
2002
Website
http://crescensinc.com/
About Company
Crescens Inc. is an industry leader in providing IT staffing services and tailored workforce solutions to meet the demanding expectations and distinctive needs of clients across the United States and Canada. We have grown tremendously in the past years and have been applauded by our clients for the quality of workforce and the quick turnaround time. We have evolved from good service to great service and all management plans are geared towards quality.
Our vision is to be the best in Talent Acquisition and strive for excellence consistently by focusing on four performance dimensions; Quality, Efficiency, Cost and Risk. A satisfied client and candidate are the backbone to our continued success. Headquartered in New Jersey, we are a team with unique expertise to deliver exceptional results to our clients by setting benchmarks and establishing best practices.
Skills
Agile Programming Methodologiesunmatched
Alliance/Partner Managementunmatched
Analysis Skillsunmatched
Business Intelligence Softwareunmatched
Business Operationsunmatched
Case Managementunmatched
Data Structuresunmatched
Data Warehousingunmatched
Database Designunmatched
Database Extract Transform and Load (ETL)unmatched
Debugging Skillsunmatched
Documentationunmatched
Establish Prioritiesunmatched
Kanbanunmatched
Metricsunmatched
Microsoft Windows Azureunmatched
On Callunmatched
Operational Auditunmatched
Operations Planningunmatched
Oracleunmatched
Oracle PL-SQLunmatched
Performance Analysisunmatched
Performance Metricsunmatched
Power BIunmatched
Problem Solving Skillsunmatched
Query Analysisunmatched
Relational Databases (RDBMS)unmatched
Reporting Dashboardsunmatched
SAP BusinessObjectsunmatched
SQL (Structured Query Language)unmatched
Sales Managementunmatched
Scripting (Scripting Languages)unmatched
Scrum Project Management and Software Developmentunmatched
Tableauunmatched
Testingunmatched
XML (EXtensible Markup Language)unmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.