THE CHALLENGE AHEAD 

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.

WHAT YOU’LL DO 

Reporting Automation & Data Process Improvements

• 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.

Data Investigation & Quality Assurance

• 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.

Campaign & Client-Facing Analytics

• 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.

Cross-Functional Collaboration

• 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.

WHAT YOU’LL BRING 

• 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.

WHAT WE’D CONSIDER A BONUS 

• 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

WHY YOU’LL LOVE WORKING AT KERV

• We are a team of talented, kind people, driven by innovation.
• We put the human first. Whether our employee, client, partner, or community; we genuinely care about your well-being and will do whatever we can to support it.
• We are relentless in our pursuit of innovation, remaining flexible and open to change, remaining scrappy and collaborative in pursuit of common goals.
• We balance our dedication to success with the accountability to deliver, trusting our expertise, while verifying our thinking at every step.
• We advocate for the growth and success of our people and the communities in which they belong to through transparent & clear communication, championing a culture in which everyone has a voice and contributes to our success, and a socially aware approach to everything we touch.
• We aim to cultivate a work environment where each person, no matter the identities they hold, not only feels safe, seen, and heard, but also celebrated.
• We offer…
• 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.

KERV provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. KERV participates in E-Verify to confirm the employment eligibility of all new hires.