Kentro - ETL Developer

Developer is needed in United States.

Client: Kentro

Location: Remote

Contract: undefined

Job Description

Thank you for considering IT Concepts dba Kentro, where innovation drives opportunity and collaboration leads to success. Our dynamic community of experts is fully committed to advancing our customers’ missions, fostering professional growth, and making a positive impact on our communities.

Kentro is always interested in connecting with cleared professionals supporting mission-focused work in FAA Governance. The ETL Developer maintains and modernizes data integration workflows across legacy and cloud platforms. This role supports existing ETL in the on-premise data platforms while transitioning data pipelines to modern, cloud-based patterns aligned with cloud-based platforms supporting the Federal Aviation Administration (FAA).

This application is for a talent pipeline and is not tied to an active job opening. By applying, you are expressing interest in future opportunities that match your skills and experience. Our team regularly reviews resumes for both immediate and upcoming openings. If your background aligns with a current or future position, we’ll be in touch.

Requirements

You may be a great fit if you have experience with:

• Experience using PL/SQL, SAP Data Services, Python, SQL, Airflow, and Glue.
• Bachelor’s degree (master’s preferred, but not required) in computer science, engineering, or related field.
• A minimum of 4 years of relevant data engineering experience.
• Experience supporting ETL systems in enterprise or regulated environments.
• Strong understanding of data modeling, ETL (Extract, Transform, Load) processes, and data architecture principles.
• Preferable in-depth knowledge of Palantir Foundry, including its ontology, data lineage, pipeline development, and data governance features.
• Proficiency in relational and non-relational database systems (e.g., SQL Server, PostgreSQL, MySQL, MongoDB, Cassandra).
• Familiarity with cloud data services, especially AWS (e.g., Redshift, Glue, S3, EMR) and Azure (e.g., Data Lake, Synapse, Data Factory).
• Knowledge of big data technologies and distributed computing frameworks (e.g., Apache Spark, Hadoop, Kafka).
• Understanding of data warehousing concepts, star/snowflake schemas, and data mart design.
• Awareness of data governance, data privacy, security, and compliance standards (e.g., NIST, FISMA, GDPR, FAA if applicable).
• Familiarity with programming languages used in data engineering (e.g., Python, SQL, Scala, Java).
• Knowledge of workflow orchestration and automation tools (e.g., Apache Airflow, Luigi).
• Ability to design, build, and maintain scalable data pipelines for batch and real-time processing, preferably including within the Palantir Foundry platform.
• Skilled in developing robust ETL/ELT processes to ingest, cleanse, transform, and load data from diverse sources preferably using Foundry’s tools.
• Proficiency in writing efficient, maintainable SQL and Python for data manipulation and integration.
• Ability to optimize data storage, retrieval, and indexing for performance and cost-effectiveness.
• Experience in integrating data solutions with AI/ML platforms and analytics tools for downstream consumption.
• Skilled in troubleshooting, debugging, and resolving data pipeline and infrastructure issues.
• Proficient in implementing data quality, monitoring, and validation frameworks.
• Experience with version control (e.g., Git), CI/CD pipelines, and containerization (e.g., Docker).
• Ability to document data flows, schemas, and engineering processes.
• Ability to collaborate effectively with data scientists, analysts, software engineers, and business stakeholders.
• Ability to translate business and analytics requirements into scalable data engineering solutions.
• Ability to manage multiple projects, prioritize tasks, and deliver results within deadlines.
• Ability to maintain awareness of emerging data engineering technologies and best practices.
• Ability to ensure data security, integrity, and compliance in all data engineering activities.
• Ability to communicate technical information clearly to both technical and non-technical audiences.

Qualifications

Preferred Qualifications:

• Preferred (but not required) experience in regulated industries (aviation, healthcare, government, finance).
• Preferred (but not required) familiarity with data catalog and metadata management tools.

Clearance Requirement

US Citizen. Must comply with FAA System and access requirements. Must meet updated ID requirements as outlined by the GSA. If you do not currently meet these ID requirements, you must be willing and able to update your ID forms in a timely manner.

Benefits

Kentro offers a competitive benefits package including paid time off, healthcare benefits, supplemental benefits, 401k including an employer match, and more. We invest in our employees with education reimbursement for certifications, degrees, or professional development.

We work hard and play hard, hosting various events and celebrations to foster a positive work environment. Our commitment to our communities is also reflected in the charity events we host and attend.

Commitment to Equal Opportunity Employment

Kentro is an equal opportunity employer, committed to creating an inclusive workplace. We encourage protected veterans to self-identify during the application process.