Application Support Analyst Amazing Opportunity and Great Place to Work! Are you a fast learner who is fascinated by technology? Our Story At Alight, we believe a company’s success starts with its people. At our core, we Champion People, help our colleagues Grow with Purpose and true to our name we encourage colleagues to “Be Alight.” Our Values Champion People – be empathetic and help create a place where everyone belongs. Grow with purpose – be inspired by our higher calling of improving lives. Be Alight – act with integrity, be real and empower others. It’s why we’re so driven to connect passion with purpose. Alight helps clients gain a benefits advantage while building a healthy and financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, absence management and navigation. With a comprehensive total rewards package, continuing education and training, and tremendous potential with a growing global organization, Alight is the perfect place to put your passion to work. Join our team if you Champion People, want to Grow with Purpose through acting with integrity and if you embody the meaning of Be Alight. Learn more at careers.alight.com. “This role supports services provided to the federal government or federal government contractor and therefore requires US Citizenship. Proof of citizenship status will be required at time of hire.” About the Role Alight is looking for an ETL/Informatica Application Support Engineer with strong analytical skills, excellent troubleshooting abilities, and a proactive approach. The ideal candidate will drive stability and continuous improvement in production environments, working independently in a fast-paced setting while delivering high-quality support within the Applications Support team. The IT Support Engineer is part of a team responsible for 24X7 customer support for Alight’s proprietary Leave of Absence Management software platforms, including troubleshooting and resolving incoming issues upon first contact within the team whenever possible; documenting tickets with triage information before escalating to next tier; providing ongoing support until issues are resolved. Responsibilities - Monitor, support, and troubleshoot ETL and data integration workflows across production, QA, and development environments to ensure smooth daily operations. - Analyse and resolve incidents, job failures, and performance issues related to Informatica workflows, mappings, and SQL jobs. - Own and maintain ETL components including Informatica mappings, metadata, scripts, schedules, and operational procedures. Identify opportunities to optimize performance, scalability, and reliability of existing jobs/processes. - Ensure stability of data ingestion pipelines spanning batch, nearrealtime, and realtime patterns. Finetune ETL solutions by developing a deep technical understanding of data flows and upstream/downstream dependencies. - Collaborate with DBAs and Data Architects to implement appropriate data partitioning, indexing, and optimization strategies to enhance job performance. - Develop or modify SQL scripts, stored procedures, database triggers, and queries as part of incident resolution, change requests, or performance tuning. Work closely with cross functional and offshore teams, ensuring timely resolution of issues, clear communication, and adherence to support SLAs and operational guidelines. - Manage multiple concurrent support tickets, change requests, and enhancement tasks, balancing priorities based on business impact and urgency. - Ensure compliance with published support, development, coding, and testing standards, as well as change management practices. Requirements - 3-5 years of experience in ETL application support, Informatica PowerCenter/Cloud, and SQL Server in production environments. - Practical experience with SQL Server, including schema understanding, stored procedure development, query tuning, and optimization. - Handson experience with job scheduling tools such as ControlM or AutoSys for monitoring and support automation. - Excellent communication skills and ability to work both independently and as part of a distributed global team. - Strong analytical thinkers with the ability to troubleshoot complex data and integration issues effectively. - Flexible, adaptable, and pragmatic, with the ability to remain focused on objectives while handling shifting priorities. Flexible Working So that you can be your best at work and home, we consider flexible working arrangements wherever possible. Alight has been a leader in the flexible workspace and “Top 100 Company for Remote Jobs” 5 years in a row. Benefits We offer programs and plans for a healthy mind, body, wallet and life because it’s important our benefits care for the whole person. Options include a variety of health coverage options, wellbeing and support programs, retirement, vacation and sick leave, maternity, paternity & adoption leave, continuing education and training as well as a number of voluntary benefit options. By applying for a position with Alight, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Alight’s employment policies. Background checks may include some or all the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position. Our commitment to Inclusion We celebrate differences and believe in fostering an environment where everyone feels valued, respected, and supported. We know that diverse teams are stronger, more innovative, and more successful. At Alight, we welcome and embrace all individuals, regardless of their background, and are dedicated to creating a culture that enables every employee to thrive. Join us in building a brighter, more inclusive future. As part of this commitment, Alight will ensure that people with disabilities are provided with reasonable accommodations for the hiring process. If reasonable accommodation is needed, please contact alightcareers@alight.com. Equal Opportunity Policy Statement Alight is an Equal Employment Opportunity employer and does not discriminate against anyone based on sex, race, color, religion, creed, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, marital or domestic partner status, citizenship, military or veteran status, sexual orientation, gender, gender identity or expression, genetic information, or any other legally protected characteristics or conduct covered by federal, state or local law. In addition, we take affirmative action to employ disabled persons, disabled veterans and other covered veterans. Alight provides reasonable accommodation to the known limitations of otherwise qualified employees and applicants for employment with disabilities and sincerely held religious beliefs, practices and observances, unless doing so would result in undue hardship. Applicants for employment may request reasonable accommodation/modification by contacting their recruiter. Authorization to work in the Employing Country Applicants for employment in the country in which they are applying (Employing Country) must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the Employing Country and with Alight. Note, this job description does not restrict management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units. P&T 2026 #LI-Remote We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization. Salary Pay Range Minimum : 110,000.00 USDMaximum : 130,000.00 USD Pay Transparency Statement: Alight considers a variety of factors in determining whether to extend an offer of employment and in setting the appropriate compensation level, including, but not limited to, a candidate’s experience, education, certification/credentials, market data, internal equity, and geography. Alight makes these decisions on an individualized, non-discriminatory basis. Bonus and/or incentive eligibility are determined by role and level. Alight also offers a comprehensive benefits package; for specific details on our benefits package, please visit: Wellbeing and Benefits Selector Page - Alight DISCLAIMER: Nothing in this job description restricts management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units. Alight Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, pregnancy, childbirth or related medical condition, veteran, marital, parental, citizenship, or domestic partner status, or any other status protected by applicable national, federal, state or local law. Alight Solutions is committed to a diverse workforce and is an affirmative action employer.

• Architect the initial dbt project structure and establish modeling patterns for our EHR integration layer. • Design and build foundational data models that normalize and standardize data from diverse EHR systems (Epic, Cerner, NextGen, etc.). • Establish data quality frameworks, testing strategies, and observability patterns for the EHR integration layer. • Create reusable transformation patterns and documentation that enable rapid integration of new EHR data sources. • Collaborate with product and engineering teams to define data contracts and specifications for the EHR layer. • Build resilient data pipelines that handle the complexities of healthcare data (HL7, FHIR, proprietary formats).

• Define and implement the strategy for LLM-based data products, including data preparation, semantic layer design, and embedding pipelines for RAG-based applications. • Own the design and evolution of our Snowflake architecture. Lead the implementation of Snowflake Cortex for AI/ML workloads, including semantic models and LLM agents. • Design and maintain reliable, performant ELT/Reverse ETL pipelines. Ensure our multi-tenant SaaS data remains isolated, secure, and performant at scale. • Build and operationalize pipelines for large-scale ML and LLM model development, moving from POC to production-grade deployment within the Snowflake perimeter. • Think holistically about the data estate. Reduce complexity through modularity and well-defined service boundaries (e.g., Medallion Architecture). • Serve as the go-to expert for emerging data trends. Mentor engineers and partner with Product and Design to translate complex business logic into automated deliverables.

Role Overview We are seeking a Principal Data Engineer and Data Governance Lead with deep Snowflake expertise, strong Master Data Management (MDM) skills, and proven experience leading data governance and managing data and reporting teams. This role is central to unifying data across Salesforce, HubSpot, Gong, BigCommerce, LMS systems, and internal delivery platforms, enabling accurate segmentation, forecasting, GTM insights, operational efficiencies, and AI-driven automation. This role owns both the technical data foundation and the governance and people leadership required to make data trustworthy and usable at scale. You will architect robust data pipelines, establish the enterprise data model, design AI-ready semantic layers, lead the data and reporting function, and coach cross-functional teams on data stewardship while operating effectively in a matrixed environment. Why This Role Matters for Teachstone Teachstone is entering a phase where reliable, unified, and well-governed data is essential to achieving our 2026 goals: strengthening profitability, improving predictability, expanding digital delivery, diversifying markets, and deepening customer engagement. Today, critical data lives in disconnected systems with inconsistent definitions, duplicated records, and manual reporting workarounds. This role provides the technical, governance, and leadership backbone needed to: - Create and enforce a single source of truth across Growth, Delivery, CS, Finance, and Product - Lead and mature the data and reporting team to deliver consistent, high-impact insights - Establish sustainable data governance practices that scale beyond individuals - Enable advanced reporting, forecasting, and AI-driven decision support - Reduce manual reporting, rework, and operational friction across the organization Key Responsibilities Enterprise Data Architecture & Pipeline Development - Design, build, and maintain high-performance ELT/ETL pipelines into Snowflake across Enterprise systems - Architect optimized Snowflake schemas, warehouses, and data models that support analytics, forecasting, and operational workflows - Build scalable transformation logic using SQL, Python, dbt, and other modern data tools Data Governance, MDM & Stewardship - Own and lead Teachstone’s data governance framework, including standards, policies, operating cadences, and decision rights - Define and maintain canonical enterprise data models for accounts, customers, products, segments, and lifecycle stages - Establish and enforce field definitions, naming conventions, data lineage, and documentation standards - Lead cross-system deduplication, normalization, and data quality initiatives - Chair or co-lead an enterprise data governance council, driving alignment across Growth, Delivery, CS, Finance, and Product - Ensure governance practices are practical, adopted, and embedded into day-to-day workflows—not theoretical Data & Reporting Team Leadership - Manage and develop the data engineering and reporting team, including analysts and analytics engineers as applicable - Set clear priorities, standards, and delivery expectations for data pipelines, dashboards, and reporting outputs - Balance short-term reporting needs with long-term platform and governance maturity - Coach team members on best practices in data modeling, governance, and stakeholder partnership - Establish sustainable operating rhythms for intake, prioritization, and delivery of data work Data Quality, Reliability & Controls - Implement validation frameworks to monitor data accuracy, completeness, and consistency - Develop automated error detection, alerting, and traceability for critical pipelines - Ensure adherence to performance, privacy, and compliance requirements Cross-Functional Collaboration & Enablement - Partner with Growth, CS, Delivery, Product, Marketing, and Finance to translate business needs into governed, scalable data solutions - Coach non-technical stakeholders on data ownership, stewardship, and responsible data practices - Help leaders understand how upstream data decisions affect downstream reporting, metrics, and AI use cases - Operate effectively within a matrixed organization with shared ownership and competing priorities Performance Optimization & Innovation - Optimize Snowflake compute usage, storage strategies, and query performance - Evaluate emerging tools and technologies to strengthen the data platform - Support long-term modernization, including real-time ingestion, event-driven pipelines, and AI/ML enablement Qualifications Required - 10+ years of experience in data engineering, including people leadership or functional leadership of data/reporting teams - 4+ years of hands-on Snowflake experience (RBAC, warehouse design, performance tuning, cost management) - Snowflake certification required - Advanced SQL and proficiency in Python or another data-oriented language - Experience with dbt, Matillion, Fivetran, Airflow, Prefect, or similar tools - Experience leading analytics engineering or enterprise reporting functions - Demonstrated familiarity with semantic layers and AI/ML-enabled analytics - Demonstrated experience designing and leading data governance and MDM initiatives - Strong communication skills with the ability to influence technical and non-technical stakeholders - Comfort operating in a matrixed organization Preferred - Experience in SaaS, education, or services-based delivery environments - Prior participation in enterprise data strategy or governance council What We Offer: Fair, Competitive Pay: We ensure equal pay for equal work, using consistent salary bands based on market benchmarks, reviewed annually. Prior salaries, negotiation skills, or fear of conflict don’t influence your pay. Salary Range: $135,000 - $175,000, determined by your experience, skills and internal equity. Comprehensive Benefits: Medical/dental, 401(k), PTO, insurance, development opportunities. Details provided at offer. Eligibility depends on your role and employment status. Ready to Make a Difference? At Teachstone, we believe that every interaction shapes a brighter future. If you're passionate about transforming education and want to be part of a team that's committed to meaningful impact, we want to hear from you. Apply today and help us create classrooms where every child thrives! At Teachstone, we encourage all individuals to apply and bring their unique perspectives to our team. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, gender, gender identity, sexual orientation, protected veteran status, disability, age, or any other characteristic protected by law. We value the different experiences and ideas our team members bring and believe they are essential to solving complex challenges and driving our mission forward.