About dexcom:
Founded in 1999, dexcom, inc(nasdaq: dxcm), develops and markets continuous glucose monitoring (cgm) systems for ambulatory use by people with diabetes and by healthcare providers for the treatment of people with diabetesThe company is the leader in transforming diabetes care and management by providing cgm technology to help patients and healthcare professionals better manage diabetesSince the company’s inception, dexcom has focused on better outcomes for patients, caregivers, and clinicians by delivering solutions that are best in class—while empowering the community to take control of diabetesDexcom reported full-year 2020 revenue of $1.9b, a growth of 30% versus 2019Headquartered in san diego, california, with additional offices in the u.s., europe, and asia pacific, the company employs over 6,000 people worldwide.
Summary:
Provide expertise in osi pi system administration, sql database queries, data historian content, validation, and reports designSupport validation activities related to the data historian and maintain the validate state of the systemDevelop test plans for verification of the system changesTest system changesInterface the system with additional data sources as neededDevelop new content as requested by system users.
Functional description: professional individual contributor
Essential duties & responsibilities:
Osi pi administration: provide administration, development, validation and support of all aspects of the data historian, osi pi, including interfaces to automated equipment, control systems, other data bases and software.
Design and interface additional data sources with osi pi.
Lead data historian projects and internal/external resources, develop and manage project schedules and report and resolve project issues.
Experienced regarding relational database and data warehouse architect and design.
Experienced with sql and design and implementation of queries and stored procedures.
This position may also support and provide system administrator to some sql databases.
Possess full life-cycle experience on software projects.
Develop additional visualization and graphical object for osi pi with java scripts.
Develop and maintain source code for osi pi and database projectsEnsure that projects build successfully in a continuous integration environment.
Document and troubleshoot data historian performance or availability issues, data quality issues in an fda-compliant manner.
Work with cross-functional departments to define requirements, compliance documentation, test plans, test records and release implementation.
Provide periodic 24/7 remote phone support for the systems.
Work with cross-functional teams including r&d, operations, quality assurance, contract manufacturers, and other stakeholders to facilitate data access in terms of reporting, analysis systems, and data integration.
Develop reports and facilitate training for users to develop their own reports.
Effectively plan, define test strategy, provide qa estimates and provide test management throughout the testing cycle.
Create, maintain, and enforce internal development processes that align with industry best-practices and medical regulations alike.
Required qualifications:
Experience in osi pi system administration and content development.
Experience in sql server 2012+.
Experience in computer systems validation.
Experience in reporting and query tools and practices.
Hands on investigation and troubleshooting of databases issues is required.
Exposure to test-driven development and experience with all test phases.
Working knowledge with data management and data processing flowcharting techniques, and other tools, such as jira and confluence.
Good understanding of the organization’s goals and objectives.
Creative problem solver with attention to detail.
Able to prioritize and execute tasks in a high-pressure environment.
Experience working in a team-oriented, collaborative environment.
Strong english written and oral communication skills.
Preferred qualifications:
Working knowledge of plcs, hmis, opcs.
Working knowledge of microsoft sql reporting services and tableau.
Working knowledge of other data platforms such as oracle, microsoft azure, and hadoop.
Working knowledge of gmp standards and procedures.
Experience creating and/or reviewing design specifications, drawings, and other project documents such as urs, frs, sds, etc.
Experience with testing in a 21 cfr part 11 regulated environment.
Experience in working in clean room environments.
Familiarity with business continuity and disaster recovery plans.
Familiarity with oracle databases.
Familiarity with python, perl, r squared desired.
Familiarity with automation direct ignition scada.
Familiarity with siemens camstar.
Familiarity with labview.
Use of analytical tools and procedures used in lean six sigma such as utilizing the dmaic methodology for continuous improvement.
Experience and education requirements:
Typically requires a bachelor’s degree in a technical discipline, and a minimum of 8 years related experience or master’s degree and minimum 6 years equivalent industry experience or a phd and minimum 4 years related experience.
Travel required:
Up to 25% (international and domestic)
Functional/business knowledge:
Possesses broad understanding of technical principles and theoriesAbility to synthesize external data and research findings for application that may impact technical objectives.
Scope:
Demonstrates successes in technical proficiency and independent thoughtWorks on complex problems in which analysis of situations or data requires an indepth evaluation of various factorsExercises judgment within broadly defined practices and policies in selecting methods, techniques and evaluation criteria for obtaining results.
Judgement:
Exercises good judgment in selecting methods and techniques for obtaining solutions.
Normally receives little instruction on day-to-day work, general instructions on new assignments.
Language skills: must be able to communicate effectively in englishAbility to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manualsAbility to write routine reports and correspondenceAbility to speak effectively before groups of customers or employees of organization.
Physical demands: the physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this jobReasonable accommodations may be made to enable individuals with disabilities to perform the essential functionsMay be required to perform the following physical activity: standing, walking, sitting, using hands, handle or feel, reach with hands and arms, climb or balance, stoop, kneel, crouch, or crawl, talk or hear, taste or smellMay be required to lift 0 lbsTo over 100 lbs.
Work environment: the work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this jobReasonable accommodations may be made to enable individuals with disabilities to perform the essential functionsMay be exposed to the following environmental conditions: wet or humid conditions, work near moving parts, work in high - precarious places, fumes or airborne particles, toxic or caustic chemicals, outdoor weather conditions, extreme heat (non-weather), extreme cold (non-weather), risk of electric shock, work with explosives, risk of radiation, vibrationThe noise level in this work environment can range from quiet to very loud.
Please note: the information contained herein is not intended to be an all-inclusive list of the duties and responsibilities of the job, nor are they intended to be an all-inclusive list of the skills and abilities required to do the jobManagement may, at its discretion, assign or reassign duties and responsibilities to this job at any timeThe duties and responsibilities in this job description may be subject to change at any time due to reasonable accommodation or other reasons.
If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact dexcom talent acquisition at talentacquisition@dexcom.com.
An equal opportunity employerAll qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, or protected veteran status and will not be discriminated against on the basis of disabilityDexcom’s aap may be viewed upon request by contacting talent acquisition at talentacquisition@dexcom.com.
View the ofccp`s pay transparency non discrimination provision at this link.
