Senior Data Engineer

Sonata Software; Irvine (CA); On-site; USD 180,000 - 240,000; Full time

Job summary

Sonata Software is seeking a Principal Snowflake Data Platform Engineer to lead the design and optimization of enterprise analytics platforms from Irvine, CA. You will craft scalable data models and semantic layers, and drive BI initiatives with cross-functional teams.

The role requires strong leadership, cloud data experience, and collaboration with stakeholders to translate business needs into analytics solutions. This onsite position from Day 1 emphasizes governance and scalable architecture.

Qualifications

• 10+ years in data architecture or enterprise data platforms.
• 5+ years in senior/lead architect role driving platform strategy, standards and governance.
• Proven expertise designing and operating cloud-based data platforms (Snowflake or similar).
• Hands-on experience with ELT/ETL tools, data modeling, and metadata management (dbt, Fivetran, or comparable).
• Strong background in enterprise integration (API-led, event-driven, or batch patterns).
• Experience enabling self-service BI with governed semantic layers and collaboration with business leaders.

Responsibilities

• Design and maintain enterprise analytics data models and semantic layers.
• Build and optimize BI dashboards and reporting surfaces for scalable insights.
• Maintain and improve BI platforms with governance, security, and standards.
• Analyze source systems and ensure accurate data integration for analytics.
• Partner with business stakeholders to align data strategy with analytics roadmaps.

Skills

Data architecture

Data engineering

Leadership

Stakeholder management

BI & analytics

Education

Bachelor's degree in CS/IS

Master's degree preferred

Tools

Snowflake

dbt

Fivetran

Job description

Sonata Software, with over $1.2 Billion Revenue, is a leading AI-first Modernization Engineering company, powered by our unique PlatformationTM framework. Our 6400+ AI Engineers are helping enterprises transform from systems to intelligent business platforms leveraging partner ecosystem to drive speed, efficiency, and growth. Our bouquet of Modernization Engineering Services with AI -first approach cuts across Cloud, Data, AI, Dynamics, Test Automation, and Managed Services.

Sonata’s AI-led modernization is enabled by a powerful suite of proprietary tools and assets. At the core is the Harmoni.AI Enterprise Platform, which includes AgentBridge-a governance and observability framework; AgentBuilder-a development toolkit for fungible agents integrated into enterprise systems; and the Agent Marketplace-an internal ecosystem for modular, reusable agents.

Headquartered in Bengaluru, India, Sonata Software has a strong global presence, including key regions US, UK, India, Malaysia, Mexico, Australia, DACH (Germany/Switzerland) & Nordics (Finland). We are a trusted partner of Fortune 500 companies in Banking, Financial Services and Insurance; Healthcare and Lifesciences; Telecom, Media, and Technology; and Retail, Manufacturing and Distribution space.

Deep collaborations with partners like Microsoft, AWS, Salesforce, and Snowflake strengthen our ability to deliver cutting-edge AI solutions. Our 30+years of partnership with Microsoft, and being part of the elite Microsoft Inner Circle, places us among the top 1% of global Microsoft partners. Sonata is now among the first companies to earn the Microsoft Frontier Partner Badge Also; Sonata Software is proud to achieve AWS Premier Tier Status in the AWS Partner Network.

Job Title: Principal Snowflake Data Platform Engineer

Location: Irvine, CA (Onsite from Day 1)

Major Duties and Responsibilities:

• Reporting & Visualization Development Design, develop, and optimize interactive dashboards, reports, and visualization solutions that enable reliable and scalable business insights across the organization. Implement best practices in BI development including data modeling, visualization standards, and performance optimization to ensure high usability and responsiveness of reporting platforms. Collaborate with cross-functional teams to align reporting solutions with business objectives and evolving analytical needs. availability and uninterrupted service delivery. Collaborate with cross-functional teams to align engineering solutions with organizational goals and evolving business needs.
• Semantic Modeling & BI Platform Development Develop and maintain modern semantic data models and reporting layers using BI platforms such as Power BI, Tableau, or other cloud-based reporting tools. Ensure data accuracy, consistency, and governance through standardized metric definitions, data validation, and documentation practices. Contribute to BI development standards, reusable dashboards, templates, and data models to promote scalability and self-service analytics.
• BI Platform Support & Optimization Maintain and enhance existing dashboards, reports, and BI assets to ensure performance, reliability, and alignment with security and governance policies. Evaluate and recommend new BI tools, visualization techniques, and reporting frameworks to continuously improve analytics capabilities. Support production reporting environments, troubleshoot issues, and perform root cause analysis while driving continuous improvement of BI processes.
• Data Modeling & Source Integration for Analytics Design and implement efficient analytical data models (star schemas, semantic layers, and aggregates) that support enterprise reporting and dashboarding needs. Perform detailed analysis of source systems and datasets to ensure accurate integration with reporting platforms. Apply best practices in data modeling, metadata management, and version control to maintain consistency and transparency across BI assets.
• Business Partnership & Insights Enablement Partner with business stakeholders, analysts, and data teams to deliver trusted and actionable insights through well-designed dashboards and reports. Translate business questions and analytical requirements into scalable BI solutions aligned with enterprise data and analytics strategies. Contribute to the evolution of enterprise BI platforms by shaping reporting standards, governance frameworks, and long-term analytics roadmaps.
• Additional responsibilities as assigned.

Education and Experience:

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field required.
• Master's degree in Computer Science, Information Management, or Business/Technology discipline preferred.
• 10+ years of experience in data architecture, data engineering, or enterprise data platforms.
• 5+ years in a senior/lead architect role driving platform strategy, standards, and governance at enterprise scale.
• Proven expertise designing and operating cloud-based data platforms (Snowflake or similar), including Lakehouse/medallion architectures.
• Hands-on experience with ELT/ETL tools, data modeling, and metadata management (dbt, Fivetran, or comparable).
• Strong background in enterprise integration (API-led, event-driven, or batch patterns).
• Demonstrated success enabling self-service BI and analytics platforms with governed semantic layers.
• Exposure to machine learning/AI platforms and MLOps// practices for operationalizing models.
• Track record of partnering with business leaders to align data platforms with strategic business needs(growth, efficiency, compliance, innovation).
• Excellent leadership, communication, and stakeholder management skills; experience influencing technical and executive audiences.

Why join Sonata Software?

At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.

Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.