Analytics Solutions Architect/Power BI/Salesforce/Chicago Local

Chicago, IL, US • Posted 28 days ago • Updated 8 hours ago
Full Time
On-site
$145000 - $160000/yr
Company Branding Image
Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

  • Business Acumen
  • Advanced Analytics
  • Information Systems
  • Computer Science
  • Business Intelligence
  • Modeling
  • Optimization
  • Data Validation
  • Dimensional Modeling
  • Analytical Skill
  • Facilitation
  • Professional Services
  • SQL Azure
  • Microsoft
  • Cloud Computing
  • Extract
  • Transform
  • Load
  • Data Governance
  • Master Data Management
  • Predictive Analytics
  • Statistics
  • Artificial Intelligence
  • Finance
  • Leadership
  • KPI
  • Decision-making
  • Dashboard
  • Semantics
  • Microsoft Power BI
  • DAX
  • Salesforce.com
  • Recruiting
  • Sales
  • Data Quality
  • Usability
  • Collaboration
  • Data Structure
  • Data Warehouse
  • SQL
  • Documentation
  • Reporting
  • Roadmaps
  • Analytics
  • Data Integrity
  • Insurance
  • SAP BASIS

Summary

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10105282
  • Position Id: 882421
  • Posted 28 days ago

Company Info

About Motion Recruitment Partners, LLC

Motion Recruitment delivers IT Talent Solutions for Contract, Direct Hire, Managed Solutions and Statement of Work to all of North America from our 21 delivery centers. Our high-touch, specialized, team-based recruitment model’s success is proven through our exemplary track record in filling the most challenging IT positions for startup and enterprise clients alike. Our hyper-specialized tech focus results in a truly consultative approach for both our clients and candidates, within our recruiting areas of expertise: Software, Mobile, Data, Infrastructure, Cybersecurity, Product + UX and Functional.

Motion also delivers IT Consulting Solutions through the Motion Consulting Group (MCG) that create true digital transformation for IT projects in Agile Development & Coaching, DevOps & DevSecOps Solutions, and Managed Services for IT Operations.

We’re also the proud creators of Tech in Motion and the Timmy Awards, our North American community platform, events series and award program that connects over 250,000 tech enthusiasts to meet, learn, and innovate.

About_Company_OneAbout_Company_Two
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Oak Brook, Illinois

Today

Easy Apply

Full-time

$140000 - $160000

Chicago, Illinois

Today

Easy Apply

Full-time

$160000 - $180000

Chicago, Illinois

Today

Easy Apply

Full-time

$170000 - $200000

Remote

Today

Easy Apply

Contract

$40 - $60

Search all similar jobs