Power BI Engineer

AVATAR Computing, Inc.; Worcester (MA); On-site; USD 85,000 - 110,000; Full time

Job summary

A technology firm supporting military applications is seeking an experienced Power BI Engineer to develop interactive dashboards and ensure secure data access. The ideal candidate holds a Bachelor's degree in Computer Science, has 3-5 years of Power BI experience, and possesses an Active Secret Clearance. Responsibilities include implementing data security, optimizing data transformations, and providing user training. This role is essential for data compliance and security in military applications.

Qualifications

• 3-5+ years of experience in data preparation, data modeling, and reporting using Power BI.
• Strong knowledge of SQL, Data Modeling (star schemas), and DAX.
• Active Secret Clearance Required.

Responsibilities

• Design, develop, and maintain advanced interactive dashboards using Power BI.
• Develop complex DAX queries for advanced data analysis.
• Implement Row-Level Security in Power BI.

Skills

Data Preparation

Data Modeling

Power BI

DAX

SQL

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Azure SQL

Azure Data Services

Job description

Description

Avatar Computing is seeking an experienced Power BI Engineer to support the Army's Enterprise Application/System Modernization and Migration (EAMM) program. You will ensure that sensitive business data is accessible only to authorized users, automating access requests and audit workflows within the Power BI environment.

Key Responsibilities:

• Design, develop, and maintain advanced interactive dashboards, reports, and KPIs using Power BI Desktop and Service
• Develop complex Data Analysis Expressions (DAX) queries and calculated measures for advanced data analysis
• Create data models, define relationships, and optimize data transformation processes using Power Query
• Implement Row-Level Security (RLS) and Column-Level Security in Power BI to ensure proper data access controls
• Integrate Power BI workspaces with Active Directory (Azure AD/Entra ID) to manage user access and permissions
• Develop audit reports to track user access, usage, and permission changes, supporting compliance requirements (GDPR, SOX)
• Collaborate with the InfoSec team to integrate Power BI report access with IGA tools (e.g., SailPoint, Saviynt) for automated access certification
• Optimize Data Gateways and Power BI reports for performance and scalability
• Provide training and documentation to end-users on data security policies

Qualifications

• US Citizen (No Dual Citizens)
• Active Secret Clearance Required
• Security+ or equivalent certification
• Bachelor's degree in Computer Science, Information Technology, or a related field
• 3-5+ years of experience in data preparation, data modeling, and reporting using Power BI
• Strong knowledge of SQL, Data Modeling (star schemas), and DAX
• Demonstrated experience in implementing data security, Row-Level Security (RLS), and Azure AD integration
• Understanding of data governance principles and compliance standards
• Experience integrating Power BI with IGA tools (e.g., SailPoint) preferred
• Experience with Azure Data Services (Azure SQL, Synapse) preferred
• Knowledge of Power Automate for automating data alerts and compliance workflows preferred

Avatar Computing is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.