Power BI Engineer
About The Position
IPTA's Technology Solutions Team focuses on providing customers with technical solutions that meet their business needs through collaborative interactions with various stakeholders. As a member of this group, you will work with a team of technologists to deliver innovative business solutions using emerging technologies. The team seeks talented individuals passionate about applying technology to achieve innovative outcomes with determination, integrity, and service, emphasizing continuous learning and career growth. This role is for an experienced Power BI Developer who will ensure sensitive business data is accessible only to authorized users by automating access requests and audit workflows within the Power BI environment.
Requirements
- US Citizen (No dual citizens)
- Active Secret Clearance Required
- Possession of Security+ or equivalent
- 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
Nice To Haves
- Experience integrating Power BI with IGA tools (e.g., SailPoint)
- Experience with Azure Data Services (Azure SQL, Synapse)
- Knowledge of Power Automate for automating data alerts and compliance workflows
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 users only see data they are authorized to access
- 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 within Power BI, 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
- Collaborate with stakeholders to gather reporting requirements and translate them into technical specifications
- Optimize Data Gateways and Power BI reports for performance and scalability
- Provide training and documentation to end-users on data security policies within the reporting environment
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
101-250 employees
