Data Engineer & Database Administrator III

Salary Range: $ To $ Annually

U.S.

-based employees have access to medical, dental, and vision insurance, a 401(k) plan and company contribution, short-term and long-term disability coverage, basic life insurance, and wellbeing benefits, among others. U.S.

-based employees also receive, per calendar year, up to 6 scheduled paid holidays. Additionally, eligible hourly/non-exempt and exempt employees accrue up to 112 hours of PTO based on years of service and may annually take up to 8 hours of paid volunteer time. Additional paid sick leave is also provided if required by state or local law.

The Data Engineer & Database Administrator will build and maintain scalable data pipelines while ensuring databases are reliable, secure, and high-performing. This role works closely with analysts, engineers, and product teams to deliver clean and timely data.

• Design, build and maintain ETL/ELT pipelines across multiple systems
• Design and optimize data models in Postgre
  
  SQL, Mongo
  
  DB, and Amazon Redshift
• Develop and manage data workflows using AWS (S3, Glue, Lambda, Step Functions, Kinesis)
• Administer and maintain database environments across development, staging, and production
• Monitor data pipelines and databases, troubleshoot issues, and implement alerts
• Optimize query performance, indexes, and configurations across relational and No
  
  SQL systems
• Manage database provisioning, upgrades, backups, and disaster recovery (RDS, Mongo
  
  DB, Redshift)
• Ensure database security, including access control, encryption, and role management
• Plan capacity and scale systems to support growing data needs
• Define and enforce data retention and archival policies
• Collaborate with analytics and product teams to support reporting and data needs
• Document data pipelines, database processes, and operational procedures
• Participate in code reviews and follow engineering best practices
• Lead and mentor Data Engineers I and II
• Drive architectural decisions and best practices
• Train team members on new tools, technologies, and processes
• Act as a technical lead on cross-functional projects

• Ensures Accountability
• Tech Savvy
• Communicates Effectively
• Values Differences
• Customer Focus
• Drives Results
• Plans and Prioritizes
• Decision Quality
• Self-Development

This role requires physical capabilities that support the successful execution of key responsibilities. The employee regularly engages in verbal and written communication with colleagues and clients to address project-related inquiries and must be able to convey accurate information clearly and efficiently. The position involves remaining seated at a workstation for approximately 75% of the time, with occasional movement throughout the office to access equipment, supplies, and shared resources.

Daily tasks include consistent use of computers and standard office technology such as keyboards, printers, and multifunction devices. The role also involves transporting equipment boxes weighing up to 25 pounds within the building and to other offsite locations as needed for project support.

Bachelor’s degree in Computer Science, Engineering, or a related field — or equivalent experience.

5-8 years of Data Engineering Experience or equivalent experience.

• 5-8 years of experience in data engineering, database administration, or similar roles
• Strong experience with Postgre
  
  SQL, Mongo
  
  DB, and Amazon Redshift
• Solid SQL skills for both transactional and analytical workloads
• Experience with AWS data and database services (S3, Glue, Lambda, RDS, Redshift, etc.)
• Proficiency in Python or another scripting language
• Experience with workflow orchestration tools (Airflow, Step Functions, etc.)
• Redshift (cluster management, query tuning, WLM, snapshots)
• Postgre
  
  SQL (replication, performance tuning, connection pooling)
• Familiarity with monitoring tools (Cloud Watch, pg Badger, Mongo
  
  DB Atlas, etc.)
• Understanding of database security (encryption, auditing, least-privilege access)
• Strong problem-solving and analytical skills
• Ability to translate business needs into data solutions
• Comfortable working in a fast-paced, collaborative environment
• Clear communicator with both technical and non-technical audiences
• Self-motivated with a focus on clean, maintainable code

3MD Inc. is an equal opportunity employer and does not discriminate based on gender, sex, age, race and color, religion, marital status, national origin, disability, sexual orientation, gender identity or expression, veteran status or any other category that is protected by applicable law.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.