The Role
Design, build, and maintain production data pipelines and ETL/ELT workflows. Integrate SaaS and operational systems via APIs, transform JSON/XML to structured datasets, optimize SQL, implement data quality checks, and contribute to cloud-based data infrastructure using Python, Airflow, and cloud data services.
Summary Generated by Built In
REQUIRED: Active TS/SCI with Full Scope Polygraph
LOCATION: Full-time onsite in Herndon, VA
We’re looking for a motivated data engineer who enjoys building reliable pipelines and solving real‑world data challenges. In this role, you’ll help design and maintain production data workflows, write and optimize SQL, integrate data from SaaS platforms via APIs, and transform semi‑structured JSON/XML into clean, structured datasets. You’ll work with Python, cloud data services (AWS, Azure, or GCP), dimensional modeling concepts, and ETL/ELT patterns while contributing to scalable, well‑documented data infrastructure.
Who We Are:
We offer advanced services in data science, data engineering, software engineering, AI solutions, cybersecurity, staff augmentation, and IT program management.
Passionate Integrity, Driven by Excellence
At Ardent Principles, passionate integrity and a relentless pursuit of excellence define who we are. We offer a competitive salary range and a comprehensive benefits package designed to support your long‑term success. Our mission is to connect fulfilled employees with satisfied clients, ensuring your well‑being and professional satisfaction directly contribute to exceptional outcomes for those we serve.
Join us as we continue building the future of secure, high‑impact solutions.
LOCATION: Full-time onsite in Herndon, VA
We’re looking for a motivated data engineer who enjoys building reliable pipelines and solving real‑world data challenges. In this role, you’ll help design and maintain production data workflows, write and optimize SQL, integrate data from SaaS platforms via APIs, and transform semi‑structured JSON/XML into clean, structured datasets. You’ll work with Python, cloud data services (AWS, Azure, or GCP), dimensional modeling concepts, and ETL/ELT patterns while contributing to scalable, well‑documented data infrastructure.
Who We Are:
We offer advanced services in data science, data engineering, software engineering, AI solutions, cybersecurity, staff augmentation, and IT program management.
Passionate Integrity, Driven by Excellence
At Ardent Principles, passionate integrity and a relentless pursuit of excellence define who we are. We offer a competitive salary range and a comprehensive benefits package designed to support your long‑term success. Our mission is to connect fulfilled employees with satisfied clients, ensuring your well‑being and professional satisfaction directly contribute to exceptional outcomes for those we serve.
Join us as we continue building the future of secure, high‑impact solutions.
Key Responsibilities
In this challenging yet rewarding role, you are an integral part of what brings our Company's mission to life. You must have the following required skills, certifications and demonstrated experience providing testing support in and/or with:
- Designing, building, and maintaining production data pipelines using orchestration tools such as Apache Airflow or similar.
- SQL skills including complex queries, optimization, nd performance tuning across multiple database platforms.
- Integrating data from Sponsor SaaS platforms and operational systems via APIs, including handling authentication, pagination, and rate limiting.
- Working with semi-structured data (JSON and XML) from API responses and transforming into structured datasets.
- Developing robust API integrations with proper error handling and retry logic.
- Working with systems that have limited documentation or vendor-specific data models.
- Working with dimensional modeling and data warehouse design patterns.
- Proficiency in Python for data engineering including working with data processing libraries.
- Cloud data platforms such as AWS, Azure, or GCP, including data services and infrastructure.
- Implementing ETL/ELT processes from diverse data sources.
- Version control (Git) and software engineering best practices.
- Strong problem-solving and troubleshooting skills for complex data pipeline issues.
- Implementing data quality checks and validation frameworks.
- Translating business requirements into technical data solutions.
- Having a proven track record of delivering reliable, scalable data infrastructure.
Highly Desired Qualifications
Other skills and demonstrated experiences with or in the following are highly desired but not mandatory to perform the work include:
- ServiceNow APIs, data models, and integration patterns.
- Network management or IT operations systems data extraction.
- Forward Networks, NetIM, SolarWinds, or similar network management platforms.
- Working with and knowledge of ITSM (Information Technology Service Management), ITOM (Information Technology Operations Management), and CMDB (Configuration Management Database) data structures and relationships.
- API gateway platforms and API management tools.
- Apache Spark, particularly PySpark, for distributed data processing.
- DBT (data build tool) for transformation workflows.
- Infrastructure-as-code tools such as Terraform or CloudFormation. Implementing CI/CD (Continuous Integration / Continuous Delivery) pipelines for data engineering code.
- Knowledge of streaming data technologies such as Kafka, Kinesis, or similar platforms.
- Data quality platforms such as Great Expectations, Soda, or Monte Carlo.
- Implementing data observability and monitoring solutions.
- Knowledge of Data Vault or other advanced modeling methodologies.
- Containerization (Docker) and orchestration (Kubernetes) for data workloads.
- Reverse ETL and operational analytics patterns.
- Data governance platforms and metadata management tools.
- Multiple cloud platforms and multi-cloud architectures.
- Mentoring or leading data engineering initiatives.
What We Offer You
- Highly Competitive Salary: Recognizing and rewarding your expertise and contributions.
- Generous Paid Time Off: Providing ample time for rest, relaxation, and personal pursuits.
- Dedicated Training Budget: Supporting continuous learning and professional development.
- 100% Employer-Covered Family Vision, Dental, and Health Insurance: Ensuring comprehensive health coverage for you and your family.
- 100% Employer-Covered Life and Disability Insurance: Offering financial security and peace of mind.
- 401(k) Plan with a 6% Employer Match: Helping you plan and save for a secure retirement, with 100% vesting from day one.
- 11 Paid Government Holidays: Observing national holidays to ensure time off with family and friends.
- Spot Bonuses for Exceptional Performance: Rewarding outstanding contributions and achievements.
SCHEDULE:
This is a full-time position with consultants expected to be available and working onsite in Herndon, VA during core hours.
Ready to take the next step in your career? Join us and be part of a team dedicated to driving positive change through technology. Apply now with our easy 3-minute, mobile-friendly initial application process. Your future starts here!
About
At Ardent Principles, we're more than just a technology company - we're a team of innovators, problem-solvers, and collaborators dedicated to pushing the boundaries of what's possible. Our mission is to empower organizations with transformative IT solutions and program management services, while our values of integrity, excellence, and teamwork guide everything we do. We foster a culture of open communication, where every voice is heard, and every idea is valued. Join us and be part of a company where your contributions truly make a difference.
Skills Required
- Active TS/SCI with Full Scope Polygraph
- Onsite full-time in Herndon, VA
- Designing, building, and maintaining production data pipelines using orchestration tools such as Apache Airflow or similar
- SQL skills including complex queries, optimization, and performance tuning across multiple database platforms
- Integrating data from SaaS platforms and operational systems via APIs, including authentication, pagination, and rate limiting
- Working with semi-structured data (JSON and XML) and transforming into structured datasets
- Developing robust API integrations with proper error handling and retry logic
- Working with systems that have limited documentation or vendor-specific data models
- Working with dimensional modeling and data warehouse design patterns
- Proficiency in Python for data engineering and data processing libraries
- Experience with cloud data platforms (AWS, Azure, or GCP) and related data services
- Implementing ETL/ELT processes from diverse data sources
- Version control (Git) and software engineering best practices
- Strong problem-solving and troubleshooting skills for complex data pipeline issues
- Implementing data quality checks and validation frameworks
- Translating business requirements into technical data solutions
- Proven track record of delivering reliable, scalable data infrastructure
- Experience with ServiceNow APIs, data models, and integration patterns
- Experience with network management or IT operations systems data extraction (Forward Networks, NetIM, SolarWinds)
- Knowledge of ITSM, ITOM, and CMDB data structures and relationships
- Experience with API gateway platforms and API management tools
- Experience with Apache Spark / PySpark
- Experience with DBT for transformation workflows
- Infrastructure-as-code tools such as Terraform or CloudFormation and CI/CD for data engineering
- Knowledge of streaming technologies (Kafka, Kinesis)
- Familiarity with data quality platforms (Great Expectations, Soda, Monte Carlo) and observability
- Knowledge of Data Vault or other advanced modeling methodologies
- Containerization (Docker) and orchestration (Kubernetes) for data workloads
- Experience implementing Reverse ETL and operational analytics patterns
- Experience with data governance platforms and metadata management tools
- Experience mentoring or leading data engineering initiatives
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Ardent Principles, Inc. is a people-focused IT and management consulting firm for commercial and government clients, specializing in IT services and program management, and offering advanced services in data science, data engineering, software engineering, AI solutions, cybersecurity, and staff augmentation.
