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
- Experience in data modeling (logical and/or physical) with a solid understanding of 3NF, Star Schemas, and performance concerns
- 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.
Job Tags
Remote job, Full time, Offshore,