Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
CI
Compunnel, Inc.
Data & BI Professional
Career Insights for Business Intelligence Developer / Architect
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on Ohio data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A Business Intelligence Developer or Architect develops and builds technology systems that support business intelligence for a company. Identifies software needed for business intelligence analysts; sets up systems for collecting data on business operations, customers or sales.
$106,014 / year median in Ohio
-7% projected decline
Job Description
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