The Senior Business Intelligence (BI) Specialist's role is to design, implement, and maintain BI software and systems that support business secondary uses of data. This includes data acquisition, transformation, storage, reporting, and analytics. The BI Specialist is responsible for the full lifecycle of BI systems ensuring quality through in-depth testing, monitoring, and support.
Compensation: $110,000-$130,000 + Bonus incentives.
Responsibilities
Strategy & Planning
- Leads BI implementation strategies based on business needs and direction from senior leaders.
- Assess and develop long-term strategic goals for BI systems in conjunction with data owners and department managers.
- Establish a common BI architecture, processes, and technologies to support data discovery, analysis, and reporting across disparate data sources.
- Conduct research and make recommendations on BI products, services, protocols, and standards in support of procurement and development efforts.
- Analyze design of systems and reports to improve business performance.
- Design data architecture and work to install the architecture.
- Establish a BI development lifecycle to ensure timely, consistent delivery of high-quality solutions.
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
- Provide and apply quality assurance best practices for data science services across the organization.
- Assist in the development of data management policies and procedures.
- Communicate BI strategy to stakeholders at all levels of the organization
Development, & Delivery
- Gather, prioritize, and coordinate data requirements among business stakeholders, analytics team, and software development team.
- Drive the collection of new data and the refinement of existing data sources.
- Design and develop ETL/ELT processes that land data for query and reporting.
- Enhance data model to include additional data and transformations as required.
- Develop tools and libraries that will help team members more efficiently interface with large amounts of data.
- Create, or support creation of, required reports in response to business user needs.
- Facilitate use of BI systems through documentation and user training.
- Work with leaders, software development, and key stakeholders to translate prototypes into production
Operational Management
- Install, maintain, monitor, troubleshoot databases and BI toolsets.
- Develop and maintain appropriate user access control and security models.
- Respond to and resolve access and performance issues related to the BI systems.
- Maintain change control and testing processes for modifications to databases and BI toolsets.
- Perform BI database/software transaction and security audits.
- Identify and implement improvements to increase efficiency, effectiveness, and agility of BI systems.
- Provide guidance to junior members of the team tasked with report development.
Position Requirements
Formal Education & Certification
- College diploma or university degree in the field of computer science and/or 8 years equivalent work experience.
- Certifications related to business intelligence design, architecture, and/or industry leading tools favorably considered.
Knowledge & Experience
- Strong understanding of relational database structures, theories, principles, and practices.
- Working knowledge of software engineering and application to BI methodologies, techniques, and tools.
- 5+ years technical experience with designing, building, installing, configuring, and supporting SQL Server database servers.
- 5+ years developing SQL Server database objects in a data lake / data warehouse environment.
- 5+ years supporting BI solutions such as Power BI and Tableau
- Ability to conduct research into database issues, standards, and products as required.
- Hands-on database tuning and troubleshooting experience in a data warehouse environment.
- Experience documenting data processes for technical and nontechnical audiences.
- Project management experience.
- Understanding of how BI systems relate to the company’s goals and objectives.
Personal Attributes
- Solid written and oral communication skills.
- Ability to build relationships with teammates, vendors, and other stakeholders.
- Highly self-motivated and directed.
- Ability to present ideas in user-friendly language.
- Keen attention to detail.
- Proven analytical and problem-solving skills.
- Ability to effectively prioritize and execute tasks in a fast-paced environment.
- Strong customer service orientation.
- Experience working in a team-oriented, collaborative environment.