Lead Specialist, Federal Data Architect

KPMG LLP; St. Louis (MO); On-site; USD 110,000 - 160,000; Full time

Job summary

KPMG LLP is seeking a Lead Specialist to join our Federal Advisory practice in St. Louis, MO. The role focuses on data architecture, analytics, and ML model development across data discovery, ETL/ELT, and governance, with client workshops and cross-functional collaboration.

The position requires five years of data architecture experience, strong SQL, and on-site presence; U.S. Government Secret clearance is required. Travel to engagements will be necessary as part of the role.

Qualifications

• Minimum five years of Data Architecture/technical experience.
• Familiarity with Data Lake/Data Warehouse architecture and dimensional modeling.
• Experience with data governance and metadata management.
• Experience with data modeling tools (ERWin, ER Studio, Power Designer).
• Strong SQL skills and knowledge of relational databases (SQL Server, Oracle, PostgreSQL).
• Willingness to travel; on-site presence in St. Louis, MO region.

Responsibilities

• Support delivery of data supply chain projects and define objectives/deliverables.
• Lead workshops and innovation sessions with clients and cross-functional teams.
• Engage with clients to discover data sources and manage data requests; perform ETL/ELT processes.
• Develop analytics and ML models through all development phases.
• Define, monitor, and report key business metrics; design dashboards and reporting processes.

Skills

Data modeling

SQL

Big data

Client engagement

Risk management

Education

Bachelor's degree

Tools

ERWin

ER Studio

PowerDesigner

IBM Data Architect

Job description

KPMG is currently seeking a Lead Specialist to join our Federal Advisory practice.

Responsibilities:

• 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

Qualifications:

• 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