This 12-month contract role is based in Santa Clara, California, and supports the design, modernization, and operation of database and data-platform capabilities for customer applications and analytics platforms. The engineer will partner with backend, frontend, analytics, and Power Platform engineers to build reliable, scalable, and observable data services.
Responsibilities:
• Design database architecture for CAE, Mission Control, and related SPT applications.
• Build and optimize schemas, queries, stored procedures, indexes, and data models.
• Develop reliable extract, transform, load (ETL) and extract, load, transform (ELT) pipelines between enterprise systems and customer platforms.
• Help standardize database application programming interfaces (APIs) and reusable data services.
• Troubleshoot database performance, reliability, and scalability issues.
• Support migration and modernization efforts, including SQL-to-PostgreSQL workloads.
• Collaborate with backend, frontend, analytics, and Power Platform engineers.
• Improve data quality, monitoring, observability, and automation.
Qualifications:
• Advanced SQL expertise and hands-on PostgreSQL experience.
• Strong knowledge of relational database design, database architecture, schemas, normalization, indexing, and query optimization.
• Experience developing ETL/ELT processes and production data pipelines.
• Experience with API-based data integration and integrating multiple enterprise data sources.
• Python experience for data processing and automation.
• Demonstrated performance-tuning and troubleshooting skills.
• Experience handling large-volume data and developing data models.
• Preferred: experience with Microsoft Fabric or Databricks, Splunk, SAP or other enterprise-system integrations, REST APIs or Model Context Protocol (MCP) integrations, Power BI backend/data models, cloud databases, CI/CD, Git, web applications, or analytics platforms.
Tools and Technologies:
• SQL and PostgreSQL
• Python
• ETL/ELT pipelines and REST APIs
• Microsoft Fabric or Databricks
• Splunk and SAP
• Power BI
• Cloud database platforms
• Git and continuous integration/continuous delivery (CI/CD)