Data Architect - Mid-Level Data Analyst
Sunrise Systems Inc
Trenton, NJ
Job ID: 25-11547
Location: Trenton, NJ
Duration: 06 Months of contract
This Data Analyst position is to work with Business Teams and bridge the gap between Client 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 Client 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 Client 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 Client 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 departments .
- 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)
Skill Matrix:
| 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 |
Compensation:
The hourly rate for this position is between $63.00-$70.00 per hour
Factors which may affect starting pay within this range may include [geography/market, skills, education, experience and other qualifications of the successful candidate].
Benefits:
Sunrise offers ACA compliant medical coverage/dental insurance/vision insurance to all employees. We also offer Sick time benefits as required per State regulations.
Contact:
Jaya Balaji: jayabalaji.s@sunrisesys.com | (732) 515-5373 | URL: www.sunrisesys.com
About the Company
Sunrise Systems Inc
Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.
We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.
Our collective business experience spans over two and a half decades and ranges from:
- Business, management, and technical fields
- Information technology consulting and software solutions.
- Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
- Motivating technology staff and establishing partnerships with Fortune 500 companies
Sunrise Systems has a vast range of competence in:
- Design, development, and support of cloud-based solutions from simple to highly complexed
- Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
- Data processing and data migration
- Application re-engineering and platform migration
- Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.