Data Engineer II

Job Title: Data Engineer II

Department: Development

Reporting to: Manager of Data Engineering

Location: Baltimore, MD. This is a hybrid role with 3-days per week required to be worked in the Baltimore, MD office.

Hours of work: Typical hours of work are from 8:30 AM until 5:30 PM local time Monday through Friday. Additional hours may be necessary as needed. This position is exempt from overtime.

Compensation: $100,000 - $120,000 annually.

Who we are:

InVita develops specialized medical software for regulated industries that support the advancement of public health and safety. We are the acknowledged leader in the markets we serve. Our subject matter expertise is unmatched in the industry, and our products are used by public health and medical professionals across the globe. We have employees spanning across the US and two main offices (Baltimore & Los Angeles).

Overview:
The Data Engineer II is a highly technical, client-facing role responsible for supporting the implementation, integration, and configuration of data solutions while serving as a trusted technical resource for internal and external technical and non-technical partners. This role requires strong communication and problem-solving skills, with the ability to explain complex technical concepts, navigate challenges, and develop effective solutions while working closely with clients and cross-functional teams.

Essential Functions:

• Client Partnership: Serve as primary technical point of contact for assigned clients, developing strong working relationships and building trust throughout the engagement.

• Technical Consultation: Work directly with clients to understand their technical needs, data requirements, workflows, and challenges, and translate those needs into practical technical solutions.

• Client Engagement: Build strong, trusted working relationships with client technical and non-technical stakeholders across the full client lifecycle, and clearly explain technical concepts, data processes, system functionality, and proposed solutions.
• Professional Services: Work directly with clients to understand their data requirements, workflows, and challenges, and deliver practical technical solutions such as data migrations, integrations, and configuration.

• Database Design & Management: Develop and maintain databases, data warehouses, and other data storage solutions, ensuring they meet the company and client’s data needs and business goals.

• Data Pipeline and ETL/ELT Processes: Design, build and deploy robust ETL/ELT pipelines and staging transformations to migrate and synchronize datasets with target schemas.
• Data Quality & Governance: Ensure high data quality and availability by implementing appropriate monitoring, testing, and validation techniques.

• Collaboration: Work closely with data integration engineers, business analysts, and software engineers to understand their data requirements and provide timely solutions.

• Data Security & Compliance: Ensure that all data solutions comply with data security, privacy, and regulatory requirements (e.g., GDPR, HIPAA).

• Performance Optimization: Continuously monitor the performance of data systems and make improvements to increase efficiency and scalability.

Required Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

• Proven experience (3+ years) as a Data Engineer, or in a similar role.

• External client-facing experience.

• Proficiency in database technologies (e.g., MySQL, PostgreSQL, SQL Server).

• Strong experience with data modeling, data warehousing, and ETL/ELT processes.

• Familiarity with cloud data platforms (AWS)

• Knowledge of data governance frameworks and data quality best practices.

• Strong problem-solving skills and the ability to translate business needs into data architecture solutions.

• Excellent communication and interpersonal skills.

Physical Demands and Work Environment:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions.

• While performing the duties of this position, prolonged periods of sitting at a desk and working on a computer may be required.

• Additionally, the employee is regularly required to talk or hear.

• The employee frequently is required to use hands or fingers, handle, or feel objects, tools, or controls.

• The employee is occasionally required to stand, walk, sit; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl.

• The employee must occasionally lift and/or move up to 15 pounds.

• Specific vision abilities required by this position include close vision, distance vision, color vision, peripheral vision, and the ability to adjust focus.

• The noise level in the work environment is usually moderate.

This job description in no way states or implies that these are the only duties to be performed by the employee(s) incumbent in this position. Employee(s) will be required to follow any other job-related instructions and perform any other job-related duties requested by any person authorized to give instructions or assignments.

This document does not create an employment contract, implied or otherwise, other than an "at-will" relationship.

InVita provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.