LEAD SPECIALIST, FEDERAL DATA ARCHITECT WITH SECURITY CLEARANCE
KPMG
St. Louis MO 63101 US
Business Title: Lead Specialist, Federal Data Architect Requisition Number: 117455 - 48 Function: Advisory Area of Interest: State: MO City: Saint Louis Description: The KPMG Advisory practice is currently our fastest growing practice. We are seeing tremendous client demand, and looking forward we don't anticipate that slowing down. In this ever-changing market environment, our professionals must be adaptable and thrive in a collaborative, team-driven culture. At KPMG, our people are our number one priority. With a wealth of learning and career development opportunities, a world-class training facility and leading market tools, we make sure our people continue to grow both professionally and personally. If you're looking for a firm with a strong team connection where you can be your whole self, have an impact, advance your skills, deepen your experiences, and have the flexibility and access to constantly find new areas of inspiration and expand your capabilities, then consider a career in Advisory. KPMG is currently seeking a Lead Specialist to join our Federal Advisory practice. Responsibilities: * Plan, lead, and execute delivery of data / AI engagements, including definition of objectives / key deliverables while managing and mitigating risks in data, modeling, validation, and delivery
* Lead 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; Lead 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)
* Oversee 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.
* Familiarity with data science concepts, business intelligence applications, warehouse design, as well as analytics in cloud and hybrid environments
* Ability to travel as required to support firm engagements
* Applicant must possess a U.S. Government Secret clearance
KPMG complies with all local/state regulations regarding displaying salary ranges. If required, the ranges displayed below or via the URL below are specifically for those potential hires who will work in the location(s) listed. Any offered salary is determined based on relevant factors such as applicant's skills, job responsibilities, prior relevant experience, certain degrees and certifications and market considerations. In addition, the firm is proud to offer a comprehensive, competitive benefits package, with options designed to help you make the best decisions for yourself, your family, and your lifestyle. Available benefits are based on eligibility. Our Total Rewards package includes a variety of medical and dental plans, vision coverage, disability and life insurance, 401(k) plans, and a robust suite of personal well-being benefits to support your mental health. Depending on job classification, standard work hours, and years of service, KPMG provides Personal Time Off per fiscal year. Additionally, each year the firm publishes a calendar of holidays to be observed during the year and provides two firmwide breaks each year where employees will not be required to use Personal Time Off; one is at year end and the other is around the July 4th holiday. Additional details about our benefits can be found towards the bottom of our KPMG US Careers site at â??Benefits & How We Workâ?. Follow this link to obtain salary ranges by city outside of CA: https://kpmg.com/us/en/how-we-work/pay-transparency.html/?id=M101_3_24KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an affirmative action-equal opportunity employer. KPMG complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, citizenship status, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. The attached link â??https://assets.kpmg.com/content/dam/kpmg/us/pdf/2018/09/eeo.pdf? â?contains further information regarding the firm's compliance with federal, state and local recruitment and hiring laws. No phone calls or agencies please. KPMG does not currently require partners or employees to be fully vaccinated or test negative for COVID-19 in order to go to KPMG offices, client sites or KPMG events, except when mandated by federal, state or local law. In some circumstances, clients also may require proof of vaccination or testing (e.g., to go to the client site). KPMG recruits on a rolling basis. Candidates are considered as they apply, until the opportunity is filled. Candidates are encouraged to apply expeditiously to any role(s) for which they are qualified that is also of interest to them. GL: 4 GF: 15306
* Lead 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; Lead 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)
* Oversee 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.
* Familiarity with data science concepts, business intelligence applications, warehouse design, as well as analytics in cloud and hybrid environments
* Ability to travel as required to support firm engagements
* Applicant must possess a U.S. Government Secret clearance
KPMG complies with all local/state regulations regarding displaying salary ranges. If required, the ranges displayed below or via the URL below are specifically for those potential hires who will work in the location(s) listed. Any offered salary is determined based on relevant factors such as applicant's skills, job responsibilities, prior relevant experience, certain degrees and certifications and market considerations. In addition, the firm is proud to offer a comprehensive, competitive benefits package, with options designed to help you make the best decisions for yourself, your family, and your lifestyle. Available benefits are based on eligibility. Our Total Rewards package includes a variety of medical and dental plans, vision coverage, disability and life insurance, 401(k) plans, and a robust suite of personal well-being benefits to support your mental health. Depending on job classification, standard work hours, and years of service, KPMG provides Personal Time Off per fiscal year. Additionally, each year the firm publishes a calendar of holidays to be observed during the year and provides two firmwide breaks each year where employees will not be required to use Personal Time Off; one is at year end and the other is around the July 4th holiday. Additional details about our benefits can be found towards the bottom of our KPMG US Careers site at â??Benefits & How We Workâ?. Follow this link to obtain salary ranges by city outside of CA: https://kpmg.com/us/en/how-we-work/pay-transparency.html/?id=M101_3_24KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an affirmative action-equal opportunity employer. KPMG complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, citizenship status, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. The attached link â??https://assets.kpmg.com/content/dam/kpmg/us/pdf/2018/09/eeo.pdf? â?contains further information regarding the firm's compliance with federal, state and local recruitment and hiring laws. No phone calls or agencies please. KPMG does not currently require partners or employees to be fully vaccinated or test negative for COVID-19 in order to go to KPMG offices, client sites or KPMG events, except when mandated by federal, state or local law. In some circumstances, clients also may require proof of vaccination or testing (e.g., to go to the client site). KPMG recruits on a rolling basis. Candidates are considered as they apply, until the opportunity is filled. Candidates are encouraged to apply expeditiously to any role(s) for which they are qualified that is also of interest to them. GL: 4 GF: 15306