Senior Power BI Developer
Trillion Technology Solutions, Inc · Reston, VA · 3 wk ago
Information TechnologyFull-time
Leidos is seeking a Senior Power BI and Power Automate Developer to join a critical Department of Warfighting (DoW) program. The role involves designing and developing advanced business intelligence solutions that support the customer’s mission, with a focus on analytics across an unclassified network environment, building analytic data models, semantic layers, and optimized query structures using Databricks SQL, Spark SQL, and Power BI.
Responsibilities
- Prototype, design, develop, and publish Power BI reports; develop Power BI data models; recommend best practices for report creation and visualizations.
- Develop automated reporting frameworks that leverage mission telemetry, operational readiness indicators, pipeline performance metrics, and tool‑utilization signals.
- Create dashboards with drill‑down analytics, predictive components, and alerting pathways connected to Jira, Confluence, SharePoint, SolarWinds, ServiceNow, MS Project, and Splunk.
- Lead data‑quality analytics by performing source‑to‑target validation, statistical profiling, completeness scoring, drift detection, and anomaly triage.
- Collaborate with engineering, cybersecurity, and governance teams to validate data‑integrity controls, encryption policies, and access mechanisms.
- Produce analytic specifications, metric dictionaries, and test protocols that guide downstream implementation.
- Conduct training for analysts and mission partners to elevate enterprise analytic literacy.
- Drive continual modernization through evaluation of new BI tools, visualization enhancements, federated catalog integrations, and automated analytic workflows.
- Partner 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.
- Implement security on developed dashboards in accordance with security and access requirements.
- Ensure Agile/Scrum practices are followed during development.
- Evaluate self‑service reporting and dashboard tools.
- Estimate work content and achieve planned timelines.
Required Skills
- Experience with business analytics tools and developing reporting and dashboards.
- Proficiency in Power BI reporting and analytics, including M Query, DAX, data modelling, and row‑level security.
- Strong SQL query writing skills and experience with database technologies, preferably SQL Server.
- Analytical thinking for converting data into relevant reports and graphics.
- Understanding of implementing solutions with multiple data sources.
- Experience working with Agile methodology; 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.
- 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.
- Ability to multitask effectively across projects.
- Capability to work independently and cooperatively as part of a team.
- Analytical and complex problem‑solving skills.
Education and Experience
- Bachelor of Science in Computer or Data Science or a related field.
- 10+ years of related experience.
Security Clearance
TS/SCI clearance required; U.S. citizenship mandatory.