Description

Why Orthofix?

Guided by our organizational values Take Ownership | Innovate Boldly | Win Together we collaborate closely with world-class surgeons and other partners to improve people's quality of life. At Orthofix, we want team members who build relationships and share knowledge, challenge the status quo, and deliver results every day to help us achieve our vision to be the unrivaled partner in Med Tech.

Our global team of over 1,600 employees brings to market highly innovative, cost-effective, and user-friendly medical technologies that heal musculoskeletal pathologies for patients and the healthcare professionals who treat them. Looking to change people's lives? Look no further.

Data Engineer III

Perform data profiling and logical and/or physical data modelling to build new Extract, Transform, Load (ETL) designs and solutions. Develop, implement, and deploy ETL solutions to update data warehouse and datamarts. Maintain quality control, document technical specifications, and perform unit testing to ensure accuracy and quality of Business Intelligence (BI) data. Troubleshoot, debug, and diagnose ETL issues. Perform technical design, development, testing, and documentation of Data Warehouse and/or ETL projects. Provide production support and work with other IT team members and end users to resolve data refresh issues, including off-hours operational support when needed. Work with users, BI, and ERP teams to understand source system underlying architecture; and build ETL design and/or solutions. Perform performance tuning and enhancement of SQL and ETL processes and prepare related technical documentation. Meet with functional analysts or end users to gather and clarify requirements as needed to complete BI and/or DW projects. Develop and enhance BI reports or models, and provide support as needed. Work with Offshore team to coordinate development work and operational support. Keep abreast of latest ETL technologies and plan effective use. Implement new EDW and Cloud technologies to help evolve EDW architecture in efficiency and performance. Lead ETL tasks and activities related to BI projects; and assign or coordinate follow up on activities to meet ETL project timelines. Follow through and ensure proper closure of service request issues. Perform code reviews on ETL report changes where appropriate. Maintain appropriate skills needed for team growth in the skills matrix, determine areas requiring training, and mentor other data engineers in the BI Team. Coordinate with the DBA team on migration, configuration, and tuning of ETL codes. Assure execution of Standard Operating Procedures impacting the BI team. Continue to develop and assist in the promotion of the company's corporate culture environment, including working with other departments and company-wide to establish initiatives.

Bachelor's degree in Computer Information Systems, Electronics Engineering, Data Analytics, or related field and 5 years of experience building ETL designs and solutions; Building data warehouse systems in Medical device industry using Modern Data warehouse concepts, EDW and Data Lake/Cloud architecture; Working in SQL, writing Stored procedures and tuning SQL, using Oracle PL/SQL; Working in Cloud data integration; and Working with BI applications tools, such as Cognos.

Job Location: Carlsbad, CA

DISCLAIMER

The duties listed above are intended only as representation of the essential functions of this position. The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change at the sole discretion of the employer. Nothing in this document alters an employee's at-will employment status.

We are committed to providing equal employment opportunities to all employees and applicants without regard to race (including traits historically associated with race, such as hair texture and protective hairstyles, including braids, locks, and twists), ethnicity, religion, religious creed (including religious dress and grooming practices), color, caste, sex (including childbirth, breast feeding, and related medical conditions), gender, gender identity or expression, sexual orientation, national origin, ancestry, citizenship status, uniform service member and veteran status, marital status, pregnancy, age (40 and over), protected medical condition (including cancer and genetic conditions), genetic information, disability (mental and physical), reproductive health decision-making, medical leave or other types of protected leave (requesting or approved for leave under the Family and Medical Leave Act or the California Family Rights Act), domestic violence victim status, political affiliation, or any other protected status in accordance with all applicable federal, state, and local laws.

This policy extends to all aspects of our employment practices including, but not limited to, recruiting, hiring, discipline, termination, promotions, transfers, compensation, benefits, training, leaves of absence, and other terms and conditions of employment.

Since 1980, Orthofix has evolved and grown to become one of the leading medical device companies with a spine and orthopedics focus in the world. Our newly merged Orthofix-SeaSpine organization is a leading global spine and orthopedics company with a comprehensive portfolio of biologics, innovative spinal hardware, bone growth therapies, specialized orthopedic solutions, and a leading surgical navigation system. Our products are distributed in 68 countries worldwide.

Our medical device company is headquartered in Lewisville, Texas, and has primary offices in Carlsbad, CA, and Verona, Italy. Our combined company's global R&D, commercial and manufacturing footprint also includes facilities and offices in Irvine, CA; Toronto, Canada; Sunnyvale, CA; Wayne, PA; Olive Branch, MS; Maidenhead, UK; Munich, Germany; Paris, France; and São Paulo, Brazil.

Founded in Verona, Italy, and now headquartered in Lewisville, Texas, Orthofix is proud to be recognized as the 8th Largest Orthopedic Medical Device Company in the World by Medical Design & Outsourcing magazine. Orthofix is committed to improving patients' lives and delivering innovative, quality-driven solutions that empower physicians and healthcare organizations to meet the needs of their patients every day.

PI280817114