Talent Space is searching for a fulltime Data Engineer for our healthcare client headquartered in Irvine, CA. Must Haves:
- Matillion and SSIS ETL
- Snowflake Cloud Data Warehouse
- Python
Responsibilities
- Work closely with Data Warehouse product owner and BSA to thoroughly understand the business user stories
- Work with the Data Architect to accurately interpret the data modeling and design the ETL data flow
- Develop ETL/ELT data pipeline flow to load data from various data sources to the staging database and apply complex business logic to populate normalized and denormalized data structure
- Write efficient and well-performed stored procedures to extract and transform the source data
- Build reusable components for a scalable data integration methodology such as error handling, logging, and recoverability
- Participate in the data modeling / schema design
- Perform and support query development and optimization
Qualifications
- Experienced in database development, OLTP and Data Warehouse/Dimensional
- Proficient in programming languages - SQL
- 3+ years of experiences working with Snowflake
- Experienced in building or maintaining ETL/ELT processes
- Agile Methodologies
- Source Control Bitbucket/Git/Github
- Experienced with the software development lifecycle
- Detail-oriented and excellent organizational skills
Preferred
- Experiences with Snowflake Cloud Data Warehouse ELT tools (dbt or Matillion)
- Experienced in integration of data from disparate sources including 3rd party vendor data and/or API calls
- Experience using Microsoft SSIS
- Experience using Python for data integration and analysis
Knowledge/Skills/Abilities
- Ability to multi-task effectively without compromising the quality of the work.
- Excellent interpersonal, oral and written communication skills.
- Detail oriented, organized, process focused, problem solver, proactive, ambitious, customer service focused.
- Ability to draw conclusions and make independent decisions with limited information.
- Ability to respond to common inquiries from customers, staff, regulatory agencies, vendors, and other members of the business community.
- Self-motivated, reliable individual capable of working independently as well as part of a team.
- Possess the intellectual curiosity to work through ambiguity and have ability to work independently with minimal instruction.
- Ability to manage change and do extremely well in a fast-paced environment under time constraints.
- Ability to take initiative and work independently, and work effectively with individuals belonging to all levels within the organization.
- Ability to work with mathematical concepts such as probability and statistical inference.
- Ability to effectively and succinctly simplify complex data and communicate information to Senior Management.
- Customer service oriented and proactive in anticipating and resolving problems while maximizing efficient use of computing resources.
100% Onsite in Irvine, CA.
No Visa Sponsorships available