Role Description We are seeking a highly motivated and talented Data Engineering Intern to join our team and play a critical role in shaping the future of healthcare data management. This individual will be involved in supporting building robust, scalable, and accurate data systems that empower operational and analytics teams to make informed decisions and drive positive outcomes. Position Responsibilities: - Partner closely with operational and analytics teams to translate business needs into effective data solutions - Architect and implement ETL workflows leveraging CapitalRx platforms and technologies such as Python, dbt, SQLAlchemy, Terraform, Airflow, Snowflake, and Redshift - Conduct testing to ensure the flawless execution of data pipelines before production deployment - Proactively identify and resolve data-related issues, ensuring system reliability and data integrity - Provide ongoing maintenance and support for data infrastructure - Responsible for adherence to the Capital Rx Code of Conduct including reporting of noncompliance. Qualifications - Pursuing a Masters degree in Computer Science, Information Technology, or a related field - Knowledge of Python (or Java), SQL, JSON, and XML - Knowledge of data warehousing architecture techniques and familiarity with Kimball methodology - A strong interest in data engineering, displaying the ability to design, implement, and maintain complex data pipelines - Capacity to analyze the company's broader data landscape and architect scalable data solutions that support growth - Excellent communication skills to collaborate effectively with both technical and non-technical stakeholders - A self-motivated and detail-oriented individual with the ability to tackle and solve intricate technical challenges Requirements - Experience as a Data Engineer, ideally in the healthcare or PBM sector - Knowledge of Airflow, dbt, Snowflake, and SQL development and Python experience Benefits - Salary Range: $35 - $40 USD

This is a remote position. - ​ Snowflake Data Engineer & Developer Position: Snowflake Data Engineer & Developer Location: VA, MD, DC - Hybrid or Remote Type: Full-time Experience Level: Mid-Senior Level Department: Data Engineering / Development About the Role: As a Snowflake Data Engineer & Developer working on the DoD’s Analytics Platform, you will design, develop, and optimize data pipelines, ensuring seamless data ingestion, transformation, and processing in Snowflake. You will collaborate with teams to integrate data from various sources, maintain data integrity, and ensure the platform supports DoD's mission-critical analytics. Key Responsibilities: - Data Pipeline Development: Build and manage efficient data pipelines for ingesting, transforming, and loading data into Snowflake. - ETL/ELT Workflows: Develop and automate ETL/ELT processes using Snowflake, Snowpipe, and Streams & Tasks. - Database Optimization: Design Snowflake database structures and optimize queries, ensuring high performance and scalability. - Integration: Collaborate with other teams to integrate data from various sources (cloud, databases, APIs) into Snowflake. - Data Security: Implement data encryption, role-based access controls (RBAC), and compliance with DoD IL5/IL6 standards. - Data Transformation: Apply transformation logic and create reusable components for scalable data processing across the platform. - Performance Monitoring: Monitor and tune performance, proactively identifying bottlenecks and optimization opportunities. Required Qualifications: - Experience: - 3+ years of experience in data engineering, with at least 1 year of experience working with Snowflake. - Proven experience in designing and implementing ETL/ELT workflows. - Technical Skills: - Proficient in SQL and Snowflake-specific capabilities (e.g., Time Travel, Snowpipe, Streams). - Experience with cloud platforms (AWS, Azure), particularly data-related services. - Knowledge of Python or Java for scripting and data automation. - Security Clearance: Active U.S. DoD Secret Clearance (Top Secret/SCI preferred). - Data Management: Experience in handling large-scale datasets, performing data integration, and ensuring data quality in a DoD or similar secure environment. Preferred Qualifications: - Certifications: - Snowflake SnowPro Certification or equivalent. - Cloud certifications (AWS or Azure) focusing on data. - Data Tools: Experience with big data tools (e.g., Spark, Kafka, Hadoop). - Automation: Familiarity with automation tools like Airflow and CI/CD pipelines for data workflows. Why Join Us?: - Directly support national defense and warfighter missions. - Work on cutting-edge technology in the high-stakes environment of combat command analytics. - Competitive compensation and benefits, along with growth opportunities in the DoD sector.

Huron helps its clients drive growth, enhance performance and sustain leadership in the markets they serve. We help healthcare organizations build innovation capabilities and accelerate key growth initiatives, enabling organizations to own the future, instead of being disrupted by it. Together, we empower clients to create sustainable growth, optimize internal processes and deliver better consumer outcomes. Health systems, hospitals and medical clinics are under immense pressure to improve clinical outcomes and reduce the cost of providing patient care. Investing in new partnerships, clinical services and technology is not enough to create meaningful and substantive change. To succeed long-term, healthcare organizations must empower leaders, clinicians, employees, affiliates and communities to build cultures that foster innovation to achieve the best outcomes for patients. Joining the Huron team means you’ll help our clients evolve and adapt to the rapidly changing healthcare environment and optimize existing business operations, improve clinical outcomes, create a more consumer-centric healthcare experience, and drive physician, patient and employee engagement across the enterprise. Join our team as the expert you are now and create your future. This role sits within a strategic investment to embed AI into how we operate, serve customers, and make decisions within our healthcare business. We’re building an healthcare-wide AI data and context platform with a focus on deep domain expertise embedded throughout our architecture. Our goals are: Turn structured and unstructured information into trusted, reusable “building blocks” (semantic layers, retrieval services, and agent-ready interfaces) that accelerate product innovation Deliver transformational speed and leverage —faster time-to-insight, higher automation of knowledge work, and a foundation that scales AI safely and reliably as adoption grows. Unlock new capabilities across our business. Create the foundation that drives deeper domain innovation and allows cross-domain collaboration to flourish. This is a hands-on technical leader who builds core AI/context data capabilities and leads delivery through architecture, implementation, and mentorship. The role owns key parts of the AI context platform—unstructured ingestion, embeddings, retrieval, semantic layers, and governance—while partnering across teams to ship production-grade AI data products. This roles does not have direct reports initially. Leadership is through technical ownership and influence. Key responsibilities (hands-on + technical leadership) Build and own the AI context platform - Design and implement end-to-end pipelines: ingestion → parsing/chunking → enrichment → embeddings → vector indexing → retrieval/serving. - Build scalable patterns for incremental refresh, backfills, re-embeddings, deduplication, and lineage across unstructured sources. - Improve retrieval quality (query strategies, hybrid search, metadata filtering, reranking hooks) in partnership with AI engineers. Deliver semantic and governed data products - Define and implement semantic layers (metrics/entities) that power BI and agent reasoning consistently. - Establish data contracts and “context contracts” for AI inputs (schemas, metadata requirements, freshness, citation expectations). - Ensure datasets and indexes are discoverable, documented, and reusable. Operational excellence - Own reliability and performance: monitoring, alerting, SLAs/SLOs, runbooks, incident response, postmortems. - Optimize cost and latency across warehouse/lakehouse and vector infrastructure. AI safety, governance, and compliance - Implement security-by-design: RBAC/ABAC patterns, PII redaction, retention controls, audit logging, and safe access pathways for agent tools. - Partner with Security/Legal/Compliance on guardrails for AI access to enterprise knowledge. Lead through influence - Drive technical direction and roadmap decomposition with product/AI/application stakeholders. - Set best practices for testing, CI/CD, and evaluation (retrieval eval sets, regression tests, online telemetry). - Mentor engineers via pairing, code reviews, and lightweight enablement sessions. Required qualifications - 6–10+ years in data engineering/platform roles with significant hands-on delivery. - Expert SQL and strong Python (or Scala/Java); strong production engineering habits. - Proven experience designing cloud data pipelines and operating them reliably at scale. - Experience working with unstructured data processing and search/retrieval concepts. - Strong communication skills and ability to lead cross-functionally. Preferred qualifications - Hands-on experience with vector search and embeddings (pgvector/Pinecone/Weaviate/OpenSearch/Elastic) and retrieval patterns (semantic retrieval, hybrid search, reranking). - Experience supporting LLM applications (RAG, agent tool interfaces, evaluation/observability). - Knowledge of knowledge graphs/semantic modeling or metrics layers at scale. - Experience in regulated environments and mature governance programs. Example Success measures - Measurable improvement in AI outcomes: higher retrieval precision/recall, better citation coverage, fewer “missing context” failures. - Reduced latency/cost per retrieval and improved platform reliability (SLO attainment, lower MTTR). - Broad adoption of semantic definitions and context contracts across teams. - Accelerated delivery by enabling others via standards, templates, and mentorship. Behavioral attributes - Business-curious and eager to learn: Proactively learns the functional domain (processes, terminology, KPIs, constraints) and can speak credibly with SMEs and business leaders—not just translate requirements, but help shape the right questions and success measures. - Stakeholder-first collaborator: Builds strong relationships with stakeholders, SMEs, and consultants; clarifies goals, constraints, and tradeoffs early; communicates progress and risks clearly; and sets realistic expectations around timelines, scope, and quality. - Consultative problem-solver: Approaches requests with a “diagnose before prescribe” mindset—asks smart questions, proposes options, and guides teams toward durable solutions rather than one-off fixes. - Influence without authority: Leads through expertise and trust—drives alignment, facilitates decisions, and unblocks teams across functions even without direct reports. - High ownership and follow-through: Treats reliability, documentation, and operational readiness as part of the work; finishes what they start; and holds a high bar for production quality. - Clear communicator for mixed audiences: Can go deep with engineers and also explain concepts plainly to non-technical partners; writes crisp docs, designs, and runbooks. - Pragmatic builder mindset: Biases toward shipping value in iterations, validating with users, and improving based on feedback—balancing innovation with maintainability and risk. - Comfortable with ambiguity: Thrives in early-stage or evolving spaces (AI/data products), adapts quickly, and turns unclear goals into actionable plans. - Integrity and stewardship: Handles sensitive data responsibly, respects governance, and advocates for secure-by-design patterns while enabling the business to move fast. The estimated base salary for this job is $140,000 - $190,000 USD. The range represents a good faith estimate of the range that Huron reasonably expects to pay for this job at the time of the job posting. The actual salary paid to an individual will vary based on multiple factors, including but not limited to specific skills or certifications, years of experience, market changes, and required travel. This job is also eligible to participate in Huron’s annual incentive compensation program, which reflects Huron’s pay for performance philosophy. Inclusive of annual incentive compensation opportunity, the total estimated compensation range for this job is $161,000 - $237,500 USD. The job is also eligible to participate in Huron’s benefit plans which include medical, dental and vision coverage and other wellness programs. The salary range information provided is in accordance with applicable state and local laws regarding salary transparency that are currently in effect and may be implemented in the future. Position Level Manager Country United States of America

Office of Information Technology Annual Salary Range Lead IT Analyst: $112,497 - $149,972 FLSA Exempt / Union Represented This position allows for up to four days of remote work per week About the Office The Office of Information Technology (IT) is responsible for enabling State Bar’s internal and external stakeholders by the management, implementation, and maintenance of an organization's technology to support of State Bar’s mission and goals. The office’s primary goals are to build and maintain functional capabilities, to support innovation and to ensure that all systems are running smoothly, efficiently, and securely to support the needs of the organization and its stakeholders. Job Overview The Office of Information Technology is seeking a Lead Data Engineer to join our dynamic team at the State Bar of California. In this role, you will define and drive the modernization of our data infrastructure using Microsoft cloud technologies. As the technical authority for the Bar’s data platform, you will lead the development of scalable, automated data pipelines, establish governance standards, and guide cross-functional teams to deliver data driven solution that support Analytics, AI, compliance, and operational efficiency. The Ideal Candidate The ideal candidate is a hands-on technical leader with experience in building scalable, cloud-based data solutions. This individual brings a strong understanding of modern data architectures, data integration patterns, and secure design principles and is capable of driving architectural decisions that align with long-term business goals. They have demonstrated success in leading cross-functional collaboration, setting standards for data quality and governance, and building reusable data frameworks that support analytics, automation, and decision making. A clear understanding of compliance standards (e.g.,PII, PCI, HIPAA, CPRA) and experience applying those principles in large scale environments is essential. Microsoft certification in one or more of the following is strongly desired: Azure Data Engineer Associate; Power BI Data Analyst Associate; Azure Solutions Architect Expert; or any other data analysis-related certifications. Definition With minimum direction, the Lead IT Analyst provides technical leadership and direction for major IT projects, and/or serves as the technical authority for one or more related functions, including: network operating systems; software applications; data analytics applications, project/program management; product management; desktop support; system engineering; network infrastructure; database management; cloud services administration; and web server management. The Lead IT Analyst performs advanced, highly specialized IT work involving the business requirements, analysis, product roadmaps, planning, project management, architecture, designing, implementation, maintenance, troubleshooting, and/or enhancement of complex IT systems and procedures, and may serve in a lead capacity over other IT analysts and support staff. Distinguishing Characteristics The Lead IT Analyst is the highest level in the IT Analyst series and may be assigned to a function as an individual technical expert, project team leader. When assigned as a technical expert, performs work requiring a very high level of technical knowledge of a specific area, or ability to integrate at a high level the knowledge of several areas, while working with a significant amount of independent authority and judgment. When assigned as a project team leader, manages and provides technical leadership of projects involving large-scale, complex, and highly analytical tasks. When assigned as a supervisor, may perform work comparable to a project team leader, but with direct supervision over subordinate IT analysts and support staff. The Lead IT Analyst is distinguished from the Senior IT Analyst in that the former performs the most complex IT operations and applications-related duties, provides technical leadership and direction to lower-level IT staff, and assumes responsibility for completion of major IT projects in accordance with the State Bar’s needs. The Lead IT Analyst also provides strategic input and guidance within the incumbent’s area of specialization. Role-Specific of Essential Duties Duties may include, but are not limited to the following: - Lead the design, development, and maintenance of scalable data pipelines using Azure Data Factory, Synapse Analytics, and Data Lake Storage to ingest, transform, and publish structured and unstructured data. - Drive the automation of end-to-end and event-driven workflows using Azure Logic Apps, ensuring real-time or scheduled data synchronization and integration with external systems. - Direct enterprise-level data modeling and transformation efforts to support reporting, dashboards, and analytics, including validation and quality checks to ensure consistency and reliability. - Guide and collaborate with IT and business teams to gather data requirements, define transformation logic, and develop shared documentation such as the data dictionaries. - Develop and oversee enhancements of the Azure-based data architecture, focusing on scalability, reusability, and long-term maintainability. - Establish and implement data governance standards, including metadata management, lineage tracking, and data privacy and security controls aligned with organizational compliance needs. - Optimize datasets for Power BI and promote self-service analytics through clean, reusable data models and standardized practices. - Manage, monitor, troubleshoot, and tune pipeline performance, proactively resolving issues and establishing observability standards for operational reliability. - Ensure comprehensive documentation and lead knowledge transfer efforts to support long-term IT business and user sustainability and system adoption. - Maintain and support databases for custom and legacy applications, including performance tuning, backup and recovery, indexing, and monitoring. - Spearhead the optimization of stored procedures, ETL jobs, and scheduled tasks, ensuring efficiency and reliability across both modern and legacy environments. - Partner with application teams to troubleshoot and resolve data-related issues, implement fixes, and ensure data integrity in legacy platforms. - Lead enterprise data migration efforts aligning strategies for access control, security, and compliance as data moves from legacy to modern platforms. - Build and maintain an enterprise data dictionary and catalog to improve data discoverability and consistency across the organization. - Lead and implement data security and compliance standards, across the Bar’s data footprint. Examples of Essential Duties When assigned to the IT Application Engineering, Product Management, or Program Management Teams, duties may include, but are not limited to the following: - Analyzes and evaluates existing IT applications, products, and systems for cost effective and efficient operation, and identifies opportunities for modifications and improvements; prepares feasibility studies and project proposals accordingly. - Plans, designs, tests, develops, and integrates solutions based on operational needs to support the business roadmap. - Determines project schedules and allocation of resources for projects; determines operating characteristics, requirements; monitors the utilization of resources to ensure optimal effectiveness and efficiency; resolves production issues; and ensures projects, tasks and other activities are completed on schedule and in a timely and efficient manner. - Monitors and maintains existing IT applications and products to ensure optimal functionality. - Acts as the leader, supervisor, and primary point of contact for their assigned team. - Coordinates closely with other IT staff and business partners to accomplish the collective goals and objectives of assigned programs, projects, and activities. - Develops, maintains, and enforces various standards, best practices, procedures, policies and standard operating processes. - Serves as the subject matter expert, mentor, guide in their respective area of expertise. When assigned to the IT Operations and Infrastructure Team Duties may include, but are not limited to the following: - Supports the IT Director and IT Management team in the development, planning, estimating, and implementation of goals, objectives, and other activities for modifications and improvements. - Acts as the leader, supervisor, and primary point of contact for the IT Operations and Infrastructure Team. - Oversees the desktop support team and/or infrastructure team to ensure that all known incidents and Zendesk tickets are accurately identified and assigned efficiently; ensures that any tickets that cannot be resolved within agreed timeframes are properly escalated. - Oversees the desktop support team and/or infrastructure team, and manages the ticket queue and incoming requests related to IT issues. - Administers and supports configurations and maintains records of end-user’s equipment. Endpoints include laptops, mobile devices, printers, AV systems, and other related peripherals.  - Oversees the infrastructure configuration and management to support State Bar data retention, security, business continuity, disaster recovery planning/testing, and information risk management policies.  - Coordinates closely with IT Application Engineering, IT PMO, and IT Product Management teams to accomplish the goals and objectives of assigned programs, projects, and activities. - Collaborates with end-users and the system engineer team to ensure optimal functionality and system effectiveness. Role Specific Employment Standards Knowledge of: - Advanced functions of computer information systems, including the core hardware and software components that comprise complex IT systems and networks, as well as personal computer applications, word processing, and spreadsheet programs. - Analysis and evaluation techniques to plan, design, integrate, implement, maintain and troubleshoot complex IT systems and networks. - Techniques and practices of supervision, leadership, project management, and training. - Project management and information systems development, design, and maintenance. - Technical, operational, and programming problem-solving analysis. - Principles of Agile application development methodologies. - Problem identification, analysis and evaluation. - Principles of effective writing and verbal presentation. Desired Knowledge: - Proficient in building scalable data pipelines using Azure Data Factory, Synapse Analytics, Azure Data Lake, and Logic Apps. - Strong SQL skills with experience in data transformation, validation, and optimization for reporting and analytics. - Skilled in dimensional modeling and modern data platform design to support dashboarding and analytical use cases. - Familiar with data quality frameworks, including validation, anomaly detection, and exception handling processes. - Experience with metadata management, data cataloging, and governance tools such as Azure Purview (or equivalents). - Familiarity with CI/CD practices and version control systems such as Git. - Demonstrated ability to translate business needs into technical requirements and collaborate effectively across IT and business teams. - Strong communication, documentation, and stakeholder engagement skills to support alignment and knowledge sharing. - Data engineering languages such as Python. - Knowledge of data security best practices including encryption, data masking. - Familiarity with data visualization tool Power BI. - Technical, operational, and programming problem-solving analysis. - Problem identification, analysis and evaluation. - Principles of effective writing and verbal presentation. Ability to: - Exercise independent judgement, decisiveness, and creativity in designing, planning, troubleshooting, and integration of complex systems or networks based on the potential benefits and/or consequences. - Analyze, evaluate, present and recommend technology methodologies and solutions. - Solve problems with minimal disruption or impact to the organization business functions. - Develop technology guidelines and standards. - Develop alternative solutions within established guidelines and standards. - Prioritize competing requests for service. - Develop policies, procedures and standards relevant to the area of expertise. - Interpret and implement IT policies, procedures, and standards. - Operate modern office equipment including computer hardware, software, and internet and web-based applications. - Compile data and prepare narrative and statistical reports. - Communicate clearly and concisely, both orally and in writing. - Establish and maintain effective interpersonal relationships at all organizational levels as well as with the public. - Maintain the confidentiality of information. General Employment Standards Knowledge of: - Advanced functions of computer information systems, including the core hardware and software components that comprise complex IT systems and networks, as well as personal computer applications, word processing, and spreadsheet programs. - Analysis and evaluation techniques to plan, design, integrate, implement, maintain and troubleshoot complex IT systems and networks. - Techniques and practices of supervision, leadership, project management, and training. - Project management and information systems development, design, and maintenance. - Technical, operational, and programming problem-solving analysis. - Principles of Agile application development methodologies. - Problem identification, analysis and evaluation. - Principles of effective writing and verbal presentation. Ability to: - Exercise independent judgement, decisiveness, and creativity in designing, planning, troubleshooting, and integration of complex systems or networks based on the potential benefits and/or consequences. - Analyze, evaluate, present and recommend technology methodologies and solutions. - Solve problems with minimal disruption or impact to the organization business functions. - Determine the systems or networking requirements to plan for or enhance the core data processing needs for the system or network. - Develop technology guidelines and standards. - Develop alternative solutions within established guidelines and standards. - Direct, schedule, and orchestrate the installation, maintenance, and enhancements of complex IT systems and networks. - Prioritize competing requests for service. - Develop policies, procedures and standards relevant to the area of expertise. - Interpret and implement IT policies, procedures, and standards. - Plan, schedule, make work assignments, set priorities, train, mentor, evaluate, and select staff; - Operate modern office equipment including computer hardware, software, and internet and web-based applications. - Compile data and prepare narrative and statistical reports. - Appropriately respond to requests and inquiries from the public, State Bar members, or other departments. - Communicate clearly and concisely, both orally and in writing. - Establish and maintain effective interpersonal relationships at all organizational levels as well as with the public. - Maintain the confidentiality of information. Minimum Qualifications Education: - Bachelor’s degree in computer science or a closely related field that develops skills related to the essential duties, or equivalent academic achievement. Experience: - Five (5) years of experience at the advanced journey-level in the information systems field including system analysis, business process design, development and implementation of business application solutions or IT project management, of which at least one (1) year was in a lead capacity. License, Certificate, Registration Requirements: - Possession of one or more approved information technology certificates and/or completion of other approved technology-related training may substitute for some or all of the required education. Applicants who meet the Minimum Qualifications will be required to successfully complete the State Bar’s selection process for this classification. About the State Bar The State Bar of California’s mission is to protect the public and includes the primary functions of licensing, regulation, and discipline of attorneys; the advancement of the ethical and competent practice of law; and support of efforts for greater access to, and inclusion in, the legal system. Our Values Clarity | Investing in Our People | Excellence | Respect | Growth Mindset Learn more about our values. DEI Statement We are a diverse, equitable, and inclusive workplace where all of our employees and prospective employees experience fairness, dignity, and respect. Learn more about our commitment to DEI.