Analytics Solutions Architect/Power BI/Salesforce/Chicago Local

Analytics Solutions Architect/Power BI/Salesforce/Chicago Local


Job ID: mrp-882421

Chicago, IL, US

Information Technology

Full Time,

$145000 - $160000

On-site

Other/Non Classified

Chicago, IL, US

$145000 - $160000

Full Time,

Other/Non Classified

On-site

Information Technology

Job details

Our client is seeking an Analytics Solutions Architect to lead the design, development, and evolution of their reporting and analytics ecosystem. This is a full-time, hybrid opportunity for a hands-on leader who can bridge business stakeholders and technical teams, using Power BI, Salesforce, and SQL to turn operational reporting needs into intuitive, actionable insights.

This is a highly visible role that serves as the bridge between business stakeholders and technical development resources. Our client is looking for someone who combines strong business acumen with advanced analytics expertise, partnering closely with Sales, Recruiting, Operations, Finance, and Executive Leadership to define meaningful KPIs and shape reporting architecture. This is not a pure developer role: it’s for someone who can communicate effectively with business leaders, challenge assumptions, and become the trusted subject matter expert for the organization’s entire analytics ecosystem.

Required Skills & Experience

  • Bachelor’s degree in Information Systems, Analytics, Business, Computer Science, or related field, or equivalent work experience
  • 5+ years of experience in business intelligence, analytics, reporting, or data-focused roles, including working directly with business stakeholders to define and deliver solutions
  • Advanced Power BI experience, including semantic modeling, DAX development, Power Query, dashboard/report design, and dataset optimization
  • Strong SQL skills, including complex joins, CTEs, window functions, and data validation/analysis
  • Experience working with Salesforce reporting and data structures
  • Understanding of dimensional data modeling (fact and dimension design) and KPI development
  • Exceptional ability to translate business questions into analytical solutions, with strong verbal, written, and stakeholder-facilitation skills

Desired Skills & Experience

  • Experience in staffing, recruiting, professional services, or sales-driven organizations
  • Experience with Azure SQL, Microsoft Fabric, or other cloud-based analytics platforms
  • Knowledge of data warehouse concepts and ETL processes
  • Experience working with outsourced development teams or third-party technology partners
  • Understanding of data governance and master data management practices
  • Familiarity with predictive analytics, statistical analysis, or AI-powered reporting tools

What You Will Be Doing

  • Partner with Sales, Recruiting, Operations, Finance, and Executive Leadership to define meaningful KPIs and deliver reporting solutions that drive better decision-making
  • Design, develop, and maintain interactive dashboards, reports, semantic models, and scorecards in Power BI, including advanced DAX calculations and reusable reporting components
  • Design and maintain Salesforce reporting solutions that support recruiting, sales, and operational teams, and improve data quality and usability
  • Collaborate with internal and outsourced development teams to design analytics-ready data structures, fact/dimension models, and data warehouse requirements
  • Write and maintain SQL queries for reporting analysis, validation, troubleshooting, and ad-hoc business requests, investigating and resolving data discrepancies
  • Establish reporting standards, documentation, and a prioritized reporting roadmap, promoting self-service analytics while maintaining data integrity

The Offer

  • Bonus eligible

You will receive the following benefits:

  • Medical, Dental, and Vision Insurance
  • Vacation Time
  • Stock Options

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.

Share this job

I want more jobs like this in my inbox.

Share this job

As part of our promise to talent, Kelly supports those who work with us through a variety of benefits, perks, and work-related resources. Please note: The following benefits reflect Kelly's general offerings. Eligibility may vary by assignment, location, and job type. Kelly offers eligible employees voluntary benefit plans including medical, dental, vision, telemedicine, term life, whole life, accident insurance, critical illness, a legal plan, and short-term disability. As a Kelly employee, you will have access to a retirement savings plan, service bonus and holiday pay plans (earn up to eight paid holidays per benefit year), and a transit spending account. In addition, employees are entitled to earn paid sick leave under the applicable state or local plan. Click here for more information on benefits and perks that may be available to you as a member of the Kelly Talent Community.



About Kelly

Work changes everything. And at Kelly, we’re obsessed with where it can take you. To us, it’s about more than simply accepting your next job opportunity. It’s the fuel that powers every next step of your life. It’s the ripple effect that changes and improves everything for your family, your community, and the world. Which is why, here at Kelly, we are dedicated to providing you with limitless opportunities to enrich your life—just ask the 300,000 people we employ each year.

Kelly is committed to providing equal employment opportunities to all qualified employees and applicants regardless of race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, age, marital status, pregnancy, genetic information, or any other legally protected status, and we take affirmative action to recruit, employ, and advance qualified individuals with disabilities and protected veterans in the workforce. Requests for accommodation related to our application process can be directed to the Kelly Human Resource Knowledge Center. Kelly complies with the requirements of California’s state and local Fair Chance laws. A conviction does not automatically bar individuals from employment. Kelly participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.

Kelly may use AI-powered tools during the recruitment and hiring process. For full details, including how Kelly uses AI, your rights, and how to request a reasonable accommodation, visit the Recruitment Artificial Intelligence Notice.