BA/BSA

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.
11 days ago