Job Seekers, Please send resumes to swapna@hireitpeople.com

Job Description:

RESPONSIBILITIES

• Design and develop or modify ETL processes that load data for the data warehouse using ETL tools (SSIS) and SQL packages.
• Maintain existing ETL, SQL procedures, packages, and scripts
• Provide ETL performance tuning
• Design data warehouse schema and star schema data models
• Assist with the creation of reusable components as they relate to the ETL framework
• Build AWS solutions for the Data Management

REQUIREMENTS

• Bachelor’s Degree or comparable work experience. Computer Science or similar preferred
• Five years (minimum) of work experience as a Developer, and part of a Development team, personally and successfully implementing ETL code, projects and software. Seven years preferred.
• 3+ years of experience working across healthcare data in technical capacities. Specifically, you have strong knowledge of claims data, prior authorization data, and provider-side data. 
• 5+ years of experience in advanced Microsoft SQL Server.
• 2+ years of experience with ETL tools in a Data Warehouse environment.
• Proficiency with ETL tools such as SSIS.
• 2+ years of strong experience with AWS data services Lambda, Glue, EMR, Kinesis, Step Functions, Data Pipeline, Aurora, DynamoDB, Red Shift
• Developing Tableau workbooks from multiple data sources
• Minimum 1 year of experience in building Visualization / Analytics using Tableau (both extracted and live connected data sources)
• Understanding of Star schema database modeling. (OLTP & OLAP experience)
• Experience evaluating existing data warehouse implementation, architectures and processes
• Experience in Data Warehouse integration methodology; In-depth knowledge of developing and supporting data warehouses.

ATTRIBUTES

• Is eager to seek out and apply new technologies and skills for ETL improvement in daily work through conferences, online training, reading, participation in organizations and user groups, etc.
• Can translate business needs into technical and system design specifications
• Ability to work directly with business analysts or business sponsors clarifying business details.
• Is comfortable working in a young, growing EDW environment, where processes and systems are still being defined.