Senior Power BI & Automate Analytics Leader

Trillion Technology Solutions, Inc.; Reston (OR); On-site; USD 120,000 - 190,000; Full time

Job summary

Trillion Technology Solutions, Inc. seeks a Senior Power BI and Power Automate Developer to join a critical DoW program.

The role focuses on designing and building BI solutions across the unclassified network, including data models, semantic layers, and optimized queries using Databricks SQL, Spark SQL, and Power BI. You will collaborate with engineering, cybersecurity, and governance teams to ensure data integrity, enforce security on dashboards, and train analysts in advanced analytics

Qualifications

• Experience in business analytics tools and dashboards.
• Power BI reporting including M Query, DAX, data modeling, and Row-Level Security.
• Strong SQL skills, preferably SQL Server.
• Analytical thinking to convert data into reports and graphics.
• Ability to integrate multiple data sources and work in an agile environment.
• Self-starter capable of rapid adaptation.

Responsibilities

• Prototype, design, develop, and publish Power BI reports and data models.
• Develop automated reporting frameworks using mission telemetry and performance metrics.
• Create dashboards with drill-down analytics, predictive components, and alerts linked to Jira, Confluence, SharePoint, SolarWinds, ServiceNow, MS Project, and Splunk.
• Lead data quality analytics including source-to-target validation and anomaly triage.
• Collaborate with engineering, cybersecurity, and governance teams on data integrity and access controls.
• Produce analytic specifications, metric dictionaries, and test protocols.
• Conduct training for analysts and mission partners to raise analytic literacy.
• Drive modernization via new BI tools, federated catalog integrations, and automated workflows.
• Gather business requirements with Business Analysts and optimize SQL queries.
• Ensure dashboard security and adherence to security requirements.

Skills

Power BI

Power Automate

DAX

SQL Queries

Data Modeling

Agile

TS/SCI clearance

Education

BS in Computer or Data Science

Tools

Jira

Confluence

SharePoint

SolarWinds

ServiceNow

MS Project

Splunk

Databricks SQL

Spark SQL

Job description

Trillion Technology Solutions, Inc. seeks a Senior Power BI and Power Automate Developer to join a critical DoW program.

The role focuses on designing and building BI solutions across the unclassified network, including data models, semantic layers, and optimized queries using Databricks SQL, Spark SQL, and Power BI. You will collaborate with engineering, cybersecurity, and governance teams to ensure data integrity, enforce security on dashboards, and train analysts in advanced analytics