SR. ENGINEER, DATA MANAGEMENT AND ANALYTICS (HYBRID)

Irvine, California • Salary: $140k - 160k per year + benefits • Posted: 1 month agoSr. 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 storiesWork with the Data Architect to accurately interpret the data modeling and design the ETL data flowDevelop 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 structureWrite efficient and well-performed stored procedures to extract and transform the source dataBuild reusable components for a scalable data integration methodology such as error handling, logging, and recoverabilityParticipate in the data modeling / schema designPerform and support query development and optimizationWhat Gets You The Job: Experienced in database development, OLTP and Data Warehouse/DimensionalProficient in programming languages – SQL3+ years of experiences working with SnowflakeExperienced in building or maintaining ETL/ELT processes – Matillion and SSISExperience with Agile MethodologiesExperience with Source Control – Bitbucket/Git/GithubExperienced with the software development lifecycleDetail-oriented and excellent organizational skillsExperienced using APIs as part of the data pipeline.Experiences with Snowflake Cloud Data Warehouse ELT MatillionExperience using Microsoft SSISExperience using Python for data integration and analysisAbility 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.