IT BI Engineer

Job Title: IT BI Engineer – Fresher

Location: Irvine, CA (3-4 days work from office)

Duration: 6 Months Contract to hire

Job Summary

We are looking for a motivated and analytical IT BI Engineer to join our Business Intelligence team. The candidate will work with business and technical teams to develop reports, dashboards, data models, and data integrations that support business decision-making.

This is an entry-level position suitable for candidates who have a good foundation in SQL, databases, data analysis, and BI concepts and are interested in building a career in Business Intelligence and Data Engineering.

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

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

Good to Have

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

Educational Qualification

• Bachelor's degree in Computer Science, Information Technology, Engineering, Data Science, or a related field.
• MCA / relevant postgraduate qualification is also acceptable.

Key Competencies

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

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

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

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