Business Analyst

Cygnus Professionals; Trenton (NJ); On-site; USD 70,000 - 90,000; Full time

Job summary

A technology consulting firm is seeking a Business Analyst/Integration Specialist in Trenton, NJ. The ideal candidate will assist in identifying and documenting business requirements and data integration rules. Responsibilities include gathering business requirements, analyzing data quality, and collaborating with architects and developers. A bachelor's degree and experience in data integration for large enterprises are essential. Proficiency in MS Project, Word, and Excel is required.

Qualifications

• Bachelor's degree is a minimum requirement.
• 3+ years of experience in documenting business requirements and data integration rules.
• 1+ year as a lead analyst in a large enterprise environment.
• Thorough knowledge of business analytics technology.
• Strong interpersonal skills are essential.

Responsibilities

• Participate in gathering business requirements.
• Document business rules and requirements including data changes.
• Identify source systems for potential data contributions.
• Analyze data quality in source systems.
• Work with data architects to ensure proper representation of business rules.
• Develop mappings from source systems to the logical data model.
• Provide feedback on project timelines and updates.
• Work with development teams to resolve data mapping issues.
• Assist Quality Assurance in developing test plans.

Skills

Documenting business requirements

Data integration rules

Business analytics technology

Interpersonal skills

Education

Bachelor's degree

Tools

MS Project

MS Word

MS Excel

Job description

Overview

This endeavor will require a Business Analyst/Integration Specialist. Under direction of the Project Manager or designee in the Office of Information Technology (OIT), the Business Analyst/Integration Specialist will assist the Project Manager and Project Technical Architect in the identification and documentation of business requirements, the identification and analysis of potential source systems, the rationalization and documentation of data definitions and business rules from multiple systems, and the documentation and communication of data mappings to the data integration developers.

Responsibilities

• Participate in the gathering of business requirements
• Document business rules captured in the requirements sessions, including the requirements for tracking data changes over time
• Identify the source systems with potential data to contribute to the solution
• Analyze the quality of the data in the source systems to confirm that the data is as described; work with data stewards to resolve any discrepancies
• Work with the Data Architect / Data Modeler to make sure all business rules are properly represented in the project logical data model
• Develop mappings of the source system data to the project logical data model, including all transformation and aggregation rules, and provide these mappings to the Data Architect / Data Modeler and the development team
• Develop mappings from the project logical data model to any analytical structures that are required (data marts or dashboards), including all transformation and aggregation rules, and provide these mappings to the Data Architect / Data Modeler and the development team
• Provide feedback to the Project Manager regarding the development of realistic timelines, resource requirements, and data mapping deliverables, provide progress reports and status updates as necessary, and be accountable for those aspects of the resulting project plan
• Work with the Data Architect / Data Modeler and the development team to resolve problems with the data mappings that are uncovered during development, including unexpected data quality issues
• Assist the Quality Assurance Specialist to develop effective test plans to verify the business rules represented by the project objectives

Qualifications

• Bachelor's degree (minimum requirement) Required
• Documenting business requirements and data integration rules for data integration and/or data warehousing projects Required 3 Years
• Lead analyst for a project in a large heterogeneous enterprise environment Required 1 Years
• Thorough knowledge of business analytics technology Required
• Proficient in MS Project and MS word and MS excel Required
• Strong interpersonal skills Required

All your information will be kept confidential according to EEO guidelines.