Sr. Engineer, Data Management and Analytics (Hybrid)

We have an immediate need for a direct hire Sr. Engineer, Data Management and Analytics to join a leading dental business support organization. The Sr. Engineer, Data Management and Analytics will be responsible for leading and managing the execution and overall performance of data management initiatives within the organization.

Location: Irvine, CA (Hybrid)

This job expects to pay about $140,000 – 160,000 annually plus bonus and benefits.

What You Will Do: 

• 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

What Gets You The Job: 

• 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 – Matillion and SSIS
• Experience with Agile Methodologies
• Experience with Source Control – Bitbucket/Git/Github
• Experienced with the software development lifecycle
• Detail-oriented and excellent organizational skills
• Experienced using APIs as part of the data pipeline.
• Experiences with Snowflake Cloud Data Warehouse ELT Matillion
• Experience using Microsoft SSIS
• Experience using Python for data integration and analysis
• 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.

Irvine Technology Corporation (ITC) is a leading provider of technology and staffing solutions for IT, Security, Engineering, and Interactive Design disciplines servicing startups to enterprise clients, nationally. We pride ourselves in the ability to introduce you to our intimate network of business and technology leaders – bringing you opportunity coupled with personal growth, and professional development!  Join us. Let us catapult your career!

Irvine Technology Corporation provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Irvine Technology Corporation complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.