Sr. Bi & Reporting Analyst

Title: Sr BI & Reporting Analyst
Why is this position open? New Data/Reporting platform implementation (DOMO)
Pay/Salary/Benefits/Perks: $80-$90k, bonus, PTO, company matched 401(k) and Retirement Savings Fund Plan, Medical, Dental, Life, Disability, Vision, Health Savings Account, Financial Wellness Services, Employee Assistance Program
Position reports to: CIO
Work from Home Policy: Onsite/ flex as needed Hybrid flex
Interview Process: 1) Tech eval with team 2) video call with IT Mgrs
Best Personality Match for this Role - self starter, collaborative, strong cross functional communication, willingness to speak up
Screening / Background checks Required: Background check
:

We are seeking a Senior Business Intelligence and Reporting Analyst with experience in data analytics, metrics optimization, and administering various data environments/platforms. We are interested in furthering our data collection and analysis practices, so you will play a key role in developing and implementing data strategy and governance program to include being responsible for data intake, data cleansing, development cycles, testing, and production readiness, and instituting new policies, procedures, and programs from the ground up. This position will require a determined, detail-oriented individual with strong problem-solving skills and the ability to interpret the user requirements as well as think "out of the box" when addressing the company's reporting needs.
Duties

• Explores the data and discovers patterns, meaningful relationships, anomalies and trends
• Responsible for managing and maintaining reporting platforms, including creating and updating complex dashboards and reports, integrating data from a variety of sources, and training users on best practices
• Development and maintenance of company dashboards highlighting key performance indicators
• Work with various stakeholders to interpret business needs, document requirements and manage schedule of deliverables
• Monitor and manage business system data interfaces, files, integrity, security with multiple data sources, data models, reports, interactive visualizations, and dashboards, while ensuring best practices are followed
• Implement data quality management best practices to ensure integrity of data collection and utilization
• Develop policies and procedures for the collection and analysis of data
• Use the business requirements to create Design documents that will later be used for QA testing, and inline documentation
• Other duties and ad hoc analyses as assigned
• Troubleshoot and correct any issues that may arise
• Provides design support for the development of business intelligence solutions
• Designs and delivers end-user training and training materials relative to BI solutions
• Participates in work stream planning process including inception, technical design, development, testing and delivery of BI solutions
• Stay up-to-date on the latest features and functionality of the reporting platforms

Required Skills and Experience

• Employee is versatile, engaged, self-starter, and analytically driven

• Clauses (where, group by, order by)
• Alter Tables
• Aggregate Functions
• Case Statements
• Experience with MySQL and Redshift
  • Joins (left join, right join, inner join, outer join)
  • Clauses (where, group by, order by)
  • Aggregate Functions
  • Alter Tables
  • Add Indexing
  • Case Statements
• Add Indexing
• Joins (left join, right join, inner join, outer join)

• Strong understanding of data analytics and visualization, as well as advanced experience with SQL and database management

• MySQL & MS SQL Server familiarity to track data from source to reporting platforms

• Demonstrated experience in analysis, design, development and deployment using various data/reporting and visualization platforms to include: Redshift, MySQL & MYSQL server, visual studio, SQL server management studio, Tableau, PowerBI, and DOMO

• Knowledge of data integration and data integrity issues and solutions.

Desired Skills and Experience
Title: Sr BI & Reporting Analyst
Why is this position open? New Data/Reporting platform implementation (DOMO)
Pay/Salary/Benefits/Perks: $80-$90k, bonus, PTO, company matched 401(k) and Retirement Savings Fund Plan, Medical, Dental, Life, Disability, Vision, Health Savings Account, Financial Wellness Services, Employee Assistance Program
Position reports to: CIO
Work from Home Policy: Onsite/ flex as needed Hybrid flex
Interview Process: 1) Tech eval with team 2) video call with IT Mgrs
Best Personality Match for this Role - self starter, collaborative, strong cross functional communication, willingness to speak up