Data Engineer & Database Administrator II

Job Description BenefitsU.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.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:Design, build and maintain ETL/ELT pipelines across multiple systemsDesign and optimize data models in PostgreSQL, MongoDB, and Amazon RedshiftDevelop and manage data workflows using AWS (S3, Glue, Lambda, Step Functions, Kinesis)Administer and maintain database environments across development, staging, and productionMonitor data pipelines and databases, troubleshoot issues, and implement alertsOptimize query performance, indexes, and configurations across relational and NoSQL systemsManage database provisioning, upgrades, backups, and disaster recovery (RDS, MongoDB, Redshift)Ensure database security, including access control, encryption, and role managementPlan capacity and scale systems to support growing data needsDefine and enforce data retention and archival policiesCollaborate with analytics and product teams to support reporting and data needsDocument data pipelines, database processes, and operational proceduresParticipate in code reviews and follow engineering best practicesLead small technical initiatives or projectsConduct or participate in code reviews with a coaching lensMentor or provide guidance to junior team members (Level I)Competencies:Ensures AccountabilityTech SavvyCommunicates EffectivelyValues DifferencesCustomer FocusResourcefulnessDrives ResultsPlans and PrioritizesDecision QualitySelf-DevelopmentWork Environment:This position is based in a professional office setting and regularly utilizes workplace technology, including computers, smartphones, multifunction printers, cloud-based filing systems, and collaboration tools.Physical Demands: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.Required Education and Experience:Bachelor's Degree Required3 - 5 Years of ExperienceQualifications:3-5 years of experience in data engineering, database administration, or similar rolesStrong experience with PostgreSQL, MongoDB, and Amazon RedshiftSolid SQL skills for both transactional and analytical workloadsExperience with AWS data and database services (S3, Glue, Lambda, RDS, Redshift, etc.)Proficiency in Python or another scripting languageExperience 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 skillsAbility to translate business needs into data solutionsComfortable working in a fast-paced, collaborative environmentClear communicator with both technical and non-technical audiencesSelf-motivated with a focus on clean, maintainable codeNice to HaveExperience with Kafka or Kinesis (streaming data)Familiarity with dbt for data transformationKnowledge of data lake/lakehouse architectures (Delta Lake, AWS Lake Formation)Experience with Terraform or CloudFormationCI/CD experience for data pipelinesBasic DevOps skillsAAP/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.Other Duties: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.