Power BI Engineer

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.

• 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 work spaces with Active Directory (Azure AD/Entra ) 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 Info Sec 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

• 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.