Senior Power BI Developer

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

The Leidos team is seeking a Senior Power BI and Power Automate Developer to join a critical DoW program. The Senior Power BI and Power Automate Developer will play a critical role in designing and developing advanced business intelligence solutions supporting the customer's mission. In this role, it will help with analytics across the unclassified network environment. This role also entails building analytic data models, semantic layers, and optimized query structures using Databricks SQL, Spark SQL, and Power BI.

Security clearance level: TS/SCI

Job Duties

• Prototyping, designing, developing, and publishing Power BI Reports, developing Power BI Data models, and recommending best practices for report creation and visualizations.
• Develops automated reporting frameworks that leverage mission telemetry, operational readiness indicators, pipeline performance metrics, and tool utilization signals.
• Develop dashboards with drill-down analytics, predictive components, and alerting pathways connected to Jira, Confluence, SharePoint, SolarWinds, ServiceNow, MS Project, and Splunk.
• Leads data quality analytics by performing source-to-target validation, statistical profiling, completeness scoring, drift detection, and anomaly triage.
• Collaborates with engineering, cybersecurity, and governance teams to validate data integrity controls, encryption policies, and access mechanisms.
• Produces analytic specifications, metric dictionaries, and test protocols that guide downstream implementation.
• Conducts training for analysts and mission partners to elevate enterprise analytic literacy.
• Drives continual modernization through evaluation of new BI tools, visualization enhancements, federated catalog integrations, and automated analytic workflows.
• Collaborate with Business Analysts to gather business requirements for analytics and reporting.
• Troubleshoot reporting issues and tune report performance.
• Create and modify database tables and views. Review plans to optimize SQL queries.
• Responsible for implementing security on developed Dashboards in accordance with security and access requirements.
• Ensure agile/scrum practices are followed during the development process.
• Evaluate self-service reporting and dashboard tool.
• Responsible for estimating work content and achieving planned timelines.

Required Skills

• Experience in Business Analytics tools, developing Reporting and Dashboards.
• Experience in Reporting and Analytics using Power BI - M Query, DAX, Data Modelling, Row Level Security.
• Experience in database technologies and strong SQL query writing skills, preferably SQL Server.
• Analytical thinking for converting data into relevant reports and graphics.
• Understanding of how to implement solutions with multiple data sources.
• Experience working with Agile methodology and a self-starter who can quickly acclimate to a dynamic environment.

Preferred Skills

• Strong foundational knowledge of the Microsoft 365 platform, including AWS and the Azure ecosystem.
• Demonstrate an understanding of security concepts, including access control and data security.
• Subject Matter Expert in visualization, Power BI, and Power Automate.
• Strong interpersonal and communication skills.
• Multi-task effectively between projects.
• Ability to work independently and cooperatively as part of a team.
• Must possess analytical and complex problem-solving skills.

Education: BS in Computer or Data Science or related field.

Experience: 10+ years of related experience

Security clearance level: TS/SCI, US citizenship required

Trillion is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local law.