Business Intelligence Intern (Part Time, Remote)

Job Description

Job Description

Description :

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 databases (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 the candidate that enjoys problem solving in a sometimes-ambiguous environment is the one that will find success in this role.

This internship is ongoing (currently no defined end date), with longevity highly preferred (6+ Months). Ideal candidate is a first year Master's level student or undergraduate (Junior or Senior) with experience in SQL, Python, or JavaScript

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

Hours Per Week : 20 to 25 per week during school, potential of full time during the summer. We fully understand the flexibility and autonomy students need as they balance classes, homework, and college life.

Job Responsibilities

• Collaborate with Senior DBA to understand production 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 OLAP techniques (Online Analytical Processing) 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.

Requirements :

Preferred Qualifications

Remote work is only available in the following states : AZ, CA, CO, OR, UT, WA, TX, and ID.

Employment is contingent upon completing and passing a background & live scan check. MetaSource is an equal opportunity employer.