Power BI Analyst Intern
For the past 25 years, Longwood Collective has engaged in data collection outreach efforts from our 22 member institutions. This data includes critical demographic, facilities, parking, commuting benefit, financial, workforce development, and sustainability data that help us tell the story of Longwood over time. This data has recently been migrated from hundreds of excel workbooks to a software platform, Acumatica. The Intern will be responsible for diligent QA of the data, collecting additional data, and assist in building a dashboard in Power BI to visualize trends for reporting, ensuring the dashboard can be maintained and refreshed by non-technical staff. The Power BI Analyst is expected to work in-person with flexible and negotiable hours between 7am-5pm, Monday-Friday. Essential Responsibilities
- With project manager and IT department support, use the data in Acumatica to build a Power BI dashboard for internal data analysis using formulas and SQL queries and user-friendly navigation.
- With project manager, co-lead meetings with senior management to help determine what visualizations and navigation structure would be most helpful for Area Planning and Communications.
- Serve as the technical advisor, with the ability to interpret non-technical goals and suggest Power BI capabilities, recommending and mocking up options to align on the desired result.
- Find and scrub recently migrated data for duplicates, errors, and upload newly collected data.
- Use critical thinking and good judgement to evaluate data and bring recommendations, issues, and questions to the project manager.
- Take initiative to solve problems, communicate with the project manager, and schedule meetings.
- Assist in creating best practices and Standard Operating Procedure (SOP) for using the dashboard and instructions for LC staff to refresh the dashboard when new data is collected in Acumatica.
- Present a walkthrough of the dashboard and instructions to the organization and collaborate with IT on sharing the interactive dashboard in the organization's SharePoint.
- With Communications’ support, adapt the dashboard to a simplified version for sharing externally and collaborate with design consultant.
- Experience with Power BI is required.
- Proficiency with Excel, SharePoint and the rest of the Microsoft Suite.
- Meticulous attention to detail and discretion is required to handle sensitive and confidential data with accuracy to minimize human error, and to cross check for quality assurance.
- Potential opportunity to assist with other data collection tasks and collaborate with various Longwood Collective project managers.
- Excellent verbal and written communication.
- Experience with data management software.
- Strong critical thinking skills.
Longwood Collective values an inclusive work environment that celebrates the diversity represented by our employees and member institutions. Candidates passionate about this role with diverse backgrounds and experiences are encouraged to apply. Longwood Collective is proud to be an equal-opportunity employer.
Recommended Jobs
Forklift Operator - Sit Down - Now Hiring
Ready to earn more and receive better benefits in a new sit down forklift operator role? If you're a detail-oriented stand-up clamp forklift operator with an impeccable safety record, excellent balan…
Your Road to a Successful Truck Driving Career Starts Here
Job Description Job Description Your Road to a Successful Truck Driving Career Starts Here Join one of the nation's leading trucking companies and begin a rewarding career behind the wheel.…
Administrative Assistant
Job Description Job Description Administrative Assistant Clearance Level: Must be able to willing to obtain an Active Secret Clearance - Must be US Citizen to be considered Location: Must…
Purchasing Assistant
Job Title: Purchasing Assistant Location: Canton, Massachusetts Type: Contract To Hire Compensation: $25.00 Work Model: Onsite Hours: 40.0 hours per week Responsibilities Tr…
Building Controls Service Technician
seeking an experienced Building Controls Service Technician to maintain, troubleshoot, and optimize Building Automation Systems for commercial facilities throughout Connecticut. Responsibilities …
Travel CT Tech Job
Job Overview TLC Nursing Associates, Inc. is seeking an experienced Computed Tomography (CT) Technologist to perform high?quality CT scans, ensure patient safety, and uphold regulatory standard…
Preschool Teacher Assistant
Job Description Job Description Overview What You’ll Do Support a positive and respectful classroom environment , ensuring each child is treated with care, dignity, and respect. Greet …
Operations Admin I
Minimum Education ~ High School Diploma or GED required Minimum Experience ~ Previous clerical or customer service experience preferred Knowledge Skills and Abilities General busines…
Crew Member
Job Description Job Description Description: Job Description Working at Dunkin, we support our team members-for your best days, your worst days - your everyday. Our team members are the ingre…
Team Member
Job Description Job Description Position Description: Who We Are: Playa Bowls is New Jerseys Original Acai Shop, and our mission is to bring superfruit bowls to the masses using only the fresh…