What are the responsibilities and job description for the IT Internship position at Schellman?
Schellman is a Top 50 CPA firm and a leading provider of attestation and compliance services. Our professional services focus on security and privacy audits, assessments, and certifications. Schellman has become one of the largest cybersecurity assessment firms in the United States without providing any traditional accounting services. We are an accredited multi-framework ISO Certification Body for security, privacy, business continuity, and quality; a globally licensed PCI Qualified Security Assessor and a top provider to clients serving the federal DoD space as a leading FedRAMP 3PAO and the first assessment firm authorized as a CMMC C3PAO. Our specialty and expertise remain in providing best in class Cybersecurity and IT Audits and Attestations. Our culture, approach with clients, and dedication to our values has led us to consistently be a Great Places to Work certified company and rated as a Best Firms to Work For by Accounting Today and a Glassdoor Best Places to Work. We deeply appreciate our employees, as shown by our first core value – People Come First. This is demonstrated in our culture, benefits, and how we handle business. Come see what makes Schellman special!
Job Summary
Data & Business Intelligence
At Schellman, we strive to provide a flexible and balanced environment and therefore offer the opportunity to work remotely, unless otherwise stated in the job requirements.
Schellman is an equal opportunity employer (EOE) and strongly supports diversity in the workplace; therefore, providing equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law. Schellman uses E-Verify in our hiring process.
At Schellman, we strive to provide a flexible and balanced environment and therefore offer the opportunity to work remotely, unless otherwise stated in the job requirements. Connecting, collaborating and continuous education are also highly valued and therefore we require some travel annually for our Internal Service Delivery roles, which can include in-person training, team meet-ups, and strategy meetings. Service Delivery team members will also be required to travel based on business and client needs.
Job Summary
- As an IT Intern with Schellman, you'll support the firm's data and business intelligence initiatives in a hands-on, collaborative role. You'll work closely with the IT team on metrics, dashboarding, and a transition to a new BI platform, helping make data more accessible, organized, and actionable across the organization. This role is more interface and collaboration-focused than deeply technical, making it a great fit for someone who enjoys working with data and communicating insights.
Data & Business Intelligence
- Support the transition to a new Business Intelligence platform, including data migration and validation tasks
- Assist with building and maintaining dashboards and metrics reporting in Power BI Pro
- Write and review SQL queries to support data analysis and reporting needs
- Help catalog data fields in the new data platform, including assigning data owners and documenting definitions
- Assist with data governance tasks using tools such as Ovaledge
- Maintain and organize accurate data records and documentation
- Collaborate with IT and cross-functional stakeholders to surface insights in a centralized, easy-to-navigate format
- Adhere to project schedules and keep team members informed of task progress
- Escalate technical issues internally in a timely and appropriate manner
- Attend project kick-off and closing meetings
- Foundational knowledge of data analytics, BI tools, or data engineering concepts
- Ability to read and write SQL
- Familiarity with Power BI, AWS, or similar platforms is a plus
- High attention to detail and quality of work product
- Strong organizational and communication skills
- Ability to work independently and collaboratively in a remote environment
- Proficiency in Microsoft Office Suite, particularly Excel
- Actively pursuing a Bachelor's degree in Data Engineering, Data Analytics, Information Technology, Business Finance with a concentration in Computer Information Systems (CIS), or any other applicable degrees
- Completed 2 years of education, achieving Junior level status
- Experience through coursework, internships, or projects involving data, analytics, or BI tools
At Schellman, we strive to provide a flexible and balanced environment and therefore offer the opportunity to work remotely, unless otherwise stated in the job requirements.
Schellman is an equal opportunity employer (EOE) and strongly supports diversity in the workplace; therefore, providing equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law. Schellman uses E-Verify in our hiring process.
At Schellman, we strive to provide a flexible and balanced environment and therefore offer the opportunity to work remotely, unless otherwise stated in the job requirements. Connecting, collaborating and continuous education are also highly valued and therefore we require some travel annually for our Internal Service Delivery roles, which can include in-person training, team meet-ups, and strategy meetings. Service Delivery team members will also be required to travel based on business and client needs.