Lead Data Visualization Designer

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

SALARY: $79,788.80 - $93,870.40

LOCATION: 33 N. High St. Columbus, OH 43215

BENEFITS:

• Medical, Vision, Dental, Supplemental and 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 Program
• Public Pension through OPERS & Ohio Deferred Compensation

POSITION SUMMARY:

COTA's Lead Data Visualization Designer serves as the organization's technical expert for Power BI, responsible for enforcing enterprise standards, managing the analytics portfolio, and ensuring data quality and governance. This role partners with business and IT teams to deliver scalable, high-impact analytics solutions while driving modernization, automation, and adoption of emerging analytics capabilities.

Performs duties that advance COTA's Strategic Plan and reflect the organization's core values of safety, empowerment, accountability, teamwork, and service, and support the mission of Moving Every Life Forward.

ESSENTIAL JOB FUNCTIONS:

• Serves as the organization's senior Power BI authority, establishing and enforcing enterprise standards for dashboard design, governance, documentation, deployment, and data connectivity to ensure consistency, scalability, and quality.
• Leads the Power BI portfolio by managing intake, prioritization, lifecycle management, and performance monitoring to ensure transparency and reliability across analytics assets.
• Drives data governance maturity by identifying recurring data issues, defining quality standards, establishing monitoring and remediation workflows, and escalating risks to leadership and governance councils.
• Acts as a trusted analytics consultant to business and IT partners, advising on dataset design, architecture alignment, and solution tradeoffs while translating technical concepts into clear business narratives.
• Develops semantic models and data structures informed by deep understanding of business processes, application workflows, and analytical requirements.
• Conducts data discovery, profiling, and root cause analysis on priority data assets, partnering with IT to resolve data issues and ensure infrastructure and ETL processes support analytics needs.
• Serves as the organization's Power BI and SQL subject matter expert, mentoring analysts, guiding administrative resources, and delivering training to support consistent and effective BI adoption.
• Leads innovation and continuous improvement initiatives by evaluating emerging analytics capabilities-including AI‑enabled features such as Copilot‑and recommending enhancements to BI tools, data architecture, and automation practices.
• Presents clear, actionable data stories to technical and non‑technical audiences, including senior leadership.
• Leads internal outreach to expand data literacy, improve access to analytics, and support adoption of BI solutions across the organization.
• Partners with business units to implement improved reporting processes and coordinates post‑implementation support, including end‑user feedback and solution refinement.
• Maintain advanced Power BI expertise and certifications, serving as the organization's go-to expert for administration, advanced functionality, and enterprise analytics strategy.
• Regular, predictable and punctual attendance required; and,
• Performs other duties as assigned.

MINIMUM EDUCATION & EXPERIENCE REQUIRED:

• Requires a Bachelor's Degree in Information Systems, Data Analytics, Computer Science, Business Administration, or a related field and five (5) years' experience in business intelligence, data analytics, or data engineering roles with hands‑on responsibility for report development, data modeling, and analytics delivery. An equivalent combination of education/training and relevant data analytics experience will also be considered.

LICENSES & CERTIFICATIONS:

• Power BI certification preferred.

COTA is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. All employment decisions are based on job needs, job requirements and individual qualifications, without regard to race, color, religion or belief, sex, sexual orientation, age, genetic information, gender identity, national origin, veteran or disability status