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.
Benefits
Sr Engineer, Data Management and Analytics • Irvine, California, US
We want you to feel comfortable doing great work and bringing your best, authentic self to everything you do.We value your talents, traditions, and uniqueness-and we're committed to fostering a str...[internal_linking.show_more]
Operations And Customer Analyst.Taco Bell was born and raised in California and has been around since 1962.We went from selling everyone's favorite Crunchy Tacos on the West Coast to a global brand...[internal_linking.show_more]
DataAnnotation is committed to creating high-quality AI.Join our team to help train the next generation of AI while enjoying the flexibility of remote work and the freedom to set your own schedule....[internal_linking.show_more]
Director of Financial Planning & Analysis.Director of Financial Planning & Analysis.Director of Financial Planning & Analysis.Director of Financial Planning & Analysis.The Director of Financial Pla...[internal_linking.show_more]
MV Transportation is seeking a Data Manager to ensure that all personnel who are required to input data, forms, and/or reports into the automated, web-enabled MIS system be able to do so with the h...[internal_linking.show_more]
A leading electric vehicle manufacturer is seeking a Staff Engineer for its Core Data team.This high-impact role focuses on building a top-tier data platform, setting data engineering best practice...[internal_linking.show_more]
Innovation starts from the heart.Our Advanced Technology (AT) teams harness the imagination, courage, and resourcefulness to think beyond what's currently possible, and create solutions for patient...[internal_linking.show_more]
Senior Analyst Supply Chain Data & Analytics.As a Senior Analyst of the Supply Chain Data & Analytics teams at ICU Medical, you will help influence leaders, improve Supply Chain efficiency, decreas...[internal_linking.show_more]
We are looking for a passionate individual with a sense of responsibility and willingness to help create families to join us as a surrogate.In this role, you will be instrumental in supporting indi...[internal_linking.show_more]
Logistics And Procurement Specialist.Minimum 8 to 10 years of experience in logistics and procurement.Should have done 2 full lifecycle implementations in S4 HANA.Preferably with good data migratio...[internal_linking.show_more]
We're building a world of health around every individual - shaping a more connected, convenient and compassionate health experience.At CVS Health, you'll be surrounded by passionate colleagues who ...[internal_linking.show_more]
Sales Analyst, is an on-site position based out of Corona, CA, and is responsible for the generation of statistical reports and analyzing the results to provide insight to the Director of Business ...[internal_linking.show_more]
This role provides technical leadership in designing and optimizing ETL/ELT frameworks using Azure data services (Fabric, Data Lake, Data Factory), integrating data from ERP, CRM, and operational s...[internal_linking.show_more]
Senior Research and Data Solutions Analyst.Under supervision, will assist in developing, designing, and preparing major institutional research studies, perform complex higher order statistical anal...[internal_linking.show_more]
Omaha, NE; Fargo, ND; Sioux Falls, SD; Irvine, CA or other Eide Bailly markets.Remote / Hybrid (near Eide Bailly location).Eide Bailly is seeking a results-driven Sales Executive with strong.Micros...[internal_linking.show_more]
Are you an analyst with a knack for solving problems through data and turning complex information into clear, actionable insights? Do you thrive in fast-paced environments where your analysis direc...[internal_linking.show_more]
We are looking for an experienced MLOps Engineer to build and scale machine learning solutions that address critical challenges in the healthcare revenue cycle.You will report to Experian Health an...[internal_linking.show_more]
Driving Profitable Growth: The CMO is accountable for revenue growth through customer acquisition and retention, ensuring all marketing initiatives align with the company's financial goals and busi...[internal_linking.show_more]
