Database Reporting & SQL Specialist
Job description
- Administrator: Vice President of Data & Information Services
- Preferred Experience: 2+ years of experience in SQL programming and SQL Server databases; or an equivalent combination of education and experience
- Education Required: Baccalaureate Degree in computer science, computer engineering, information systems / technology, or related Degree with relevant experience
- Overtime Status: Exempt, not eligible for overtime
- Full Time Equivalent: 1.0 FTE; eligible for benefits
- Work Status: the position is located in Bozeman, MT; hybrid and/or remote options will be considered
MAJOR DUTIES AND RESPONSIBILITIES:
The Database Reporting & SQL Specialist for the Montana State University Alumni Foundation (“Alumni Foundation”) is primarily responsible for fulfillment of targeted data and report requests from both external Montana State University (“University”) partners, and internal Alumni Foundation team members. The Database Reporting & SQL Specialist reports to the Vice President, Data & Information Services.
Anticipated distribution of time and effort are outlined below:
- 30% Manage and fulfill data and information requests from University partners and internal Alumni Foundation team members.
- 30% Develop ad hoc and self-serve reports in Power BI Report Server, aka SQL Server Reporting Services (“SSRS“).
- 30% Design/Maintain/Perform regular data extract, transform, and load operations (“ETL”) using SQL Server Integration Services (“SSIS”).
- 10% Other duties including but not limited to: Organizational Software Helpdesk function. Business process development & SOPs Documentation. Assist in data hygiene and maintenance.
SPECIFIC DUTIES AND RESPONSIBILITIES:
- Serve as primary liaison for data and information requests (i.e., list requests) to external University partners and manage all request-related communications.
- Manage the queue of data and report requests by collaborating with other members of the Data & Information Services team.
- Implement existing procedures and develop new SQL-based queries and procedures to fulfill targeted data requests, reporting needs, and data ETLs.
- Develop, document, and disseminate targeted best practices and standard operating procedures (“SOP’s”) related to the fulfillment of targeted data and information requests from the Alumni Foundation database.
- Identify database-related improvement opportunities and collaborate with members of the Data & Information Services team to develop and implement solutions.
- Provide an organization-wide software helpdesk function, acting as the primary resource and first line of support. Serve as a liaison between the software vendor and MSUAF end users.
- Affect and maintain a professional, proactive, positive, highly collaborative, and performance-centric work environment.
- Other duties, as assigned by the Vice President, Data & Information Services.
Duties and responsibilities may change at any time.
SPECIAL SKILLS AND QUALIFICATIONS:
- In-depth experience with SQL Server database query development.
- Understanding of and experience with the Microsoft SQL Server & BI stack, including SQL Server Management Studio, VS Data Tools, SSRS, and SSIS.
- General programming and database administration experience helpful.
- Excellent time management skills and the ability to prioritize in a fast-paced environment while remaining helpful, pleasant, and courteous.
- Demonstrated knowledge of computer hardware, including installation, operation, security, maintenance, and networking requirements.
- Complete respect for confidentiality.
- Excellent interpersonal and business communication skills.
- Strong attention to detail and organizational skills.
- Ability to meet deadlines for multiple projects and priorities.
colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.