Lead Data & BI Automation Analyst
Obviant
Lead Data & BI Automation Analyst
Obviant
Provides Excel-based project cost planning templates
About the Role As a Lead 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.
Compensation:
This role has a compensation range of $110,000 - $155,000 annually.
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
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.
To apply, visit obviant.com/careers
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.
Obviant provides Excel-based templates for project cost planning and budget management. The templates let users build detailed cost breakdowns, track expenses, and generate reports to give a clear financial overview of projects. The product works by users entering project data into organized Excel templates, which then compute budgets, monitor variances, and produce summary reports. This approach differs from competitors by offering a simple, affordable, and widely accessible solution that relies on Excel rather than complex, costly project management software. Obviant’s goal is to help project managers and businesses gain better cost control and financial visibility through easy-to-use spreadsheet templates.
Explore more opportunities at Obviant