BI Engineer

SiloSmashers • Arlington, VA

1d • Onsite

About The Position

SiloSmashers is hiring a lead Business Intelligence (BI) Engineer to support a government customer. The role is responsible for architecting, designing, developing, governing, and sustaining dashboards, analytic visualizations, and decision-support experiences across a Databricks-enabled unified data platform and approved BI tools. The BI Engineer serves as the lead technical authority for enterprise BI solutions, including semantic modeling, metric-layer design, and secure publishing of dashboards and insights. The position collaborates with the Project Manager/Contractor Lead, federal technical teams, and platform, SRE, governance, privacy, and development personnel to ensure visualizations and integrations are accurate, performant, secure, and compliant.

Regular, physical attendance at customer sites is required. The BI Engineer Lead must be available to the customer by telephone from 0900 to 1700 EST, Monday through Friday.

Requirements

• Ability to obtain and maintain a Public Trust clearance.
• At least five years of experience building and operating production-grade visualizations or dashboards, with at least four of those years within the last six years.
• Experience with at least two of the following: Power BI, Tableau, Kibana/Elastic, Databricks Dashboards, or custom web UI dashboards such as React, Vue, or D3.
• Bachelor’s degree in information systems, computer science, engineering, analytics, or a related field, or eight years of total equivalent experience in lieu of a degree.
• At least one of the following certifications: Microsoft Power BI Data Analyst Associate (PL-300) or successor; Tableau Certified Data Analyst, or Tableau Desktop Specialist with demonstrable experience; Elastic Certified Analyst (Kibana); or Qlik Sense Business Analyst (QSBA).
• Hands-on experience with SQL queries and medallion data patterns (bronze/silver/gold), including authoring SQL views and BI-ready tables that conform to governance and privacy controls.
• Proficiency with Git-based workflows such as GitHub Enterprise or Azure DevOps for BI assets, versioning datasets, dashboards, and deployment scripts.
• Familiarity with declarative bundles or CI/CD for promoting BI assets across development, test, and production environments.
• Regular, physical attendance at customer sites.
• Availability by telephone to the customer from 0900 to 1700 EST, Monday through Friday.

Nice To Haves

• Databricks Lakehouse Fundamentals or Databricks SQL credentials.
• Databricks Data Engineer Associate or Professional certification for candidates with strong data-modeling responsibilities.
• Cloud certifications, such as AWS or Azure associate-level credentials, relevant to BI or data services.

Responsibilities

• Serve as the principal BI and visualization authority, owning end-to-end dashboard design patterns, accessibility and usability standards, data-to-visual mapping, and visual quality assurance.
• Design and deliver BI solutions using platforms such as Power BI, Tableau, Kibana, and Databricks Dashboards.
• Author governed semantic models, calculation logic, and BI-ready datasets sourced from Lakehouse tables and Databricks SQL Warehouses; implement row- and column-level security and governed tags through Unity Catalog.
• Establish patterns for incremental refresh, Direct Query or live connections, and aggregation tables to balance freshness, performance, and cost.
• Partner with Data Engineering to apply medallion architecture conventions and ensure upstream tables and views meet BI performance and governance requirements, including schema stability and quality checks.
• Coordinate with Privacy and Governance teams to enforce Unity Catalog RBAC/ABAC, governed tags, lineage capture, and data-sharing rules in BI tools and export pathways; ensure PTA/PIA/SORN considerations are reflected in visualization features and sharing modes.
• Provide operational support and incident response for BI assets, including root-cause analysis of refresh and query failures, change-related regressions, and access issues; maintain runbooks, monitoring, and alerts for dataset, warehouse, and usage health.
• Lead stakeholder enablement through demonstrations, office hours, and training on dashboard usage and interpretation; maintain data dictionaries, metric definitions, and usage guides.
• Mentor BI engineers and analysts and enforce BI quality gates, including peer reviews, DAX/SQL test coverage, visualization accessibility checks, and reproducible deployments consistent with program DevSecOps practices.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior