Offer summary

Qualifications:

At least 8 years experience as a technical business analyst with a focus on data-related projects. Familiarity with Data Warehousing, Teradata, Big Data, and Google Cloud Platform. Solid SQL skills and experience in data modeling using tools like Erwin. Previous work on large-scale integration projects and Cloud migrations..

Key responsabilities:

Analyze the impacts of data integration on the Data Warehouse environment. Coordinate testing requirements and performance evaluation for moving to Google Cloud Platform. Capture usage requirements, design data models, manage project plans, and liaise between business and technical teams. Review data models, coordinate with development teams, lead projects to completion, provide stakeholder interfaces, limit interoperability while applying critical thinking to resolve problems

Job description

BUSINESS SYSTEMS ANALYST

((Compensation))

Pay is $45 - 55/hr. DOE (If the pay does not work for you, please do not apply as this is non-negotiable)

**Remote Until COVID**

What you’ll do:

Act as a Business Systems Analyst in client Data Integration & Account Conversion project team

Analyze the impacts of data integration on Data Warehouse and Big Data environment

Analyze and coordinate regression testing requirements across all lines of businesses

Analyze the performance impacts of moving Data Warehouse to Google Cloud Platform (GCP)

Coordinate with source systems and downstream system teams to assess the impacts and implement a remediation plan

Coordinate with infrastructure teams, DBA’s, and admins to evaluate the performance impact on ETL jobs, SLA’s on data availability, and plan on remediation

Analyze source system data, profiling data (using SQL and Hive QL), and arranging service level agreements with data providers

Design conceptual and logical data models (using ERwin), create metadata definitions and create the source-to-target mapping.

Act as requirements coordinator for 1-2 medium to large projects, capture usage requirements, and design the semantic/information layer.

Prepare and manage the project plans and recommending solutions.

Partner with business users and act as a liaison between business and technical teams.

Coordinate data model reviews and handoff to the ETL development team.

Build a deep understanding of the warehouse data and capabilities.

What you have:

At least 8 years of experience as a technical business analyst with a track record of delivering well-documented data requirements

Substantial experience in Data Warehousing / Information Management, preferably using Teradata database platform, Big Data and Google Cloud Platform (GCP)

Must have at least 1-year of recent experience using Google Cloud Big Query.

Experience in working on large scale data integration and Cloud Migration projects

Expert-level SQL skills

Experience in data modeling (logical and/or physical) with a solid understanding of 3NF, Star Schemas, and performance concerns

Experience using Erwin

Familiarity with Informatica and Hive preferred.

Experience /knowledge of Project Management with the ability to drive projects to successful completion

Experience in Agile development methodology

Prior experience interfacing with various partners, including vendors, offshore development teams, and internal groups

Strong interpersonal, analytical, problem-solving, influencing, prioritization, decision- making and conflict resolution skills.

Excellent written/verbal communication skills

Strong knowledge of MS Project, Excel, MS Word, Visio Drawing tools, and general familiarity with Outlook and other MS Office applications is also required.

Required profile