IT BI Engineer - Fresher

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 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

Responsibilities

• Develop and maintain BI reports and dashboards based on business requirements.
• Write and optimize SQL queries to extract and analyze data.
• Assist in developing ETL/ELT processes for data extraction, transformation, and loading.
• Work with databases and data warehouses to support reporting requirements.
• Perform data validation, reconciliation, and quality checks.
• Assist senior BI engineers in developing data models and reporting solutions.
• Troubleshoot report, data, and integration issues.
• Understand business requirements and convert them into technical reporting solutions.
• Prepare technical documentation for reports, dashboards, and data processes.
• Participate in testing, deployment, and production support activities.
• Collaborate with Business Analysts, Developers, QA, and business users.

Requirements

• Technical Skills Good knowledge of SQL and relational databases.
• Basic understanding of Data Warehousing concepts.
• Knowledge of ETL/ELT concepts.
• Exposure to any BI/reporting tool such as: Power BI Tableau Qlik Looker Basic knowledge of Excel including Pivot Tables, VLOOKUP/XLOOKUP, and data analysis.
• Understanding of database concepts such as tables, joins, indexes, views, and stored procedures.
• Basic understanding of data visualization and reporting concepts.
• Bachelor's degree in Computer Science, Information Technology, Engineering, Data Science, or a related field.
• MCA / relevant postgraduate qualification is also acceptable.
• Strong analytical and problem-solving skills.
• Good communication and interpersonal skills.
• Willingness to learn new technologies.
• Ability to understand business requirements.
• Attention to detail and commitment to data accuracy.
• Ability to work independently as well as in a team.

Preferred

• Knowledge of Python for data analysis.
• Exposure to Azure / AWS / GCP.
• Knowledge of Snowflake, SQL Server, Oracle, or other databases.
• Understanding of APIs and data integration.
• Exposure to Git or other version-control tools.
• Academic project or internship experience in BI, Data Analytics, or Data Engineering.

Role details

IT BI Engineer – Fresher Location: Irvine, CA (3-4 days work from office) Duration: 6 Months Contract to hire Job Summary

Typical Technology Stack

SQL | Power BI | Excel | ETL | Data Warehouse | Python | SQL Server / Oracle | Cloud

Interview Focus Areas for Freshers

• SQL fundamentals and joins
• Database concepts
• Basic ETL concepts
• Data warehouse concepts
• Power BI / Tableau fundamentals
• Excel and data analysis
• Basic Python
• Problem-solving and analytical ability
• Academic project discussion
• Communication and willingness to learn

Equal opportunity

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