Data Engineer & Database Administrator II

Benefits

• Medical, dental, and vision insurance
• 401(k) plan with company contribution
• Short-term and long-term disability coverage
• Basic life insurance
• Wellbeing benefits
• Up to 6 scheduled paid holidays per calendar year
• Paid time off (PTO) based on years of service
• Up to 8 hours of paid volunteer time annually
• Additional paid sick leave as required by state or local law

Summary Of Position

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.

Essential Functions

1. Design, build and maintain ETL/ELT pipelines across multiple systems
2. Design and optimize data models in PostgreSQL, MongoDB, and Amazon Redshift
3. Develop and manage data workflows using AWS (S3, Glue, Lambda, Step Functions, Kinesis)
4. Administer and maintain database environments across development, staging, and production
5. Maintain and monitor data pipelines and databases, troubleshoot issues, and implement alerts
6. Optimize query performance, indexes, and configurations across relational and NoSQL systems
7. Manage database provisioning, upgrades, backups, and disaster recovery (RDS, MongoDB, Redshift)
8. Ensure database security, including access control, encryption, and role management
9. Plan capacity and scale systems to support growing data needs
10. Define and enforce data retention and archival policies
11. Collaborate with analytics and product teams to support reporting and data needs
12. Document data pipelines, database processes, and operational procedures
13. Participate in code reviews and follow engineering best practices
14. Lead small technical initiatives or projects
15. Conduct or participate in code reviews with a coaching lens
16. Mentor or provide guidance to junior team members (Level I)

Competencies

Ensures Accountability Tech Savvy Communicates Effectively Values Differences Customer Focus Resourcefulness Drives Results Plans and Prioritizes Decision Quality Self-Development Work Environment Based in a professional office setting Regularly utilizes workplace technology Physical Demands Seated for approximately 75% of the time Occasional movement throughout the office Daily tasks include consistent use of computers and standard office technology Transporting equipment boxes weighing up to 25 pounds within the building and to other offsite locations as needed for project support Required Education And Experience Bachelor's Degree Required 3 - 5 Years of Experience Qualifications 3-5 years of experience in data engineering, database administration, or similar roles Strong experience with PostgreSQL, MongoDB, 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.) Hands-on database administration experience, including: MongoDB (replica sets, sharding, indexing, backups) Redshift (cluster management, query tuning, WLM, snapshots) PostgreSQL (replication, performance tuning, connection pooling) Familiarity with monitoring tools (CloudWatch, pgBadger, MongoDB 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 Nice to Have Experience with Kafka or Kinesis (streaming data) Familiarity with dbt for data transformation Knowledge of data lake/lakehouse architectures (Delta Lake, AWS Lake Formation) Experience with Terraform or CloudFormation CI/CD experience for data pipelines Basic DevOps skills AAP/EEO Statement 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.