Business Intelligence and Data Analyst

About the Role

Key Responsibilities

• Analyze and interpret complex data sets to identify trends, patterns, and insights.
• Develop and maintain reports, dashboards, and visualizations for key stakeholders.
• Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions.
• Design and implement business intelligence solutions using tools such as Tableau, Power BI, or similar platforms.
• Develop and optimize ETL (Extract, Transform, Load) processes for efficient data retrieval and transformation.
• Ensure data accuracy, consistency, and reliability in business intelligence solutions.
• Design and implement database structures based on business requirements.
• Develop efficient SQL queries, stored procedures, and triggers.
• Ensure data integrity, security, and availability.
• Monitor database performance, conduct regular maintenance, and optimize for efficiency.
• Implement backup and recovery plans to safeguard data.
• Install, configure, and upgrade database software and related tools.
• Manage virtual servers used for hosting data analysis and BI solutions.
• Manage virtual servers used for ETL operations and other server needs.
• Manage other college servers as needed for website hosting and file storage.
• Stay current with industry trends and emerging technologies.
• Identify opportunities for process improvement and recommend system enhancements.

Requirements

• BA/BS in relevant fields plus at least four years of experience, or master's degree plus at least two years of experience.
• Demonstrated ability to write complex SQL queries for data extraction, transformation, and analysis.
• Hands-on experience building dashboards and reports in Tableau, Power BI, or Qlik.
• Demonstrated experience using Python or R for data analysis, statistical modeling, and automation.
• Familiarity with data warehousing concepts, dimensional modeling, and experience working with data warehouses (e.g., Snowflake, Amazon Redshift, Google BigQuery).
• Proven experience using Microsoft Excel for data analysis, pivot tables, and charting.
• Experience installing, configuring, administering Microsoft SQL Server and Microsoft SQL Server Reporting Services on Windows Server.
• Proven experience (3+ years) in a Business Intelligence, Data Analyst, or similar role.
• Experience creating data visualization workbooks and data sources using Tableau Desktop and Tableau Server.
• Familiarity with basic server administration tasks in Linux and Windows environments.
• Analytical and problem-solving skills with attention to detail and accuracy.
• Experience designing and building desktop applications using Microsoft Access, Filemaker, Microsoft SQL Server, or similar platforms.
• Experience using Git or GitHub for version control of scripts, queries, or analytics projects.

Nice to Have

• Experience creating data visualization workbooks and data sources using Tableau Desktop and Tableau Server.
• Familiarity with basic server administration tasks in Linux and Windows environments.

Qualifications

• Bachelor's degree or higher in relevant fields.
• At least two years of experience with data analysis and BI tools if holding a master's degree.
• At least four years of experience if holding a bachelor's degree.

Benefits & Perks

• Flexible, hybrid work environment.
• Supportive colleagues committed to empowering lifelong learners.
• Opportunities for professional development and growth.