|Business Intelligence Administrator|
Company: Columbus Zoo and Aquarium
Location: Powell, OH
Employment Type: Full Time
Date Posted: 07/05/2022
Expire Date: 09/05/2022
Job Categories: Computers, Software
Business Intelligence Administrator|
Manage information and data assets of the Columbus Zoo Family of Parks through active engagement with internal business organizations, constant review of data sources and data mining capabilities, creation of reports and portals to assist business initiatives, and assisting with management of source databases to ensure quality and accessibility of information.
Leverage existing Microsoft SQL Business Intelligence software and tools to generate reports and connect to external data sources through shared files, APIs, and data connectors.
Administer and manage Microsoft SQL databases, Power BI Service and Report Server, and other data sources.
Analyze Microsoft SQL databases and other data sources for quality issues and implement data quality solutions.
Analyze data for trends and anomalies and take appropriate action in conjunction with team members and internal customers.
Administer and manage the organization’s Google Tag Manager, Google Analytics, and web site heatmap accounts.
Integrate email marketing software into existing web sites and applications.
Research user concerns associated with the organization’s application databases and suggest possible solutions.
Build custom reports within an existing application’s reporting tools.
Assists with end user support of computers, applications, and mobile devices as needed.
Constantly strives to further the mission of the organization and avidly supports the Columbus Zoo Family of Parks.
Implements sustainable practices in daily tasks whenever possible.
Performs other duties as assigned.
High school diploma or equivalent required.
Bachelor’s degree or equivalent experience in a computer related field required.
5+ years database administration, data analysis, or similar functions required.
Solid working knowledge of Microsoft SQL database technologies and management tools required.
Strong experience with Microsoft Power BI, SQL Server Reporting Services and Integration Services required.
Strong experience with web analytics required.
Familiarity with commercial email marketing software required.
Ability to create and modify complex Microsoft SQL stored procedures and views to handle data management functions required.
Ability to analyze data and derive conclusions that enhance business value required.
Ability to create meaningful reports based on business requests required.
Ability to effectively engage non-technical users required.
Understanding of information and data security principles required.
Previous experience with Business Intelligence software required.
Other programming skills (Python, HTML, XML, etc.) required.
Strong experience with Microsoft Excel including pivot tables required.
Familiarity with commonly used commercial software packages required.
Ability to communicate well both verbally and in writing required.
Ability to work a flexible schedule including evenings, weekends and holidays required.
Ability to plan and prioritize work in an efficient and cost-effective manner and without direct supervision required.
Ability to provide excellent guest service by positively interacting with guests required.
Ability to adhere to standard operating procedures, and in particular, safety protocols, required.
Possession of a valid Ohio motor vehicle operator’s license and a good driving record required.
Ability to adhere to the Columbus Zoo and Aquarium’s drug-free workplace policy including but not limited to pre-employment, random, post-accident, reasonable suspicion, and follow-up treatment required.
Ability to successfully complete a criminal history background check annually required.
Phone Number: 614-645-3400
Fax Number: 614-645-3599
Contact Email: firstname.lastname@example.org
Our mission at the Columbus Zoo Family of Parks is to lead and inspire by connecting people and wildlife. When you are a part of our full-time Columbus Zoo and Aquarium team, you are helping us achieve that mission! We offer competitive wages, paid time off, excellent benefits including covered premiums for vision, dental, basic life and disability insurance, and OPERS retirement. Did we mention the perks? Company provided tuition reimbursement, Zoo family membership, free admission and discounts at all of our parks, team member appreciation events, wellness program, and more. Plus, as a nonprofit organization, our employees can take advantage of the student loan forgiveness through the Federal Public Service Loan Forgiveness Program Interested in joining our team? You're on the right track! Equal Opportunity Employer