App Tech Specialist - ETL- Data Integration
Apply NowCompany: RICEFW Technologies, Inc.
Location: Trenton, NJ 08618
Description:
Lead the design and architecture of data integration solutions, aligning them with project goals and adhering to industry best practices
The App Tech Specialist - Data Integration will work on two critical, high-priority projects. First, the contractor will work on ensuring all portions of the potential Public Safety Assessment redesign is fully tested and documented. This may include the preparation of presentations for court stakeholders and documentation for court staff to implement the changes, if adopted. Second, this individual will also work on drafting the Criminal Analytics Warehouse, which will require a deep review of all current PSA documentation and to work with the data engineer and data scientists to ensure their design is written into the requirements for the NJ Judiciary ITO to build the warehouse.
Responsibilities: Requirements Gathering and Documentation
Technical and Non-Technical Collaboration
Data Integration Design
Testing and Quality Assurance
Complex Issue Troubleshooting
Education and Experience:
Technical Skills:
Required/Desired Skills
Skill Required /Desired Amount Candidate Experience Experience working in data integration & leading complex data integration projects, including req gathering, design, testing, and quality assurance Required 5 Experience gathering, analyzing, and documentin data integration requirements and translati those requirements into functional and technical solutions Required 5 Expert knowledge of data integration tools and technologies like ETL platforms, APIs, data warehousing, transformation tools, and related software Required 5 Experience in designing and building data models that efficiently consolidate data from disparate sources Required 5 Experience with scripting languages like SQL or Python for data manipulation and transformations Required 5 Expertise in data quality testing, validation, and cleansing techniques Required 5 Experience with Advanced troubleshooting skills to identify and resolve complex data integration issues Required 5 Minimum of a bachelor's degree in Computer Science, Information Technology, Data Science, or a related field Required 0 Questions
No. Question Candidate Answer Question1 Absences 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 agree to this requirement? Question2 What is your candidate's email address? Question3 Where does your candidate currently reside (City & State)? Question4 If your candidate resides more than 1 hour from the Client site, will your candidate relocate for the position? Question6 Please provide link to Linkedin profile if available.
The App Tech Specialist - Data Integration will work on two critical, high-priority projects. First, the contractor will work on ensuring all portions of the potential Public Safety Assessment redesign is fully tested and documented. This may include the preparation of presentations for court stakeholders and documentation for court staff to implement the changes, if adopted. Second, this individual will also work on drafting the Criminal Analytics Warehouse, which will require a deep review of all current PSA documentation and to work with the data engineer and data scientists to ensure their design is written into the requirements for the NJ Judiciary ITO to build the warehouse.
Responsibilities: Requirements Gathering and Documentation
- Gather, analyze, and document data integration requirements and translate those requirements into functional and technical solutions
- Ensure clear and comprehensive documentation detailing project specifications and objectives, ETL processes, data models, and data lineage
Technical and Non-Technical Collaboration
- Bridge the gap between technical and non-technical stakeholders, translating business needs into technical specifications
- Facilitate communication and understanding between clients, stakeholders, and the data analytics team
Data Integration Design
- Lead the design and architecture of data integration solutions, aligning them with project goals and adhering to industry best practices
- Strategize and develop data models, integration processes, and transformations to consolidate data from disparate sources
Testing and Quality Assurance
- Conduct extensive testing and quality assurance to ensure the accuracy and reliability of data integration solutions
- Implement comprehensive data validation procedures to maintain data integrity
Complex Issue Troubleshooting
- Investigate and resolve complex data integration issues using advanced troubleshooting skills and technical expertise
- Proactively identify potential challenges in data integration to minimize operational disruptions
Education and Experience:
- Minimum of a bachelor's degree in Computer Science, Information Technology, Data Science, or a related field
- Minimum of five years of proven experience in data integration and leading complex data integration projects, including requirement gathering, design, testing, and quality assurance
Technical Skills:
- Expert knowledge of data integration tools and technologies like ETL platforms, APIs, data warehousing, transformation tools, and related software
- Proficiency in designing and building data models that efficiently consolidate data from disparate sources
- Strong understanding of scripting languages like SQL or Python for data manipulation and transformations
- Expertise in data quality testing, validation, and cleansing techniques
- Advanced troubleshooting skills to identify and resolve complex data integration issues
Required/Desired Skills
Skill Required /Desired Amount Candidate Experience Experience working in data integration & leading complex data integration projects, including req gathering, design, testing, and quality assurance Required 5 Experience gathering, analyzing, and documentin data integration requirements and translati those requirements into functional and technical solutions Required 5 Expert knowledge of data integration tools and technologies like ETL platforms, APIs, data warehousing, transformation tools, and related software Required 5 Experience in designing and building data models that efficiently consolidate data from disparate sources Required 5 Experience with scripting languages like SQL or Python for data manipulation and transformations Required 5 Expertise in data quality testing, validation, and cleansing techniques Required 5 Experience with Advanced troubleshooting skills to identify and resolve complex data integration issues Required 5 Minimum of a bachelor's degree in Computer Science, Information Technology, Data Science, or a related field Required 0 Questions
No. Question Candidate Answer Question1 Absences 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 agree to this requirement? Question2 What is your candidate's email address? Question3 Where does your candidate currently reside (City & State)? Question4 If your candidate resides more than 1 hour from the Client site, will your candidate relocate for the position? Question6 Please provide link to Linkedin profile if available.