Design and implement scalable data platforms, build ETL/ELT pipelines, integrate multiple data sources, define KPIs, create dashboards and executive reports, ensure data quality/governance, and collaborate with stakeholders to optimize BI capabilities.
This is a remote position.
Job Title: Business Intelligence & Data Analytics Consultant
Location: Chicago, IL (Remote- Locals Higly Prefered)
Employment Type: Contract
Duration: 3–6 Months (Possible Extension)
Job Summary
We are seeking an experienced Business Intelligence & Data Analytics Consultant to help design and implement a scalable data platform while defining key business metrics and reporting capabilities. The ideal candidate will have experience with data architecture, ETL processes, cloud platforms, and BI tools to transform raw data into actionable business insights.
Responsibilities
- Design and implement scalable data platforms.
- Gather business reporting and analytics requirements.
- Integrate data from multiple sources.
- Develop ETL/ELT pipelines.
- Create dashboards and executive reports.
- Define and document business KPIs and metrics.
- Collaborate with business stakeholders to understand reporting needs.
- Ensure data quality, governance, and security.
- Optimize data models for reporting and analytics.
- Provide recommendations for improving business intelligence capabilities.
Requirements
Required Skills
- 5+ years of experience in Business Intelligence or Data Analytics.
- Strong SQL skills.
- Experience with Power BI, Tableau, or Looker.
- Experience with Azure, AWS, or Google Cloud.
- Knowledge of data warehousing concepts.
- Experience building ETL/ELT pipelines.
- Strong understanding of KPIs and business reporting.
- Excellent communication and stakeholder management skills.
Nice to Have
- Experience working with executive leadership.
- Experience designing enterprise reporting solutions.
- Agile/Scrum experience.
- Relevant Microsoft, AWS, or Google Cloud certifications.
Similar Jobs
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Provide remote technical support for VinSolutions and Cox Automotive products via phone, email, and chat. Troubleshoot and resolve application issues, log cases in the CRM, escalate to other teams as needed, and keep clients informed while meeting quality standards and shift requirements.
Top Skills:
Genesys PurecloudExcelMicrosoft OutlookMicrosoft WordSalesforceVinsolutions
Agency • Artificial Intelligence • Consumer Web • Digital Media • Analytics • Design
Manage end-to-end paid media campaigns across multiple clients and channels, including strategy, setup, optimization, tracking, and reporting. Analyze performance data, maintain tracking (GA4/Tag Manager), build reports and dashboards, and present insights to clients. Collaborate with account, creative, and analytics teams to drive growth and improve ROI while staying current on platform best practices.
Top Skills:
Conversions ApiFacebook/Meta AdsGoogle AdsGoogle Analytics (Ga4)Google Looker StudioGoogle SheetsGoogle Tag ManagerLinkedin AdsMicrosoft/Bing AdsPerformance MaxPinterest AdsProgrammatic AdvertisingReddit AdsTwitter/X AdsYoutube Ads
Security • Cybersecurity
Design, build, and deploy production-grade ML systems for ICS/xOT cybersecurity, including threat detection, anomaly detection, NLP/LLM applications, and scalable data pipelines with observability and MLOps practices for cloud and on-prem environments.
Top Skills:
Ci/CdDockerGoHuggingfaceJavaKubernetesLlmsMessage QueuingMlopsModel VersioningNlpPipeline OrchestrationPythonPyTorchRetrieval-Augmented Generation (Rag)RustScikit-LearnSQLStream ProcessingTensorFlow
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
