Senior Analyst, BI

General Summary

The Senior Analyst, BI - Tableau / Domo is responsible for maintaining consistent data quality across managed entities in our business systems and is responsible for developing Tableau / Domo analytics, dashboards, and reports related to the company's data warehouse development and maintenance. They must be well-versed in creating both standard and specialized analytics to meet the needs of Twin Star Home. The Enterprise Data Analyst partners across the organization to ensure data is created, managed, and effectively utilized. They also maintain the integrity and performance of the company databases. They will be responsible for training / informing / providing support to end users, as well as assisting in the adoption of the Tableau Toolset across the organization.

Primary / Key Essential Functions and Responsibilities

• Review and optimize the current TSH Data and BI environment.
• Possess a comprehensive Information Technology and Services training, background, and expertise
• Working knowledge of database design, development, and maintenance
• Experience working within a cloud development environment (e.g., Azure, AWS, Google, etc.)
• Strong working knowledge of the Tableau toolset (primary) and Domo
• Ability to define both technical and customer requirements necessary to bring analytics from the conceptual to product delivery
• Demonstrably strong data analysis and data mining skills (Snowflake and Tableau)
• Manage design and operation of databases and business intelligence data warehouses on Snowflake; maintain the database; and schedule and perform regular server maintenance.
• Continually review processes for improvement; review existing solutions, analyzing the impact of database changes to the business, including evaluating new data needs for the company.
• Performs database performance analysis, capacity planning, system sizing, and ongoing maintenance / tuning to ensure maximum performance
• Implement a backup and recovery plan, including preventing data loss; and ensuring data is secure
• Debug database issues on live data
• Develop and test methods to synchronize data
• Ensure databases run efficiently & platform availability
• Provide end-to-end technical support and problem resolution
• Database programming in Snowflake to support company procedures
• Gather data from Microsoft Navision, NetSuite or D365 Business Central to feed other systems, i.e., EDI and Anaplan Demand Planning
• Solid understanding of data analysis, budgeting, and business operations
• Working knowledge of various Extract, Transform, and Load tools
• Participate in the development and maintenance of data dictionaries, to include identification of business-critical fields
• Provide reporting coupled with suggested actions to leaders whose teams provide master data inputs, to reduce data quality issues, non-value record maintenance, and process deviation
• Identify solutions which improve data architecture, quality, and processes as well as drive the implementation of such solutions
• Identify and manage data cleanup projects to improve data accuracy
• Collaborate in designing and delivering the Master Data Management technology foundation across the entire company
• Develop and implement a periodic review, inclusive of robust reporting, of all master data to ensure data is current and accurate across business functions, conforms to business rules, and meets data quality standards
• Assist with new user set up to ensure employees have proper access to Tableau / Domo. Design, Develop and Customize Financial and Operational Analytics
• Work closely with financial and operational directors in devising, designing, developing, and maintaining needed analytics to support business objectives
• Develop and maintain dashboard reports according to specifications developed in conjunction with company Directors / Executive Leadership Team
• Maintain organized libraries of all coding necessary to maintain data estate and related output products
• Develop and maintain complete documentation for all production data warehouse analytics, dashboards, and reports.

Education and / or Experience and Qualifications

Minimum Education : Bachelor's Degree (B.S. / B.A.) in Computer Science or equivalent degree and / or work experience Minimum Experience : Five (5) years' experience as a Database Administrator and Two (2) + years' experience in data analysis, creation of reports and dashboards, including creating and implement key metrics.

Knowledge, Skills and Abilities

Financial Responsibility

n / a

Management / Supervisory Authority

n / a

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; balance; stoop, kneel, crouch or crawl; talk or hear. The employee must occasionally lift and / or move up to 25 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus. The employee is exposed to outside weather conditions.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. External and internal applicants, as well as position incumbents who become disabled, must be able to perform the essential job functions either unaided or with assistance of a reasonable accommodation as determined on a case by case basis.

Standard Specifications

The above statements are intended to describe the general nature and level of work performed and represents minimum levels of knowledge, skills, and / or abilities. To perform this job successfully, the incumbent will possess the abilities or aptitudes to perform each duty proficiently.

A review of this description has excluded the marginal functions of the position that are incidental to the performance of fundamental job duties and is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. Employees will be required to perform any other job-related duties assigned by their supervisor.

This document does not create an employment contract, implied or otherwise, other than an "at will" employment relationship.

8 : 30am-5 : 30pm