• Design and build the data pipelines and transformation models that move raw data from source systems into a centralized data warehouse. • Drive the creation of a canonical employee record with a stable, consistent identifier that survives job changes, rehires, and system migrations. • Own the semantic layer for people metrics: define, document, and maintain agreed-upon definitions for core measures so that HR, Finance, and leadership are always working from the same numbers. • Bridge the gap between raw sources and business value. Ensure that data models are not just technically sound, but are purposefully built to answer the specific strategic questions for Wealthsimple. • Build slowly-changing dimension patterns and dated workforce snapshots that enable accurate point-in-time analysis. • Establish data governance practices that belong in a people analytics function. • Partner with HR business partners, Finance, and People Operations leaders to translate business questions into well-structured data models and durable analytical solutions. • Use AI tools to accelerate your work, drafting pipeline code, generating documentation, stress-testing metric logic, and turning technical findings into clear communication for non-technical partners.

Role Description We are seeking an innovative Senior Data Engineer to join our Startup AI and Data Analytics Business Unit. This role is a critical bridge, connecting technical engineering with business strategy. Beyond just managing tickets or building pipelines, you will take full ownership of the data ecosystem. You will play a pivotal role in supporting our AI/ML initiatives, managing the modern data stack while simultaneously answering critical business questions to ensure data accessibility, reliability, and scalability. WHAT YOU'LL DO: - Ecosystem Ownership & Strategy - Own the Data Ecosystem: Build and maintain robust data pipelines and ETL processes, taking full responsibility for the health, cost, and observability of the stack to prevent downtime before it impacts stakeholders. - Business-First Data Modeling: Design and manage data warehouses to support advanced analytics, focusing on creating "Gold Standard" data models that make self-service easy in platforms like PowerBI, Tableau, and Sigma. - Documentation & Governance: Maintain comprehensive documentation of all data engineering processes to enable stakeholder self-service, following the industry’s best practices. - Engineering & Execution - Infrastructure Development: Design and manage data lakes, warehouses, and databases to support advanced analytics and AI workflows. - Performance Tuning: Act as a SQL/Python expert to optimize data pipelines and troubleshoot issues proactively, ensuring queries are efficient and scalable. - Data Quality Management: Implement frameworks that ensure data reliability across the organization, ensuring smooth integrations across systems. WHO YOU MIGHT BE: - The Product-Minded Engineer: You are a Senior Data Engineer who is tired of just "taking tickets." You want to understand the business strategy behind the data and take ownership of the full lifecycle. - The Analytics Architect: You have a background in BI or Analytics but have grown into a "Ninja-level" technical expert in SQL and Python. You build pipelines not just to move data, but to answer questions. - The Startup Builder: You have worked in small teams driving innovative solutions and are comfortable wearing multiple hats—from architecting infrastructure to troubleshooting a dashboard. Analytics Translation & Collaboration - Bridge the Gap: Collaborate with cross-functional product, engineering teams, and customers to translate vague business goals into precise technical requirements. - Support AI/ML: Create models that specifically enhance Analytics and AI/ML projects. Qualifications - 5+ years of experience in data engineering roles, including taking ownership of pipelines and optimizing infrastructure. - Technical "Ninja" Skills: Ninja-level proficiency in SQL (specifically CTE optimization) and Python (complex scripting and ML/AI). - Pipeline Architecture: Expertise in architecting data pipelines and ETL processes, with tools like Fivetran, Snowflake, and DBT. - Business Intuition: Proven ability to apply business intuition, leveraging analytical skills to present complex data insights and actionable recommendations to technical and non-technical stakeholders. - Visualization Proficiency: Experience building visual data analytic business-driven solutions using tools like PowerBI, Sigma, or similar analytic tools. - Masters degree in engineering or analytics. Requirements - Cloud & Big Data: Familiarity with cloud platforms like AWS and experience with big data technologies such as Snowflake. - Leadership: Proven experience in leading data engineering projects and integrating data from multiple sources. - Small Team Experience: You have worked in small teams driving innovative solutions and thrive in agile environments. Benefits - $130,000 - $175,000 a year. - Robust benefits package, including health and dental and 401k with company match. - Flexible Time Off policy or generous PTO plan (role dependent) and paid holidays. - Up to 4 weeks paid bonding leave. - Tuition reimbursement. - Robust Employee Assistance Program through TotalCare offering free counseling 24/7/365, plus financial counseling, legal guidance, adoption assistance services and much more! - 24/7 access to virtual medical care with Teladoc. - Quarterly awards based on peer nominations. - Regional discounts and perks. - Opportunities to participate in charitable events and give back to the community.

Role Description The Principal, Pricing and Analytics provides oversight for pharmacy network activities, focusing on the alignment of pharmacy and client network strategies. This role is responsible for the integrity of financial true-ups, advanced analytics, and high-level reporting to drive organizational revenue and cost savings. The Principal manages relationships with internal and external stakeholders and oversees the analysis of large-scale claim data to optimize pricing configurations and ensure all contractual guarantees are met. Essential Duties and Responsibilities - Orchestrates pharmacy network strategies to fulfill corporate initiatives, support product offerings, and grow revenue streams through complex data analytics using a deep understanding of PBM industry, technical skills, and team collaboration. - Governs all pharmacy network activities, including the execution of pharmacy and client true-ups, analytics, and performance reporting. - Directs comprehensive analyses to identify enhanced revenue opportunities through strategic network configurations and monthly client performance evaluations. - Translates complex pharmacy transaction data into actionable insights to ensure all pharmacy and client contract guarantees are met. - Leads the development of automated reporting tools to streamline the reconciliation of pricing data and enhance departmental efficiency. - Monitors and calibrates performance for all clients, adjusting pricing structures to maximize revenue while maintaining market competitiveness. - Spearheads the implementation of strategic pricing initiatives in collaboration with cross-functional teams. - Manages the rigorous tracking and monitoring of pricing benchmarks to ensure consistent alignment with contractual obligations. - Provides expert guidance on network performance and pricing trends to internal stakeholders and senior management. - Engineers advanced analytical models to forecast the financial impact of proposed network changes or pricing adjustments. Qualifications - BA/BS Degree; 10+ years related experience and 8+ years of SME in respective area(s); (or equivalent combination of education and experience). - Advanced SQL knowledge, Expert Microsoft Excel, and Golden (SQL query tool). - Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form. - Ability to apply principles of logical or scientific thinking to a wide range of intellectual and practical problems. - Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. - Ability to write reports, business correspondence, and procedure manuals. Requirements - Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations. - Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume. - Ability to apply concepts of basic algebra and geometry. Benefits - Medical / Dental / Vision / Wellness Programs - Paid Time Off / Company Paid Holidays - Incentive Compensation - 401K with Company match - Life and Disability Insurance - Tuition Reimbursement - Employee Referral Bonus Company Description MedImpact, is a privately-held pharmacy benefit manager (PBM) headquartered in San Diego, California. Our solutions and services positively influence healthcare outcomes and expenditures, improving the position of our clients in the market. MedImpact offers high-value solutions to payers, providers and consumers of healthcare in the U.S. and foreign markets.

• Mentor and support data analysts, data engineers and developers, fostering a collaborative and psychologically safe environment. • Set high standards for technical excellence in SQL, dbt modeling, and LookML architecture. • Collaborate with other analytics engineers on the migration of legacy logic from Redshift/Postgres into performant Databricks silver and gold layers. • Independently implement complex data models in dbt, demonstrating expertise in modularity, testing, and performance optimization on Spark. • Own the LookML layer, ensuring our explores and dashboards are performant, intuitive, and accurate. • Act as a "Hybrid Analyst," comfortably balancing long-term engineering projects with ad-hoc requests to support the business. • Translate stakeholder questions into Looker-based reports and visualizations, ensuring the business has the right insights at the right time. • Lead technical data planning through discovery, design, and release, ensuring clear documentation for data catalogs and version tracking. • Identify opportunities for "data debt" reduction and architectural improvements in our Lakehouse and semantic layers. • Proactively address system characteristics like latency and throughput, ensuring our data pipelines are optimized for cost and speed. • Act as a subject matter expert in your data domain, contributing to business strategy to ensure we are measuring what matters. • Provide engineering perspectives on the product roadmap, clearly communicating data feasibility and reporting limitations.