What are the responsibilities and job description for the Senior Software Engineer position at HireDirectNow.com?
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.
What You'll Do:
- 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.
- Develop robust Python and JavaScript scripts for automation, monitoring, and seamless integrations.
- 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.
What We're Looking For:
- 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.
- Strong Python/JavaScript skills for production solutions.
- API design and integration know-how.
- Oracle Simphony experience, especially OSDM Plugin.
- BI tool expertise (Power BI, Tableau, Looker).
- Deep knowledge of data governance, security, and compliance.
- Leadership in cross-functional projects with excellent communication skills.
Why Join Us?
- 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!