Senior Power BI Developer

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

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.