Analytics Engineer

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 32 states: AZ, CA, CO, CT, FL, GA, ID, IL, IN, KS, MA, MD, ME, MI, MN, MO, NC, NH, NJ, NV, NY, OH, OK, 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. Responsibilities Develop, maintain, and deeply understand core data models and curated datasets that support reporting, AI, and advanced analytics use cases, effectively communicating their structure and purpose to enable broad access to trusted data. Develop a deep understanding of business and operational needs by building strong relationships across the teams who manage and use Guild’s data. Perform in-depth data QA by diving into various data sources to identify and resolve issues. Efficiently execute on assigned projects and requests from business partners, proactively communicating progress, timelines, and any challenges to manage stakeholder expectations for delivery. Translate business questions into technical requirements as part of a well‑defined development cycle. Act as subject matter expert for Looker/Omni infrastructure and content, supporting team members in troubleshooting issues that arise. Implement and maintain robust governance and oversight processes to ensure accuracy and continuity of critical data sources and reporting. Experience 3+ years of full‑time work experience as an analytics engineer, data analyst, BI analyst, data engineer or similar. Experience designing, developing, and maintaining core data models that support a range of downstream use cases, including reporting, self‑service analytics, and AI/ML applications. Hands‑on experience with modern data transformation frameworks (e.g., dbt or similar tools), including building scalable models, managing dependencies, and scheduling reliable data pipelines. Strong understanding of data modeling best practices and modeling layers (e.g., staging, intermediate, marts), with a focus on maintainability, performance, and long‑term extensibility of the analytics layer. Hands‑on experience with data model development and reporting in data visualization tools such as Looker, Omni or Tableau. Additional Information Highly skilled in SQL, and some experience in a scripting language (e.g., Python, R). Demonstrated attention to detail and commitment to data quality and reporting accuracy. Analytical, intellectually curious, creative problem‑solver who is comfortable going beyond data access to analytics and strategic insights. Keen design and data visualization skills – you know how to transform data to generate useful insights and be easily digestible. In‑depth understanding and application of Data Engineering standard processes. Teammate approach, with strong interpersonal and influencing skills. Passion for our mission – Guild is pioneering a new path for career development as a benefit in a complicated and regulated space – success means quickly and effectively adapting your expertise. We are committed to equal pay for equal work and believe in compensation transparency. All salary ranges are standardized nationwide and will not vary by region. This role offers a competitive total compensation package, including a base salary of $110,000 - $159,000 and stock options. Compensation offered will be based on a combination of factors such as experience, competencies, and internal equity. Posting Date : 6/3/2026 *This role will stay open for a minimum of 3 days. Benefits We currently offer the following benefits: Access to low‑cost, high‑quality health care options through Collective Health and Kaiser (due to coverage limitations, Kaiser is currently only available in CA & CO) Access to a 401k to help save for the future Vacation policy 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; 2‑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 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. #J-18808-Ljbffr