Business Intelligence Develop

General Description OF Responsibilities

Essential Functions:

• Requirements Gathering Collaborating with stakeholders and business analysts to understand data and reporting needs, translating these into technical specifications.
• Data Preparation and Integration Extracting, cleansing, and transforming data from various sources (databases, spreadsheets, cloud services, APIs) using Power Query to ensure data quality and integrity.
• Data Modeling Designing and developing robust data models, including creating relationships and hierarchies, to support complex reporting requirements and ensure optimal performance.
• Report and Dashboard Development Building interactive and visually appealing reports and dashboards with KPIs and filtering capabilities using Power BI Desktop.
• Advanced Calculations Using Data Analysis Expressions (DAX) to create complex measures, calculated columns, and tables for in-depth analysis.
• Deployment and Maintenance Publishing reports to the Power BI Service, managing work spaces, configuring data refresh schedules, and troubleshooting issues.
• Performance Optimization Tuning report and query performance to handle large datasets efficiently.
• Data Governance and Security Implementing data governance practices, including role-level security (RLS), to ensure data privacy and compliance.

Experience:

• Minimum 3-4 years of experience in relational Data Modeling.
• Minimum 3-4 years of experience with Microsoft SQL Server.
• Minimum 3-4 years of experience writing Data Analysis Expressions (DAX) in Power BI.
• Demonstrated ability to deliver high impact business intelligence solutions in complex environments.

Knowledge, Skills and Abilities:

• Extensive knowledge of Power BI Desktop, Power Query, Power BI Cloud Service, and Power BI On-Premise Reporting Service
• Extensive experience writing Data Analysis Expressions (DAX) in Power BI.
• Knowledge of BI security best practices.

• Bachelor’s degree in Computer Science or Analytics, Operations Research, Mathematics, Statistics or related subject preferred.