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 San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
