Data Engineer

Job Description

Job Description

Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations.

We are currently seeking a Data Engineer for our client in the Technology domain. We value our professionals, providing comprehensive benefits and the opportunity for growth.

This is a Permanent position, and the client is looking for someone to start immediately.

Duration : Full-time

Location : Beaverton, OR

Role : Data Engineer

Primary Skills : PostgreSQL

Role Description : As a Data Engineer you must have at least 7+ years of experience.

Responsibilities :

• Interpret data-related business requirements into technical ones.
• Relational database design and feature development with a primary focus on high-velocity, write-intensive transactional systems.
• Secondary focus on relational database design and feature development for read intensive applications.
• Experience in non-relational data storage and retrieval preferred.
• Maintain and enhance the functionality and performance of existing PostgreSQL-based database systems, including PostgreSQL running in WSL Docker and AWS RDS / PG.
• Monitor and control database instances including use of the pg stat extension, DBeaver, the AWS Management Console, AWS CloudWatch, and AWS Performance Insights.
• Implement multi-environment database change processes using scripts, Jenkins, and Terraform.
• Proactively address scalability, performance, and availability requirements and concerns.
• Ensure data quality and integrity.
• Collaborate closely with Product personnel and in particular the backend Engineering group, as well as other groups within Engineering.
• Document processes related to core responsibilities.

Knowledge & Skills

• Bachelor’s degree in Computer Science or related field with at least 7+ years of experience in data engineering
• Extensive knowledge of PostgreSQL, related AWS services (RDS / PG, Aurora, and Redshift), and associated tools.
• Expert in relational database design, data modeling, and management.
• Excellent written, verbal, and inter-personal communication skills.
• Ability to work with small, cross-functional teams from multiple regions / time zones by effectively leveraging multi-form communication (Email, MS Teams for voice and chat, meetings).
• Excellent prioritization and problem-solving skills.

Required Experience

• Extensive experience in transactional database design and SQL coding.
• Rapidly and fluidly scaling high velocity data sets.
• Considerable hands-on time with PostgreSQL, possessing a deep knowledge of the internals and architecture, familiarity with the system catalogs, extensions, best practices, security, monitoring and control, related tools, error handling, etc.
• Experience with team tools including Jira, Git / GitHub, Jenkins, Docker, and Teams.
• Experience with Agile / Scrum development methodologies.

Nice-To-Have

• Experience working in the firmware business domain or a related field such as hardware engineering.
• Experience working in a high security business domain.
• Experience in highly related infrastructural areas, e.g., AWS IAM security and data encryption both in transit and at rest.
• Experience in cross-process workflow orchestration.
• Data warehouse, data mart, and ETL / ELT data pipeline design and implementation.
• Experience in non-relational data storage and retrieval.
• Familiarity with DevOps and SecOps practices.
• The use of advanced PostgreSQL features such as row-level security, replication, partitioning, and high availability features.
• Experience in additional non-PostgreSQL data platforms, including non-relational stores and technologies.
• Multi-platform change control, in particular deploying to SQLite in addition to PostgreSQL-based systems.
• Cross-platform data migrations.

Education : Bachelor’s degree in Computer Science, Electrical / Electronic Engineering, Information Technology or another related field or Equivalent

Experience : Minimum 7+ years of experience

Relocation : This position will not cover relocation expenses

Travel : No

Local Preferred : Yes

Note : Must be able to work on a W2 basis (No C2C)

Recruiter Name : Divya Mishra

Recruiter Phone : +1 412 648 6348 / +1 203.678.9801

Equal Employment Opportunity

LI-DM1

Mastech1