Senior Data & BI Automation Analyst

AI Chopping Block, Inc.; Arlington, Northern (VA, KY); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Equity

Flexible schedule

Work from home option

Flexible vacation

Health, dental, and vision insurance

Job summary

Obviant seeks a Senior Data & BI Automation Analyst to lead analytics and automation initiatives, designing self‑service reporting and robust data delivery systems. You will replace manual workflows with scalable, automated processes and collaborate with cross‑functional teams to deliver actionable insights.

You will partner with Data Engineering to optimize data models and scheduled ELT/ETL jobs (dbt, Airflow), while championing automated data quality and scalable metrics in a fast‑paced

Qualifications

• 4+ years of professional experience in data analytics, BI engineering, or data automation, with a proven track record of automating operational workflows.
• Degree in Computer Science, Information Systems, Mathematics, Statistics, Economics, or a strong quantitative/technical field preferred.
• Advanced proficiency in SQL and experience with modern transformation tools (dbt) for production‑grade data models.
• Strong Python skills for API integration, data manipulation, and automation (Pandas, Airflow, Prefect).
• Hands‑on experience with modern BI tools and self‑service dashboards (Looker, Tableau, Power BI).
• Ability to distill complex automated architectures into clear business narratives for technical and non‑technical stakeholders.

Responsibilities

• Lead analytics and data pipeline initiatives that scale decision making and automate reporting frameworks.
• Audit and replace manual reporting with automated, production‑grade data workflows and self‑updating dashboards.
• Interface with business leaders and cross‑functional teams to translate needs into scalable automated solutions.
• Collaborate with Data Engineering to design analytic data models and scheduled ELT/ETL jobs (dbt, Airflow).
• Translate complex data models into actionable, self‑service business insights for Product, Marketing, and Operations.
• Pioneer automated data quality frameworks and scalable metrics for company growth.

Skills

SQL

dbt

Python

Airflow

Prefect

Looker

Tableau

Power BI

API integration

Pandas

Education

BS in Computer Science or related field

Tools

dbt

Airflow

Looker

Tableau

Power BI

Job description

About the Role

As a Senior Data & BI Automation Analyst at Obviant, you will lead high-impact analytics and data pipeline initiatives that scale our decision-making capabilities, streamline internal workflows, and optimize overall business performance. You will act as a trusted technical partner, designing automated reporting frameworks, building robust data delivery mechanisms, and replacing manual workflows with resilient, self-service data systems for Obviant.

What You’ll Do

• BI Automation & Scalable Systems: Architect, deploy, and maintain automated reporting frameworks, self-updating dashboards, and data delivery pipelines using modern BI tools and orchestrators.

• Workflow & Process Optimization: Audit existing manual reporting processes across teams, replacing fragmented spreadsheets and ad-hoc queries with automated, production-grade scripts and data workflows to determine requirements for fully automated systems.

• Stakeholder Alignment & Delivery: Interface directly with business leaders, cross-functional teams, and government partners to conduct targeted analytics, understand operational workflows, and translate complex business needs into scalable, automated solutions.

• Data Pipeline Collaboration: Partner closely with Data Engineering to design and optimize analytical data models, automated data transformations, and scheduled ELT/ETL jobs (e.g., via dbt or Airflow).

• Cross-Functional Analytics: Collaborate with Product, Marketing, and Operations teams to translate complex, automated data models into clear, actionable, self-service business insights.

• Data Strategy & Architecture Expansion: Pioneer automated data quality frameworks, monitoring systems, and scalable metrics trees as obviant.com continues to expand.

What You Need

• Experience: 4+ years of professional experience in data analytics, BI engineering, or data automation, with a proven track record of automating operational workflows.

• Education: Degree in Computer Science, Information Systems, Mathematics, Statistics, Economics, or a field with a strong quantitative/technical focus preferred.

• Data & Transformation Mastery: Advanced proficiency in SQL and experience with modern transformation layer tools (e.g., dbt) for building scheduled, production-grade data models.

• Automation & Scripting: Strong programming skills in Python using libraries for API integration, data manipulation, and task automation (e.g., Pandas, Airflow, Prefect, or custom cron jobs).

• Modern BI & Visualization: Deep hands‑on experience setting up automated, self‑service BI dashboards and semantic layers using enterprise tools (e.g., Looker, Tableau, Power BI).

• Communication & Storytelling: Proven ability to distill complex automated architectures and data models into clear, actionable business narratives for both technical and non‑technical stakeholders.

• End-to-End Ownership: Strong project management skills with the ability to take an automation project from initial scoping and architecture design through execution and stakeholder adoption.

• Culture Fit: Ability to thrive in an ego‑free, highly collaborative, and fast‑paced environment.

Our Principles

We live these every day. If they don't sound like you, this won't be a fit and we'd both rather know now.

• Impact. Our work matters. We take a lot of pride in building to advance mission outcomes.

• Overdeliver. We go above and beyond in everything we do - creating products and serving our users

• Hustle. We get stuff done, no matter what it takes.

• Empathy. Our users’ problems are our own. We don't push products, we solve problems.

• Humility. We’re not afraid to admit what we don’t know. Our job is to listen and grow.

• Integrity. Transparency & respect above all else. It’s non‑negotiable, even when it isn't easy

Benefits & Structure

• We’re a tight‑knit team headquartered in Arlington, VA. We work in the office together most days, and believe being in the same place is a competitive advantage.

• Flexible schedule - We all have other things going on in our lives. Doctor visits, kids’ activities, dog walks - take care of it whenever you have to. And work from home when you need to.

• Sizeable equity - We’re building something with massive upside potential, and you’ll have ownership in that. This is ours.

• Flexible vacation time - Use what you want, as long as you’re taking care of what needs to get done.

• Full health, dental, and vision insurance.

Obviant is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.