Sign upLog in

Data Engineer & Database Administrator

Saicon Consultants Inc

Bellevue, WA

Apply
JOB DETAILS
SKILLS
AWS Lambda, Access Control, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Auditing, Best Practices, Business Skills, Calculators, Capacity Management, Coaching, Code Reviews, Communication Skills, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Copying Machines, Cryptography, Customer Relations, Data Lake, Data Management, Data Modeling, Data Partitioning, Data Recovery, Database Administration, Database Extract Transform and Load (ETL), Database Programming, DevOps, Disaster Recovery, Establish Priorities, Identify Issues, Information/Data Security (InfoSec), Keyboards, Lift/Move 25 Pounds, Mentoring, MongoDB, NoSQL, Office Equipment, Operations Processes, People Management, Performance Tuning/Optimization, Physical Demands, PostgreSQL, Printers, Problem Solving Skills, Product Support, Python Programming/Scripting Language, Query Optimization, Replication and Remote Mirroring, SQL (Structured Query Language), Scripting (Scripting Languages), Team Player, Theater Production
LOCATION
Bellevue, WA
POSTED
Today
Job Description:
Essential Functions:
  • Design, build and maintain ETL/ELT pipelines across multiple systems
  • Design and optimize data models in PostgreSQL, MongoDB, 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 NoSQL systems
  • Manage database provisioning, upgrades, backups, and disaster recovery (RDS, MongoDB, 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 small technical initiatives or projects
  • Conduct or participate in code reviews with a coaching lens
  • 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:
This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.

Physical Demands:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
While performing the duties of this job, the employee in this position frequently communicates with other co-workers/clients who have inquiries about the various projects and other needs. Must be able to exchange accurate information in these situations. The employee must be able to remain in a stationary position 75% of the time. The employee in this position needs to occasionally move about inside the office to access file cabinets, office machinery, etc. Constantly operate a computer and office machinery such as a calculator, keyboard, copy machine, and printer. Frequently moves boxes with equipment weighing up to 25lbs across the building and/or to other offsite buildings for various project needs.

Required Education and Experience:
  • Bachelor's degree in computer science, Engineering, or a related field or equivalent experience.
  • 3-5 years of Data Engineering Experience or equivalent 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

About the Company

S

Saicon Consultants Inc

Resume Resources

Free Resume TemplatesFree Resume Builder