Data Engineer 3 (Mid-Level)

Uncomn, Llc.; Shiloh (IL); Híbrido; USD 110 000 - 165 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Day-one health benefits

401K matching

Flexible PTO

Career development

Resumo da oferta

UN COMN is seeking an ETL & Data Ingestion Engineer (Data Engineer/Scientist 3 - Mid-Level) to support the Integration Data Environment and Global Transportation Network Convergence team at Scott AFB, IL. The role emphasizes Informatica PowerCenter, SQL, and data-quality controls across enterprise ingestion workflows.

You will design and optimize data pipelines, validate end-to-end data processing, and mentor junior engineers while collaborating with cross-functional teams in a hybrid work setup.

Qualificações

• 8+ years in ETL development, data engineering, or related field.
• Bachelor’s degree in CS/IT or related field; or active security certification.
• Strong Informatica PowerCenter experience and SQL proficiency.

Responsabilidades

• Lead design, development, testing, deployment, and maintenance of enterprise ETL solutions.
• Develop and optimize Informatica mappings, workflows, and restart/recovery logic.
• Design ingestion patterns from APIs, databases, files, and services.
• Coordinate changes with cross-functional teams to ensure data-flow accuracy.

Conhecimentos

ETL development

Data engineering

Informatica PowerCenter

SQL

Python

Git

Cloud data services

Formação académica

Bachelor's degree or equivalent

Ferramentas

Informatica

Oracle

Aurora/RDS

GitLab CI/CD

Descrição da oferta de emprego

An UNCOMN Genius Leading Innovation means believing in the power of business to make the world a better place through everyday business relationships and interactions. If you join our team, our commitment to you is to find a role that accentuates your strengths and helps you exercise your own brand of “UNCOMN Genius” to reach your career aspirations. We’ll invest in you because — as a consultancy — our people are our brand and great companies invest in their brands.

Learn Together

Our Communities of Practice (COPs) offer a dynamic platform for team members to enhance their professional skills and pursue personal growth in their desired areas. These communities facilitate the development of professional skills, foster the sharing of information and expertise, and encourage the incubation of innovative ideas. Additionally, they provide a space for collaboration with seasoned professionals. Participants are assigned their COP, and we supply the necessary framework and a collaborative environment for their development. This approach not only supports individual growth, but also strengthens our collective expertise.

Location: Scott AFB, IL

Remote Status: Hybrid

Job Id:670

# of Openings:1

At UN COMN, we don’t just fix issues; we deliver secure solutions that power essential operations in both the public and private sectors. Our team tackles tough challenges—whether it’s improving organizational systems, streamlining logistics, or making sense of complex data—all with one goal: helping our clients succeed so they can continue serving others.
We’ve built a culture rooted in our Core Values , where innovation thrives, work-life balance is respected, and career growth is always encouraged. We're also proud to be recognized as a ‘ Top Workplace ’, and that’s not just us talking; it’s our employees. Now, we’re looking for another Uncommon Genius to join our dynamic team. If you love solving puzzles, building new things, fixing what’s broken, or pushing the boundaries of creativity, we encourage you to explore the details of this position below!

UN COMN is seeking an ETL & Data Ingestion Engineer (Data Engineer/Scientist 3 - Mid-Level) to support the Integrated Data Environment & Global Transportation Network Convergence (IGC) team. Responsibilities could include the following:

ETL and Informatica Engineering

• Lead the design, development, testing, deployment, and maintenance of enterprise ETL and data-integration solutions using Informatica and related approved technologies.
• Develop and optimize Informatica mappings, transformations, workflows, sessions, reusable components, scheduling configurations, and restart/recovery logic.
• Modernize legacy ETL workflows by refactoring mappings, SQL, transformation logic, interfaces, and operational processes for approved database and cloud environments.
• Develop and optimize complex SQL queries, views, stored procedures, functions, indexes, and transformation logic supporting high-volume data-processing workloads.
• Perform design and code reviews and establish reusable ETL patterns, development practices, and technical approaches for complex data-integration work.

Data Ingestion and Interface Integration

• Design ingestion patterns for relational databases, APIs, web services, message-based interfaces, structured and unstructured files, and other approved enterprise data sources.
• Design and implement batch, micro-batch, incremental, event-driven, and change-data-capture processing approaches based on approved mission, interface, and performance requirements.
• Analyze source-system structures, interfaces, dependencies, formats, and business rules and develop source-to-target mappings, transformation specifications, data dictionaries, lineage documentation, and interface-control artifacts.
• Develop analytics-ready datasets, views, and data services supporting downstream applications, reporting, and approved business-intelligence platforms.
• Modify ETL mappings, SQL, connectivity, and transformation logic required to support migration to approved cloud-managed database platforms, including Amazon Aurora where implemented.
• Coordinate interface changes with application, database, BI, testing, cybersecurity, and production-support teams to protect end-to-end data-flow accuracy and availability.

Data Quality, Reliability and Performance

• Implement data profiling, validation, cleansing, standardization, reconciliation, deduplication, exception handling, and automated controls supporting data completeness, accuracy, timeliness, integrity, and consistency.
• Develop validation queries, reconciliation reports, automated tests, and technical evidence to confirm transformation results and end-to-end processing behavior.
• Investigate and resolve failed workflows, rejected records, data discrepancies, interface defects, processing bottlenecks, and recurring data-quality issues.
• Tune Informatica workflows, SQL, database access, transformation logic, and scheduling to improve throughput, scalability, processing time, and resource efficiency.
• Implement pipeline-level logging, metrics, alerting, audit trails, restart controls, and recovery procedures to support rapid diagnosis and restoration of failed or delayed processing.
• Design and optimize ingestion and transformation processes to support IGC data-availability and latency objectives while minimizing processing backlogs and repeated failures.

Secure Delivery and Automation

• Maintain ETL code, SQL, configurations, and supporting artifacts in approved Git repositories using established branching, review, and configuration-management practices.
• Develop ETL-specific build, validation, test, packaging, and deployment automation within established GitLab CI/CD processes; coordinate platform and Runner requirements with DevSecOps personnel.
• Develop scripting and data-processing automation using Python, Bash, PowerShell, SQL, or comparable approved technologies.
• Apply secure data-handling practices including least privilege, encryption, secrets protection, secure transfer, logging, and auditability, and support remediation of security findings affecting ETL and data-ingestion components.
• Provide technical evidence and remediation support for applicable RMF, STIG, secure-configuration, testing, and release activities associated with assigned ETL and data-integration components.

Technical Leadership and Documentation

• Prepare and maintain technical designs, data-flow diagrams, source-to-target mappings, interface specifications, data dictionaries, lineage documentation, deployment procedures, troubleshooting guides, and operational runbooks.
• Lead technical design discussions for complex ingestion, transformation, and interface requirements and identify technical risks, dependencies, and recommended mitigations.
• Mentor ETL developers and data engineers and provide guidance on Informatica development, SQL, data quality, performance tuning, testing, and maintainable data-integration design.
• Collaborate with software developers, database engineers, BI developers, cloud/DevSecOps engineers, cybersecurity personnel, testers, functional analysts, Product Owners, operations staff, and Government stakeholders.
• Participate in Agile planning, technical reviews, sprint demonstrations, release activities, defect resolution, and production-support efforts as assigned.

This position description outlines the core duties for this role, but it is not all-inclusive. Responsibilities may shift based on contract requirements, mission needs, or organizational objectives.

Requirements

• 8+ years of professional experience in ETL development, data engineering, data integration, database development, or a related technical field.
• Bachelor’s degree in computer science, Cybersecurity, Data Science, Software Engineering, Information Technology, Information Systems, or a related technical field; OR
  • An active/current certification from the following list: Certified Cloud Security Professional (CCSP), CyberSec First Responder (CFR), Federal IT Security Professional–Manager (FITSP-M) AND
  • An active/current certification from the following list: GIAC Security Essentials Certification (GSEC), CompTIA Security+, or Systems Security Certified Practitioner (SSCP)
• Must be eligible to obtain a security clearance, granted by the U.S. Government, which requires U.S. citizenship. The government also uses 13 adjudicative guidelines to determine an individual's eligibility.
• Demonstrated experience designing and supporting complex enterprise data-ingestion and transformation solutions.
• Advanced hands-on experience with Informatica PowerCenter and/or another Informatica enterprise data-integration platform, including mappings, transformations, workflows, sessions, reusable components, parameterization, and scheduling.
• Advanced SQL skills, including complex queries, joins, views, stored procedures, functions, indexing, query optimization, and troubleshooting.
• Experience with Oracle, PostgreSQL, MySQL, Amazon Aurora/RDS, SQL Server, or comparable enterprise relational database platforms.
• Experience integrating data from APIs, web services, relational databases, message-based interfaces, and file-based sources.
• Experience developing source-to-target mappings, transformation rules, metadata, lineage, and interface documentation.
• Experience implementing data-quality, validation, reconciliation, error-handling, restart, and recovery controls.
• Experience troubleshooting and tuning high-volume or mission-critical ETL and data-processing workloads.
• Experience using Python, Bash, PowerShell, SQL, or another applicable scripting/programming language for data processing and automation.
• Experience using Git and automated software-delivery processes for ETL, SQL, or data-engineering components.
• Familiarity with cloud-native data services and managed database platforms used to support enterprise ingestion and transformation workloads.
• Strong technical leadership, analytical, troubleshooting, documentation, mentoring, and stakeholder-communication skills.

Preferred

• Experience modernizing legacy Informatica workflows or migrating data-integration capabilities to AWS-based environments.
• Experience with Informatica Intelligent Cloud Services (IICS), Informatica Cloud Data Integration, or comparable Informatica cloud capabilities.
• Experience processing large-volume, high-velocity, or mission-critical transportation and logistics data.
• Experience with Amazon Aurora PostgreSQL or Aurora MySQL, Amazon RDS, S3, Glue, Lambda, Kinesis, Database Migration Service, CloudWatch, or comparable approved cloud data services.
• Experience preparing datasets, views, or data services for Apache Superset or another enterprise business-intelligence platform.
• Familiarity with data lakes, event streaming, data catalogs, metadata management, and data-governance practices.
• Familiarity with containerized environments, infrastructure-as-code processes, and automated cloud deployment practices used by cloud/DevSecOps teams.
• Experience supporting USTRANSCOM, Department of Defense logistics, or another mission-critical federal data environment.

Why UN COMN?

• Instant Flexible PTO: Enjoy flexible paid time off starting your very first day with us!
• Generous Holidays: Benefit from 7 paid holidays and up to 3 floating holidays annually.
• Immediate Health Coverage: Get access to comprehensive health benefits from day one.
• 401K Safe Harbor Match: Secure your future with our top-tier 401K matching program.
• Growth Opportunities: Advance your career with our training and education assistance programs.
• Free Employee Assistance Program (EAP):Access complimentary support services for you and your family.

Note: Benefits apply to full-time employees only.

Don’tmeet every single requirement?We’re dedicated to building an uncommon, inclusive, and authentic workplace, so if you’re excited about this role but your experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, or national origin.

Day-one health, dental, and vision coverage

protection

Health Savings Account (HSA) with annual

employer contribution

Free telemedicine (including mental health)

access for you and your family

Free Employee Assistance Program (EAP)

for confidential support

100% company-paid short and long-term

disability and life insurance

Optional hospital indemnity coverage for

extra peace of mind

Fully paid parental leave (12 weeks

maternity, 4 weeks parental/adoption)

Flexible paid time off (PTO)

Paid company holidays

Military (caregiver) leave

Legal services through MetLaw

Life & Family

401(k) Matching Program - fully vested

from day one

Education and certification reimbursement

Bonuses for performance, as well as

completing professional training

and certifications

Invest in

Your Future

Professional

Development

At UNCOMN, passion meets possibility.

We offer opportunities and remove

obstacles so you can take your career

into your own hands. Our

comprehensive suite of Professional

Development resources is designed to

support your career journey every step

of the way. Each employee has

immediate access to unlimited training

courses (Udemy), micro-learning teams,

education assistance, and professional

Communities of Practice (COPs).

Our Culture

passions, and personalities because

we believe diversity is a strength.

We are a community of equals, and

we strive to make every team

member feel valued and respected.

Our team works a little smarter,

dresses a little sharper, and plays a

little harder. Here are some

opportunities that set us apart:

Monthly Happy Hours

Social Communities (Gaming,

Competitive Events (Trivia,

Local Philanthropy & Community

Involvement

Day-one health, dental, and vision coverage

protection

Health Savings Account (HSA) with annual

employer contribution

Free telemedicine (including mental health)

access for you and your family

Free Employee Assistance Program (EAP)

for confidential support

100% company-paid short and long-term

disability and life insurance

Optional hospital indemnity coverage for

extra peace of mind

Fully paid parental leave (12 weeks

maternity, 4 weeks parental/adoption)

Flexible paid time off (PTO)

Paid company holidays

Military (caregiver) leave

Legal services through MetLaw

Life & Family

401(k) Matching Program - fully vested

from day one

Education and certification reimbursement