Senior Software Engineer

Senior Software Engineer - Data Warehouse

Location: Tustin, CA (Onsite)

Department: IT

Reports To: Vice President of IT

Compensation: Competitive Salary + Bonus + Benefits (Exempt Position)

Join Our Clients Innovative Team and Shape the Future of Data-Driven Decisions!

Are you a data wizard passionate about building scalable, enterprise-grade data solutions that power business growth? A forward-thinking organization seeking a Senior Software Engineer - Data Warehouse to lead the analytics ecosystem. If you thrive on architecting high-performance data platforms, optimizing ETL pipelines, and delivering actionable insights, this is your chance to make a real impact in a collaborative, fast-paced environment.

This organization has been around for many decades, they thrive to keep their human assets engaged and happy.

• Architect and optimize enterprise-scale data warehouses using Snowflake (or similar cloud platforms) to handle massive transactional and analytical workloads.
• Own ETL/ELT strategies:
  Ingest, transform, and orchestrate data from diverse sources like Oracle Simphony POS, financial systems, and third-party APIs.
• Craft high-performance SQL queries, dimensional models, and stored procedures for flawless data accuracy and scalability.
• Build executive BI dashboards and self-service tools with Power BI, Tableau, or Looker to turn complex data into strategic insights.
• Design secure RESTful APIs and event-driven connections to link internal systems with external partners.
• Lead Oracle Simphony integrations (including OSDM Plugin) for reliable, auditable data flows.
• Collaborate as a technical bridge between IT, Finance, Operations, and vendors to scope projects and deliver results.
• Mentor junior talent, enforce best practices, and maintain top-tier documentation and data governance.
• Drive projects from concept to completion:
  Define scopes, timelines, risks, and ensure on-time, on-budget success.
• Influence our data roadmap, pioneering enhancements in architecture and analytics.

• Bachelor's in Computer Science, Information Systems, or equivalent experience.
• 10+ years in data warehouse design, ETL/ELT, and BI in enterprise settings.
• SQL mastery with relational and dimensional modeling expertise.
• Proven Snowflake (or equivalent) hands-on experience.
• Proficiency in ETL tools like Fivetran, Airbyte, Matillion, or dbt.
• API design and integration know-how.
• Oracle Simphony experience, especially OSDM Plugin.
• Deep knowledge of data governance, security, and compliance.
• Leadership in cross-functional projects with excellent communication skills.

• Competitive pay, comprehensive benefits, and performance bonuses.
• Onsite work in sunny Tustin, CA.
• Opportunities for professional growth, certifications, and cutting-edge tech.
• Collaborative culture with mentorship and innovation at its core.
• Make a tangible difference:
  Your work will fuel executive decisions and operational excellence.

If you're ready to elevate your career and build the data foundation of tomorrow, apply now!

Mid-Senior level

Full-time

Information Technology

Retail and Restaurants

• Medical insurance
• Vision insurance
• 401(k)