Associate BI Engineer

Job Title: Associate BI Engineer

• Location: Irvine, CA (3 days work from office per week)
• Duration: CTH

About Sonata Software

Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms.

Powered by its Platformation™ framework and Harmoni.AI platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services.

Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenue and 6,400+ AI engineers supporting global delivery across regions including the US, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics.

With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.

For more information, please visit www.sonata-software.com

Responsibilities

• The Associate BI Engineer supports the development, maintenance, and enhancement of business intelligence solutions, including reports, dashboards, semantic models, and data assets that enable informed business decision-making. Working closely with senior BI engineers, data engineers, analysts, and business stakeholders, this role helps ensure reporting solutions are accurate, reliable, well-documented, and aligned with business requirements.
• Report & Dashboard Development - Design, develop, test, and maintain business intelligence reports, dashboards, scorecards, and visualizations using approved BI platforms. Support report enhancements, troubleshoot issues, optimize performance, validate results, and ensure reporting solutions meet business requirements and usability standards.
• Data Modeling & Analytics Support - Assist in developing and maintaining semantic models, business metrics, and reporting data structures. Support analytical initiatives by validating data relationships, defining KPI calculations, performing data analysis, and helping translate business requirements into scalable reporting solutions.
• Data Quality, Governance & Documentation - Perform report validation, data reconciliation, and quality assurance activities to ensure reporting accuracy and consistency. Maintain technical and business documentation, support metadata management, document report definitions, and adhere to enterprise data governance and reporting standards.
• Business & Team Collaboration - Collaborate with BI Engineers, Data Engineers, Business Systems Analysts, and business stakeholders to gather requirements, resolve reporting issues, support user acceptance testing, provide production support, and contribute to continuous improvement of reporting and analytics capabilities.

Requirements

• 'Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Data Science, or a related technical field.
• 0-2 years of experience in business intelligence, analytics, reporting, software development, data engineering, or related technical roles.
• Foundational knowledge of SQL and relational databases.
• Basic understanding of reporting, dashboard development, and data visualization principles.
• Familiarity with BI platforms such as MicroStrategy, Power BI, Tableau, or similar technologies through coursework, internships, certifications, or work experience.
• Exposure to data warehousing, dimensional modeling, and data integration concepts.
• Strong analytical, problem-solving, and communication skills.
• Ability to learn new technologies and work effectively in a collaborative team environment.
• SQL (Basic) – Ability to write, troubleshoot, and validate queries used for reporting and analysis.
• Business Intelligence Tools (Basic) – Familiarity with dashboard and report development using MicroStrategy, Power BI, Tableau, or similar platforms.
• Data Visualization (Basic) – Understanding of visualization best practices and KPI design.
• Data Warehousing (Basic) – Knowledge of dimensional modeling, facts, dimensions, and reporting data structures.
• Analytics & Reporting (Basic) – Ability to interpret business requirements and translate them into reporting solutions.
• Data Validation & Reconciliation (Basic) – Ability to validate report outputs and perform data quality checks.
• Cloud Data Platforms (Basic) – Familiarity with Snowflake or other cloud-based analytical environments.
• Communication & Teamwork – Ability to collaborate effectively with technical and business teams while learning from senior BI professionals.

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