Lead, BI Solutions

KERV • Austin, TX

9d • $125,000 - $135,000 • Hybrid

About The Position

We are seeking a BI Solutions Architect who will play a critical role in building automated reporting pipelines, implementing testing and monitoring for data quality issues, and assembling complex client-facing analytical deliverables—such as PLD (Physician-Level Data) reporting for pharmaceutical partners and other specialized campaign analytics.
This role is ideal for someone who enjoys solving data problems end-to-end: from digging into raw datasets, to packaging insights into dashboards and reports used by internal stakeholders and clients.

Requirements

• 4+ years experience in BI, analytics engineering, data analysis, or a closely related role.
• Strong SQL skills (e.g., BigQuery, Snowflake, Redshift) with ability to write complex queries efficiently.
• Comfort leveraging AI platforms to solve challenges and supercharge productivity
• Experience with dashboarding tools (e.g., Looker, Tableau, Power BI, Mode).
• Familiarity with Python for data extraction, transformation, and automation is a plus.
• Comfortable working with large datasets, multiple data sources, and ambiguous or imperfect data environments.
• Excellent communication skills, with the ability to translate complex technical findings into business-friendly explanations.

Nice To Haves

• Prior experience with digital advertising datasets, DSP platforms, and the larger digital ad ecosystem is a plus
• Prior work in a high-growth startup or ad-tech environment

Responsibilities

• Design, build, and maintain automated dashboards, recurring reports, and data workflows that support operational and client needs.
• Improve existing reporting processes for reliability, accuracy, and scalability to minimize manual touchpoints.
• Collaborate with Engineering and Product teams to define and standardize key metrics and data models used across KERV’s analytics ecosystem.
• Lead deep-dive investigations into data irregularities, discrepancies, or performance anomalies across KERV’s dynamic ad products.
• Serve as a point of escalation for data accuracy questions, proactively debugging pipeline issues and proposing solutions.
• Develop automated QA checks, anomaly detection rules, and monitoring processes.
• Assemble complex, multi-source reporting packages—including PLD-style reporting—for pharmaceutical and other enterprise clients.
• Translate campaign-level data into clear insights, summaries, and visualizations that support client objectives.
• Partner with Client Success and Sales to scope custom reporting needs and ensure timely, accurate delivery.
• Work closely with Data Engineering, Ad Operations, and Product teams to define requirements, troubleshoot data flows, and improve data accessibility.
• Participate in documentation of reporting logic, business rules, and data lineage for internal teams.

Benefits

• Unlimited PTO with a healthy culture of taking time off to recharge so you can bring your best self to work
• Competitive compensation packages
• Comprehensive health and wellness benefits including modern support services via Bennie, such as a custom app and healthcare concierge to support a simplified benefits experience for our staff
• Mental Health Support via Samata Health paid 100% by KERV
• 401K with company match and 100% vesting on day 1
• Unlimited referral bonuses
• Flexible working schedules with remote and hybrid opportunities
• Fitness Reimbursement Program
• “Moments that Matter” program, centered around our heart-centered value, which celebrates and supports employees through life’s biggest wins, transitions, and challenges — because at KERV, we show up for each other beyond just the work.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 11-50 employees