CACI is seeking a Power BI and Power Automate Developer to support a federal government customer and internal team. The candidate will help create and use existing data sources to design reports and dashboard using Microsoft Power Business Intelligence (BI).
Requirements
- minimum 5 years’ overall experience with Power BI and Power Automate
- Experience building Power BI Dashboards and using Power BI Reports Builder to develop paginated reports
- Experience in Data Modeling and Data Transformation using relational database-based systems
- Experience using SQL to extract data and Data Analysis Expressions (DAX) to perform complex calculated measures
- Ability to work with a broad range of datasets (Dynamics 365, Azure SQL, ServiceNow, SharePoint, Excel)
- Experience building web parts, applications, page layouts and content types using the O365 API.
- Strong Power BI Data Analytics experience and experience
Responsibilities
- Build business intelligence tools, dashboard reporting applications, and intelligent workflows to automate repetitive business processes
- Create reports and dashboards from various data sources like SharePoint environments and applications
- Participate in requirements meeting and data mapping sessions to analyze data dictionaries and develop Entity Relationship diagrams
- Engage with multiple stakeholders to capture business requirements, translate them into technical requirements, and implement solutions
- Develop solutions by studying requirements, information needs and existing data sources
- Provide technical support and guidance to users interacting with SharePoint and Power Platform/Power BI
- Perform data manipulation and cleansing to prepare datasets for implementation
Other
- DHS EOD Eligible
- BA + 10 years of experience or Equivalency (equivalency includes MA + 7 years applicable experience, AA + 12 years applicable experience)
- Percentage of Travel Required: Up to 10%
- Type of Travel: Local
- Provide expert advice to customers in support of business intelligence and reporting needs