Data Engineer

Lead Consultant - U.S. Recruitment and Hiring Specialist.

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.

Location:
Westalke, TX

Duration:
Full-Tme/W2

Job Description:

This role will be working in a newly formed squad created to untangle the data requirements related to the way we pays its advisors and wholesalers. Very important work and the highest executive visibility.

MUST HAVES:

• Strong SQL for querying and data validation
• Oracle
• AWS
• ETL experience with Java Spring Batch (for the ETL data transformation).

Note:

• The ETL work is done in Java (so Python is only a nice to have). Must have Java for ETL which makes this role difficult to source on.
• Python
• Snowflake

Also note: Informatica ETL experience is not helpful at all to us in this role. It’s fine if someone has it, but the experience we need is on the Java ETL side.

The Expertise and Skills You Bring

• Bachelor's or Master's Degree in a technology related field (e.g. Engineering, Computer Science, etc.) required with 5+ years of working experience
• 4+ years of Java development utilizing Spring frameworks. Experience writing batch jobs with Spring Batch is a must
• 2+ years of experience developing applications that run in AWS, with focus on AWS Batch, S3, IAM
• 3+ years working with SQL (ANSI SQL, Oracle, Snowflake)
• 2+ years of Python development
• Experience with Unix shell scripting (bash, ksh) and scheduling / orchestration tools (Control-M)
• Strong data modeling skills with experience working with 3NF and Star Schema data models
• Proven data analysis skills; not afraid to work in a complex data ecosystem
• Hands-on experience on SQL query optimization and tuning to improve performance is desirable
• Experience with Dev Ops, Continuous Integration and Continuous Delivery (Jenkins, Terraform, Cloud Formation)
• Experience in Agile methodologies (Kanban and SCRUM)
• Experience building and deploying containerized applications using Docker
• Work experience in the financial services industry is a plus
• Proven track record to handle ambiguity and work in a fast-paced environment, either independently or in a collaborative manner
• Good interpersonal skills to work with multiple teams within the business unit and across the organization

• Mid-Senior level

• Full-time

• Information Technology
• IT Services and IT Consulting, Banking, and Financial Services

• Medical insurance
• Vision insurance
• Disability insurance