Reports Developer

Crescens Inc.

Raleigh, NC
3 days ago

Highlights

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. Primary Responsibilities 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.

Numbers & Facts

Location	Raleigh, NC
Industry	Computer/IT Services
Company Size	20 to 49 employees
Year Founded	2002
Website	http://crescensinc.com/

Description

Job Title: Reports Developer
Location: Raleigh, NC (Onsite)
Duration: 12+ Months

Primary Responsibilities

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

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.