IT BI Engineer - Fresher

Location:

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

Duration:6 Months Contract to hire

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 isan entry-level position suitable for candidates who have a good foundation inSQL, databases, data analysis, and BI concepts and are interested in building acareer in Business Intelligence and Data Engineering.

• 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 intesting, deployment, and production support activities.
• Collaborate with Business Analysts, Developers, QA, and business users.

• Good knowledge ofSQL and relational databases.
• Basic understanding of Data Warehousing concepts.
• Knowledge ofETL/ELT concepts.
• Exposure to anyBI/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.

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

• Bachelor's degreein Computer Science, Information Technology, Engineering, Data Science, ora related field.
• MCA / relevant postgraduate qualification is also acceptable.
• Strong analytical and problem-solving skills.
• Good communication and interpersonal skills.
• Willingness tolearn new technologies.
• Ability to understand business requirements.
• Attention todetail and commitment to data accuracy.
• Ability to work independently as well as in a team.

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

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

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

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