Bestpass is hiring a
Data Analyst

Summary

The job is for a Data Analyst at Bestpass – Fleetworthy. The role involves building dashboards and analytics, data collection, organization, management, and storage, creating reports and dashboards, troubleshooting, communicating with stakeholders, and providing technical expertise in data storage structures.

Requirements

• Familiarity with data modeling – relational (3NF) and dimensional
• Understand how to query and handle large, diverse datasets
• ETL and ELT
• Proficiency in T-SQL and Python
• Familiarity with Dashboarding software (Tableau, Power BI, Sisense, etc.)and the purpose they serve
• Troubleshooting, critical thinking, and solution building
• Communicating data and requirements to non-technical stakeholders, and understanding non-technical stakeholders’ needs to gather requirement
• MS Access, MS Excel, and VBA
• Salesforce
• SSIS and SSRS
• Git and code review
• Containerization
• Bachelor’s degree in a STEM field or equivalent work experience
• Authorized to work in the United States

Responsibilities

• Build dashboards and analytics from core software products
• Create solutions for collecting, collating, and storing data from internal and external sources
• Build simple user interfaces when necessary
• Create repeatable and ad hoc reports or data extracts to serve business needs
• Develop and generate reports and dashboards from single or multiple systems
• Develop, automate, and maintain data collection, organization, management, and storage for ad hoc and/or repeated use
• Extract and transform data from internal systems as well as client and vendor data sets for inclusion in the data warehouse, reports, and dashboards
• Troubleshoot the reporting database environment and reports and communicate with appropriate teams to remedy issues when needed
• Process confidential data and information according to established guidelines
• Manage and maintain the reporting environment, including data sources, security, and metadata
• Support initiatives for data integrity and normalization
• Evaluate changes and updates to source production systems
• Document new reports and dashboards and changes to each
• Provide technical expertise in data storage structures, data mining, and data cleansing
• Visualize data to be digestible to stakeholders
• Create and maintain simple UIs for data requests and uploads
• Train end-users and present new features and findings

Preferred Qualifications

Some travel for onsite meetings or client visits (5-10%)

Benefits

• Flexible work environment with a mix of 100% remote and/or hybrid roles and some that are in the office
• An amazing benefits package so you can rest assured your needs are taken care of
• Paid time off so you can have time to relax and experience a healthy work-life balance
• A 401K plan with an impressive company match. It’s never too early to start saving for retirement!
• Health and wellness-focused work environment with office fitness challenges, and plenty of outdoor space to take a walk or just clear your mind
• Opportunities to participate in charitable events, give back to the community, and get paid for your efforts!
• We reward success with promotions from within and encourage all employees to switch lanes and check out other departments
• We pay hefty referral bonuses to all employees who refer family and friends!