Title: Data Engineer Location: Crystal City, VA Full Time Mid Level INTEGRITYOne Partners Data Engineer: Mid-Level Location: Hybrid – 1-2 days per week on-site in Crystal City, VA The Role As a mid-level Data Engineer, you'll be at the forefront of delivering software solutions that directly impact our clients' law enforcement mission. You'll work with dedicated team members and clients to solve complex technical problems and develop systems that keep our country safe and secure. About Us INTEGRITYOne Partners specializes in IT modernization and business transformation for Federal clients. We tackle big problems with missions that positively impact our country's health, safety, and security. Our team of dedicated consultants and technologists thrives on learning new technologies, frameworks, and methodologies. With decades of experience, we pride ourselves on building outstanding and sustainable software products and systems. Ideal Candidate Profile - Demonstrates intellectual curiosity and a passion for continuous learning - Thrives in a collaborative, fast-paced environment - Shows adaptability and resilience in the face of complex challenges - Exhibits strong problem-solving skills and attention to detail - Possesses excellent communication and interpersonal skills Technical Skills Required - Python - Java - Microservices (REST/SOAP/GraphQL) - JSON and JSON format mediation techniques - AWS Managed Services for back-end infrastructure (S3, RDS, EC2, Lambda) - High-volume ETL solutions - LINUX (RHEL preferred), shell scripting - Relational database knowledge in Oracle or Postgres, Strong SQL Knowledge - DevSecOps tools and techniques (Jenkins, Ansible, Terraform, Vault) Key Responsibilities - Collaborate with cross-functional teams to deliver results over 2-week sprints - Gather requirements, design, implement, and test software and systems - Develop scalable, high-performance, and highly available applications and systems components - Diagnose and resolve complex system issues - Communicate effectively with clients, team members, and other development teams - Respond to client requirements in tight timeframes, demonstrating flexibility in work location and hours Requirements - US Citizenship (ability to obtain and maintain a DHS 6C Public Trust clearance) - Bachelor's degree or higher (computer science background recommended but not required with suitable experience) - Ability to work on-site in Crystal City, Virginia, 1-2 days per week Experience - 4-6 years of experience in Agile software development - Proven track record in designing and developing scalable applications - Experience working in government or high-security environments is a plus Career Development At INTEGRITYOne Partners, we reward hard work and outstanding results. We offer: - Mentorship programs - Ongoing training and certification opportunities - Clear path for advancement within the organization - Exposure to cutting-edge technologies and high-impact projects - Competitive raises, bonuses, and promotions Ready to Make a Difference? If you're passionate about technology, driven by innovation, and want to contribute to national security, we want to hear from you. Apply now and join our team of dedicated professionals shaping the future of federal IT solutions. Interviewing Tips From researching to preparing for your interview and putting your best foot forward, we want you to be prepared and confident as you explore opportunities with INTEGRITYOne Partners. Check out interviewing tips from our recruiters. At INTEGRITYOne Partners, we have high standards for the members of our team ---- and when our people meet these standards, the personal and professional rewards are plentiful. We help INTEGRITYOne Partners’ employees grow in their careers by gaining enhanced Federal knowledge and experience, sought-after skills, greater discipline and drive, and targeted education and training INTEGRITYOne Partners is an equal opportunity employer Minorities / Females / Veterans / Disabilities. All qualified applicants will be considered without regard to race, ethnicity, color, national origin, religion, sexual orientation, gender identity, veteran status, or status as a qualified individual with a disability or any other personal characteristic protected by law.

Role Description itD is seeking a Data Engineer to support a high-impact enterprise data migration initiative focused on transitioning business-critical operations from Salesforce to an internal entity-modeled data platform. This role will contribute directly to the success of Meta’s Developer Ecosystem Success organization by building scalable ETL pipelines, designing data architectures, and ensuring reliable, AI-ready data infrastructure across distributed systems. - Design and build bidirectional ETL/ELT data pipelines between Salesforce, distributed data warehouses, and internal operational data platforms. - Develop and maintain streaming data pipelines using Kafka, Kinesis, Pulsar, or equivalent distributed event-streaming systems. - Design and manage dimensional and entity-modeled schemas, including access permissions and mutation rules. - Build data validation, reconciliation, and monitoring frameworks to ensure data quality, consistency, and auditability throughout migration activities. - Develop and maintain schema documentation, transformation logic, data dictionaries, and source-to-target mapping documentation. - Collaborate with software engineers, Salesforce administrators, and business stakeholders to define data contracts, SLAs, and migration requirements. - Investigate and resolve data quality issues, pipeline failures, and reconciliation discrepancies across batch and streaming workloads. - Utilize AI-assisted development tools such as GitHub Copilot, Cursor, and Claude Code to accelerate development workflows and schema migrations. - Support data restructuring and transformation initiatives to prepare datasets for downstream AI and analytics applications. Qualifications - 5+ years of professional data engineering experience. - Strong proficiency in SQL and relational databases such as MySQL. - Experience with Hack/PHP development and GraphQL. - Hands-on experience building and maintaining large-scale ETL/ELT pipelines in distributed data warehouse environments such as Hive, Spark, Presto/Trino, BigQuery, Snowflake, or Databricks. - Experience with real-time event-streaming systems including Kafka, Pulsar, Kinesis, or equivalent technologies. - Experience with ORM frameworks and entity/schema modeling. - Strong understanding of data quality engineering, validation, reconciliation, and monitoring frameworks. - Experience using AI-assisted coding tools such as GitHub Copilot, Claude Code, or Cursor within development workflows. - Strong troubleshooting, problem-solving, and communication skills with the ability to work independently. Requirements - Experience with Salesforce data migrations and integrations. - Familiarity with AI-ready data architecture and AI development workflows. - Experience supporting event and subscription handling systems. - Prior experience working within large-scale technology or distributed systems environments. - Experience collaborating with cross-functional engineering and business operations teams. Education - Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field required. Benefits - Comprehensive medical benefits. - 401k plan. - Paid holidays. - Networking & career learning and development programs. Company Description About itD: We are part of a new generation of consulting and software development company that blends diversity, innovation, and integrity with real business results. Our structure rejects any strong hierarchy, empowering us to deliver excellent results. We are a woman- and minority-led firm. Every day, we challenge ourselves to be considerate, fair and to re-think what great outcomes mean for our customers. The itD Digital Experience: Joining us means you’ll be part of our global community, you have a say about your own career journey, and you’ll get a chance to give back to causes that matter. You will experience working with Fortune 500 companies and high-performance teams across numerous industries.

• Own the dbt project architecture, including model structure, naming conventions, testing standards, CI/CD pipelines, and documentation frameworks to ensure consistency across all engineering work. • Manage the dataset delivery backlog with onshore stakeholders, including phase scoping, validation of source data availability, and sequencing of builds to maximise business value. • Govern code quality by reviewing all Silver and Gold models prior to UAT, ensuring no production deployment occurs without lead approval. • Own the end-to-end dataset handover process from Build to Run, including test sign-off, data catalogue documentation, observability configuration, and operational runbooks. • Coordinate and prioritise work across Build and Run workstreams operating in parallel, ensuring alignment and delivery efficiency. • Participate in standups (async where required) and lead sprint demonstrations on a fortnightly basis. • In Run steady state operations, own DataHub SLA performance, oversee new dataset onboarding, and act as the final escalation point for production support issues. • Own DataHub SLA performance, ensuring pipeline uptime and data freshness commitments are met across all production Gold datasets. • Manage new dataset intake from onshore teams, scoping requests and determining whether they require a new build phase or can be absorbed into the Run team. • Act as the primary escalation point for onshore stakeholders and the final offshore escalation for critical incidents that cannot be resolved by the data operations team.

• Semantic Model Architecture : Design and evolve the semantic modeling layer that serves as the single source of truth for metrics, dimensions, entities, and business logic across all data products. • Define the standards for how semantic models are authored, versioned, tested, and governed. • Evaluate and drive the semantic layer technology strategy (e.g., dbt MetricFlow or equivalent). • Data Product Enablement : Architect how the semantic layer is consumed across distinct product surfaces such as Reporting (high-performance BI platform for customers), and Agentic Analytics (metadata-rich, discoverable interfaces that enable AI agents to reason over and query the semantic layer). • Partner with adjacent teams to ensure the semantic layer meets each product’s unique requirements. • Performance & Scale : Own query performance, materialization strategies, pre-aggregation patterns, and cost optimization. • Ensure the semantic layer is highly performant and scalable as data volumes and consumer demand grow. • Platform & Governance : Build the semantic layer as a true platform experience: self-service metric onboarding, developer-friendly abstractions, clear documentation, data validation, and governance guardrails. • Make it easy for other teams to extend the semantic layer without compromising consistency or quality. • Technical Leadership : Operate as a technical leader across the Data & Reporting Platform organization. • Participate in and drive design sessions across teams. • Mentor engineers, manage stakeholder and leadership alignment. • Contribute to architecture decisions that span from data foundations through reporting and analytics. • Champion high-quality code with corresponding test coverage. • AI-Augmented Engineering : Use AI coding tools (Claude, Cursor, Copilot) as a core part of your daily workflow. • Drive adoption patterns, build team-specific contexts and workflows, and set the standard for how the team multiplies velocity through AI-assisted development.