Business Systems Analyst IV

Location: Remote with quarterly travel to DCClearance: Public TrustWe are seeking a Business Intelligence developer who will spearhead development and delivery of critical reports and dashboards to our business clients within the Federal Government. In this position, you will utilize your experience with Microsoft Power BI and other Microsoft reporting and analytic tools in a cloud based environment to help customers with their data needs.Job DescriptionWork directly with key stakeholders to understand data needs, document report requirements, provide user supportDesign, develop, and implement operational and analytic reports, visualizations, dashboards, and data extracts utilizing Microsoft Power BI and other query toolsReengineer existing Power BI and SSRS reports and dashboards to source data from Azure data lake, Synapse Analytics, and Azure SQL Managed InstanceAnalyze current ETL logic and data sources such as SQL Server databases and SSAS cubes to understand required data transformationsAnalyze report performance and implement performance tuning, including visual components, DAX queries, Power Query, data model, caching to deliver high performance reportsUtilize 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 needsCollaborate 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 reportsDesign, develop, and implement processes and functions to ensure data quality in reports and analyticsSupport 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 capacityEnsure alignment with data governance policies, processes, and proceduresIncorporate AI/ML techniques and functions (e.g. Power BI Copilot) to enhance data processing and reportingAssist the Help Desk with problem and incident managementAssist with end user trainingActively support Agile DevOps process, including Program Increment planningActively engage in continuous learning to increase relevant skillsQualificationsBachelor's degree and 8+ years of prior relevant experienceAt 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 ServerAt least 4 years of experience working directly with business end users to understand requirements, develop reports, and provide ongoing supportExperience with the Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, and SSIS)Experience tuning reports performance including optimizing DAX, Power Query, data modelsExperience with SQL databases (OLTP, OLAP), flat file (e.g. excel) data sources, multi-dimensional models, TSQL, DAX/MDX, Power QueryUnderstanding of reports development using Azure based data services (Synapse Analytics)Experience in Agile projects, working with a multi functional teamStrong analytical capabilities with proven problems solving skillsMust be detail oriented, and able to support multiple projects and tasksDemonstrate continuous learning to increase relevant skillsAbility to work well in a team environment and/or work alone with limited supervisionAbility to successfully obtain a government-issued Public Trust clearancePreferredExperience working on Federal government projectsExperience delivering reports in the law, HR, financial management, inventory, property, management domainsPower BI and Microsoft Azure data analytics related certificationsExperience supporting data governanceExperience with Design Thinking and Human Centered Design, and persona driven solutionsPosition DetailsPay Rate / Range: $54.07-$59.07Benefits (Regular, Full Time Employees):Medical, Dental, and Vision offeringsWeekly Direct DepositPaid Holidays and Personal Time Off401(k) with matchVoluntary Life and AD&D, Short / Long Term Disability, plus other voluntary coveragesPre-Paid Legal and Employee Assistance ProgramsNorthwest Federal Credit Union MembershipBB&T @ Work ProgramThis program requires US CitizenshipABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans#J-18808-Ljbffr