Data Engineer

Overview

As a Data Engineer with Certara, you are part of a global, fast-paced IT organization with the primary mission to provide capable & resilient world class services to professional services, software, and corporate business units ensuring our team members have access and ability to perform at the highest level in service of our customers.

The Information Technology function relies on experience and judgment to plan and accomplish goals through implementation of industry best practice methodologies, governance, and tooling. The Data Engineer role is responsible for the development and design plus subsequent management and efficient operations of a cloud hosted data warehouse. The role will also establish data analysis capabilities via PowerBI and implement an integration platform strategy to govern the necessary data extractions.

The role requires a rich understanding of data warehouse design principles as applied to empower organizational wide business intelligence efforts.

Responsibilities

In this role, you will:

• Develop and maintain data engineering solutions to support Certara’s data analysis needs.
• Design, implement, and optimize data pipelines and workflows.
• Collaborate with cross-functional teams to understand business requirements and provide data-driven solutions.
• Lead data engineering initiatives and mentor junior team members.
• Stay updated with industry trends and continuously identify opportunities for process improvement.
• Ensure data integrity and security across all data systems.
• Perform data quality checks and troubleshoot any issues that arise.
• Develop and maintain data documentation and data dictionaries.
• Communicate complex technical concepts to non-technical stakeholders.
• Continuously monitor and optimize data performance.
• Collaborate with other teams to integrate data from various sources.
• Participate in project planning and provide technical expertise for data-related projects.
• Stay compliant with data governance policies and regulations.
• Develop and maintain relationships with external partners and vendors.
• Act as a subject matter expert and provide guidance on best practices for data engineering.
  
  

Qualifications

Who you are -

• Bachelor’s degree in computer science or information systems
• Proficiency in SQL for data querying, manipulation and optimization
• Proficiency in Data Modelling and Architecture
• At least 8-10+ years hands-on experience in end-to-end Data Engineering
• At least 5 years of experience with cloud technologies (Snowflake, Microsoft Azure)
• At least 7 years of experience with ETL and orchestration Tools (Workato, Azure Data Factory, Talend)
• At least 7 years of experience with BI Tools (Power BI, Tableau)
• Experience with Git, DevOps, and CI/CD pipelines.
• Experience working with large data sets (terabytes and larger) in a data ecosystem with emphasis on data reliability and availability.
• Excellent communication skills for engaging with stakeholders, facilitating discussions, and conveying complex technical concepts. Ability to educate and guide stakeholders while maintaining data quality standards and delivering a high-quality data product is necessary.
• Resilient problem solving and critical thinking skills.
• Flexibility - able to meet changing requirements and priorities.
  
  

Certara bases all employment-related decision on merit, taking into consideration qualifications, skills, achievement, and performance. We treat all applicants and employees without regard to personal characteristics such as race, color, ethnicity, religion, sex, sexual orientation, age, nationality, marital status, pregnancy, physical or mental condition, genetic information, military service, or other characteristic protected by law.