business analyst (sql experience)

business analyst (sql experience).

jersey city , new jersey

posted 5 days ago

job detailssummary

$60.26 - $68.26 per hour

contract

bachelor degree

category computer and mathematical occupations

reference1065362

job detailsjob summary:Job Description:Applies technical knowledge in determining integration requirements for Climate Risk Database. Serves as the liaison between product owners and development teams to elicit requirement deliverables for product design through interviews and workshop meetings with subject matter experts, product owners, and stakeholders. Captures detailed requirements and creates high level design documentation, activity workflows, business data dictionaries and data mapping documents. Coordinates the collaboration between various teams to support application development using best practices in AGILE methodologies. Conducts regular analysis, through data visualization and SQL Querying, to draw business-relevant conclusions and accurately communicate findings and possible solutions. Evaluates, tests, and recommends enhancement opportunities. Works under minimal supervision on developing creative solutions. IT degree preferred with a minimum of 5-7 years of applicable experience.Responsibilities:

Collaborate with Business partners to capture and document actionable written requirements and acceptance criteria.

Work with UI/UX designers, business partners and subject matter experts to design and develop screen mockups.

Data mapping source to target tables; understand the uniqueness and complexities of the data as well as its business usage.

Interface with the development team to ensure requirements are understood and delivered accordingly.

Review QA scripts as needed.

Use SQL queries to conduct analyses as needed

Work closely with Developers when questions arise, providing requirements clarifications in timely manner.

Manages UAT testing cycle

Generally be the central person for requirements and delivery between Development and Product Owner and Subject Matter Experts.

5+ years of experience in Business Analysis and/ or Requirements documentation, proficient in JIRA Horizon for requirements writing

3+ years of experience working with clients or stakeholder groups to resolve issues and design solutions

2+ years in an environment with heavy data analysis

Basic SQL Skills; able to create and run SQL scripts using TOAD.

Exposure to the Risk and Compliance domains

1 year of experience working in an Agile development environment

Participation in User Acceptance Testing for at least two projects, including test script creation, execution and defect validation.

Experience working directly with developers to communicate/interpret business requirements

Ability to explain the logic behind their analysis and express ideas clearly and concisely

Ability to provide clear status reports, explaining technical delivery in "kitchen English" appropriate for Executive reports

Experience with Microsoft Office suite of products, including Excel, PowerPoint and Word

Experience with writing documentation in Confluence Wiki

Experience with JIRA workflow management

Demonstrates sound judgement, working to resolve issues, and escalating where needed to ensure deliverables can be met

Effective written communication skills, with experience in writing Epics Stories in an Agile environment as well as HLD, LLD design documents

Effective verbal communication skills; experience with facilitating meetings with executives, technical personnel and/ or Business SMEs

Familiarity with Informatica, Oracle, Distribute, APIs, Angular, Alteryx

Familiarity with the Climate Risk domain

Exposure to Bloomberg Climate data

location: Jersey City, New Jerseyjob type: Contractsalary: $60.26 - 68.26 per hourwork hours: 8am to 5pmeducation: Bachelorsresponsibilities:

Collaborate with Business partners to capture and document actionable written requirements and acceptance criteria.

Work with UI/UX designers, business partners and subject matter experts to design and develop screen mockups.

Data mapping source to target tables; understand the uniqueness and complexities of the data as well as its business usage.

qualifications:

Experience level: Experienced

Minimum 10 years of experience

Education: Bachelors

skills:

Planning

SQL (5 years of experience is preferred)

JIRA (5 years of experience is required)Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).This posting is open for thirty (30) days.