Job Description
Job Location: Phoenix, AZ, 85034
Shift Hours: 6:00 AM to 6:00 PM
Work Mode: Remote
Arizona resident is preferred. Position is remote based, but would still like an Arizonan resident.
Candidate Location: Only local to Arizona
Position Description: Power BI report developer will create visually appealing and interactive reports, dashboards, and other data models using Power BI. Prior experience working with healthcare data including but not limited to medical claims data preferred The primary areas of responsibility for this role are as follows:
Skills Required:
Technical Proficiency: Strong expertise in Power BI, including data modeling, DAX, and Power Query.
Data Literacy: Experience working with healthcare data including but not limited to medicalclaims data. Preferred Medicaid or Medicare experience at a medical insurance company or equivalent work history at a State or Federal level for these programs.
Communication Skills: Effective communication to collaborate with cross-functional teams. Ability to explain technical concepts to non-technical stakeholders.
Problem-Solving Attitude: Analytical mindset to identify data-related challenges and propose solutions.
Skills Preferred:
Experience Required:
1. Data Modeling and Transformation: Collaborate with business analysts and subject matter experts to understand data sources, business logic, and requirements.
- Design and develop efficient data models that optimize query performance and ensure data accuracy.
- Transform data from various sources (primarily data warehouse) into a structured format suitable for reporting.
2. Report Development: Create interactive and visually appealing reports using Power BI. Leverage Power Query for data transformation, DAX (Data Analysis Expressions) for calculations, and custom visuals for enhanced user experience. Incorporate slicers, filters, and drill-through functionality to allow users to explore data intuitively.
3. Dashboard Design: Develop meaningful dashboards that provide a holistic view of business metrics. Arrange visuals logically, ensuring a clear flow of information. Use color schemes, fonts, and layouts effectively to enhance readability.
4. Data Visualization: Choose appropriate chart types (bar charts, line charts, pie charts, etc.) based on the nature of the data. Implement conditional formatting to highlight critical data points.
5. Performance Optimization: Optimize report performance by minimizing data refresh times and improving query efficiency. Use best practices for data modeling, such as avoiding unnecessary relationships and calculated columns. Monitor and troubleshoot performance bottlenecks.
6. Collaboration and Documentation: Work closely with stakeholders to gather feedback and refine reports. Document data sources, transformations, and report logic for future reference. Conduct training sessions to empower end-users in navigating and interpreting reports.
Experience Preferred:
Education Required: Prefer Bachelor's degree in Computer Science, Information Systems, Business Management or closely related field.
Education Preferred:
Additional Information: Arizona resident is preferred. Position is remote based, but would still like an Arizonan resident.