Data Architect

Job Summary :

The Data Analyst will serve as a crucial bridge between business teams and technology solution providers, focusing on translating business needs into data warehouse solutions for Business Intelligence (BI). This role involves gathering and documenting technical requirements, writing SQL queries, and ensuring comprehensive test plans to validate technical solutions. The ideal candidate will possess strong SQL skills, a solid understanding of business processes and data needs, and experience in facilitating meetings and working in a dynamic environment.

Location : Trenton, New Jersey, United States

Responsibilities :

• Collaborate with stakeholders to gather business, data, and functional requirements and translate them into technical specifications.
• Act as a liaison between business units and the data warehouse development team.
• Document business data glossaries, including business definitions and rules.
• Consolidate raw data from different departments into usable information for decision-making.
• Translate data requirements into clear documents such as business use cases, process flows, and data definitions.
• Write SQL queries for database management and support data integration efforts.
• Collaborate with business and technology SMEs to conduct design sessions, training, and demos.
• Ensure that technology solutions meet business requirements.
• Partner with the QA team and SMEs to ensure comprehensive test coverage.
• Evaluate multiple implementation options, assess risks and costs, and recommend the most appropriate solution.
• Assist with troubleshooting and managing production issues.

Required Skills & Certifications :

Preferred Skills & Certifications :

Special Considerations :

Scheduling :