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.
Compensation
This role is an exempt position with a targeted salary range of $109,114 to $156,510 annually.
Compensation at Guild is influenced by a wide array of factors including but not limited to local and federal minimum wage requirements, education, level of experience, and applicant’s geographical location.
Essential Functions
- 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.
Qualifications
- 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.
Supervision
Job Scope: Plays a key role in area by generating insights and ideas on policies, processes, procedures, and efficiency; contributes ideas to strategic and operational plans to ensure alignment.
Complexity: Problems encountered are often complex and may involve significant resource coordination and availability, evaluating and resolving discrepancies with data, analyses, processes, etc. using own expertise and judgment.
Impact: Decisions and actions have a direct impact on the outcomes of the department, projects, and programs.
Interaction/Supervision: Acts as a mentor/guide to less experienced professional contributor staff in a similar role; works independently and only under general direction; guided by professional standards, desired outcomes, and project plan specifications.
Requirements
- Work is primarily sedentary; mobility in an office setting.
- Ability to operate standard office equipment and keyboards.
- Regularly required to accurately perceive, distinguish and interpret information received visually and through audio; e.g., words, numbers and other data broadcasted aloud/viewed on a screen, as well as print and other media.
- Office environment – moderate noise, no substantial exposure to adverse environmental conditions.
- Travel 5% or less.
- Learn new tasks, remember processes, maintain focus, complete tasks independently, and make timely decisions in the context of a workflow.
- Work is primarily performed during the business week, Monday - Friday.
Guild offers a pleasant work environment, competitive compensation and excellent benefits package; including medical, dental, vision, life insurance, AD&D, LTD and 401(k) with employer match.
Guild Mortgage Company is an Equal Opportunity Employer.
REQ#: SENIO018528
Bachelor's degree in Information Management, Data Science, Computer Science, Business Analytics or related field; 5+ years data governance experience; SQL, Snowflake, Power BI, Collibra; Microsoft Office; travel 5% or less.
Key Responsibilities
- developing data policies
- managing metadata
- improving data quality
Skills & Tools
SQL, Snowflake, Power BI, Aurora DB, IBM DB2, MemSQL, MS SQL Server, MySQL, Postgres, NoSQL, Collibra, Microsoft Office, Microsoft Word, Microsoft Excel, Wiki
Job Details
- Category: Data and Analytics
- Seniority: Senior Level
- Commitment: Full Time
- Workplace: Remote — United States
- Salary: USD 109,114 – 156,510 / year
- Languages: English
Benefits
- 401k matching
- Retirement plan
About Guild Mortgage Company
A mortgage banking firm dedicated to providing affordable home financing and excellent service since 1960. — Industry: Finance