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 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 ISYS \Masters student or someone with experience in SQL/Python/JavaScript 

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

• 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.

• 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 deal with ambiguity
• Understanding of database concepts and data warehousing principles. Familiarity with business intelligence and analytics tools such as Qlik, Tableau, Power BI, or similar platforms. 
• Proficiency in data visualization techniques to create compelling dashboards and reports.
• Strong analytical and problem-solving skills, with the ability to translate complex data into actionable insights.
• Excellent communication skills to effectively convey findings and recommendations to stakeholders at various levels of the organization.
• Proactive work ethic and ability to thrive in remote work environment.

Preferred Qualifications

• Netsuite Reporting and Analytics Experience
• Qlik Reporting Experience Highly Preferred
• Working Knowledge of accounting and finance

Remote work is only available in the following states: AR, 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.