Data Engineer

Mastech Digital Inc. (NYSE : MHH) is a minority-owned, publicly traded IT staffing and digital transformation services company. Headquartered in Pittsburgh, PA, and established in 1986, we serve clients nationwide through 11 U.S. offices.

Role : Data Engineer

Location : Merrimack, NH / Smithfield, RI / Jersey City, NJ

Duration : Full-Time / W2

• Job Description :
• Must-Haves :

Python for running ETL batch jobs

Heavy SQL for data analysis, validation and querying

AWS and the ability to move the data through the data stages and into their target databases.

The Postgres database is the target, so that is required.

Nice to haves :

Snowflake

Java for API development is a nice to have (will teach this)

Experience in asset management for domain knowledge.

Production support debugging and processing of vendor data

The Expertise and Skills You Bring

A proven foundation in data engineering – bachelor’s degree + preferred, 10+ years’ experience

Extensive experience with ETL technologies

Design and develop ETL reporting and analytics solutions.

Knowledge of Data Warehousing methodologies and concepts – preferred

Advanced data manipulation languages and frameworks (JAVA, PYTHON, JSON) – required

RMDS experience (Snowflake, PostgreSQL ) – required

Knowledge of Cloud platforms and Services (AWS – IAM, EC2, S3, Lambda, RDS ) – required

Designing and developing low to moderate complex data integration solution – required

Experience with DevOps, Continuous Integration and Continuous Delivery (Maven, Jenkins, Stash, Ansible, Docker) will be preferred

Expert in SQL and Stored Procedures on any Relational databases

Good in debugging, analyzing and Production Support

Application Development based on JIRA stories (Agile environment)

Demonstrable experience with ETL tools (Informatica, Snaplogic)

Experience in working with Python in an AWS environment

Create, update, and maintain technical documentation for software-based projects and products.

Solving production issues.

Interact effectively with business partners to understand business requirements and assist in generation of technical requirements.

Participate in architecture, technical design, and product implementation discussions.

Working Knowledge of Unix / Linux operating systems and shell scripting

Experience with developing sophisticated Continuous Integration & Continuous Delivery (CI / CD) pipeline including software configuration management, test automation, version control, static code analysis.

Excellent interpersonal and communication skills

Ability to work with global Agile teams

Proven ability to deal with ambiguity and work in fast paced environment

Ability to mentor junior data engineers.

The Value You Deliver

The associate would help the team in designing and building a best-in-class data solutions using very diversified tech stack.

Strong experience of working in large teams and proven technical leadership capabilities

Knowledge of enterprise-level implementations like data warehouses and automated solutions.

Ability to negotiate, influence and work with business peers and management.

Ability to develop and drive a strategy as per the needs of the team

Good to have : Full-Stack Programming knowledge, hands-on test case / plan preparation within Jira