About Fisher & Paykel Healthcare:Driven by a strong sense of purpose, Fisher & Paykel Healthcare works to improve patient care and outcomes through inspired and world-leading healthcare solutions. We have manufacturing locations in New Zealand and Mexico, and sales offices and distributors operating in over 120 countries worldwide. Our largest sales office is here in Irvine, California.We are a leading designer, manufacturer, and marketer of products and systems for acute and chronic respiratory care, anesthesia, and the treatment of obstructive sleep apnea.The needs of our customers and their patients drive everything we do. We call this commitment Care by Design.Job Title: Business Intelligence DeveloperJob Overview:The Business Intelligence Developer will research, design, support and develop integration solutions for our data warehouses. This person will collaborate with the team to ensure availability, performance, security, consistency, and reliability of data/database across multiple systems. This role will report to the Director of Business Intelligence.Responsibilities:
Build and maintain ETL processes, stored procedures, and data models for the Data Warehouse.
Deliver and operate data and information systems including the data warehouse, master data and related integrations.
Work with Business Analyst to prepare specification documents.
Ensure performance, security, and availability of databases.
Help write and optimize SQL statements.
Handle common database procedures such as upgrade, backup, recovery, and migration.
Conduct data profiling according to pre-defined data quality rules, able to review and interpret results and engage appropriate team members for remediation, develop procedures to cleanse data and/or work with system owners to identify root cause for data quality issues.
Education and Experience Requirements:
Bachelor's degree in computer science or related field
Minimum of 2 years of experience as a Business Intelligence Developer, ETL/DW Developer, or Data Engineer.
Skills Requirements:
Advanced SQL skills including reading and writing complex SQL, Stored Procedures, and Views.
Experience performing ETL, Data Validation, Data Mapping, Data Migration, dimensional modeling.
Working experience using SSIS with SQL Server 2016 or above.
Management of SQL Jobs, Packages, including migration from Development to Production with validation processes.
Experience maintaining and developing dashboards using Power BI.
Understanding of Data Warehousing design and modeling concepts.
Knowledge of best practices for managing relational databases.
Capable of troubleshooting common database issues.
Excellent analytical and problem-solving capabilities with special attention to accuracy and detail.
Self-starter with a proven ability to take ownership of job responsibilities and ensure successful completion of all projects and requests.
Strong verbal and written communication skills, with the ability to interface effectively with all levels of management, including executive and senior management teams.
Ability to effectively prioritize and multi-task in high volume workload situations.
Salary Range:The anticipated salary range for candidates working in Irvine, CA, is $84,000-$105,000. The final salary offered to a successful candidate will depend on several factors that may include but are not limited to the type and length of experience within the job, type and length of experience within the industry, education, etc. Fisher & Paykel Healthcare is a multi-state employer, and this salary range may not reflect positions that work in other states.In return, we will offer you an opportunity to work as part of a dedicated and energetic team at a company with a fantastic culture of commitment to our employees and customers. You'll have an opportunity to participate in a comprehensive benefits package that offers medical, dental, vision, life insurance, paid parental leave, 401k, employee stock purchase plan, and other options to meet the diverse needs of our employees.Apply today and join our dynamic Fisher & Paykel Healthcare team! You will be part of a culture motivated by transforming clinical practice and improving patient care and outcomes.US work authorization is a precondition of employment. Fisher & Paykel Healthcare will not consider candidates who require sponsorship for a work-authorized visa.Company relocation benefits will not be provided for this position.Fisher & Paykel Healthcare is an equal opportunity employer. The Company's policy is not to discriminate nor allow any employee to discriminate against any employee or applicant for employment based on race, color, age, religion, sex, national origin, disability, marital status, sexual orientation, or military status, including veterans and disabled veterans.Fisher & Paykel Healthcare participates in E-Verify.
