App Tech Specialist Kondapaneni
Apply NowCompany: RICEFW Technologies, Inc.
Location: Trenton, NJ 08618
Description:
As a member of the Data Analytics, Research and Standards Team within Trial Courts Services Unit of the NJ Judiciary, the candidate will extract, analyze, and integrate or join data from various systems to assist lines of business with analytical report
The ideal candidate will be responsible for working closely with Research Analysts to assist with conducting data analysis to make informed decisions. The ideal will also conduct data extraction via SQL as well as prepare and document data requirements and conduct data validation for the automation of data extractions to be used in analytics. The candidate will have experience in designing new data warehouse structures to meet business needs. The candidate must:
-Using excellent communication skills, work closely with lines of business, including Research Analysts to address data needs for analytics.
-Be proficient in SQL.
-Analyze raw system data.
-Mine large datasets and draw valid inferences and actionable insights.
-Use SQL to extract data from a large and complex data warehouse and conduct analysis to ensure the proper data is available to support business needs.
-Align data attributes across disparate systems to ensure common connection points are utilized when joining or integrating data sets.
-Work with technical teams to identify data sources.
-Prepare data requirements, data models and transformation rules for new data warehouse structures, including summary information optimized for analytics.
-Identify areas to increase efficiency and automation of data-related processes.
-Create test cases and perform quality validation of data warehouse content to ensure accuracy.
-Create data flow diagrams to illustrate data lineage and mapping from the data warehouse to end-point publication.
-Analyze code in BI tools (e.g., WebFocus, Tableau) to determine data usage and assist with determining the data usage accuracy.
-Conduct data profiling to identify data quality issues and work with Business and IT teams to resolve the issues.
RELEVANT WORK EXPERIENCE: 5 to 8 years
PREFERRED EDUCATION: 4 year college degree or equivalent technical study or advanced degree
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience Working closely with lines of business, including Research Analysts to address data needs for analytics.Required5YearsExperience with analyzing raw system dataRequired5YearsExperience with mining large datasets and drawing actionable insightsRequired5YearsExperience extracting data from large, complex data warehouseRequired5YearsExp. Preparing data reqs, data models and transformation rules for new data warehouse structures, incl. summary info optimized for analytics.Required5YearsExperience Creating test cases and performing quality validation of data warehouse content to ensure accuracyRequired5YearsProficiency in SQLRequired5YearsExperience Conducting data profiling to identify data quality issues and work with the Business and IT teams to resolve issues.Required5YearsExperience Creating data flow diagrams to illustrate data lineage and mapping from data warehouse to end-point publication.Required5YearsExperience in DB2 Server client skillsRequired5YearsExperience preparing data for use in TableauHighly desired3YearsExperience creating data extracts and basic reports using WebFOCUS InfoAssistDesired3Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2Please list candidate's email address HERE that will be used when submitting E-RTR.Question3Do you accept the maximum hourly Vendor Rate of NA (excluding the Efficiency Fee)?Question4One hour unpaid lunch. Do you accept this requirement?Question5Fingerprinting full state & federal background check to be completed by the state.Question6Travel within NJ is required and not reimbursed.
The ideal candidate will be responsible for working closely with Research Analysts to assist with conducting data analysis to make informed decisions. The ideal will also conduct data extraction via SQL as well as prepare and document data requirements and conduct data validation for the automation of data extractions to be used in analytics. The candidate will have experience in designing new data warehouse structures to meet business needs. The candidate must:
-Using excellent communication skills, work closely with lines of business, including Research Analysts to address data needs for analytics.
-Be proficient in SQL.
-Analyze raw system data.
-Mine large datasets and draw valid inferences and actionable insights.
-Use SQL to extract data from a large and complex data warehouse and conduct analysis to ensure the proper data is available to support business needs.
-Align data attributes across disparate systems to ensure common connection points are utilized when joining or integrating data sets.
-Work with technical teams to identify data sources.
-Prepare data requirements, data models and transformation rules for new data warehouse structures, including summary information optimized for analytics.
-Identify areas to increase efficiency and automation of data-related processes.
-Create test cases and perform quality validation of data warehouse content to ensure accuracy.
-Create data flow diagrams to illustrate data lineage and mapping from the data warehouse to end-point publication.
-Analyze code in BI tools (e.g., WebFocus, Tableau) to determine data usage and assist with determining the data usage accuracy.
-Conduct data profiling to identify data quality issues and work with Business and IT teams to resolve the issues.
RELEVANT WORK EXPERIENCE: 5 to 8 years
PREFERRED EDUCATION: 4 year college degree or equivalent technical study or advanced degree
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience Working closely with lines of business, including Research Analysts to address data needs for analytics.Required5YearsExperience with analyzing raw system dataRequired5YearsExperience with mining large datasets and drawing actionable insightsRequired5YearsExperience extracting data from large, complex data warehouseRequired5YearsExp. Preparing data reqs, data models and transformation rules for new data warehouse structures, incl. summary info optimized for analytics.Required5YearsExperience Creating test cases and performing quality validation of data warehouse content to ensure accuracyRequired5YearsProficiency in SQLRequired5YearsExperience Conducting data profiling to identify data quality issues and work with the Business and IT teams to resolve issues.Required5YearsExperience Creating data flow diagrams to illustrate data lineage and mapping from data warehouse to end-point publication.Required5YearsExperience in DB2 Server client skillsRequired5YearsExperience preparing data for use in TableauHighly desired3YearsExperience creating data extracts and basic reports using WebFOCUS InfoAssistDesired3Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2Please list candidate's email address HERE that will be used when submitting E-RTR.Question3Do you accept the maximum hourly Vendor Rate of NA (excluding the Efficiency Fee)?Question4One hour unpaid lunch. Do you accept this requirement?Question5Fingerprinting full state & federal background check to be completed by the state.Question6Travel within NJ is required and not reimbursed.