Senior Power BI & Data Visualization Lead

OhioX; Columbus (OH); On-site; USD 80,000 - 94,000; Full time

Benefits offered by this job

Medical Insurance

Vision Insurance

Dental Insurance

Supplemental Insurance

Life Insurance

Paid Parental Leave

Employee Discounts

COTA Bus Pass

Wellness Initiatives

On-Site Chair Massage

On-Site Health Coach

Tuition Reimbursement

Student Loan Repayment

Public Pension (OPERS)

Ohio Deferred Compensation

Job summary

The Central Ohio Transit Authority (COTA) in Columbus, OH, is seeking a Lead Data Visualization Designer to serve as the organization's Power BI expert, enforcing enterprise standards and delivering scalable analytics solutions.

You will partner with business and IT to drive modernization, automation, data quality, and adoption of analytics capabilities, shaping governance and data storytelling for executive audiences.

Qualifications

• Bachelor's degree in information systems, data analytics, CS or related field.
• 5+ years in BI, data analytics, or data engineering with hands-on report development and data modeling.
• Equivalent combination of education and experience considered.

Responsibilities

• Establishes and enforces enterprise standards for dashboards and data connectivity.
• Manages Power BI portfolio from intake to lifecycle management and analytics asset reliability.
• Drives data governance maturity with quality standards and remediation workflows.
• Advises business and IT on dataset design and architecture tradeoffs; translates concepts for stakeholders.
• Develops semantic models and data structures aligned to business processes.
• Performs data discovery, profiling, and root-cause analysis with IT to support analytics.
• Mentors analysts and provides BI training to ensure adoption.
• Evaluates emerging analytics capabilities and recommends enhancements to BI tools.
• Delivers clear data narratives to senior leadership.

Skills

Power BI

Data governance

Data modeling

Analytics delivery

SQL

Mentoring

Education

Bachelor's degree in Information Systems/Data Analytics/CS/Business Admin

Tools

SQL Server

ETL

Job description

The Central Ohio Transit Authority (COTA) in Columbus, OH, is seeking a Lead Data Visualization Designer to serve as the organization's Power BI expert, enforcing enterprise standards and delivering scalable analytics solutions.

You will partner with business and IT to drive modernization, automation, data quality, and adoption of analytics capabilities, shaping governance and data storytelling for executive audiences.