Data Architect

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 Candidate Response Last Used (in Year) 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 candidate's email address. Question3 Where is the candidate currently geographically located?

---