Senior AI Data Engineer (Full-time)

Remote in CA, TX, NC, WA, ID, NV, AZ, CO, KS, AR, LA, AL, GA, FL, SC, TN, VA, MD, NJ, DE, IL, WI, MI, OH, MA, PA, NH, CT

Cortica is looking for a Senior AI Data Engineer to join its growing team!

The Senior AI Data Engineer will serve as both architect and builder of our data ecosystem. Every initiative will follow a complete engineering lifecycle: gathering stakeholder requirements, designing the solution, building and testing it, and shipping it to production. This role will work across data lakes, analytics pipelines, and lightweight application development— the multi-disciplinary data equivalent of a full-stack developer.

The Senior AI Data Engineer will work closely with the data science, finance, and clinical operations teams to design intelligent, automated data solutions that power care decisions, financial planning, and operational efficiency. AI augmentation is not optional — it is the standard working mode.

Cortica is a rapidly growing healthcare company pioneering the most effective treatment methods for children with neurodevelopmental differences. Our mission is to design and deliver life-changing care – one child, one family, one community at a time. Ultimately, we envision a world that cultivates the full potential of every child. At Cortica, every team member is instrumental in helping us achieve our mission!

Our culture and values guide how we work and treat one another. Cortica celebrates diversity and fosters an inclusive environment, seeking ideas and opinions from everyone on the team. We safeguard equal rights and respect for all individuals, regardless of race, color, religion, sex, national origin, age, disability, creed, genetic information, sexual orientation, gender identity or expression, ancestry, veteran status or other applicable, legally protected characteristics. All Cortica employment decisions are made based on an individual’s qualifications and ability to successfully perform the job responsibilities.

What will you do?

Full Lifecycle Project Ownership:

• Engage stakeholders directly to gather, clarify, and document project requirements.
• Translate requirements into architected data solutions: choose the right storage, pipeline, modeling, and delivery approach for each problem.
• Own testing end-to-end — unit tests, data quality checks, reconciliation, and integration tests before anything reaches production.
• Deploy solutions to production and monitor post-deployment health, iterating rapidly based on real-world feedback.

AI-First Data Engineering: 

• Run parallel AI coding sessions (Claude Code, Cursor, Codex) across different facets of a pipeline simultaneously — orchestrate, verify, and integrate the outputs.
• Build and maintain context files (CLAUDE.md equivalents) for data projects that encode schema conventions, pipeline patterns, and institutional knowledge — making every future AI session smarter.
• Design verification loops: automated data quality checks, dbt tests, CI hooks, and pipeline monitors that give AI agents concrete feedback on correctness. • Build MCP (Model Context Protocol) or equivalent integrations to connect AI agents directly to Snowflake, Amazon Athena, Postgresql, MySql, Power BI APIs, Salesforce, and internal tooling.
• Prefer frontier models for complex architectural decisions and rely on AI acceleration to dramatically increase engineering throughput.

Data Platform & Pipeline Engineering:

• Design and build complex, reliable data pipelines ingesting from AWS, Azure, Salesforce, MuleSoft, and multiple third-party APIs into our AWS Data Lake and Snowflake warehouse.
• Implement and evolve data models using Kimball methodology to support financial, operational, and clinical analytics.
• Optimize pipeline performance, manage data quality, and perform root-cause analysis on data anomalies — internal and external. • Develop and maintain orchestration workflows in Python, and AWS Glue.
• Continuously evolve the data schema as business and engineering requirements change.

Analytics & Reporting Enablement:

• Build and support Power BI data models and reports; empower analytics team members to self-serve on a reliable data foundation.
• Work with data analysts and data scientists to build reusable, well-documented pipeline components they can extend independently.
• Deliver data products that drive clinical care decisions, financial planning, and operational performance improvements.

Application Development:

• Build lightweight internal data applications and tooling where needed; data entry interfaces, operational dashboards, automation scripts that bridge the gap between data pipelines and end users.
• Design for agentic workflows: build AI-powered data tools accessible via web interfaces or Slack that surface insights proactively.
• Integrate with Salesforce Health Cloud and other platforms using APIs and event-driven patterns.

Security, Governance & Collaboration: 

• Ensure data security and HIPAA compliance in all pipeline and application work. Partner with IT to enforce data governance standards.
• Document decisions, tradeoffs, and architecture clearly so that future engineers (and AI agents) can build on your work effectively.
• Collaborate across IT, finance, clinical operations, and data science — acting as the connective tissue between data infrastructure and business outcomes.

We’d love to hear from you if:

• You have 5+ years of hands-on data engineering experience, including building and operating production data pipelines.
• You have expert-level Python skills for ETL, pipeline orchestration, and automation.
• You possess deep SQL proficiency — query optimization, data modeling, stored procedures.
• You bring 2+ years’ experience working with AI first development workflows.
• You bring 4+ years’ experience with the following AWS (S3, Glue, Lambda, Redshift), and/or Azure big data services.
• You have 1+ year of experience with Snowflake.
• You have 2+ years of experience with orchestration frameworks.
• You have 2+ years of Salesforce experience with Apex and configurations.
• You’re experienced with Kimball dimensional modeling — you've built star schemas and conformed dimensions in production.
• You have Power BI (or equivalent BI tool) experience — data model design and report development.
• You have API integration experience — REST, GraphQL, event streaming (Kafka, Kinesis, or similar).
• You possess application development literacy — comfortable building lightweight web tooling (Python/Flask, Node, or similar) to complement data products.
• You reside in one of the following states: CA, TX, NC, WA, ID, NV, AZ, CO, KS, AR, LA, AL, GA, FL, SC, TN, VA, MD, NJ, DE, IL, WI, MI, OH, MA, PA, NH, CT

Your Compensation & Benefits

Cortica cares deeply about the well-being of each member of our team, and we have created a passionate, caring, and growth-minded culture that helps teammates thrive! As a Cortica teammate, we’ll support your well-being through medical, dental, and vision insurance, a 401(k) plan with company matching and rapid vesting, paid holidays and wellness days, life insurance, disability insurance options, tuition reimbursements for professional development and continuing education, and referral bonuses. We value you and the experience you bring to your role, and are proud to provide you with a compensation and benefits package designed to enhance all aspects of your life.

The base pay range for this opening is $160,000 to $200,000. According to your skill level, relevant experience, education level, and location, you will receive compensation that fits appropriately within the range. EOE. This posting is not meant to be an exhaustive list of the role and its duties.

Privacy Notice 
Cortica is committed to protecting your personal information in compliance with applicable federal and state laws. Please review our Privacy Notice to understand how your data is collected, used, and protected. 

E-Verify Participation 
This employer participates in E-Verify. Click here to view the E-Verify Poster and your Right to Work. 
Este empleador participa en E-Verify. Este empleador participa en E-Verify. Haga clic aquí para ver el cartel de E-Verify y su derecho a trabajar. 

#LI-NF1

#LI-Remote

Senior AI Data Engineer (Full-time)

Remote in CA, TX, NC, WA, ID, NV, AZ, CO, KS, AR, LA, AL, GA, FL, SC, TN, VA, MD, NJ, DE, IL, WI, MI, OH, MA, PA, NH, CT

Cortica is looking for a Senior AI Data Engineer to join its growing team!

The Senior AI Data Engineer will serve as both architect and builder of our data ecosystem. Every initiative will follow a complete engineering lifecycle: gathering stakeholder requirements, designing the solution, building and testing it, and shipping it to production. This role will work across data lakes, analytics pipelines, and lightweight application development— the multi-disciplinary data equivalent of a full-stack developer.

The Senior AI Data Engineer will work closely with the data science, finance, and clinical operations teams to design intelligent, automated data solutions that power care decisions, financial planning, and operational efficiency. AI augmentation is not optional — it is the standard working mode.

Cortica is a rapidly growing healthcare company pioneering the most effective treatment methods for children with neurodevelopmental differences. Our mission is to design and deliver life-changing care – one child, one family, one community at a time. Ultimately, we envision a world that cultivates the full potential of every child. At Cortica, every team member is instrumental in helping us achieve our mission!

Our culture and values guide how we work and treat one another. Cortica celebrates diversity and fosters an inclusive environment, seeking ideas and opinions from everyone on the team. We safeguard equal rights and respect for all individuals, regardless of race, color, religion, sex, national origin, age, disability, creed, genetic information, sexual orientation, gender identity or expression, ancestry, veteran status or other applicable, legally protected characteristics. All Cortica employment decisions are made based on an individual’s qualifications and ability to successfully perform the job responsibilities.

What will you do?

Full Lifecycle Project Ownership:

• Engage stakeholders directly to gather, clarify, and document project requirements.
• Translate requirements into architected data solutions: choose the right storage, pipeline, modeling, and delivery approach for each problem.
• Own testing end-to-end — unit tests, data quality checks, reconciliation, and integration tests before anything reaches production.
• Deploy solutions to production and monitor post-deployment health, iterating rapidly based on real-world feedback.

AI-First Data Engineering: 

• Run parallel AI coding sessions (Claude Code, Cursor, Codex) across different facets of a pipeline simultaneously — orchestrate, verify, and integrate the outputs.
• Build and maintain context files (CLAUDE.md equivalents) for data projects that encode schema conventions, pipeline patterns, and institutional knowledge — making every future AI session smarter.
• Design verification loops: automated data quality checks, dbt tests, CI hooks, and pipeline monitors that give AI agents concrete feedback on correctness. • Build MCP (Model Context Protocol) or equivalent integrations to connect AI agents directly to Snowflake, Amazon Athena, Postgresql, MySql, Power BI APIs, Salesforce, and internal tooling.
• Prefer frontier models for complex architectural decisions and rely on AI acceleration to dramatically increase engineering throughput.

Data Platform & Pipeline Engineering:

• Design and build complex, reliable data pipelines ingesting from AWS, Azure, Salesforce, MuleSoft, and multiple third-party APIs into our AWS Data Lake and Snowflake warehouse.
• Implement and evolve data models using Kimball methodology to support financial, operational, and clinical analytics.
• Optimize pipeline performance, manage data quality, and perform root-cause analysis on data anomalies — internal and external. • Develop and maintain orchestration workflows in Python, and AWS Glue.
• Continuously evolve the data schema as business and engineering requirements change.

Analytics & Reporting Enablement:

• Build and support Power BI data models and reports; empower analytics team members to self-serve on a reliable data foundation.
• Work with data analysts and data scientists to build reusable, well-documented pipeline components they can extend independently.
• Deliver data products that drive clinical care decisions, financial planning, and operational performance improvements.

Application Development:

• Build lightweight internal data applications and tooling where needed; data entry interfaces, operational dashboards, automation scripts that bridge the gap between data pipelines and end users.
• Design for agentic workflows: build AI-powered data tools accessible via web interfaces or Slack that surface insights proactively.
• Integrate with Salesforce Health Cloud and other platforms using APIs and event-driven patterns.

Security, Governance & Collaboration: 

• Ensure data security and HIPAA compliance in all pipeline and application work. Partner with IT to enforce data governance standards.
• Document decisions, tradeoffs, and architecture clearly so that future engineers (and AI agents) can build on your work effectively.
• Collaborate across IT, finance, clinical operations, and data science — acting as the connective tissue between data infrastructure and business outcomes.

We’d love to hear from you if:

• You have 5+ years of hands-on data engineering experience, including building and operating production data pipelines.
• You have expert-level Python skills for ETL, pipeline orchestration, and automation.
• You possess deep SQL proficiency — query optimization, data modeling, stored procedures.
• You bring 2+ years’ experience working with AI first development workflows.
• You bring 4+ years’ experience with the following AWS (S3, Glue, Lambda, Redshift), and/or Azure big data services.
• You have 1+ year of experience with Snowflake.
• You have 2+ years of experience with orchestration frameworks.
• You have 2+ years of Salesforce experience with Apex and configurations.
• You’re experienced with Kimball dimensional modeling — you've built star schemas and conformed dimensions in production.
• You have Power BI (or equivalent BI tool) experience — data model design and report development.
• You have API integration experience — REST, GraphQL, event streaming (Kafka, Kinesis, or similar).
• You possess application development literacy — comfortable building lightweight web tooling (Python/Flask, Node, or similar) to complement data products.
• You reside in one of the following states: CA, TX, NC, WA, ID, NV, AZ, CO, KS, AR, LA, AL, GA, FL, SC, TN, VA, MD, NJ, DE, IL, WI, MI, OH, MA, PA, NH, CT

Your Compensation & Benefits

Cortica cares deeply about the well-being of each member of our team, and we have created a passionate, caring, and growth-minded culture that helps teammates thrive! As a Cortica teammate, we’ll support your well-being through medical, dental, and vision insurance, a 401(k) plan with company matching and rapid vesting, paid holidays and wellness days, life insurance, disability insurance options, tuition reimbursements for professional development and continuing education, and referral bonuses. We value you and the experience you bring to your role, and are proud to provide you with a compensation and benefits package designed to enhance all aspects of your life.

The base pay range for this opening is $160,000 to $200,000. According to your skill level, relevant experience, education level, and location, you will receive compensation that fits appropriately within the range. EOE. This posting is not meant to be an exhaustive list of the role and its duties.

Privacy Notice 
Cortica is committed to protecting your personal information in compliance with applicable federal and state laws. Please review our Privacy Notice to understand how your data is collected, used, and protected. 

E-Verify Participation 
This employer participates in E-Verify. Click here to view the E-Verify Poster and your Right to Work. 
Este empleador participa en E-Verify. Este empleador participa en E-Verify. Haga clic aquí para ver el cartel de E-Verify y su derecho a trabajar. 

#LI-NF1

#LI-Remote

OPEN POSITION ANNOUNCEMENT!

Data Engineer

Open until filled.

Posted 4/29/2026 San Diego County – hybrid work schedule set by SDCP

About the role:  The San Diego Community Power (SDCP) is seeking a seasoned Data Engineer to join our growing team of analytics experts who will be responsible for designing, maintaining, expanding, and optimizing our data infrastructure for data collection, management, transformation, and access. A key priority of this role will be to assist in SDCP’s development of centralizing its data eco-system to allow for creation of pipelines that convert raw data into usable formats for data analysts and other data consumers to utilize. The Data Engineer will handle the core data aspects of software engineering and data science and utilize software engineering principles to develop algorithms that automate the data flow process. They will collaborate with data and system analysts to build machine learning and analytics infrastructure from testing to deployment. 

WHO IS SAN DIEGO COMMUNITY POWER?

San Diego Community Power is a community-driven, not-for-profit public agency providing cleaner energy to the San Diego region. Formed in 2019, Community Power is the second largest Community Choice Aggregator (CCA) in California, serving nearly 1 million customer accounts across its member agencies: the Cities of San Diego, Chula Vista, Encinitas, Imperial Beach, La Mesa and National City, as well as the unincorporated areas of San Diego County.  

OUR HISTORY

San Diego Community Power was formed in 2019 as a public, not-for-profit community choice aggregator (CCA) in the San Diego region. We began electric service in 2021 and serve five member agencies: San Diego, Chula Vista, Encinitas, La Mesa and Imperial Beach, County of San Diego, and National City. SDCP was formed to bring local control and customer choice to San Diego while also providing clean and renewable energy at competitive rates. By the end of 2023, SDCP will provide electricity for nearly half the electric load in San Diego Gas and Electric’s service territory and will be the second largest CCA in California. For more information, please visit SDCommunityPower.org.

COMMITMENT TO DIVERSITY

At SDCP, we value diversity and are committed to creating an inclusive environment for all employees. We represent a diverse customer base and hope to hire employees that reflect our communities. We provide equal employment opportunities to all applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. 

ESSENTIAL DUTIES AND PRIMARY RESPONSIBILITES

• Building and maintaining a centralized cloud-based data infrastructure for optimal extraction, transformation, and loading of data from a wide variety of sources. 
• Assemble large, complex data sets that meet functional/non-functional business requirements. 
• Developing data tools and APIs for data analysis. 
• Deploying and monitoring machine learning algorithms and statistical methods in production environments to solve organizational needs. 
• Ensuring data accessibility and security and implementing company data policies regarding data privacy and confidentiality. 
• Improving data systems reliability, speed, and performance. 
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer trends, operational efficiency, and other key business performance metrics. 
• Collaborating with other internal teams, data analysts, and other stakeholders to understand and optimize how data can be leveraged to meet business needs. 
• Assist in drafting data and analytics’ solicitations and in the selection of consultants. 
• Assist with drafting staff reports and presentations for Board and Committee meetings. 
• Performs other related duties and responsibilities as required. 

MINIMUM KNOWLEDGE, SKILLS, AND ABILITES

• Advance working knowledge of SQL, experience working with relational databases, query authoring (SQL) and working familiarity with various databases. 
• Demonstrated experience in developing API and integrations to support analytics in cloud environment. 
• Experience building and optimizing ‘big data’ data pipelines, architectures, and data sets. 

• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. 
• Strong analytic skills related to working with unstructured datasets. 
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management. 
• A successful history of manipulating, processing, and extracting value from large, disconnected datasets. 
• Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores. 
• Good understanding of data architecture, data design, data warehousing and data modeling concepts. 
• Strong project management and organizational skills. 
• Experience supporting and working with cross-functional teams in a dynamic environment. 

PREFERRED KNOWLEDGE, SKILLS, AND ABILITES

• Experience in the energy sector and/or supporting the implementation of programs funded by California state agencies (e.g., California Public Utilities Commission, California Energy Commission, California Air Resources Board).
• Ability to strongly represent the organization in various professional engagement settings from local to national convenings (conferences, workshops, executive meetings, etc.).

PREFERRED QUALIFICATIONS, EDUCATION AND EXPERIENCE

Minimum of two (2) to three (3) years of professional experience in a Data Engineer role, preferably in the energy industry with a graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field. The candidate should also have experience using the following software/tools:

• Experience with big data tools: Hadoop, Spark, PowerBI, Kafka, etc.
• Experience with AWS, Azure and Google Cloud services.
• Experience with relational SQL and NoSQL databases.
• Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
• Experience with open-source technologies: Python, Pytorch, Flask, Tensorflow or Keras
• Experience with stream-processing systems: Storm, Spark-Streaming, etc.
• Experience with object-oriented/object function scripting languages: Java, C++ etc.
• Experience with batch, micro-batching and real-time data ingestion methodologies.
• Experience with GitHub or similar code repositories

WORK ENVIROMENT & CONDITIONS

Prolonged periods sitting at a desk and working on a computer. The position requires occasional carrying, lifting and/or moving objects up to 25 pounds. Occasional local travel required and reliable transportation to be able to attend SDCP events, meetings, and workshops as needed is expected. At SDCP we work in the communities we serve and in the office. SDCP works to ensure a safe and healthy workplace for employees and in our communities. SDCP requires employees to be fully vaccinated for COVID-19. SDCP is an agency required to adopt and promulgate a Conflict-of-Interest Code (“COI”). The COI code requires employees in designated positions, including those identified under the interim disclosure process to file a Statement of Economic Interests (Form 700) on an annual basis. A Successful candidate accepting this position may be required to file Conflict of Interest forms subject to the regulations of the Fair Political Practices Commission.

COMPENSATION: 

Salary Range: The position salary range is: $84,900 - $110,400; with exact compensation to be determined by SDCP, depending upon experience. 

Benefits: Standard benefits package including but not limited to:

Insurance: SDCP offers group health benefits, including medical, vision, and dental insurance, for eligible FT employees. Also provided is a $100,000 Life & AD&D policy, STD and LTD coverage that is 100% paid by SDCP.

Retirement: SDCP offers a 457(b) plan for employee contributions and contributes 10% of eligible compensation to the employee’s Money Purchase Plan.

Paid Time Off: 11 holidays per year + paid winter holiday (between 12/24-12/31), 160 hours of accrued paid time off per year (increases with time in service), and 96 hours per year of accrued paid sick leave.

This job description may not be inclusive of all assigned duties, responsibilities, or aspects of the job described, and may be amended at the discretion of SDCP as needed.