Senior Data Governance Analyst
for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule.
We must include sections only when posting has real specific content. We have:
- About the role: we have company description and position summary. That's content.
- Responsibilities: there is a long list of essential functions (Essential Functions). That's responsibilities.
- Requirements: there is a "Requirements" section later describing physical requirements, travel, etc. Also there is "Supervision Job Scope" etc. Might be considered requirements? The posting has a "Qualifications" section with education, experience, skills. Also there is a "Skills" maybe we can combine? The instruction says use headings for those categories if content exists. We have Qualifications (education, experience). We have Skills (proficiency in SQL, Snowflake, Power BI, etc). We have Benefits (they mention benefits package). We have Pay (Compensation section). We have Schedule (maybe not explicit; they mention work primarily performed during business week Monday-Friday, travel 5% or less). That's schedule info.
We must not repeat job title as heading. Do not put Job ID/requisition numbers as headings. We can fold minor metadata into short p or drop.
We must remove boilerplate: EEO, scam-warning, navigation, cookie, legal, duplicated lines. Also remove "Guild Mortgage Company is an Equal Opportunity Employer." and REQ# line.
We must preserve all substantive information; do not invent or summarize away detail. So we need to keep all details from sections.
We need to format using headings, - for any list of duties/requirements/benefits, and
for prose.
We need to decide what constitutes a list. The responsibilities are many bullet-like sentences; we can turn each into
- . Similarly qualifications: list of education, experience, skills etc. Benefits: list of medical, dental, vision, life insurance, AD&D, LTD and 401(k) with employer match. Pay: we have salary range; we can put in
. Schedule: we have work primarily performed during business week Monday-Friday, travel 5% or less.
We must not create sections with filler like "commensurate with experience". We have actual content.
We need to ensure we don't duplicate content. Let's extract.
Company description: "Guild Mortgage Company, closing loans and opening doors since 1960. As a mortgage banking firm we are dedicated to serving the homeowner/buyer. Our goal is to provide affordable home financing for our customers, utilizing the best terms available while providing a level of professionalism and service unsurpassed in the lending industry."
Position Summary: "The Senior Data Governance Analyst is a key technical and business position which plays an important role in the organization by performing a number of activities related to the company’s Information Technology functions. The role is primarily responsible, under limited supervision, for executing the data strategy and governance efforts within the company’s enterprise data platform by documenting and approving metadata for data & analytics, identifying Critical Data Elements (CDEs), documenting data quality rules for various business functions, and collaborating across the enterprise data team. Responsibilities include working with data stewards, owners, IT teams and business stakeholders to assess their data and analytics needs, reviewing and updating the data catalog and other supporting documentation, assessing availability and quality of data and researching internal and external data sources. This role requires strong understanding of data management principles, regulatory requirements, and industry best practices within the finance or mortgage industry."
We can combine company description and position summary under About the role.
Now Responsibilities: The "Essential Functions" list. Let's extract each sentence as a bullet.
Essential Functions list:
- Develop and implement and monitor adherence with data governance policies, standards, and procedures to ensure data quality, integrity, and security.
- Partner with key stakeholders, including the business unit leaders, Product, Data & Technology teams, to develop and implement data governance capabilities and apply data standard processes by eliciting metadata, certifying data, and researching internal systems of record and publicly available data sources and assessing their quality of data.
- Partners with Business and Technical Data Stewards to identify, define and maintain data definitions and corresponding metadata across business functions and data domains.
- Review and document translation or transformation requirements for sourced data into the data warehouse.
- Improve quality of sourced data by conducing data profiling, data quality rule creation, monitoring, root-cause analysis and remediation of data issues.
- Maintain the Data catalog with data lineage information (field definition, domain, source system, intermediary and destination system(s), translations, transformation rules, display screens, referenced reports, etc.), Data Stewards and Data Custodian info along with versioning for historic analysis and audit trail.
- Ensure consistent delivery of high-quality insights to key stakeholders by completing report certifications and validating dashboards and reports in a timely manner.
- Identify internal process improvements for automating manual data governance processes, optimizing metadata collection, re-designing data catalog infrastructure for greater scalability, etc.
- Help identify Personally Identifiable Information (PII) data in primary data sources as well as in data architecture, define masking and other data processing rules for special handling of PII data.
- Improve the quality of data used for analysis by assessing the accuracy of new data sources and the effectiveness of new data gathering techniques.
- Design and develop custom workflows using Groovy scripting to automate data governance processes.
- Design and configure metadata models that reflect the organization’s data assets and metadata asset model.
- Experience using or helping to implement MDM tools.
- Develop training materials, use case documentation, and implementation specifications.
- Define Key Performance Indicators (KPIs) and document technical processes to monitor and analyze data governance and data cataloging performance and data accuracy.
- Contribute to the team of data professionals by using expertise to answer questions and sharing templates, reusable artifacts with less experienced teammates, enhancing skillsets and competencies of team members, and sharing business domain knowledge throughout the team.
- Participate in stakeholder reviews and design sessions.
- Leads and/or supports facilitation of working groups, workshops, sessions and training to increase Data Governance Awareness and Data Literacy.
- Provide data, reports, and information to management as needed.
- Identify, track, and monitor trends and avoidable technology-related errors; work across functions to develop complex solutions, improvements, and stop-gaps.
- Focus on the continual improvement of policies, procedures, and processes falling under scope of authority.
- Use expertise to resolve high level issues that cannot be solved by teammates.
- Stay abreast of latest technology trends and participate in high-level decisions impacting the direction of Information Technology function.
- Monitor the data catalog ingestion of data assets and triage issues related to ingestion, lineage or performance.
- Drive strong communications, partnerships, and stakeholder management with senior leaders, functional managers and staff.
- Perform other duties as assigned.
We need to ensure no duplication. Some sentences start with "Partners" vs "Partner". Keep as is.
Now Qualifications: The section "Qualifications" includes:
- Bachelors Degree directly related to the position or equivalent, required in Information Management, Data Science, Computer Science, Business Analytics, or a related field.
- Masters Degree directly related to the position or equivalent, preferred in Information Management, Data Science, Computer Science, or a related field.
- A combination of education and experience may be considered in lieu of the Bachelor’s degree.
- Minimum five years experience in data governance, data management, or related roles.
- Proven experience in developing and implementing data governance frameworks, policies, and procedures.
- Must have hands-on experience working with data stewards and owners.
- Proficiency in SQL, Snowflake and Power BI. Proven experience with querying and analyzing data from SQL relational databases such as Aurora DB, IBM DB2, MemSQL, MS SQL Server, MySQL, Postgres, Snowflake, and NoSQL.
- Strong business acumen, ability to think strategically and build effective business partnerships.
- Solid understanding of data issues that impact user experience and remediations that need to be implemented to resolve data issues, via business processes and technical capabilities.
- Knowledge of Mortgage and Privacy Laws is preferred.
- Proven experience with Data Governance tools e.g. Collibra to design and build operating model, importing or exporting content, customizing dashboards & widgets, views, creating automation workflows, etc.
- Strong knowledge of data management principles, data quality, data security, and regulatory requirements.
- Workflow development and/or business process diagramming.
- Exceptional analytical and problem-solving skills with the ability to address complex data-related issues.
- Excellent communication and presentation skills, with the ability to convey data governance concepts to technical and non-technical audiences. Should be comfortable with presenting to all levels of management.
- Strong project management skills, with a proven track record of collaborating with cross-functional teams.
- Ability to work effectively in a collaborative team environment and manage multiple priorities.
- Self-starter with the ability to adapt to changing requirements and work independently.
- Strong organizational skills and attention to detail.
- Excellent verbal and written communication skills.
- Strong interpersonal and team building skills.
- Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques.
- Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required.
- Ability to prioritize multiple tasks in a deadline-driven environment, strong sense of urgency and responsiveness.
- Strong detail orientation and highly organized with proven ability to lead effectively and drive results in a matrixed management environment.
- Ability to think critically, including the ability to evaluate facts and data to draw conclusions, determine the downstream impact of decisions and associated risks.
- Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques.
- Excellent verbal and written communication skills required.
- Highly organized and detail-oriented; ability to work in a fast-paced, metrics-driven environment required.
- Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required.
- Commitment to company values.
- Customer Service - Proactive attention to each person.
- Integrity - Do and say what's right.
- Respect - Treat others with dignity.
- Collaboration - Listen and work together.
- Learning - Seek knowledge and strive for improvement.
- Excellence – Deliver the unexpected.
Note there are duplicates (proficiency in Microsoft Office appears twice). We should keep but maybe deduplicate? The instruction: preserve ALL substantive information; do NOT invent or summarize away detail. Duplicates are part of original; we could keep them but might be considered boilerplate? It's not boilerplate; it's repeated in the posting. We could keep both but it's redundant. Safer to keep as is? Might be considered duplication but not instructed to remove duplicates unless they are boilerplate/legal/EEO etc. It's not explicitly said to remove duplicate lines unless they are boilerplate/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines. It says "Remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines". So we should remove duplicated lines. So we need to deduplicate repeated lines.
Thus we need to identify duplicate lines and keep only one occurrence.
Duplicates observed:
- "Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required." appears twice.
- "Excellent verbal and written communication skills." appears twice? Actually we have "Excellent verbal and written communication skills." then later "Excellent verbal and written communication skills required." Slight variation; not exact duplicate.
- "Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques." appears twice.
- "Strong detail orientation and highly organized with proven ability to lead effectively and drive results in a matrixed management environment." appears once? Not duplicate.
- "Ability to think critically, including the ability to evaluate facts and data to draw conclusions, determine the downstream impact of decisions and associated risks." appears once.
We'll deduplicate exact duplicates.
Now Requirements section: after Qualifications there is "Supervision Job Scope:" etc. Then "Requirements
- for any list of duties/requirements/benefits, and
for prose. We need to decide what constitutes a list. The responsibilities are many bullet-like sentences; we can turn each into
- . Similarly qualifications: list of education, experience, skills etc. Benefits: list of medical, dental, vision, life insurance, AD&D, LTD and 401(k) with employer match. Pay: we have salary range; we can put in
. Schedule: we have work primarily performed during business week Monday-Friday, travel 5% or less. We must not create sections with filler like "commensurate with experience". We have actual content. We need to ensure we don't duplicate content. Let's extract. Company description: "Guild Mortgage Company, closing loans and opening doors since 1960. As a mortgage banking firm we are dedicated to serving the homeowner/buyer. Our goal is to provide affordable home financing for our customers, utilizing the best terms available while providing a level of professionalism and service unsurpassed in the lending industry." Position Summary: "The Senior Data Governance Analyst is a key technical and business position which plays an important role in the organization by performing a number of activities related to the company’s Information Technology functions. The role is primarily responsible, under limited supervision, for executing the data strategy and governance efforts within the company’s enterprise data platform by documenting and approving metadata for data & analytics, identifying Critical Data Elements (CDEs), documenting data quality rules for various business functions, and collaborating across the enterprise data team. Responsibilities include working with data stewards, owners, IT teams and business stakeholders to assess their data and analytics needs, reviewing and updating the data catalog and other supporting documentation, assessing availability and quality of data and researching internal and external data sources. This role requires strong understanding of data management principles, regulatory requirements, and industry best practices within the finance or mortgage industry." We can combine company description and position summary under About the role. Now Responsibilities: The "Essential Functions" list. Let's extract each sentence as a bullet. Essential Functions list: - Develop and implement and monitor adherence with data governance policies, standards, and procedures to ensure data quality, integrity, and security. - Partner with key stakeholders, including the business unit leaders, Product, Data & Technology teams, to develop and implement data governance capabilities and apply data standard processes by eliciting metadata, certifying data, and researching internal systems of record and publicly available data sources and assessing their quality of data. - Partners with Business and Technical Data Stewards to identify, define and maintain data definitions and corresponding metadata across business functions and data domains. - Review and document translation or transformation requirements for sourced data into the data warehouse. - Improve quality of sourced data by conducing data profiling, data quality rule creation, monitoring, root-cause analysis and remediation of data issues. - Maintain the Data catalog with data lineage information (field definition, domain, source system, intermediary and destination system(s), translations, transformation rules, display screens, referenced reports, etc.), Data Stewards and Data Custodian info along with versioning for historic analysis and audit trail. - Ensure consistent delivery of high-quality insights to key stakeholders by completing report certifications and validating dashboards and reports in a timely manner. - Identify internal process improvements for automating manual data governance processes, optimizing metadata collection, re-designing data catalog infrastructure for greater scalability, etc. - Help identify Personally Identifiable Information (PII) data in primary data sources as well as in data architecture, define masking and other data processing rules for special handling of PII data. - Improve the quality of data used for analysis by assessing the accuracy of new data sources and the effectiveness of new data gathering techniques. - Design and develop custom workflows using Groovy scripting to automate data governance processes. - Design and configure metadata models that reflect the organization’s data assets and metadata asset model. - Experience using or helping to implement MDM tools. - Develop training materials, use case documentation, and implementation specifications. - Define Key Performance Indicators (KPIs) and document technical processes to monitor and analyze data governance and data cataloging performance and data accuracy. - Contribute to the team of data professionals by using expertise to answer questions and sharing templates, reusable artifacts with less experienced teammates, enhancing skillsets and competencies of team members, and sharing business domain knowledge throughout the team. - Participate in stakeholder reviews and design sessions. - Leads and/or supports facilitation of working groups, workshops, sessions and training to increase Data Governance Awareness and Data Literacy. - Provide data, reports, and information to management as needed. - Identify, track, and monitor trends and avoidable technology-related errors; work across functions to develop complex solutions, improvements, and stop-gaps. - Focus on the continual improvement of policies, procedures, and processes falling under scope of authority. - Use expertise to resolve high level issues that cannot be solved by teammates. - Stay abreast of latest technology trends and participate in high-level decisions impacting the direction of Information Technology function. - Monitor the data catalog ingestion of data assets and triage issues related to ingestion, lineage or performance. - Drive strong communications, partnerships, and stakeholder management with senior leaders, functional managers and staff. - Perform other duties as assigned. We need to ensure no duplication. Some sentences start with "Partners" vs "Partner". Keep as is. Now Qualifications: The section "Qualifications" includes: - Bachelors Degree directly related to the position or equivalent, required in Information Management, Data Science, Computer Science, Business Analytics, or a related field. - Masters Degree directly related to the position or equivalent, preferred in Information Management, Data Science, Computer Science, or a related field. - A combination of education and experience may be considered in lieu of the Bachelor’s degree. - Minimum five years experience in data governance, data management, or related roles. - Proven experience in developing and implementing data governance frameworks, policies, and procedures. - Must have hands-on experience working with data stewards and owners. - Proficiency in SQL, Snowflake and Power BI. Proven experience with querying and analyzing data from SQL relational databases such as Aurora DB, IBM DB2, MemSQL, MS SQL Server, MySQL, Postgres, Snowflake, and NoSQL. - Strong business acumen, ability to think strategically and build effective business partnerships. - Solid understanding of data issues that impact user experience and remediations that need to be implemented to resolve data issues, via business processes and technical capabilities. - Knowledge of Mortgage and Privacy Laws is preferred. - Proven experience with Data Governance tools e.g. Collibra to design and build operating model, importing or exporting content, customizing dashboards & widgets, views, creating automation workflows, etc. - Strong knowledge of data management principles, data quality, data security, and regulatory requirements. - Workflow development and/or business process diagramming. - Exceptional analytical and problem-solving skills with the ability to address complex data-related issues. - Excellent communication and presentation skills, with the ability to convey data governance concepts to technical and non-technical audiences. Should be comfortable with presenting to all levels of management. - Strong project management skills, with a proven track record of collaborating with cross-functional teams. - Ability to work effectively in a collaborative team environment and manage multiple priorities. - Self-starter with the ability to adapt to changing requirements and work independently. - Strong organizational skills and attention to detail. - Excellent verbal and written communication skills. - Strong interpersonal and team building skills. - Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques. - Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required. - Ability to prioritize multiple tasks in a deadline-driven environment, strong sense of urgency and responsiveness. - Strong detail orientation and highly organized with proven ability to lead effectively and drive results in a matrixed management environment. - Ability to think critically, including the ability to evaluate facts and data to draw conclusions, determine the downstream impact of decisions and associated risks. - Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques. - Excellent verbal and written communication skills required. - Highly organized and detail-oriented; ability to work in a fast-paced, metrics-driven environment required. - Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required. - Commitment to company values. - Customer Service - Proactive attention to each person. - Integrity - Do and say what's right. - Respect - Treat others with dignity. - Collaboration - Listen and work together. - Learning - Seek knowledge and strive for improvement. - Excellence – Deliver the unexpected. Note there are duplicates (proficiency in Microsoft Office appears twice). We should keep but maybe deduplicate? The instruction: preserve ALL substantive information; do NOT invent or summarize away detail. Duplicates are part of original; we could keep them but might be considered boilerplate? It's not boilerplate; it's repeated in the posting. We could keep both but it's redundant. Safer to keep as is? Might be considered duplication but not instructed to remove duplicates unless they are boilerplate/legal/EEO etc. It's not explicitly said to remove duplicate lines unless they are boilerplate/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines. It says "Remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines". So we should remove duplicated lines. So we need to deduplicate repeated lines. Thus we need to identify duplicate lines and keep only one occurrence. Duplicates observed: - "Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required." appears twice. - "Excellent verbal and written communication skills." appears twice? Actually we have "Excellent verbal and written communication skills." then later "Excellent verbal and written communication skills required." Slight variation; not exact duplicate. - "Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques." appears twice. - "Strong detail orientation and highly organized with proven ability to lead effectively and drive results in a matrixed management environment." appears once? Not duplicate. - "Ability to think critically, including the ability to evaluate facts and data to draw conclusions, determine the downstream impact of decisions and associated risks." appears once. We'll deduplicate exact duplicates. Now Requirements section: after Qualifications there is "Supervision Job Scope:" etc. Then "Requirements