Senior ETL Developer

Job Description

HarmonyTech is currently seeking a Senior ETL (Extract, Transform, Load) developer to support and handle data management work. The candidate should have strong SAS Coding, SQL Server knowledge, Scripting (Python, Bash, SAS, and Perl) experience, and the technical skillset required to perform ETL for multiple products.

The position is available in Fairfax, VA and requires US citizenship.

Responsibilities

Refresh Data Products using Metadata Processing Engine or manual steps

Upgrade/improve, refresh process to automate manual data refreshes

Update existing scripts such as SAS, SQL, bash, Power shell, Python, Perl

Maintain technical documentation

Implement and ensure the Quality Assurance process

Required

Bachelor’s’ degree or higher in Computer Engineering or Computer Science or equivalent experience

Five (5) years of experience writing complex SQL including stored procedures to perform ETL

Five (5) years of experience developing SAS code to perform ETL

Five (5) years of experience developing and maintaining Linux shell scripting

Three (3) years of experience using Python to perform ETL functions

Three (3) years of experience using Perl to perform ETL functions

Hands-on experience in SAS coding, including troubleshooting and fixing any job failures

Expertise in writing Linux scripts using PUTTY to Stage, Move, Copy, Delete files

Expertise in debugging Linux script or Job's failures

Good knowledge of Tableau Reporting

Good working knowledge of Microsoft SQL Server

Must be an effective verbal and written communicator, able to work with both technical and business users

Must demonstrate a sense of urgency, and the ability to work independently and proactively in achieving team and individual objectives. A self-learner who can understand process\code with the least documentation

Must be able to understand the business uses of data and develop designs and specifications to meet those requirements

Ability to obtain a Public Trust Clearance

Desired

Two (2) years of experience working with applications using Amazon Redshift (or other Postgres- based databases)

Two (2) years of experience working with applications using AWS Glue (or similar)

Two (2) years of experience working with applications using Amazon S3 (or similar)

Federal Government consulting experience, Active Public Trust

Strong analytical skills

Related certifications

If you are interested and feel that you would excel in the position, we invite you to apply. During this phase of our recruiting effort, we will not be able to accept telephone calls. Only those candidates meeting the requirements will be contacted. No recruiters please.

About HarmonyTech

We have been delivering information technology services and solutions across the Federal government and commercial clients for over a decade. Our employees are the most important assets of our company because they delivery value and care for our clients. We are a company of passionate technologist constantly evolving in our understanding and application of technology to best fulfill our client’s mission needs. We operate under a flat and efficient organizational structure to ensure our hand-picked consultants have the flexibility to take risks and be innovative. We typically work in small, agile teams as we design and develop solutions to address our client’s business challenges. Our success is measured with every satisfied customer and employee.

Why you want to join us

You have a passion for solving our customers complex business problems

Awesome learning and professional development opportunities

A culture built on teamwork and excellence

Benefits

HarmonyTech offers a highly competitive salary and benefits package including:

Medical/Dental/Vision Insurance (company contributes 80% of the entire premium)

Short/Long Term Disability Coverage

Life and AD&D Insurance

401(k) Retirement Plan with Company Match

Tuition Reimbursement

Employee Referral Bonus

Paid Federal Holidays

Accrued Paid Time Off

Click the benefits package link above to check out the benefits we offer

Legal

HarmonyTech believes in a policy of equal employment and opportunity for all people based on merit. We are an Equal Opportunity Employer (EEO) and Drug Free Workplace Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or national origin or any other category protected by applicable federal, state or local laws.

The statements herein are intended to describe the general nature and level of work being performed by employees and are not to be construed as an exhaustive list of responsibilities, duties, and skills required of personnel. Additionally, they do not establish a contract for employment and are subject to change at the discretion of HarmonyTech.

Powered by JazzHR

rwiwr4EJv2