Senior Data & BI Automation Analyst

Obviant•Arlington, VA

20h

About The Position

As a Senior Data & BI Automation Analyst at Obviant, you will lead analytics and data pipeline initiatives that scale decision-making, streamline internal workflows, and improve business performance. You will design automated reporting frameworks, build reliable data delivery mechanisms, and replace manual workflows with resilient, self-service data systems. The role includes architecting and maintaining automated reports, dashboards, and data pipelines; auditing manual reporting processes and turning them into production-grade automated workflows; and partnering with business leaders, cross-functional teams, and government partners to understand operational needs and deliver scalable analytics solutions. You will work closely with Data Engineering on analytical data models, transformations, and scheduled ELT/ETL jobs, and collaborate with Product, Marketing, and Operations to make data insights clear and actionable. You will also help expand data strategy and architecture through automated data quality frameworks, monitoring systems, and scalable metrics trees. Success requires end-to-end ownership of automation projects, strong technical skills, and the ability to communicate effectively with technical and non-technical stakeholders.

Requirements

At least 4 years of professional experience in data analytics, BI engineering, or data automation, with a track record of automating operational workflows.
Advanced proficiency in SQL and experience with modern transformation tools such as dbt for scheduled, production-grade data models.
Strong Python programming skills, including experience with libraries and tools for API integration, data manipulation, and task automation.
Hands-on experience building automated, self-service BI dashboards and semantic layers using enterprise tools such as Looker, Tableau, or Power BI.
Ability to communicate complex architectures and data models as clear, actionable narratives for technical and non-technical stakeholders.
Strong project management skills and ability to own automation projects end to end.
Ability to thrive in an ego-free, collaborative, fast-paced environment.

Nice To Haves

A degree in Computer Science, Information Systems, Mathematics, Statistics, Economics, or a field with a strong quantitative or technical focus is preferred.
Experience with Pandas, Airflow, Prefect, or custom cron jobs.

Responsibilities

Architect, deploy, and maintain automated reporting frameworks, self-updating dashboards, and data delivery pipelines using modern BI tools and orchestrators.
Audit manual reporting processes across teams and replace fragmented spreadsheets and ad-hoc queries with automated, production-grade scripts and data workflows.
Work with business leaders, cross-functional teams, and government partners to conduct analytics, understand operational workflows, and translate business needs into scalable automated solutions.
Partner with Data Engineering to design and optimize analytical data models, automated data transformations, and scheduled ELT/ETL jobs.
Collaborate with Product, Marketing, and Operations to turn complex data models into clear, actionable, self-service business insights.
Develop automated data quality frameworks, monitoring systems, and scalable metrics trees.
Own automation projects from initial scoping and architecture through execution and stakeholder adoption.