• Lead the end‑to‑end SA‑CCR architecture, defining the framework for RC, PFE and EAD calculations, including netting sets, supervisory factors and collateral/CSA logic • Design a modern Databricks architecture using Delta Lake, Unity Catalog and Spark/PySpark to support versioned, reproducible and regulator‑defensible exposure calculations • Develop high‑performance compute pipelines that support intraday recalculation, scenario testing and rapid exposure analytics across complex derivatives portfolios • Establish strong governance and auditability, embedding lineage, versioning, entitlements, and evidence‑ready data flows throughout the architecture • Architect an AI‑ready platform, enabling explainable, controlled and reproducible AI‑assisted recalculation and optimisation, without compromising regulatory expectations • Collaborate with stakeholders across Risk, Quants, Technology, Capital/Treasury, Security and Front Office to align architecture with regulatory, operational and strategic requirements • Own architectural deliverables, including target state blueprints, integration patterns, data contracts, governance standards and audit artefacts • Support programme milestones, including parallel run, validation, remediation and optimisation, delivering architectural leadership with minimal onboarding.

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. If you are an Internal Candidate, please apply via our Internal Job Board. ---- To thrive as a company and meet our impact goals, we must cultivate a culture of high-performance. We know managers are often the single-largest driver of employee satisfaction and growth, and our talent is our biggest asset. Because of that, we’ve identified consistent expectations for all of Guild’s people managers — helping you know what to expect from your experience here. ---- Senior Data & AI Platforms Engineer The Opportunity Guild is looking for a Senior Data & AI Platforms Engineer to join a small, high-performing team building the backbone of our data ecosystem. In this role, you will design, build, and scale the data infrastructure that powers analytics, operational insights, and product innovation across Guild. This is a high-impact, end-to-end ownership role for someone who brings a platform mindset and wants to shape how data drives decisions across the organization. Here are the outcomes you will be expected to achieve: - Build and maintain reliable, scalable data pipelines that deliver trusted data to analysts, stakeholders, and product teams on time and without manual intervention. - Deliver accurate, well-modeled data marts and models that directly enable self-serve analytics and confident business decision-making. - Expand the data platform's scope to support production engineering use cases from the warehouse, establishing patterns and prototypes that the broader organization can adopt. Here's what you will do in this role to achieve these outcomes: - Architect, develop, and maintain data pipelines using Fivetran, dbt, S3, Glue, orchestrators, and custom Python jobs to keep data flowing reliably across the organization. - Manage and optimize data models in dbt, ensuring they are scalable, accurate, and aligned to business use cases. - Integrate and transform data from sources including AuroraDB, Snowflake, Postgres, MySQL, and DynamoDB. - Collaborate with analytics and commercial teams to design models and marts in visualization tools that empower decision-making. - Uphold data quality through testing, validation, and observability best practices. - Provide enterprise-wide guidance and prototyping on key data initiatives, especially as the platform expands to support production engineering from the warehouse. - Mentor and upskill team members while contributing to evolving data engineering standards and processes. You are probably a strong candidate for this role if you've accomplished: - Built and maintained production-grade data pipelines using tools like Snowflake, dbt, and Fivetran in a fast-paced, high-growth environment. - Designed scalable data models and warehousing solutions that connected technical infrastructure with commercial or product outcomes. - Worked cross-functionally with analytics, product, or business teams to translate data needs into reliable, self-serve solutions. - Navigated complex source systems (relational databases, NoSQL, APIs) and built integrations that handled messy, real-world data at scale. Here are the skills/competencies you have that will be needed to achieve the expected outcomes: - Expert-level SQL (window functions, CTEs, performance tuning) and Python (data pipelines, API integrations, automation). - Hands-on experience with Snowflake, dbt, and Fivetran, plus comfort navigating Unix systems, Terraform, and Git. - Deep familiarity with relational databases (Postgres, MySQL, AuroraDB) and NoSQL systems such as DynamoDB. - Strong understanding of data modeling, warehousing best practices, and ETL/ELT frameworks. - Experience with CDC (Change Data Capture) patterns, data governance, or CI/CD practices in a data engineering context. - Proven ability to work cross-functionally and connect technical design with commercial objectives. 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 $180,000 - $230,000 and stock options. Compensation offered will be based on a combination of factors such as experience, competencies, and internal equity. Posting Date: 4/9/26 This role will be open for a minimum of 3 days. Guild partners with the country’s most innovative employers, including Chipotle, Target, Walgreens, JPMorgan Chase, Hilton, Spectrum, PepsiCo, Tyson, and more, to build the talent needed for today and a resilient workforce for tomorrow. Guild helps employers identify, develop, and mobilize internal talent, enabling workers to gain skills for in-demand roles and companies to stay agile. By connecting employees to real-world learning, coaching, and career support, and providing companies with actionable talent insights, Guild transforms all talent into high-impact contributors and positions companies for long-term, sustainable growth. For more information, visit https://www.guild.com. Guild is a female-founded, certified B Corp. The company has been recognized by Fortune’s Change the World list (2021, 2025), the Forbes Cloud 100 (2020–2025), Great Place to Work (2022–2025), CNBC’s Disruptor 50 (2021–2024), TIME’s 100 Most Influential Companies (2022), Inc.’s Best-Led Companies (2021), Fast Company’s World Changing Ideas (2020), and B Lab’s Best for the World (2019), 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 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; 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 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 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. I understand and agree to Guild's use of my information in accordance with Guild's Privacy Policy and, for applicants that are residents of the State of California, Guild's Applicant Privacy Notice and California Notice at Collection.

About Fasken As a premier law firm with over 900 lawyers worldwide, Fasken is where excellence meets expertise. We are dedicated to shaping the future our clients want, precisely when it matters most. For more information, visit fasken.com. Your Role Fasken is seeking a Data Engineer to join its growing Data Analytics & Engineering team. This role is ideal for a professional who is hands-on, detail-oriented, and passionate about building reliable, well-governed, and scalable data platforms. You will be responsible for designing, building, and maintaining data warehouses and lakehouses in Microsoft Fabric, developing robust data pipelines, ensuring ongoing data integrity, and supporting analytics and governance initiatives across the firm. This role requires strong collaboration skills, a governance-first mindset, and the ability to clearly communicate complex data issues to both technical and non-technical audiences. Primary Responsibilities Data Engineering & Platform Development - Design, build, and maintain data warehouses and data lakehouses in Microsoft Fabric - Develop and support ETL/ELT pipelines, dataflows, and data ingestion processes - Use notebooks (Python, SQL) to transform, validate, and move data across platforms - Build and maintain semantic models to support analytics and reporting - Ensure data integrity, accuracy, and consistency throughout all transformations Monitoring, Reliability & Optimization - Monitor daily data loads to ensure completeness, freshness, and integrity - Maintain and follow a regular operational checklist to monitor data infrastructure health - Build Power BI dashboards, reports and alerts to monitor data movement, quality, and system performance - Monitor and optimize data platform compute usage to ensure efficient performance and cost control - Troubleshoot and resolve data-related issues and business tickets in a timely manner Governance, Security & Compliance - Act as a champion and ambassador for data governance, compliance, and ethical data usage - Adhere to strict requirements such as ethical walls, access segregation, and confidentiality controls - Participate in and lead data governance initiatives, including: - Defining and standardizing data fields - Data clean-up and quality improvement efforts - Set up and maintain secure access to data resources, leveraging Microsoft Entra ID groups and role-based access control - Perform regular production system closing procedures on month end and year end. Collaboration & Communication - Collaborate closely with: - Data analysts and senior analysts - Data governance leadership - Technology teams and business stakeholders - Translate data issues and limitations into clear, business-friendly language - Support ad hoc reporting and data requests from the business - Partner with stakeholders to identify pragmatic, compliant, and scalable data solutions - Document and or update processes and Standard Operating Procedures (SOP) Engineering Practices - Experience using GitHub and DevOps practices for version control, collaboration, and deployments - Leverage Copilot and modern tooling to optimize Python and SQL code - Contribute to improving standards, documentation, and repeatable patterns across the data platform What Success Looks Like Within this role, success is measured by: - High integrity and trustworthiness of data - Reliable and stable data pipelines and platforms - Consistent and optimal time-to-delivery for data and analytics solutions - Strong adherence to governance, security, and ethical data standards - Positive feedback from business and technology partners Required Knowledge and Experience - Bachelor’s degree in math, economics, statistics, engineering, computer science, or other quantitative field, or equivalent level of experience - 4+ years of experience in data engineering or a closely related role - Strong experience with Microsoft Azure–based data platforms, including: - - Azure services, Microsoft Fabric, SQL Server - Other equivalent platforms are also considered: AWS, Snowflake - Proficiency in SQL and Python for data transformation and pipeline development - Experience building and maintaining: - - Data warehouses and/or lakehouses - Data pipelines and dataflows - Familiarity with Power BI and semantic modeling (sufficient to build and support functional reports) - Experience working with data governance, access control, and compliance requirements - Strong troubleshooting, communication, and collaboration skills - Microsoft Certification required (or candidate to obtain Certification within the first year) - Knowledge of the Elite 3E ERP is an asset - Strong analytical and problem-solving skills; - Ability to work in a Remote-first environment, where internal clients may be located in various geographical locations and timezones. - Excellent planning and organizational skills, ability to manage multiple files simultaneously and meet established deadlines; - Professionalism, discretion and commitment to outstanding customer service; - Autonomy and ability to deal with multiple stakeholders; - Organizational skills, thoroughness and ability to manage priorities; Pay Range $90,000 to $110,000 per annum. Pay range to be commensurate with experience. Vacancy This role is being posted to fill a current vacancy.

• Help with optimization, support and deployment of cloud-based data systems • Build secure, scalable, and compliant database solutions using Azure SQL Server and other cloud-native technologies • Support the evolution of analytics lakehouse and all of its data sources • Ensure compliance with Equal Employment Opportunity laws, HIPAA, ERISA and other regulations