Data Warehouse Developer Intern at Premier Early… · Chicago

Summary: Premier Early Childhood Education Partners is a private early childhood education organization seeking a Data Warehouse Developer Intern. This role offers a hands-on opportunity in data analytics and business intelligence, focusing on developing and maintaining data solutions while collaborating with business stakeholders. Responsibilities: - Develop and maintain data warehouse and data lake solutions using Microsoft Fabric - Support the creation and optimization of data models used for reporting and analytics - Help build and maintain Power BI datasets, reports, and dashboards - Work with relational data sources, including Microsoft Access and other database systems, to extract and prepare data for analysis - Perform data validation and quality checks to ensure accuracy and consistency - Document data models, ETL processes, transformations, and reporting logic to support maintainability and knowledge sharing - Collaborate with analysts and business stakeholders to understand requirements and translate them into technical solutions - Participate in troubleshooting and resolving data, performance, and reporting issues across analytics tools - Support data governance, security, and compliance standards across reporting and analytics solutions - Assist in transforming disparate data sets into actionable insights that support data-driven decision making across the organization Required Qualifications: - Currently pursuing a Bachelor's or Master's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or a related field - Basic understanding of databases and SQL concepts - Familiarity with Microsoft Fabric - Applicants must live within driving distance to Chicago Preferred Qualifications: - Coursework or hands-on experience with Microsoft Fabric, Azure data services, or cloud analytics platforms - Familiarity with data modeling concepts such as star schemas, fact tables, and dimension tables - Experience completing data-related academic projects or internships - Interest in pursuing a career in business intelligence, data engineering, or analytics Required Skills: SQL, Microsoft Fabric Important Skills: Data modeling, Power BI Nice-to-Have Skills: Data analytics, Business intelligence, Data governance Benefits: Professional Development, Hands-on Experience with Enterprise Analytics Tools, Mentorship from Experienced Analytics Professionals, Opportunity to Build a Portfolio of Power BI Reports and Data Solutions, Fun and Positive Place to Work, Open Door Policy