Business Systems Analyst - Business Intelligence

Allegis Global Solutions; Bengaluru; On-site; INR 800,000 - 1,100,000; Full time

Job summary

Allegis Global Solutions is seeking a Business Systems Analyst II (BI) in Bengaluru to analyze data, reconcile quality, and translate issues into specifications. You will work with the BI architecture across data sources and data warehouse, guiding internal teams on optimal BI solutions.

The role requires strong SQL and PowerBI skills, plus experience with Azure/Snowflake and data governance practices. Collaboration with cross-functional teams and agile SCRUM participation are key aspects of the

Qualifications

• 3–5 years of IT BI/consulting experience.
• Experience using SQL to query data and PowerBI to visualize data.

Responsibilities

• Reconcile and manage data quality using SQL queries.
• Identify potential system issues from data insights.
• Load new clients into the enterprise data warehouse.
• Support QA processes for BI solutions with BI developers.
• Provide consultation on new BI features to users.
• Contribute to Data Governance including data quality and security.
• Monitor and triage Data Quality defects/inquiries in AGS360 (Salesforce).
• Troubleshoot integration/build failures and client delivery gaps with SQL validation in Azure/Snowflake.
• Create process models and technical specs for developers/product team.
• Participate in Agile SCRUM and backlog/test case management.

Skills

SQL

PowerBI

Data analysis

Education

B.S. in CS or related

Tools

Azure

Snowflake

Job description

Company Description

About Allegis Global Solutions We are founded on a culture that is passionate about transforming the way the world acquires talent by delivering client-focused solutions that make a difference for businesses worldwide. From refining how businesses manage their contingent workforce to strengthening employer brands to recruit top talent, our integrated solutions drive business results. As an industry leader, we draw upon decades of experience to design innovative tools, products, and processes. We develop competitive practices that position organizations for growth and we deliver the insight needed to succeed in today's global marketplace. As a workplace, we focus on relationships – with each other, our clients and our candidates. In fact, serving others is one of our core values. We support open communication and recognize that giving constructive criticism can be even harder than receiving it. We appreciate the fearless and the passionate, who force us to be better. Everything we do sits on a pillar of diversity - diverse perspectives, backgrounds, and ideas drive innovation and make us successful. See what it’s like to work at AGS by searching #LifeAtAGS on any social network. FOR U.S. ONLY AGS is an Equal Opportunity/Affirmative Action Employer (M/F/Disability/Veterans). We will consider all applications without regard to race, gender, sexual orientation, gender identity, age, color, religion, national origin, veteran status, disability, genetic information or any other status protected by applicable law. If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to disability, please call 844-604-7059 or email [e-mail].

Job Summary

The Business Systems Analyst II Business Intelligence (BI) is responsible for consulting with the business to investigate data discrepancies, translate issues into development specifications, and document, analyze, and test code changes within AGS’ business environment. The Business Systems Analyst II must deeply understand the BI architecture (front-end and back-end systems and processes) as the analyst provides technical guidance to AGS’ internal teams on the optimal solution for business logic. The analyst is seen as the subject matter expert (SME) on data, which includes but is not limited to the overarching data flow, starting with our customer’s talent systems (Vendor Management Systems, Applicant Tracking Systems, CRM, etc.), external data sources (e.g., Lightcast), AGS’ Data Warehouse, and Process Improvements. The analyst is required to communicate effectively orally and in writing.

Responsibilities

• Reconcile and manage data quality to resolve discrepancies and/or reconcile results using SQL queries.
• Utilize data to identify potential system issues.
• Facilitate the process of loading new clients into the enterprise data warehouse.
• Partner with BI Developers to support QA processes for our BI solutions.
• Provide consultation to internal and external business users requesting new BI features.
• Contribute to the effective Data Governance of our data. This includes data quality, data management, business process management, and security.
• Monitor, maintain, and triage Data Quality defects/inquiries that come through AGS360 (Salesforce).
• Troubleshoot integration/build failures and client delivery gaps to determine root causes and provide guidance on possible solutions, including writing SQL queries to validate data in Azure and Snowflake environments.
• Create process models and technical specifications to provide direction to developers and/or the product team.
• Participate in identifying and maintaining team best practices.
• Participate in Agile SCRUM process, including managing backlog items and test cases.

Qualifications

• 3 – 5 years of experience in an IT Business Analyst/Consulting role, or related position.
• 3 – 5 years of experience using SQL to query data.
• 3 – 5 years of experience using PowerBI to visualize data.
• B.S. in Computer Science, Business, or related major or equivalent business experience.
• Problem analysis and solving skills – ability to identify root causes of problems and differentiate between perceived and actual problems.

Additional Information

As a workplace, we focus on relationships – with each other, our clients and our candidates - in fact serving others is one of our core values. We support open communication and recognize that giving constructive criticism can be even harder than receiving it. We appreciate the fearless and the passionate, who force us to be better. Everything we do sits on a pillar of diversity - diverse perspectives, backgrounds and ideas drive innovation and make us successful. See what it’s like to work at AGS by searching #LifeAtAGS on any social network.

Experience Level

Mid Level