Data Engineer

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 Technologydomain. 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