Company : enGenJob Description : JOB SUMMARY This role is an integral senior member of a technical team, responsible for supporting the design, development, and maintenance of the organization's data infrastructure, ensuring the efficient and reliable flow of data across various systems. This position is responsible for ensuring the reliable movement, transformation, and storage of data across various platforms. The incumbent will work closely with data professionals, analysts, and engineers to build and optimize data pipelines, ensuring data quality and integrity. The ideal candidate is adaptable, solution-oriented, and capable of collaborating across multiple teams to support a broad range of data initiatives. The incumbent and team will be involved in every aspect of the data process, from idea generation, analysis, design, build, and support, using the latest technologies and design patterns. ESSENTIAL RESPONSIBILITIES - Design, develop, and maintain robust data processes and solutions to ensure the efficient movement and transformation of data across multiple systems - Develop and maintain data models, databases, and data warehouses to support business intelligence and analytics needs - Collaborate with stakeholders across IT, product, analytics, and business teams to gather requirements and provide data solutions that meet organizational needs - Monitor work against production schedule, provide progress updates, and report any issues or technical difficulties to lead developers regularly - Implement and manage data governance practices, ensuring data quality, integrity, and compliance with relevant regulations. - Collaborate on the design and implementation of data security measures, including access controls, encryption, and data masking - Mentor other associate and intermediate data engineers as needed - Perform data analysis and provide insights to support decision-making across various departments - Stay current with industry trends and emerging technologies in data engineering, recommending new tools and best practices as needed - Other duties as assigned or requested. EXPERIENCE Required - 5 years of experience in design and analysis of algorithms, data structures, and design patterns in the building and deploying of scalable, highly available systems - 5 years of experience in a data engineering, ETL development, or data management role. - 5 years of experience in SQL and experience with database technologies (e.g., MySQL, PostgreSQL, MongoDB). - 5 years of experience in data warehousing concepts and experience with data warehouse solutions (e.g., Snowflake, Redshift, BigQuery) Preferred - 7 years of experience with data pipeline and workflow management tools (e.g., Apache Airflow, AWS Glue, Azure Data Factory). - 7 years of experience defining system architectures and exploring technical feasibility trade-offs for optimizing short term execution while planning for long term technical capabilities - 7 years of experience working with a variety of technology systems, designing solutions or developing data solutions in healthcare - 7 years of experience with cloud platforms (AWS, Azure, GCP) and their respective data services - 7 years of experience in data governance, data quality, and data security best practices - 7 years of experience translating requirements, design mockups, prototypes or user stories into technical designs - 7 years of experience in producing data-related code that is fault-tolerant, efficient, and maintainable SKILLS - Demonstrated ability to achieve stretch goals in a highly innovative and fast-paced environment - Adaptability: Strong ability to take on diverse tasks and projects, adapting to the evolving needs of the organization - Analytical Thinking: Strong analytical skills with a focus on detail and accuracy - Interest and ability to learn other data development technologies/languages as needed - Technical Proficiency: Comfortable with a range of data tools and technologies, with a willingness to learn new skills as needed - Strong track record in designing and implementing large-scale data sources - Strong sense of ownership, urgency, and drive - Demonstrated passion for user experience and improving usability - Team Collaboration: A team player who can work effectively in cross-functional environments - Experience and willingness to mentor junior data engineers and help develop their skills and leadership EDUCATION Required - Bachelor’s degree in Computer Science, Information Systems, Data Science, Computer Engineering or related field Preferred - Master's degree in Computer Science, Information Systems, Data Science, Computer Engineering or related field LICENSES or CERTIFICATIONS Required - None Preferred - None Language (Other than English): None Travel Requirement: 0% - 25% PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS Position Type Office- or Remote-based Teaches / trains others Occasionally Travel from the office to various work sites or from site-to-site Rarely Works primarily out-of-the office selling products/services (sales employees) Never Physical work site required No Lifting: up to 10 pounds Constantly Lifting: 10 to 25 pounds Occasionally Lifting: 25 to 50 pounds Rarely Disclaimer: The job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this job title. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job. Compliance Requirement: This job adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies. As a component of job responsibilities, employees may have access to covered information, cardholder data, or other confidential customer information that must be protected at all times. In connection with this, all employees must comply with both the Health Insurance Portability Accountability Act of 1996 (HIPAA) as described in the Notice of Privacy Practices and Privacy Policies and Procedures as well as all data security guidelines established within the Company’s Handbook of Privacy Policies and Practices and Information Security Policy. Furthermore, it is every employee’s responsibility to comply with the company’s Code of Business Conduct. This includes but is not limited to adherence to applicable federal and state laws, rules, and regulations as well as company policies and training requirements. Pay Range Minimum: $78,900.00 Pay Range Maximum: $147,500.00 Base pay is determined by a variety of factors including a candidate’s qualifications, experience, and expected contributions, as well as internal peer equity, market, and business considerations. The displayed salary range does not reflect any geographic differential Highmark may apply for certain locations based upon comparative markets. Highmark Health and its affiliates prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on any category protected by applicable federal, state, or local law. We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the email below. For accommodation requests, please contact HR Services Online at HRServices@highmarkhealth.org California Consumer Privacy Act Employees, Contractors, and Applicants Notice

• Helps architect and lead the development of enterprise-scale data platforms • Assist the project delivery team with scoping and planning integration projects • Contribute to the design, implementation, and support of data artifacts in the data lakehouse and databases • Collaborates with cross-functional stakeholders to translate business and technical requirements into scalable data solutions • Manage and mentor a small team of data engineers

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description We are seeking a Data Architect to own and evolve the end-to-end architecture behind the Consumer Canvas platform. You will work across Snowflake, Databricks, identity systems, ingestion pipelines, and activation layers — ensuring our data is scalable, secure, privacy-compliant, and highly performant. You will partner closely with Data Engineering, Data Science, Machine Learning, and Product teams to build next-gen solutions that power the future of consumer insights and advertising activation. This is not a migration or maintenance role — it is a strategic influence position with the opportunity to architect new systems, components, and methodologies from the ground up. - Own the end-to-end architecture of the Consumer Canvas product. - Design systems across ingestion, identity spine creation, enrichment, governance, and activation workflows. - Collaborate with cross-functional partners (Data Scientists, ML Engineers, Data Engineers, Product Owners). - Define and enforce PII governance, privacy controls, and security best practices. - Translate complex business and technical requirements into scalable architecture. - Support technical teams with architectural guidance and model/structure design. - Participate directly in design, prototyping, and testing cycles within an Agile environment. - Act as a senior technical thought partner, providing mentorship (non-manager role). Qualifications - 5+ years of experience in Data Architecture or related technical leadership roles. - Hands-on experience with Snowflake (including Data Clean Rooms) and/or Databricks. - Strong SQL and experience with Python, PySpark, and Spark. - Proven experience working with PII data, privacy constraints, and governance frameworks (critical & non-negotiable). - Data modeling expertise (conceptual, logical, physical). - Experience designing scalable data pipelines and cloud-native architectures. - Strong communication skills and ability to influence cross-functional stakeholders. Requirements - Experience in Ad-Tech, Martech, Media, Consumer Data, or Identity Ecosystems (Nice-to-Have). - Familiarity with Medallion Architecture (Bronze/Silver/Gold) (Nice-to-Have). - Azure services (ADF, Azure Data Lake, Azure DevOps) (Nice-to-Have). - Containers & orchestration (Docker, Kubernetes) (Nice-to-Have). - Experience with audience activation platforms (e.g., Trade Desk, LiveRamp) (Nice-to-Have). Benefits - Flexible working environment. - Volunteer time off. - LinkedIn Learning. - Employee-Assistance-Program (EAP).

• Design, build, and maintain ETL/ELT pipelines using Fivetran + Snowflake integrations to ingest data from a variety of sources into our Snowflake data warehouse • Develop and manage robust data models in Snowflake, ensuring data is structured for performance, reliability, and ease of use by analysts and business stakeholders • Use Hightouch to operationalize data by syncing warehouse data to downstream CRM, marketing, and sales tools • Monitor pipeline health, troubleshoot data quality issues, and implement alerting to proactively catch failures • Document data models, pipelines, and lineage to support a culture of data literacy and self-service analytics • Integrate Claude and other LLMs directly with our Snowflake data warehouse, enabling AI-powered querying, summarization, and insight generation on top of live revenue data • Build and maintain data sources, semantic layers, and search services within Snowflake Cortex and connected AI platforms • Design and deploy AI agents that can reason over structured and unstructured revenue data to support go-to-market workflows • Architect and manage multi-step agent workflows, coordinating across tools, APIs, and data sources to automate complex analytical and operational tasks • Evaluate and implement orchestration frameworks (e.g., LangChain, LlamaIndex, or custom solutions) best suited to our use cases • Run rigorous evaluations of AI tools, models, and platforms to determine the best solution for each use case (e.g., Snowflake Cortex vs. Claude vs. Gemini vs. custom fine-tuned models) • Develop evaluation frameworks covering quality, latency, cost, and security to inform build vs. buy decisions and guide our overall AI roadmap • Stay current on the rapidly evolving AI landscape and proactively recommend new tools or approaches as the space matures • Implement and manage row-level security (RLS) in Snowflake to ensure AI tools only surface data that users are authorized to see • Maintain and evolve role-based access controls (RBAC) alongside new RLS policies • Contribute to data governance practices, including access controls, PII handling, and schema management • Partner with Data, Security, and Legal teams to establish AI data governance standards and guardrails • Monitor and manage AI credit consumption across Snowflake Cortex, API usage, and other platforms to keep spending within budget • Identify and implement optimizations — such as caching, prompt tuning, model selection, and query efficiency improvements — to reduce cost without sacrificing quality • Build reporting to give stakeholders visibility into AI spend and usage trends • Partner with Revenue Operations, Finance, and Sales to understand data needs and translate them into scalable engineering solutions • Collaborate across technical and non-technical teams to deliver data and AI solutions that directly influence revenue strategy