Data Engineer at 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