Business Intelligence Intern (Part Time, Remote)

This position will play a key role in driving data-driven decision-making processes by working with large datasets to create business insights and develop data warehouse type reporting. With expertise in database design/process/schemas, data extraction, data cleansing, building data pipelines and creating streamlined financial/operations reports. By collaborating closely with cross-functional teams, this position will translate business requirements into meaningful reports and dashboards, which will enhance our ability to identify trends, risks, and opportunities. 

 The candidate should have advanced knowledge of SQL and database design/architecture. This position will report to the AVP, Finance Planning and Analysis with collaboration and support from the database administration group. This will be a position that will work to build multiple projects and on streamlining processes. The environment requires flexibility and problem-solving in an environment that, at times, may be ambiguous.  

Target Pay Range:  $22.00 to $25.00 per hour based on applicable experience

Hours Per Week: 20 to 25 per week. We fully understand the flexibility and autonomy students need as they balance classes, homework, and college life.   

Job Responsibilities

• Collaborates with Database Administrators to understand operational database architecture and design data pipelines that tie to system of record 
• Connects APIs/ODBC to data source to sync data down from production warehouses/data sources to warehouse the data 
• Uses SQL/Python/R to cleanse data, and transform datasets, to mitigate manual data cleansing/adjustment and maintain data integrity 
• Combines data from multiple data sources in an efficient manner, utilizing Online Analytical Processing (OLAP) to streamline reporting and maintain database performance 
• Creates intuitive dashboards and reports using BI tools, facilitating easy visualization of financial metrics for stakeholders, leading to improved transparency and performance monitoring. 
• Collaborates with various departments including finance, operations, and IT to understand business needs, streamline data workflows, and drive alignment between strategic objectives and analytical insights. 
• Identifies opportunities for process optimization and automation within financial analysis workflows, improving efficiency, reducing manual effort, and enabling focus on value-added tasks. 
• Provides training and knowledge sharing sessions to empower stakeholders with BI tools and techniques, fostering a data-driven culture and enhancing organizational capabilities in leveraging data for decision-making. 

• Bachelor's degree in Information Systems, Data Analytics,?or?related field or working towards a degree in this field 
• Proficient in SQL (Structured Query Language) for data extraction, transformation and analysis. 
• Experience working with Microsoft SQL Server or other similar server software 
• Problem Solving ability and ability to …