BI Engineer

SiloSmashers•Arlington, VA

7d•Onsite

About The Position

SiloSmashers is hiring a lead Business Intelligence Engineer to support a government customer. The role architects, designs, develops, governs, and sustains 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 role works closely with the Project Manager / Contractor Lead, federal technical teams, and cross-task platform, SRE, governance, privacy, and development personnel. It ensures visualizations are accurate, performant, secure, and compliant across platforms and integrations, including Power BI and Databricks Dashboards. The BI Engineer Lead must be available to the customer by telephone from 0900 to 1700 EST, Monday through Friday. Regular, physical attendance at customer sites is required.

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 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 total years of 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).
For the Elastic Certified Analyst (Kibana) option, demonstrated expertise building Kibana dashboards and Lens visualizations, writing KQL queries, and using anomaly detection.
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, including versioning datasets, dashboards, and deployment scripts.
Familiarity with declarative bundles and CI/CD for promoting BI assets across development, test, and production environments.
Regular, physical attendance at customer sites.

Nice To Haves

Databricks Lakehouse Fundamentals or Databricks SQL credentials.
Databricks Data Engineer Associate or Professional certification for candidates with strong data-modeling responsibilities.
Relevant associate-level cloud certifications, such as AWS or Azure.

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 QA processes.
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-level 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 within 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 or query failures, change-related regressions, and access issues.
Maintain runbooks, monitoring, and alerts for dataset and warehouse health and usage.
Conduct demos, 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.