Data Scientist / Data Analyst
The Data Scientist / Data Analyst at Confidential Client leads the design and development of data integration and API ETL/ELT pipelines, transforming complex federal agency data into clean, consumable outputs. This role requires collaboration with business and technical stakeholders to resolve data quality issues, implement data governance, and support federal clients with compliance to cybersecurity standards. The position offers a hybrid work environment and focuses on advancing the firm's capabilities in emerging technologies within the federal sector.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Business Consulting and Services.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
Position Overview
Confidential Client (via Careertakes) is seeking an experienced Data Scientist / Data Analyst to design and implement robust data integration, ETL/ELT, and API-driven data products that convert fragmented agency data into clean, consumable outputs. This role supports federal and public-sector programs and focuses on modern data engineering, governance, and architecture to enable reliable analytics and reporting.
Pay Range: $110,000 - $130,000 (annually)
What You’ll Do
- Translate fragmented, opaque data sources into clean, consumable API outputs and data products.
- Map source systems to canonical data models and implement reusable data assets.
- Lead the design and development of API-driven ETL/ELT pipelines and data orchestration.
- Build and maintain data quality frameworks, validation rules, reconciliation processes, and lineage tracking.
- Resolve data quality and semantic inconsistencies across authoritative sources.
- Implement metadata management, data catalogs, and governance controls.
- Work directly with business stakeholders, system owners, and technical teams to define requirements and translate business concepts into technical designs.
- Integrate legacy systems (Oracle, DB2, mainframes) with modern cloud data stacks when required.
- Ensure designs comply with applicable federal cybersecurity and data protection standards (NIST, FISMA, FedRAMP) and role-based access controls.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, Mathematics, or related discipline — or equivalent mix of education and experience.
- 4+ years of experience designing and implementing data integration, ETL/ELT, analytics, or data engineering solutions in cloud environments (AWS, Azure, or GCP).
- Strong proficiency in SQL and Python.
- Experience with modern data orchestration and processing frameworks (Airflow, Spark, Databricks, Azure Data Factory, AWS Glue, or similar).
- Experience implementing data governance, metadata management, lineage tracking, and data catalog solutions.
- Demonstrated experience with data quality frameworks, reconciliation processes, and master/reference data management.
- Solid data modeling and architecture skills (canonical models, normalization, star schema).
- Experience authoring API data contracts and schemas (JSON Schema).
- Experience supporting U.S. Federal Government clients or similarly regulated environments, working with complex legacy systems and authoritative data sources.
- Familiarity with federal cybersecurity and compliance requirements (NIST, FISMA, FedRAMP).
- Strong communication and stakeholder-management skills.
Preferred / Nice-to-have:
- Experience with Oracle, IBM DB2, or mainframe integrations.
- Prior work on HUBZone or small-business federal engagements.
Benefits
- 401(k)
- Health, dental, and vision insurance
- Life insurance
- Paid time off
- Parental leave
Schedule
- Full-time
- 8-hour shift, Monday–Friday
Work Location
- Hybrid — primarily remote with some in-person requirements in Washington State (candidates must be able to travel to in-person sites as needed).
Notes
- As a HUBZone-certified opportunity, applicants located in SBA-designated HUBZones are encouraged to apply.
- This role will work on federal data and advisory engagements; successful candidates must be able to meet applicable federal security and compliance requirements.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range