Data Engineer V

The Cystic Fibrosis Foundation is a leading healthcare nonprofit organization like no other. For decades, we have been taking major steps and pioneering new ways to advance the mission to find a cure for cystic fibrosis and to provide all people with CF the opportunity to lead long, fulfilling lives by funding research and drug development, partnering with the CF community, and advancing high-quality, specialized care.

We are the global leader in the search for a cure for cystic fibrosis and nearly every CF drug and therapy available today was made possible because of CF Foundation support. We did this not only for the close to 40,000 people living in the U.S. with CF – and the estimated 105,000 people worldwide – but for the people with CF and families who have worked tirelessly to support the mission.

These achievements have required dedication and unwavering commitment from a talented team of CF Foundation employees. We promote an environment that attracts -- and retains -- a diverse group of talented people who are passionate about eradicating this disease . Join us and you will join an amazing team, devoted to our community, and our mission.

Position Description

The Cystic Fibrosis Foundation (CF Foundation) and its employees embrace their commitment to its core values. These core values are the pillars on which the CF Foundation stand and will continue to sustain us as we move forward.

• Keep sight of what really matters: Our decisions are based on what is best for people with cystic fibrosis and their families.
• Aspire for excellence in all we do: We take pride in our work. We are committed to continuous learning and improvement.
• Stronger together: We collaborate and work together so that we can learn more and achieve more.
• Innovate with courage: We embrace challenges. We reach beyond boundaries in pursuit of our vision.
• Care about our people: We deeply care about each other and all who support our shared mission. We listen with respect. We support one another.
  
  
  

We are a nonprofit, donor-supported organization that has raised and invested billions of dollars to help develop cystic fibrosis therapies that have changed the lives of people with this disease. Nearly every CF medicine available today was made possible because of Foundation support.

POSITION SUMMARY:

The CF Foundation is preparing for the next leap in how we serve the CF community of patients, caregivers, care providers, and researchers with our Patient Registry. We have an ambitious vision for this next generation health data ecosystem: linking the existing records to many sources of additional data (e.g., electronic medical records, patient-reported outcomes, wearables, clinical trials, pharmacy, genetics, and claims) while providing patients with the power to control what is shared and with whom; welcoming flexibility and building a new architecture that will leverage the opportunities the next decade will bring in healthcare and technology solutions.

The Data Engineer V will be an essential member of the new health data ecosystem team overseeing the development and modification of database programs and data modeling. The individual is the lead data architect responsible for designing and implementing the technical data architecture, security and access management, data models, APIs, ETL, and DevOps. The Data Engineer V will be responsible for the underlying architecture for all database/data warehousing work, as well as for overseeing the technical work being done by other Data Engineers. The Data Engineer V will lead the development of strategies for data acquisition, archive recovery, and database implementation as well as the management of data migrations/conversions and troubleshooting data processing issues. They will be part of an interdisciplinary technology team and will work closely with developers and clinical data specialists. Within the team, the Data Engineer V is also expected to serve as a technical adviser to solve uniquely complex problems. This role will report to the Application Development Manager and work closely with the Head of Data Science.

ESSENTIAL DUTIES & RESPONSIBILITIES:

• Designs/builds/tests/deploys in-house database applications, custom integration across various platforms that meet customer requirements.
• Documents work/code including and not limited to process workflows and architecture diagrams.
• Provides guidance regarding data integration and database development, best practices, and standards as needed.
• Ensures the security and confidentiality of data.
• Is responsible for the availability, reliability, and integrity of business data stored in production databases.
• Designs, develops, and implements database applications and solutions for managing and integrating data between operational systems, data repositories, and reporting and analytical applications.
• Builds the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources on-premises and cloud-based technologies.
• Leads the design, development, and maintenance of data models to support business requirements.
• Establishes and maintains the foundational architecture for databases and data warehousing projects.
• Provides technical leadership to a team of Data Engineers, mentoring them and ensuring high-quality output.
• Devises comprehensive strategies for data acquisition, archival recovery, and seamless database implementation.
• Manages and executes data migrations and conversions while effectively troubleshooting data processing challenges.
• Collaborates with cross-functional teams to identify and implement data solutions that align with business objectives.
• Designs, implements, and thoroughly tests database schemas to guarantee optimal performance and data integrity.
• Applies advanced principles, theories, and concepts to solve complex data engineering challenges.
• Innovates and contributes to the development of cutting-edge ideas, principles, and methodologies within the field.
• Acts as a technical advisor, offering expertise in resolving complex and unique problems.
  
  
  

Additional Responsibilities:

• Understanding of health care, and health coverage issues.
• Understanding HIPAA and relevant FDA regulations.
  
  
  

KNOWLEDGE, SKILLS AND ABILITIES:

• Bachelor’s in Computer Science, Information Systems, Software Engineering, Information Technology, Applied Mathematics, or related fields. Master's in Computer Science or Information Systems preferred.
• Minimum of ten years of experience with database development and DevOps. Equivalent experience will be accepted in lieu of a degree.
• Proficiency in HealthShare/Cache/Ensemble and other InterSystems products and technologies REQUIRED.
• Industry-relevant professional certifications are required.
• Demonstrated experience in data modeling for enterprise data.
• Advanced knowledge of data integration tools and techniques.
• Experience with Agile project methodology.
• Expert knowledge of logical/physical data models for database /data warehouses.
• Demonstrated ability to perform problem identification, analysis, and resolution on various DBMS on-premises or on the cloud.
• Expert knowledge to integrate data within internal and external services from various formats such as APIs, Files, SFTP, Office 365, etc.
• Strong expertise in SQL and other relevant programming languages (Python, Java, etc.).
• Hands-on experience with database technologies such as SQL Server, Data Bricks, Snowflakes, and NoSQL databases.
• Has a working experience in data warehousing and data lake house solutions and cloud platforms (AWS, Azure, Google Cloud).
• Superb analytical, problem-solving skills and the ability to address complex and unique challenges.
• Strong leadership skills with a track record of guiding and mentoring junior team members.
• Effective communication skills, both verbal and written, including the ability to communicate technical concepts to a non-technical audience.
• Superb experience with DevOps and IT Controls.
• Superb ability to implement solutions using effective and innovative methodologies and perform peer code reviews.
• Superb ability to estimate the level of effort for their and other work.
• Superb time management skills, including the ability to work on multiple concurrent projects.
• Proven ability to learn new skills and technologies as needed.
• Proven ability to work with and support other departments in the development and support of enterprise applications.
• Advanced attention to detail and ability to provide feedback for processes and improvement.
• Excellent written and verbal skills in English.
• Professional, polite, and courteous.
  
  
  

REPORTING RELATIONSHIPS:

• Reports to Application Development Manager. No direct reports.
  
  
  

WORKING CONDITIONS:

• Basic office environment, primary functions are computer-based.
• Ability to work as part of a team committed to delivering exceptional customer service.
  
  
  

The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of essential functions, responsibilities, or requirements.

The salary range is $120,000 to $162,500. Specific salary varies based on geographic location and is commensurate with experience.

Total Rewards: The CF Foundation is committed to offering competitive compensation (base pay and incentive), benefits, and professional development opportunities that maximize our ability to recruit, retain, reward, and motivate a highly-qualified and diverse workforce. Our comprehensive benefits package includes medical, dental, and vision coverage; generous time-off and leave policies; a holistic well-being program; health savings and flexible spending accounts; employer-provided life and disability insurance; retirement savings benefits; and a variety of work-life benefits to support employees and their family members.

The CF Foundation is an equal opportunity employer that is committed to being an employer of choice, not just a good place to work, but a great and inclusive place to work. We strive to recruit and maintain a diverse workforce. Qualified applicants will receive consideration for employment without regard to race, physical or mental disability, color, religious creed, ancestry, national origin, religion, age, sex, marital status, genetic information or testing, gender identity and expression, sexual orientation or status as a Vietnam-era or special disabled veteran or any characteristic protected by law.

Reasonable Accommodations: The CF Foundation is committed to providing reasonable accommodations for qualified individuals with disabilities in our job application procedures. If you need assistance or would like to request an accommodation due to a disability, please contact us at HROps@cff.org.