SQL ETL Data Analyst

6mo Contract to Hire

REMOTE

Primary Responsibilities:
Full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance
Gather and analyze business requirements
Develop technical specifications and design documents
Architect and design Data Warehouse infrastructure and solutions
Develop Test Strategy, Test Plans, Test scenarios, and Test scripts. Create Test Strategy / Test Data Requirements.
Test Data Warehouses/Data Marts
Deploy and maintain Data Warehouses/Data Marts
Write SQL statements to profile and analyze data
Work concurrently on several projects, each with specific instructions that may differ from project to project
Ensure that quality processes are carried out through all phases of the Software Development Lifecycle
Design and implement efficient and effective functional design solutions
Work closely with the Business and Developers to ensure requirements are met
Understanding of all phases of the Software Development Life Cycle, and using Agile Methodology and Tools
Respond to customer inquiries and production issues
Document, discuss and resolve business, data, and reporting issues within the team, across functional teams, and with business stakeholders
Partner with Business during User Acceptance Testing, assist business users in defining User Acceptance Testing, test cases and plans. Actively participate in user group meetings to review use cases and review Test Results prior to UAT start
Present written and verbal data analysis findings, to both the project team and business stakeholders
Monitor activities associated with responsible domains - job monitoring, issue identification, documentation, analysis, and resolution
Continually look for ways to eliminate/reduce, streamline, and automate

Required Qualifications:
5+ years of Data Analysis experience
5+ years of relational database experience
5+ years of complex SQL script writing experience
5+ years of experience testing
3+ years of experience with Agile/Scrum project management methodology and Agile tools (e.g., Rally or Jira)

Preferred Qualifications:
5+ years of Healthcare Data Analysis experience
3+ years of SQL or Teradata experience
3+ years of UNIX /Perl/Python scripting experiences
3+ years of experience with ETL tool
3+ years working on large data warehouse/big data projects
Healthcare Industry experience
Experience in an onshore/offshore model environment
Experience with Data stage ETL tool
Experience with Enterprise scheduling tools like Airflow, TWS
CA Agile Rally
Operations/production support
Excellent oral and written communication skills
Knowledge of open source tools and technologies like KAFKA , Github will be a plus.

Required Skills : 5+ years of Data Analysis experience 5+ years of relational database experience 5+ years of complex SQL script writing experience 5+ years of experience testing 3+ years of experience with Agile/Scrum project management methodology and Agile tools (e.g., Rally or Jira
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship :Yes
Interview times set :Yes
Type of project :Development/Engineering
Master Job Title :Misc: Non-Technical
Branch Code :Minneapolis