Business Intelligence Developer - Remote - Ability to obtain a Public Trust
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 driven solutions
- Candidates with a Public Trust are preferred
Employment Pre-requisites The following requirements must be met to be eligible for this position : successful completion of a background investigation, and drug urinalysis. SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, Apply tot his job Apply To this Job