Business Intelligence Analyst
HybridStamford, Connecticut, United States
Job Summary
Frame ambiguous business problems into clear analytical questions and collaborate with stakeholders to define success measures and decision points. Develop and refine KPIs that reflect business process reality while analyzing large datasets to identify patterns, root causes, and opportunities. Build decision-ready reporting and analytical outputs using Power BI, Salesforce CRM Analytics, Databricks, Tableau, or comparable platforms, validating source data, transformation logic, and calculations to ensure accuracy. Translate data findings into practical business recommendations and communicate insights clearly, including uncertainties and tradeoffs, to align stakeholder expectations. Manage competing priorities across cross-functional projects and improve analytical processes by automating workflows and applying AI-assisted analytics where appropriate.
Required Qualifications
- 1–3 years of business, analytics, operations, finance, or related analysis experience
- Experience working with stakeholders to clarify requirements, define metrics, analyze data, and communicate findings
- Experience managing multiple priorities or projects where requirements, timelines, data availability, or stakeholder needs may shift
- Hands-on experience in Power BI: building/maintaining reports, dashboards, datasets, or analytical views
- Proficiency with modern analytics and reporting tools (e.g., Excel, Power BI, Salesforce Native reporting, Salesforce CRM Analytics, Databricks, Tableau, Microsoft Fabric)
- Strong Excel skills: Power Query, pivot tables, formulas, data preparation, and quality checks
- Ability to work across CRM, data platform, and BI/reporting environments, understanding how source systems, business processes, data definitions, and transformation logic affect analytical outputs
- SQL experience for data extraction, transformation, reconciliation, validation, and repeatable analysis
- Analytical rigor and attention to detail, especially when validating data, reconciling inconsistencies, and explaining assumptions
- Critical thinking and creative problem-solving skills, including the ability to challenge assumptions, structure unclear problems, and identify the real business question behind an initial request
- Ability to distinguish between symptoms and root causes when analyzing business process issues
- Strong business process understanding and ability to connect data findings to operational decisions
- Ability to determine when analysis is directionally useful versus when additional validation is required before decisions are made
- Clear verbal and written communication skills, including the ability to explain technical findings, limitations, and recommendations to non-technical stakeholders
- Effective listening and questioning skills to uncover the actual business need behind a request
- Strong organization and time management skills, with the ability to prioritize work based on business impact, urgency, feasibility, and data readiness
Desired Qualifications
- Python for data preparation, automation, exploratory analysis, or scalable analytical workflows
- Exposure to automation and low-code tools (e.g., Power Automate, Power Apps, Copilot Studio)
- Familiarity with AI-assisted analytics tools, with an emphasis on responsible use, output review, data validation, and business context
- Experience with OPI/GSP applications
- Ability to create executive-ready outputs, including PowerPoint presentations, data visualizations, and concise written summaries
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.