Location:
Irvine, CA (3 days work from office per week)
Duration:
CTH
Purpose of the job
The Associate BI Engineer supports the development,maintenance, and enhancement of business intelligence solutions, includingreports, dashboards, semantic models, and data assets that enable informedbusiness decision-making. Working closely with senior BI engineers, dataengineers, analysts, and business stakeholders, this role helps ensurereporting solutions are accurate, reliable, well-documented, and aligned withbusiness requirements.
Major Duties and Responsibilities
- Report& Dashboard Development - Design, develop, test, and maintain businessintelligence reports, dashboards, scorecards, and visualizations using approvedBI platforms. Support report enhancements, troubleshoot issues, optimizeperformance, validate results, and ensure reporting solutions meet businessrequirements and usability standards.
- DataModeling & Analytics Support - Assist in developing and maintainingsemantic models, business metrics, and reporting data structures. Supportanalytical initiatives by validating data relationships, defining KPIcalculations, performing data analysis, and helping translate businessrequirements into scalable reporting solutions.
- DataQuality, Governance & Documentation - Perform report validation, datareconciliation, and quality assurance activities to ensure reporting accuracyand consistency. Maintain technical and business documentation, supportmetadata management, document report definitions, and adhere to enterprise datagovernance 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 productionsupport, and contribute to continuous improvement of reporting and analyticscapabilities.
Educationand Experience
- 'Bachelor'sdegree in Computer Science, Information Systems, Data Analytics, BusinessAnalytics, Data Science, or a related technical field.
- 0-2years of experience in business intelligence, analytics, reporting, softwaredevelopment, data engineering, or related technical roles.
- Foundationalknowledge of SQL and relational databases.
- Basicunderstanding of reporting, dashboard development, and data visualizationprinciples.
- Familiaritywith BI platforms such as MicroStrategy, Power BI, Tableau, or similartechnologies through coursework, internships, certifications, or workexperience.
- Exposureto data warehousing, dimensional modeling, and data integration concepts.
- Stronganalytical, problem-solving, and communication skills.
- Abilityto learn new technologies and work effectively in a collaborative teamenvironment.
Knowledgeand skill level
- SQL(Basic) – Ability to write, troubleshoot, and validate queries used forreporting and analysis.
- BusinessIntelligence Tools (Basic) – Familiarity with dashboard and report developmentusing MicroStrategy, Power BI, Tableau, or similar platforms.
- DataVisualization (Basic) – Understanding of visualization best practices and KPIdesign.
- DataWarehousing (Basic) – Knowledge of dimensional modeling, facts, dimensions, andreporting data structures.
- Analytics& Reporting (Basic) – Ability to interpret business requirements andtranslate them into reporting solutions.
- DataValidation & Reconciliation (Basic) – Ability to validate report outputsand perform data quality checks.
- CloudData Platforms (Basic) – Familiarity with Snowflake or other cloud-basedanalytical environments.
- Communication& Teamwork – Ability to collaborate effectively with technical and businessteams while learning from senior BI professionals.
ABOUTSONATA SOFTWARE
SonataSoftware is an AI-first modernization engineering company that helpsenterprises transform legacy systems into intelligent, scalable businessplatforms. Powered by its Platformation™ framework and Harmoni.AI platform,Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, testautomation, and managed services. Headquartered in Bengaluru, India, Sonata hasmore than $1.2 billion in revenue and 6,400+ AI engineers supporting globaldelivery 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 accelerateinnovation, improve efficiency, and drive sustainable growth.
\" SonataSoftware is an Equal Opportunity Employer encouraging diversity in theworkplace. All qualified applicants will receive consideration for employmentwithout regard to race, national origin, gender identity, age, religion,disability, sexual orientation, veteran status, marital status, or any othercharacteristics protected by law \"