What are the responsibilities and job description for the Power BI Engineer position at Open Systems Technologies Corporation?
Open Systems Technologies Corporation is a leader in the government contracting marketplace, providing Enterprise Security and Cloud Computing solutions to support large organizations. Our capabilities include supplying federal government entities and private businesses with software development, scientific and engineering technical assistance, systems integration and enterprise security. Since its founding in 1996, OST has been committed to delivering high-quality, best-in class results that bring added value to our clients, while investing in our employees’ futures by providing exciting projects to work on, and robust benefits to include technical training and certifications, relocation assistance and a 401K match with immediate vesting.
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
OST is an Equal Opportunity Employer and has been operating since 1996 providing support on various contracts with Government agencies. We offer a comprehensive benefits package that includes 3 weeks paid time off, 11 Federal Holidays, medical/dental coverage, STD, LTD, Life Insurance, AD&D, 401k with up to 4% match, and end-of-year profit sharing.
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
- 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.
- 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.
- 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.
- 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.
- 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.
OST is an Equal Opportunity Employer and has been operating since 1996 providing support on various contracts with Government agencies. We offer a comprehensive benefits package that includes 3 weeks paid time off, 11 Federal Holidays, medical/dental coverage, STD, LTD, Life Insurance, AD&D, 401k with up to 4% match, and end-of-year profit sharing.