Lead Specialist, Federal Data Architect
for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide which sections have content.
From posting: There's an introductory paragraph about KPMG Advisory practice, then "KPMG is currently seeking a Lead Specialist...". Could be "About the role" content. Then "Responsibilities:" list. Then "Qualifications:" list. Then later benefits and pay info: "KPMG LLP and its affiliates... 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...". Then "In addition, KPMG is proud to offer a comprehensive, competitive benefits package...". Then details about benefits. Also mention "Additional details about our benefits can be found towards the bottom of our KPMG US Careers site at Benefits & How We Work." Also "Follow this link to obtain salary ranges by city outside of CA: ...". Also "KPMG offers a comprehensive compensation and benefits package." So we have some pay transparency info but no explicit salary range numbers. The rule: do NOT create Pay/Schedule/Benefits sections unless the posting actually states them. It does state benefits (comprehensive package) and mentions salary ranges via link but not actual numbers. Should we include Benefits? Yes, because they describe benefits package. Pay? They mention salary ranges via link but not actual numbers; they say "If required, the ranges displayed below or via the URL below are specifically for those potential hires...". There's no actual range displayed. The rule: never emit a heading followed by filler/placeholder text (e.g., "commensurate with experience", "not specified", "N/A", "varies", "TBD"). Since they don't give actual numbers, but they refer to a link for ranges. Is that considered placeholder? It's not a specific range; it's a link. Might be considered not substantive. Safer to omit Pay section. Schedule: no mention. So we will have sections: About the role, Responsibilities, Qualifications, Benefits. Possibly also Skills? The qualifications list includes skills; but we can keep Qualifications. Could also have Skills separate but not needed.
We need to preserve all substantive information. Must not repeat job title as heading. Must not include Job ID etc. Must remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. So we need to strip out the EEO statements, the "No phone calls or agencies please", "KPMG recruits on a rolling basis", etc. Also the Los Angeles County specifics, etc. Also the link to benefits page maybe keep? It's part of benefits description. Might keep as part of benefits paragraph.
We need to keep the responsibilities list exactly as given. Keep qualifications list.
We need to format with headings, - for lists,
for prose.
Let's extract content.
Introductory paragraph before Responsibilities: "The KPMG Advisory practice is at the forefront of transformation, offering excellent opportunities for individuals to advance their careers and expertise with KPMG. Looking ahead, we anticipate continued evolution and success within the practice, fostering both personal and professional development, thereby creating new pathways for growth. 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 help 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."
That's about the role/firm. We'll put under
About the role
as a .
Then Responsibilities: list items after "Responsibilities:" each line starts with a verb. We'll capture each as
- .
Responsibilities list:
- 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
Note there is a semicolon inside third item; keep as is.
Then Qualifications: list after "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
We need to keep all.
Then Benefits: after that paragraph: "In addition, KPMG 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 KPMG publishes a calendar of holidays to be observed during the year and provides eligible employees two 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."
We can keep that as a
under
Benefits
. Also maybe include the link about salary ranges? That is under Pay transparency but we decided not to include Pay section. Could we include a about pay transparency under Benefits? Probably not; better to omit.
We must not include boilerplate like "KPMG LLP and its affiliates and subsidiaries (“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." That's pay-related but we are omitting Pay section. However that paragraph is substantive about pay determination; but we are not creating Pay section because we lack actual range. The rule: never create Pay/Schedule/Benefits sections unless the posting actually states them. It does state that they comply with regulations and that salary is determined based on factors. That is about pay but not a specific range. Could we include a Pay section with that prose? It's not a range but it's substantive about pay determination. The rule says "never emit a heading followed by filler/placeholder text (e.g., "commensurate with experience", "not specified", "N/A", "varies", "TBD")". This paragraph is not filler; it's explanation. However the instruction: "Prefer a few substantive sections over many thin ones." Might be okay to include Pay section with that paragraph. But we must ensure we don't include the link to salary ranges? That's also part of pay transparency. Could include as part of Pay section.
But we must also consider that the posting includes a link to salary ranges by city outside of CA. That is a specific resource. So we could include Pay section with that paragraph and the link.
However the rule: "Do NOT repeat the job title as a heading (the page already shows it) and do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short
or drop it." Not relevant.
We need to decide: include Pay section? The posting does mention salary ranges via link and says they comply with regulations. That is substantive. I'd include Pay section with that paragraph and the link.
But we must not include the boilerplate EEO etc. So we will strip those.
Thus sections: About the role, Responsibilities, Qualifications, Benefits, Pay.
We'll not include Schedule.
Now we need to output only HTML fragment.
Let's craft:
About the role
The KPMG Advisory practice is at the forefront of transformation, offering excellent opportunities for individuals to advance their careers and expertise with KPMG. Looking ahead, we anticipate continued evolution and success within the practice, fostering both personal and professional development, thereby creating new pathways for growth. 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 help 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.
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
- for lists,
for prose. Let's extract content. Introductory paragraph before Responsibilities: "The KPMG Advisory practice is at the forefront of transformation, offering excellent opportunities for individuals to advance their careers and expertise with KPMG. Looking ahead, we anticipate continued evolution and success within the practice, fostering both personal and professional development, thereby creating new pathways for growth. 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 help 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." That's about the role/firm. We'll put under
About the role
as a. Then Responsibilities: list items after "Responsibilities:" each line starts with a verb. We'll capture each as
- .
Responsibilities list:
- 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
Note there is a semicolon inside third item; keep as is.
Then Qualifications: list after "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
We need to keep all.
Then Benefits: after that paragraph: "In addition, KPMG 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 KPMG publishes a calendar of holidays to be observed during the year and provides eligible employees two 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."
We can keep that as a
under
Benefits
. Also maybe include the link about salary ranges? That is under Pay transparency but we decided not to include Pay section. Could we include aabout pay transparency under Benefits? Probably not; better to omit. We must not include boilerplate like "KPMG LLP and its affiliates and subsidiaries (“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." That's pay-related but we are omitting Pay section. However that paragraph is substantive about pay determination; but we are not creating Pay section because we lack actual range. The rule: never create Pay/Schedule/Benefits sections unless the posting actually states them. It does state that they comply with regulations and that salary is determined based on factors. That is about pay but not a specific range. Could we include a Pay section with that prose? It's not a range but it's substantive about pay determination. The rule says "never emit a heading followed by filler/placeholder text (e.g., "commensurate with experience", "not specified", "N/A", "varies", "TBD")". This paragraph is not filler; it's explanation. However the instruction: "Prefer a few substantive sections over many thin ones." Might be okay to include Pay section with that paragraph. But we must ensure we don't include the link to salary ranges? That's also part of pay transparency. Could include as part of Pay section. But we must also consider that the posting includes a link to salary ranges by city outside of CA. That is a specific resource. So we could include Pay section with that paragraph and the link. However the rule: "Do NOT repeat the job title as a heading (the page already shows it) and do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short
or drop it." Not relevant. We need to decide: include Pay section? The posting does mention salary ranges via link and says they comply with regulations. That is substantive. I'd include Pay section with that paragraph and the link. But we must not include the boilerplate EEO etc. So we will strip those. Thus sections: About the role, Responsibilities, Qualifications, Benefits, Pay. We'll not include Schedule. Now we need to output only HTML fragment. Let's craft:
About the role
The KPMG Advisory practice is at the forefront of transformation, offering excellent opportunities for individuals to advance their careers and expertise with KPMG. Looking ahead, we anticipate continued evolution and success within the practice, fostering both personal and professional development, thereby creating new pathways for growth. 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 help 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.
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