Business Intelligence Developer (Only W2)
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)
Apply tot his job Apply To this Job