Technical Specialist

Job Description:

A senior level resource Experienced ETL and Analytics developer using Pentaho data integration and Mondrian schema work bench.

North Carolina legislature passed SB 257 a few weeks ago. It will raise the juvenile age from 15 to 17 for most criminal offenses. This position will be responsible for designing data cubes to run in Pentaho’s BA server to predict the work load increase per district and county so that staffing can be in place prior to the law going in effect on Dec 1 2019.

The Technical Specialist is a senior level resource with specialized knowledge and experience in a specific technology. The Technical Specialist has an overall knowledge and understanding of application development and architecture that serves as a strong base for technical expertise in a specific product or program. Demonstrates expertise in conveying technical and functional concepts for a specific technical specialty. Identifies improvements to project standards to achieve high quality services/ products. Able to identify best practices and standards for the use of the product. Delivers support and design for industry specific applications that require integration with statewide systems or applications. Interacts with executive level business users or technical experts. May function as a niche technical SME. Advanced experience in the required technical subject matter. Proven experience with a technical specialty across large and complex implementations and systems.

Skill

• Experienced ETL and Analytics developer using Pentaho data integration and Mondrian schema work bench.
• Experience designing and implementing type 1 and 2 slowly changing dimensions in a data mart.
• Criminal or juvenile justice experience
• Experience designing data cubes
• SQL - Including DML and DDL
• MDX

******Interview Mode: In Person Only*****

****Must have State experience in past*****

Best Regards,

Amrit Lal