Bi Data Warehouse Jobs in Ohio (NOW HIRING)

Job Summary
We are seeking an experienced Data & BI Professional with 8+ years of expertise in data analytics, business intelligence, and enterprise reporting solutions. The ideal candidate will possess strong hands-on experience in advanced SQL development, data modeling, performance optimization, and large-scale data analysis, along with deep expertise in Power BI and/or Tableau. This role requires a proven leader who can collaborate with business and technology stakeholders, translate complex business requirements into scalable reporting solutions, drive BI strategy, and make key decisions related to data platforms, reporting architecture, and analytics solutions.
Key Responsibilities
• Lead the design, development, and implementation of enterprise reporting and analytics solutions.
• Translate business requirements into scalable and efficient BI dashboards, reports, and data models.
• Develop and optimize complex SQL queries, stored procedures, views, and large-volume data processing solutions.
• Design and maintain dimensional and relational data models to support reporting and analytics initiatives.
• Drive data quality, reporting governance, and BI best practices across the organization.
• Build interactive dashboards, scorecards, and executive reporting solutions using Power BI and/or Tableau.
• Define reporting standards, semantic models, KPI frameworks, and visualization best practices.
• Collaborate with business stakeholders to identify opportunities for data-driven decision-making.
• Analyze large datasets to generate actionable insights and business recommendations.
• Lead technical teams and mentor developers, analysts, and BI engineers.
• Participate in BI architecture reviews and data platform strategy discussions.
• Ensure optimal report performance, scalability, security, and maintainability.
• Work closely with Data Engineering, Product, Operations, and Business teams to deliver analytics solutions.
• Support release planning, production deployments, and ongoing reporting enhancements.
Required Qualifications
• Bachelor's degree in Computer Science, Information Technology, Engineering, Mathematics, Statistics, or related field.
• 8+ years of experience in Data Analytics, Business Intelligence, Reporting, or Data Warehousing.
• Advanced expertise in SQL, including complex querying, optimization, indexing strategies, and performance tuning.
• Strong experience in data modeling, dimensional modeling, and database design.
• Proven experience developing enterprise dashboards and reports using Power BI and/or Tableau.
• Experience creating semantic models, datasets, data marts, and reporting frameworks.
• Strong understanding of BI architecture, reporting governance, and analytics best practices.
• Experience leading technical teams and delivering enterprise-scale reporting solutions.
• Excellent analytical, problem-solving, and stakeholder management skills.
• Strong communication skills with the ability to present insights to executive leadership.
Preferred Qualifications
• Experience working in Healthcare, Health Insurance, Financial Services, or other highly regulated industries.
• Exposure to cloud-based analytics platforms such as Azure, AWS, or Google Cloud.
• Experience with ETL/ELT frameworks and data integration processes.
• Knowledge of data governance, data quality, and metadata management practices.
• Experience with Agile delivery methodologies and DevOps processes.
• Relevant certifications in Power BI, Tableau, Azure Data, or cloud analytics technologies.
• Experience with Python for data analysis and automation.
• Exposure to AI/ML-driven analytics solutions.
• Experience with enterprise reporting modernization initiatives.
• Knowledge of healthcare data domains such as Claims, Membership, Provider, or Clinical Data.
Technical Skills
• Advanced SQL
• Query Optimization & Performance Tuning
• Data Modeling
• Data Warehousing
• Data Analysis & Data Visualization
• Data Governance
• Statistical Analysis
• Power BI
• Tableau
• Dashboard Development
• Executive Reporting
• Semantic Models
• KPI & Metrics Design
• Reporting Governance
• SQL Server
• Oracle
• PostgreSQL
• Snowflake
• Azure SQL
• Azure Data Services
• AWS Analytics Services
• Databricks
• Data Lake Architecture
• Technical Leadership
• Solution Design
• Stakeholder Management
• Team Mentoring
• Strategic Decision Making
• Business Requirement Analysis
Notes:
Experience Required & Mandatory Skill
8+ Years Data Analytics / Business Intelligence / Reporting / Data Warehousing
8+ Years Advanced SQL Development
8+ Years SQL Query Optimization & Performance Tuning
8+ Years Data Modeling & Database Design
8+ Years Dimensional Modeling
5+ Years Power BI Dashboard & Report Development
5+ Years Tableau Dashboard & Report Development
5+ Years BI Architecture & Reporting Solutions
5+ Years Executive Reporting & KPI Framework Design
5+ Years Semantic Models, Data Sets & Data Marts
5+ Years Reporting Governance & BI Best Practices
3+ Years Large-Scale Data Analysis
3+ Years Stakeholder Management & Business Requirement Analysis
3+ Years Technical Leadership & Team Mentoring
3+ Years Enterprise Reporting Solution Delivery
Primary Skills
Advanced SQL
Power BI
Tableau
Data Modeling
Performance Tuning
BI Architecture
Dashboard Development
Reporting Governance
Executive Reporting
Technical Leadership
Preferred Domain Experience
Healthcare
Health Insurance
Financial Services
Other Highly Regulated Industries
Nice to Have Skills
Azure Data Services
AWS Analytics Services
Databricks
Snowflake
ETL/ELT Frameworks
Python
Data Governance
AI/ML Analytics
Agile & DevOps Methodologies
Domain Experience (If any ) - Good to have healthcare experience
Must have Certifications - None
Location -Mason, OH
Onsite Requirement - Hybrid/Remote
Number of days onsite -