IT PowerBI Summer Internship 2024 – Arizona
If you are looking for a summer intern program where a large company puts you in a large room to work on one large project with little interaction with the rest of the company, you can stop reading this now.
If, on the other hand, you want to work in a small dynamic company where you will:
- Learn about the dynamic banking and fintech industry.
- Conduct primary research that results in a Capstone project that will be presented to the entire 170-person company and may be published.
- Collaborate closely with senior members of Business Intelligence team to strategize, design, and implement data integrations, insights and advanced analytics solutions using data warehousing concepts and technologies.
Then you should apply to the Intern Program at Cornerstone Advisors and spend the summer in Scottsdale, AZ.
Cornerstone Advisors is a national management consulting firm offering a wide range of consulting services to meet the needs of regional and mid-size banks and credit unions, as well as financial vendors throughout the country.
Responsibilities for Business Intelligence Intern
- Identify areas of potential growth within our existing client set with new clients.
- Work on Business Intelligence reporting structure and content organization.
- Work on special projects and support with ad hoc analysis across departments.
- Create interactive BI dashboards for audiences ranging from analysts to executives.
- Utilizing Microsoft Excel, PowerBI, Smartsheet, Microsoft Dynamics 365, Azure Synapse, Azure pipelines and Azure SQL Servers and others as data sources.
- Providing general administrative support to BI system and platform.
- Filtering and ‘cleaning’ existing data.
- Establishing dashboards and KPI’s that help create actionable analytics for senior management.
- Querying complex databases to prepare datasets for business analysis.
- Collaborating with business users.
- Be creative in approaches to solving problems and managing data.
- Participation in development of training materials.
Skills for Business Intelligence Intern
Desired skills include:
- Various predictive analytics/statistical modeling
- Microsoft Office Products, Excel in particular
- SQL
- PowerBI
- Agile Methodology
- Microsoft Dynamics 365 and Dataverse experience preferred but can train.
- Database architecture and design
- Database (Azure Cloud)
- Relational Database Management System concepts
- Able to drink more than 3 shots of whiskey and keep programming (just kidding!)
This is a full-time, paid internship in Scottsdale, AZ. Program dates: May 22 – August 2, 2024.
What You’ll Do
As part of the Cornerstone Intern Program, you will develop a broad understanding of our consulting business, as well as gain deep insights into your department. As an active member of the team, you will support and drive projects that both challenge and develop you. Our interns get hands-on experience. You will make new connections, and partner with experienced professionals and business leaders to sharpen the skills you need to succeed in your future career.
As a Business Intelligence Intern you will define problem statements, analyze/evaluate solutions, and execute features that deliver business results through technology critical for Cornerstone’s success. You’ll work with a cross-functional team of product managers, engineers, designers, and subject matter authorities in an agile methodology. We are here to help you both identify and continue to develop your future career goals and passions.
At Cornerstone, you’ll have the opportunity to interact with senior executives, get paired with a formal mentor, and attend company-sponsored knowledge shares and group activities. In your day-to-day work, you’ll learn how employees collaborate to serve all our stakeholders by being part of the team. Your internship performance may even lead to a full-time offer upon your graduation.
At Cornerstone, we value making sure our employees feel welcome and supported at work while challenging you to develop personally and professionally. While working here, you’ll be empowered with the tools you need to succeed in your role and grow your career.
To apply, please submit a full application to include a resume, cover letter, and college transcripts.
Background screening including past employment, education and references required.
Education for Business Intelligence Intern
School Years: Senior
Bachelor undergraduate (rising senior) Computer Science, Business, Statistics, Economics, Engineering, Finance, Mathematics, Marketing related majors.
GPA: 3.4 or better
Work Authorization: Cornerstone will not be providing visa sponsorship for this position now or in the future. Therefore, in order to be considered for this position, you must have the ability to work without a need for current or future visa sponsorship.
Cornerstone Advisors provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, our firm complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.