IT BI Engineer - Fresher

Sonata Software•San Antonio, TX

20h•Hybrid

About The Position

Sonata Software is seeking a motivated, analytical, entry-level IT BI Engineer to join its Business Intelligence team. The engineer will work with business and technical teams to create reports, dashboards, data models, and data integrations that support business decision-making. This role is suitable for candidates with foundational knowledge of SQL, databases, data analysis, and BI concepts who want to develop a career in Business Intelligence and Data Engineering. The position is in Irvine, California, with work from the office 3–4 days per week. It is a six-month contract-to-hire role. The role involves developing and maintaining BI reports and dashboards, writing and optimizing SQL queries, assisting with ETL/ELT processes, supporting databases and data warehouses, validating data, and troubleshooting reporting and integration issues. The engineer will also help translate business requirements into technical reporting solutions, document reports and data processes, participate in testing, deployment, and production support, and collaborate with analysts, developers, QA, and business users. Candidates should have a bachelor's degree in a relevant field or an acceptable MCA or other relevant postgraduate qualification. Familiarity with SQL, relational databases, data warehousing, ETL/ELT, BI tools, Excel, and data visualization is expected. Python, cloud platforms, additional database technologies, APIs, version control, and relevant academic or internship projects are advantageous. Sonata Software states that it is an equal opportunity employer and encourages diversity in the workplace.

Requirements

Good knowledge of SQL and relational databases.
Basic understanding of data warehousing concepts.
Knowledge of ETL/ELT concepts.
Exposure to at least one BI or reporting tool, such as Power BI, Tableau, Qlik, or 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; an MCA or 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.

Nice To Haves

Knowledge of Python for data analysis.
Exposure to Azure, AWS, or 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.

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.