About the Role
Description
DAILY DUTIES / RESPONSIBILITIES:
• Data Modeling and Transformation: Collaborate with stakeholders to gather requirements and translate them into technical specifications. Build and maintain data models within Power BI using DAX (Data Analysis Expressions) and Power Query.
• Report Development: Design, develop, and publish interactive dashboards and reports in Power BI. Ensure reports are user-friendly and meet business requirements.
• Data Integration: Connect Power BI to various data sources, including databases, APIs, and flat files. Perform data cleansing and transformation to prepare data for analysis.
• Performance Optimization: Monitor and optimize dashboard performance and responsiveness. Implement best practices for data visualization and reporting.
• Collaboration and Communication: Work closely with business stakeholders, data analysts, and other stakeholders to understand reporting needs. Provide training and support to end-users and ITS on using Power BI.
• Documentation: Maintain documentation of Power BI solutions, including data models, reports, and business logic. Create user guides and training materials for stakeholders.
• DEVELOP TECHNICAL DOCUMENTATION FOLLOWING AGENCY POLICIES, CJIS SECURITY GUIDANCE, AND STATE SECURITY STANDARDS.
• Troubleshooting and Support: Address any Power BI reports and dashboards issues. Provide ongoing support and maintenance for existing Power BI solutions.
• Facilitate ongoing knowledge sharing sessions with IT Team
• SUPPORTS AND ADHERES TO CHANGE MANAGEMENT PROCESS
• AWARENESS OF SECURITY-BASED CHANGE PROCESSES, I.E., DOCUMENTATION, DEPLOYMENT STRATEGIES, AND CHANGE LOG REVIEWS.
• IDENTIFIES RISKS AND COMMUNICATES RISKS TO THE CIO AND IT TEAMS.
Requirements
Proficient in Power BI Desktop and Power BI Service for report creation and publishing. – Experience embedding PowerBI in custom applications
Strong understanding of data modeling concepts and experience in building complex data models.
Ability to write advanced DAX queries for calculations and data manipulation.
Proficient in SQL for querying and extracting data from relational databases.
Strong skills in creating engaging and effective visualizations that communicate data insights clearly.
Ability to analyze data requirements and translate them into actionable insights.
Strong verbal and written communication skills for collaboration and
• EXPERIENCED IN POWER APPS, POWER PLATFORM, AND DYNAMICS 365 APPS
• SKILLED WITH SHAREPOINT, STREAM, AND TEAMS
• CANDIDATE MUST BE ABLE TO DEMONSTRATE WORKING KNOWLEDGE
• ABILITY TO COMMUNICATE DIRECTLY WITH THE IT TEAM, BUSINESS EMPLOYEES, AND VENDOR PARTNERS.
• FAMILIARITY WITH ETL (EXTRACT, TRANSFORM, LOAD) TOOLS SUCH AS AZURE DATA FACTORY OR SSIS.
• UNDERSTANDING OF AZURE SERVICES RELATED TO DATA ANALYTICS AND REPORTING.
• FAMILIARITY WITH BUSINESS INTELLIGENCE METHODOLOGIES AND BEST PRACTICES.
•UNDERSTANDING OF PROGRAMMING LANGUAGES LIKE DATA MANIPULATION AND ANALYSIS.
EXPERIENCE WITH IBM SPSS