Senior Power BI and Power Automate Architect

Trillion Technology Solutions, Inc; Reston (VA); 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 design and develop advanced BI solutions supporting the DoW program.

You will create analytic data models, semantic layers, and optimized queries using Databricks SQL, Spark SQL, and Power BI within a TS/SCI environment. The role requires collaboration with engineering, cybersecurity, and governance teams to ensure data integrity, security, and compliant reporting, while driving modernization and

Qualifications

• BS in Computer or Data Science or related field.
• 10+ years of related experience.
• TS/SCI security clearance; US citizenship.

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 tied to Jira, Confluence, SharePoint, SolarWinds, ServiceNow, MS Project, and Splunk.
• Lead data quality analytics including profiling, completeness scoring, drift detection, and anomaly triage.
• Collaborate with engineering, cybersecurity, and governance teams to validate data integrity controls.

Skills

Power BI

Power Automate

Data modeling

SQL queries

Agile

Analytics tools

Education

BS in Computer or Data Science

Tools

Jira

Confluence

SharePoint

SolarWinds

ServiceNow

Splunk

Job description

Trillion Technology Solutions, Inc. seeks a Senior Power BI and Power Automate Developer to design and develop advanced BI solutions supporting the DoW program.

You will create analytic data models, semantic layers, and optimized queries using Databricks SQL, Spark SQL, and Power BI within a TS/SCI environment. The role requires collaboration with engineering, cybersecurity, and governance teams to ensure data integrity, security, and compliant reporting, while driving modernization and