Job details

Sr. Data Quality Analyst (Remote)

United States

At Guild, we believe talent is everywhere and that opportunity should be too. We continue to have our home and headquarters in Denver, but we have embraced a distributed model of working to reach the best talent in the United States. While some roles may require proximity to our Denver office, roles based outside of our Denver office can sit in any of the following 30 states: AZ, CA, CO, CT, FL, GA, ID, IL, KS, MA, MD, ME, MI, MN, MO, NC, NH, NJ, NV, NY, OH, OR, PA, SC, TN, TX, UT, VA, WA, WI and Washington D.C. Please only apply if you are able to live and work full-time in one of the states listed above. State locations and specifics are subject to change as our hiring requirements shift.

----

If you are an Internal Candidate, please apply via our Internal Job Board.

----

At Guild, we uphold our Core Values in everything we do. Our team emphasizes our Core Values in the following ways:

Nurture A Learner’s Mindset - using a combination of feedback and reflection to gain productive insight into personal strengths and development areas
Build Shared Success - building partnerships and working collaboratively with others to meet shared objectives
Be an Owner - holding self and others accountable to meet commitments
Create Belonging - recognizing the value that different perspectives and cultures bring to our company

Guild is hiring a Senior Data Quality Analyst. This role will play a critical role in ensuring the accuracy and reliability of our data assets. The ideal candidate will have a deep understanding of data quality concepts and experience working with large, complex data sets and also set up and perform automated testing of our data products. In addition to your technical expertise in SQL, Looker, and programming languages like Python, you will be responsible for setting up and guiding Data Quality Analysts on QA best practices, and collaborating with cross-functional teams to improve data quality across the organization.

As Sr. Data Quality Analyst, you will:

Develop and implement comprehensive data quality assurance processes and strategies.
Own the planning, design, and execution of data quality tests and validation procedures.
Build test cases, scripts, and scenarios to assess data accuracy and integrity.
Write sophisticated SQL queries to identify and resolve data discrepancies.
Perform data testing on DWH and Data Vault to ensure data accuracy, completion and validation of business rules.
Perform data quality assessments and root cause analysis for identified issues.
Present complex issues in an easy to understand way to stakeholders
Collaborate with data engineering and product teams to identify data quality issues and recommend solutions.
Collaborate with multi-functional teams to resolve data quality issues promptly.
Lead by example in promoting a culture of data quality excellence and implement process improvements to enhance data quality standards.
Create and maintain data quality dashboards and reports using Looker to visualize data quality trends and issues.
Find opportunities for process improvement and automation to enhance data quality and efficiency.
Mentor and provide guidance to Data Quality Analysts, including helping define and drive QA standard processes and reviewing their testing deliverables.

You are a Strong fit for this role if you have:

Required Competencies

5+ years experience in conducting comprehensive backend and ETL testing to ensure the accuracy and integrity of data throughout the processing pipeline.
Ability to design and implement test plans, test cases, and test scripts to validate data transformations and migrations.
Experience in working with large datasets, understanding complex data structures, and identifying data quality issues.
Strong SQL skills with the ability to write sophisticated queries and proficiency in tools like Snowflake, Mode Analytics etc.
Exceptional analytical and problem-solving skills, with a keen eye for detail.
Ability to analyze data trends, identify patterns, and proactively address potential data quality issues.
Proficient in documenting data quality issues, testing processes, and results in a clear and concise manner.
Ability to create and maintain documentation related to data quality standards, best practices, and guidelines.
Experience working in Jira, setting up best practices for the team for efficient management and tracking of data issues.
Proficiency in using data visualization tools, with a strong emphasis on Looker for creating and maintaining data models and reports.
Experience in working with large datasets, understanding complex data structures, and identifying data quality issues.
Hands-on experience with data transformation tools, specifically DBT, for effective modeling and structuring of data.

Preferred Competencies

Familiarity with data governance principles and the ability to contribute to the establishment and enforcement of data quality standards.
Python scripting for data manipulation, automation as needed.
Knowledge of data observability and continuous monitoring principles is a plus.

We feel passionately about equal pay for equal work, and transparency in compensation is one vehicle to achieve that. Total compensation for this role is market competitive, including a base salary range of $100,000 - $137,500, as well as company stock options. We are committed to providing opportunities that align with our larger company strategy of Career Mobility. We believe that skills are transferable and value candidates that have a passion for our mission and a learner’s mindset. If you don’t have 100% of the qualifications but can see yourself doing a great job, we invite you to apply.

#LI-AB1

At Guild, we unlock the talent and economic potential of America’s workforce for employees and their companies. We partner with the nation’s largest employers—including Walmart, Chipotle, Discover, Hilton, Macy’s, Target, and The Walt Disney Company—to create cultures of opportunity that help them attract and retain top talent, while building the workforce of the future from within. By using our proprietary Career Opportunity Platform to develop education and learning programs that work in the real-world, thousands of employees at those companies have gained the skills, knowledge, and guidance they need to build a brighter future for themselves and their families—all without paying for tuition or career services on their own.

Guild is female-founded and a certified B Corp. The company has been named to the TIME100 Most Influential Companies of 2022 list, CNBC Disruptor50 list three years in a row, Inc. Best Led Companies list, Fast Co. World Changing Ideas list and the B Lab Best for the World list among many others.

Guild is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. If you have a disability or special need that requires accommodation, please let your recruiter know. We currently offer the following benefits:

Access to low-cost, high-quality health care options through Cigna and Kaiser (due to coverage limitations, Kaiser is currently only available in CA & CO)
Access to a 401k to help save for the future
Open vacation policy for employees to rest and recharge
8 days of fully-paid sick leave, to take the time to heal and or recover
Family-friendly benefits, including 12 weeks of parental leave for non-birthing parents and 18-20 weeks for birthing parents; 4-week ramp-up period for when employees return from a leave of 6 weeks or more; as well as employer-paid short-term and long-term disability, employer-sponsored life insurance, fertility and caregiving benefits.
Well-rounded wellness benefits including free and low cost mental health resources and financial wellbeing support services
Education benefits and tuition assistance to help your future development and growth

PRIVACY NOTICE

I understand that I am applying for employment with Guild Education and am being asked to provide information in connection with my application. I further understand that Guild gathers this information through a third-party service provider and that Guild may also use other service providers to assist in the application process. Guild may share my information with such third-party service providers in connection with my application and for the start of employment. Guild will treat my information in accordance with Guild’s Privacy Policy.