Join Us
Advantex is in need of talented and determined individuals to join our community.
ETL Engineer III
Location: Huntsville, Alabama
Clearance Requirement: Top Secret (SCI Eligibility)
Roles and Responsibilities:
We are seeking a Data Engineer who can leverage experience and expertise in data exploration, engineering, and ETL to explore, architect, develop, and deploy scripts for processing structured and unstructured data into usable data formats for long term storage, search, and analysis.
Creating a custom ingest pipeline to a Big Data platform with consistent performance and scalability
Understanding of programming and data engineering concepts and best practice.
Experience working with both structured, semi-structured, and unstructured data to include data parsing, transformation, schema definition, and query/analysis.
Ability to manage and organize data while identifying trends and inconsistencies that will impact downstream analytics
Ability to work both independently and collaboratively.
High levels of curiosity, creativity, and problem-solving capabilities.
Strong written and verbal communication skills.
Experience with data pipelines or be willing to learn a pipeline from bottom to top
Be able to trouble shoot files against an architecture to see where the upload process is failing.
Be able to understand unit tests and add to them to increase stability to the entire pipeline.
Be prepared to use GIT, JIRA, Confluence, Anaconda, Spyder, and Microsoft tools.
Be prepared to express ideas and solutions and walk together with teammates through coding challenges
Required Qualifications:
Six years’ experience with ETL with experience in following:
Oracle 11g/12c, Sun Solaris OS, Linux (CentOS, Red Hat), and Windows environments
Performing software and scripting engineering for data ingest with Java or Python for ETL
Web services and/or microservices
ETL tools such as NiFi or Informatica
Using software repository tools such as GIT or SVN
A current Top Secret security clearance with SCI eligibility and the ability to obtain a polygraph.
Desired Qualifications:
Have knowledge of Databricks, Scala, Python, and PySpark
Have experience tuning complex SQL queries
Experience with the AWS and Data Ingest/Transformation processes
Have worked in an Agile environment.
You have worked on teams that practice Agile methodologies.
We are an equal opportunity employer. All applicants will receive consideration for employment, without regard to race, color, religion, creed, national origin, gender or gender-identity, age, marital status, sexual orientation, veteran status, disability, pregnancy or parental status, or any other basis prohibited by law.
If you think you might align with this position, please visit our careers page and submit an application.
PROTECTED VETERAN DEFINITIONS
Disabled Veteran, Recently Separated Veteran, Active Duty Wartime or Campaign Badge Veteran, Armed Forces Service Medal Veteran
NOTICES
Advantex Consulting is a Woman Owned Small Business (WOSB). Advantex is subject to Executive Order 11246, which requires government contractors to take affirmative action to ensure that equal opportunity is provided in all aspects of their employment. In addition, we are subject to Vietnam Era Veterans’ Readjustment Assistance Act of 1974, as amended by the Jobs for Veterans Act of 2002, 38 U.S.C. 4212 (VEVRAA), which requires Government contractors to take affirmative action to employ and advance in employment protected veterans. In order to comply with these laws, Advantex invites applicants and employees to voluntarily self-identify their gender, race/ethnicity and protected veteran status. Advantex does not discriminate on the basis of race, religion, color, sex, sexual orientation, gender identity, age, protected veteran status, non-disqualifying physical or mental disability, national origin, genetic information, or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.
Submission of this information is voluntary and refusal to provide it will not subject you to any adverse treatment. The information obtained will be kept confidential and may only be used in accordance with the provisions of applicable laws, executive orders, and regulations, including those that require the information to be summarized and reported to the federal government for civil rights enforcement. When reported, data will not identify any specific individual.
AlphaSix Corporation is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability. Equal Employment Opportunity Posters If you’d like to view a copy of the company’s affirmative action plan or policy statement, please email jake@advantexconsulting.com . If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact Jolynn Pehlke at 703-727-1906 or jake@advantexconsulting.com. This telephone line and email address is reserved solely for job seekers with disabilities requesting accessibility assistance or an accommodation in the job application process. Please do not call about the status of your job application if you do not require accessibility assistance or an accommodation. Messages left for other purposes, such as following up on an application or non-disability related technical issues, will not receive a response.
Voluntary Self-Identification of Disability
Form CC-305 OMB Control Number 1250-0005 Expires 1/31/2020 Page 1 of 2
Why are you being asked to complete this form?
Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities i To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.
If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.
How do I know if I have a disability?
You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition. Disabilities include, but are not limited to:
Blindness
Deafness
Cancer
Diabetes
Epilepsy
Autism
Cerebral palsy
HIV/AIDS
Schizophrenia
Muscular dystrophy
Bipolar disorder
Major depression
Multiple sclerosis (MS)
Missing limbs or partially missing limbs
Post-traumatic stress disorder (PTSD)
Obsessive compulsive disorder
Impairments requiring the use of a wheelchair Intellectual disability (previously called mental retardation)
Advantex Consulting is a Woman Owned Small Business (WOSB) implementing strategic technical consulting services to the Federal Government and commercial companies nationally. With over 30 years of combined experience in both the federal and commercial space, we are a well-funded company driven by our desire to successfully collaborate with our clients, uncover their needs, consult with them on solutions and provide well qualified candidates for mission critical requirements. We have grown our business by providing exceptional contractor performance onsite. Our core competencies include direct hires, contract to hire and sub-contractors.