Analytics Solutions Architect/Power BI/Salesforce/Chicago Local

About the role

The Analytics Solutions Architect will lead the design, development, and evolution of our client's reporting and analytics ecosystem. This role bridges business stakeholders and technical teams, using Power BI, Salesforce, and SQL to transform operational reporting needs into intuitive, actionable insights.

Responsibilities

• Partner with Sales, Recruiting, Operations, Finance, and Executive Leadership to define meaningful Key Performance Indicators (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.

Requirements

• 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.

Qualifications

• 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.

Skills

• Experience in staffing, recruiting, professional services, or sales-driven organizations.
• 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.

Benefits

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