Data Engineer - Mastech Digital
Beaverton, OR
About the Job
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