Job description

Business Intelligence Developer DOJ Public Trust Remote-Quarterly travel to DC Remote Job Description: • Work directly with key stakeholders to understand data needs, document report requirements, provide user support • Design, develop, and implement operational and analytic reports, visualizations, dashboards, and data extracts utilizing Microsoft Power BI and other query tools • Reengineer existing Power BI and SSRS reports and dashboards to source data from Azure data lake, Synapse Analytics, and Azure SQL Managed Instance • Analyze current ETL logic and data sources such as SQL Server databases and SSAS cubes to understand required data transformations • Analyze report performance and implement performance tuning, including visual components, DAX queries, Power Query, data model, caching to deliver high performance reports • Utilize Azure cloud data services such as data lake (ADLS), data warehouse, Synapse Analytics, and Analysis Services, to design and develop optimal reports to meet user needs • Collaborate with other team members including business analyst, data modeler, data architect, and data engineers to support design and implementation of data models and data transformations for Power BI reports • Design, develop, and implement processes and functions to ensure data quality in reports and analytics • Support Power BI administration tasks, including workspaces, access controls, apps, gateway and cloud data source connections, monitoring reports usage, monitoring and tuning utilization of compute and storage capacity • Ensure alignment with data governance policies, processes, and procedures • Incorporate AI/ML techniques and functions (e.g. Power BI Copilot) to enhance data processing and reporting • Assist the Help Desk with problem and incident management • Assist with end user training • Actively support Agile DevOps process, including Program Increment planning • Actively engage in continuous learning to increase relevant skills Qualifications: • Bachelor's degree and 8+ years of prior relevant experience • At least 4 years of demonstrated experience delivering reports, visualization, and analytics using Power BI, to include Power BI Cloud Service, Power BI desktop, Power BI Report Server • At least 4 years of experience working directly with business end users to understand requirements, develop reports, and provide ongoing support • Experience with the Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, and SSIS) • Experience tuning reports performance including optimizing DAX, Power Query, data models • Experience with SQL databases (OLTP, OLAP), flat file (e.g. excel) data sources, multi-dimensional models, TSQL, DAX/MDX, Power Query • Understanding of reports development using Azure based data services (Synapse Analytics) • Experience in Agile projects, working with a multi functional team • Strong analytical capabilities with proven problems solving skills • Must be detail oriented, and able to support multiple projects and tasks • Demonstrate continuous learning to increase relevant skills • Ability to work well in a team environment and/or work alone with limited supervision • Ability to successfully obtain a government-issued Public Trust clearance Preferred: • Experience working on Federal government projects • Experience delivering reports in the law, HR, financial management, inventory, property, management domains • Power BI and Microsoft Azure data analytics related certifications • Experience supporting data governance • Experience with Design Thinking and Human Centered Design, and persona driven solutions #J-18808-Ljbffr

Requirements