Senior Data & BI Automation Analyst

Senior Data & BI Automation Analyst 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. 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. 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. 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 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