Sr.Data Analyst

Job Description

Data Analyst SQL, Power BI & Advanced Excel (US Shift)

Location: Ahmedabad (on-site)

Shift: 6:30 PM 3:30 AM IST (8:00 AM 5:00 PM US Central; shifts by one hour with US daylight saving)

Requirements: ONLY AHMEDABAD BASED CANDIDATES

About Company: Profusion Systems is a Chicago-based, AI-enabled custom software development company with an engineering team in Ahmedabad. We build production software and data-driven solutions for clients across fintech, non-profit, food and facility services, and SaaS. Our work includes AI and LLM integrations, Azure AI deployments, document automation, custom web and mobile applications, and business reporting solutions. We work closely with international clients, helping them turn business requirements into reliable, scalable technology.

About the role

You will work directly with a US-based client as their embedded reporting and analysis resource. This is not a back-office ticket queue you will talk to business stakeholders, understand what they actually need, and build the reporting that answers it. The work spans pulling data from multiple systems, analysing it, and delivering it as reports and dashboards people make decisions from. We are looking for someone who is technically capable and comfortable in front of a client. Both matter equally.

What you'll do

• Query data from multiple sources databases, exports, third-party systems and reconcile it into a single reliable dataset
• Build reports and dashboards in Power BI, and advanced Excel models with pivot tables, charts, and lookup logic
• Map and document existing data-pull processes, including feeds into Databricks, so they are repeatable rather than tribal knowledge
• Ask questions about why a report exists and what decision it drives, and propose better ways to produce it
• Work directly with client stakeholders clarify requirements, set expectations on timelines, and follow up until closed
• Flag data quality problems and blockers early rather than delivering a report you know is wrong

What you need

• 3+ years in a data analysis or reporting role (analytics experience, not general BPO tenure)
• Strong SQL joins, aggregations, subqueries, and the judgment to know when a result looks wrong
• Advanced Excel INDEX-MATCH/XLOOKUP, pivot tables, charts, text manipulation, and cleaning messy source data
• Hands-on Power BI data modelling, DAX basics, publishing and maintaining dashboards
• Strong written and spoken English; able to hold a working call with a US client without supervision
• Willingness to work the night shift on a sustained basis

Preferred

• Exposure to Databricks or a comparable data platform
• Experience supporting US or international clients
• Familiarity with MS Outlook, Word, and PowerPoint in a professional client setting
• Role: Data Analyst
• Industry Type: IT Services & Consulting
• Department: Data Science & Analytics
• Employment Type: Full Time, Permanent Role
• Category: Business Intelligence & Analytics
• Education: UG (Any Graduate)