NJAOC Data Architect Mid-Level Data Analyst

Trenton, NJ - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

This Data Analyst position is to work with Business Teams and bridge the gap between business partners and the technology solution providers by translating business needs into Warehouse solutions for BI.

This Data Analyst position is to work with Business Teams and bridge the gap between business partners and the technology solution providers by translating business needs into Warehouse solutions for BI. Data Analyst should have extensive SQL writing experience. This position will also involve identification/Verifications of test plans to ensure that technical solutions meet the needs of the business.
In addition to being experienced in gathering and documenting requirements facilitating meetings and delivering results this person must also be a highly organized self-starter who thrives in a fast-paced and rapidly changing environment.

Responsibilities:

Collaborate with stakeholders from multiple disciplines to elicit business data and functional requirements into Technical requirements
The role is to act as a liaison between business units and data warehouse technical development team to ensure business requirements are understood and translated into functional and technical requirements.
Document business data glossaries including business definitions and business rules for technical team to develop logical and physical data model design.
Data Analysts will understand raw data for various departments and consolidate it into information useful for decision-making by users for Unified Enterprise System.
Translate data requirements into clearly defined and easily understood documents including business use cases process flows data flows business rules data definitions and process-to-data mapping diagrams etc.
Required experience on SQL writing like DB2 AWS (Dynamo Redshift) as well as have a High-level Understanding of Technical Programing like Java Python Pega etc.
Work with stakeholders including business and technology SMEs to conduct design sessions/training sessions / demos and to develop user manuals and guides if necessary.
Work closely with the design and development team to ensure that the technology solution satisfies business requirements.
Partner with QA team and SMEs to ensure adequate test coverage (relying on own knowledge as well as facilitating conversations with SMEs to identify additional test scenarios).
Suggest multiple implementation options each with associated risks/costs and where applicable recommend an option
Assist with troubleshooting and managing production issues when needed

Requirements:

Curiosity and desire to question the status quo
A proactive self-starter with the ability to work independently with limited supervision
Proven record of strategic thought leadership and ability to drive results
Success collaborating motivating and influencing stakeholders and partners in various deparments .
Excellent communicator with superior verbal written technical and presentation skills
2 3 years of experience with SQL like DB2 (Legacy) AWS (Dynamo Redshift ) is a must.
Track record of innovation in the everyday as well as development of breakthrough ideas
Strong attention to detail with the ability to break down project tasks define project scope plan and organize resources to complete projects on time and within budget
Excellent interpersonal and collaboration skills
5 years of experience with at least 2 years working in a business analyst function supporting data governance and management initiatives is preferred
Knowledge of SharePoint and JIRA is a plus (Preferred)
2 3 years of Experience Microsoft Excel Visio PP Docs. (preferred)
1 year Experience in Data Visualization. (preferred)
Good Presentation Skills
Experience in SQL writing (preferred)

Required/Desired Skills

Skill	Required /Desired	Amount	of Experience
Excellent communicator with superior verbal written technical and presentation skills	Required	3	Years
experience with SQL like DB2 (Legacy) AWS (Dynamo Redshift )	Required	3	Years
Track record of innovation in the everyday as well as development of breakthrough ideas	Highly desired	3	Years
5 years of experience with at least 2 years working in a business analyst function supporting data governance and management initiatives is preferre	Required	5	Years
Knowledge of SharePoint and JIRA is a plus	Nice to have	4	Years
2 3 years of Experience Microsoft Excel Visio PP Docs.	Required	3	Years
1 year Experience in Data Visualization.	Required	1	Years
Good Presentation Skills	Highly desired	2	Years
Experience in SQL writing	Required	3	Years
4 years college degree or equivalent technical study	Required	4	Years

Questions

No.	Question	Candidate Response
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 accept this requirement
Question2	Please list candidates email address.
Question3	Where is the candidate currently geographically located

Collaborate with stakeholders from multiple disciplines to elicit business data and functional requirements into Technical requirements
The role is to act as a liaison between business units and data warehouse technical development team to ensure business requirements are understood and translated into functional and technical requirements.
Document business data glossaries including business definitions and business rules for technical team to develop logical and physical data model design.
Data Analysts will understand raw data for various departments and consolidate it into information useful for decision-making by users for Unified Enterprise System.
Translate data requirements into clearly defined and easily understood documents including business use cases process flows data flows business rules data definitions and process-to-data mapping diagrams etc.
Required experience on SQL writing like DB2 AWS (Dynamo Redshift) as well as have a High-level Understanding of Technical Programing like Java Python Pega etc.
Work with stakeholders including business and technology SMEs to conduct design sessions/training sessions / demos and to develop user manuals and guides if necessary.
Work closely with the design and development team to ensure that the technology solution satisfies business requirements.
Partner with QA team and SMEs to ensure adequate test coverage (relying on own knowledge as well as facilitating conversations with SMEs to identify additional test scenarios).
Suggest multiple implementation options each with associated risks/costs and where applicable recommend an option
Assist with troubleshooting and managing production issues when needed

Requirements:

Curiosity and desire to question the status quo
A proactive self-starter with the ability to work independently with limited supervision
Proven record of strategic thought leadership and ability to drive results
Success collaborating motivating and influencing stakeholders and partners in various deparments .
Excellent communicator with superior verbal written technical and presentation skills
2 3 years of experience with SQL like DB2 (Legacy) AWS (Dynamo Redshift ) is a must.
Track record of innovation in the everyday as well as development of breakthrough ideas
Strong attention to detail with the ability to break down project tasks define project scope plan and organize resources to complete projects on time and within budget
Excellent interpersonal and collaboration skills
5 years of experience with at least 2 years working in a business analyst function supporting data governance and management initiatives is preferred
Knowledge of SharePoint and JIRA is a plus (Preferred)
2 3 years of Experience Microsoft Excel Visio PP Docs. (preferred)
1 year Experience in Data Visualization. (preferred)
Good Presentation Skills
Experience in SQL writing (preferred)

Required/Desired Skills

Skill	Required /Desired	Amount	of Experience
Excellent communicator with superior verbal written technical and presentation skills	Required	3	Years
experience with SQL like DB2 (Legacy) AWS (Dynamo Redshift )	Required	3	Years
Track record of innovation in the everyday as well as development of breakthrough ideas	Highly desired	3	Years
5 years of experience with at least 2 years working in a business analyst function supporting data governance and management initiatives is preferre	Required	5	Years
Knowledge of SharePoint and JIRA is a plus	Nice to have	4	Years
2 3 years of Experience Microsoft Excel Visio PP Docs.	Required	3	Years
1 year Experience in Data Visualization.	Required	1	Years
Good Presentation Skills	Highly desired	2	Years
Experience in SQL writing	Required	3	Years
4 years college degree or equivalent technical study	Required	4	Years

Questions

No.	Question	Candidate Response
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 accept this requirement
Question2	Please list candidates email address.
Question3	Where is the candidate currently geographically located