> Markdown version of [/jobs/ext/2978481-lead-specialist-federal-data-architect](https://www.wearedevelopers.com/jobs/ext/2978481-lead-specialist-federal-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Specialist, Federal Data Architect

- **Company:** Kpmg LLP
- **Location:** St. Louis, MO, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Architecture, Data Discovery, Data Governance, Extract Transform Load (ETL), Data Profiling, Data Warehousing, Relational Databases, Database Queries, Dimensional Modeling, Distributed Data Store, PostgreSQL, Machine Learning, Meta-Data Management, Microsoft SQL Server, Operational Data Store, Oracle (Applications), Teradata SQL, Unstructured Data, Netezza, Data Lakes, Data Management, Amazon Redshift
- **Published:** September 18, 2026
- **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/18353412?backUrl=%2Fcareer%2F18353412%2FLead-Specialist-Federal-Data-Architect-Missouri-St-Louis

## About the Role

* A minimum of five years of Data Architecture / technical experience; U.S. Federal government consulting experience preferred
 * Bachelor's degree from an accredited college/university
 * Familiarity with Data Lake / Data Warehouse architecture, design, implementation, dimensional modeling, data profiling, and source to target mapping best practices
 * Familiarity with data governance and management strategies, including data standards, data policies, metadata management, master data management
 * Experience utilizing data modeling tools such as ERWin, ER Studio, Power Designer, IBM Data Architect
 * Strong SQL skills and working knowledge of relational databases such as SQL Server, Oracle, PostgreSQL; knowledge of distributed databases such as Netezza, Teradata, Amazon Redshift etc.
 * Ability to travel as required to support firm engagements
 * Initial project will be located in the St. Louis, MO region, requires daily on-site presence
 * Applicant must possess a U.S. Government Secret clearance

## Description

* Support the delivery of data supply chain projects, including definition of objectives / key deliverables while managing and mitigating risks in data, modeling, validation, and delivery
 * Support workshops and innovation sessions with clients, multi-disciplinary, and cross-functional teams to identify business opportunities, define problem statements, and design high level analytical solutions
 * Engage with clients to discover data sources and create data requests; Engage in data discovery and ETL/ELT processes to ingest structured data and annotation processes to enrich unstructured data leveraging a variety of data sources (social media, news, internal / external documents, financial data, operational data)
 * Support the creation of analytics and machine learning models through all phases of development, from design through training, evaluation, validation, and implementation
 * Define, monitor, and report key business metrics
 * Design, implement, and manage various reporting processes and dashboards
 * Leverage a variety of modern big data tools and approaches to solve complex business objectives


## Related Videos

- [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [Tracking vehicles at scale](https://www.wearedevelopers.com/videos/1999-tracking-vehicles-at-scale)
- [The Data Mesh as the end of the Datalake as we know it](https://www.wearedevelopers.com/videos/156-the-data-mesh-as-the-end-of-the-datalake-as-we-know-it)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)