Minimum 8 years of experience as a technical business analyst.
Strong background in Data Warehousing and Information Management, especially with Teradata, Big Data, and GCP.
Recent experience of at least 1 year with Google Cloud BigQuery.
Expert-level SQL skills and experience with data modeling and ERwin.
Requirements:
Analyze data integration impacts on Data Warehouse and Big Data environments.
Coordinate testing, system impacts, and remediation plans across teams.
Design data models and manage requirements for medium to large projects.
Act as a liaison between business and technical teams to ensure project success.
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.
