Power BI Developer

Position Summary As a Power BI Full Stack Developer on the Data Services team, you'll play a crucial role in driving data-driven decision-making within the fellowship and residency recruitment space. You'll be responsible for designing, developing, and maintaining powerful dashboards that deliver critical insights to our internal and external users. Your expertise in data integration, modeling, analysis, and visualization will be instrumental in helping to optimize and enhance the experience for our community of users. Essential Duties: Data Integration and ETL • Connecting to various data sources: Integrating data from databases, files, APIs, and other sources. • Transforming data: Cleaning, preparing, and restructuring data for analysis. • Loading data: Importing data into Power BI for analysis and visualization. Data Modeling and Analysis • Design data models and optimize performance: Creating the structure of data relationships ensuring efficient data retrieval and calculations. • Create calculated columns and measures: Using DAX to calculate derived values and aggregate metrics. • Perform exploratory data analysis (EDA): Using BI tools to explore data, identify trends, and patterns. • Apply advanced data analysis techniques (e.g., statistical analysis, time series analysis, predictive modeling). • Integrate machine learning models into Power BI dashboards. Dashboard Development and Visualization • Designing dashboards: Creating visually appealing and interactive dashboards. • Creating visualizations: Using charts, graphs, and other visual elements to represent data. • Implementing interactivity: Adding filters, slicers, and drill-down capabilities. Troubleshooting and Maintenance • Identifying and resolving issues: Debugging dashboards and data models. • Updating and maintaining dashboards: Ensuring dashboards remain accurate and relevant. • Providing support: Assisting end-users with dashboard usage and troubleshooting. Collaboration and Communication • Work with stakeholders: Understand business needs and translate them into visualizations and collaborate with a product manager to align BI development with business objectives. • Collaborate with cross-functional IT staff: Work effectively with data engineers, data architects, and others to ensure data quality and integration. • Communicate findings: Presenting data insights and recommendations to stakeholders. Qualifications • Bachelor’s Degree OR 5+ years of related work experience. • Expertise in SQL, DAX and knowledge of Python, R. • Strong proficiency in Power BI. • Data modeling and visualization skills. • Strong problem-solving skills to address technical challenges and data quality issues. • Analytical skills with capacity to analyze complex data problems and draw meaningful insights.