Senior ETL Developer

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 processcode 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.