What are the responsibilities and job description for the Power BI Developer (Secret clearance) position at System One?
Power BI Developer
Secret clearance
Fort Belvoir, VA – hybrid preferred
Must have Security or equivalent certification
Required Qualifications:
• 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.
Preferred Skills:
• 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.
We are seeking an experienced Power BI Developer to join our team. The ideal candidate 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:
1. Power BI Development & Visualization
• 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.
2. IGA (Identity Governance & Administration) & Data Security
• 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.
3. Collaboration & Data Management
• 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.
Required Qualifications:
• 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.
Preferred Skills:
• 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.
System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#M1
#LI-VH1
Ref: #851-Rockville-S1