At SMS Assist, we're not just in the business of fixing properties-we're fixing an entire industry. Typically, facilities maintenance is tough work-both in the nature of the job (plumbing, HVAC, snow removal) and the lack of clarity throughout the experience. We decided a better way wasn't only possible, but essential. Through our award-winning technology platform, built and powered by SMSers, we connect local contractors to our customers and help manage an experience that surpasses expectations.
Recognized on Forbes' Cloud 100 list, Deloitte's Technology Fast 500, Chicago Crain's Top Tech Employers, and more, SMS Assist manages more than 186,000 properties where people live and work. Our customers' livelihoods are in our hands-think a restaurant manager whose only fryer goes down on a busy Friday night or a family in Florida without power after a hurricane. We work across the industries that make up your community, including retail, food service, banking, residential, and more, and we help them find the right provider in our network (we call them Affiliates) in more than 45 trades.
We're innovators, disruptors, and out-of-the-box thinkers. We set each other up for success in the office and for the perfect spike on the volleyball court during an intramural game. We're community volunteers, karaoke partners, and lifelong friends. We're passionate about the people we serve, and we give our all because we care. We want to make every property better, and we want your help to make it happen.
Summary
The Senior Analyst will design and develop dashboards using Tableau Desktop for the common repairs and maintenance data of SMS Assist. In addition, the Senior Analyst will support the development and maintenance of automated processes to identify data and monitor the patterns and trends. They will partner with other team members and collaborate with cross-functional teams to pro-actively devise solutions to data analysis challenges. This multidisciplinary role will provide leadership with detailed solutions for timely analysis and way forwards. The location of the job is United States (Remote). This role will report to the Director of Cost.
Responsibilities

• Supports senior management in the development and implementation of analytical models and creative reporting concepts by using both internal and external data sources to enhance processes and gain efficiencies
• Independently builds, populates, and maintains standard and ad-hoc dashboards, reports and visual presentations to ensure data is conveyed in meaningful and thoughtful formats for all audience levels
• Works with SQL Server Management Studio (SSMS) for query writing, and stored procedure execution, as well as for data analysis
• Supports the development and maintenance of automated processes to identify data and monitor the patterns and trends after assessing current practices and collecting information
• Develop operational, tactical and financial performance tracking dashboards and variance analysis using Tableau and other BI tools
• Take high-level instruction from leadership with minimal supervision and delivers insightful work products
• Proactively identify voids in reporting and analytics, and design solutions for the problem
• Provide management with reports specifying and comparing factors affecting costs
• Appropriately account for the timeliness and quality of all work assignments
• Identifies and implement industry best in class practices

• Ensure confidentiality of internal and external data
• Analyze audits of costs and prepare reports
• Fosters a positive team environment
• Perform ad-hoc projects and other duties as assigned

Professional Skills
These are the professional skills we would expect from an individual fully established in this role.

• Verbal Communication - Advanced
• Written Communication - Advanced
• Teamwork - Advanced
• Learning Agility - Advanced
• Analysis - Expert
• Problem Solving - Advanced
• Process Orientation - Advanced
• Prioritization - Advanced

Role Specific Skills

• Demonstrated analytical skills and an ability to make timely decisions in a logical and effective manner
• Computer Skills: Advanced proficiencies in Microsoft Word, Excel, PowerPoint, Outlook required
• System Experience: SQL and Tableau required

Qualifications
Minimum Qualifications

• Bachelor's degree required
• MBA, MS or MIS preferred
• 07 Year of data or business analysis experience
• Tableau desktop certification preferred

Other Relevant Qualifications

• Background preferably in Business Administration, Business or Data Analytics, Information Systems, Computer Science, Finance, Mathematics, Statistics or related discipline
• Industry trade knowledge: HVAC, electrical, plumbing, general maintenance etc.

Please note, this job description 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, and schedule may change at any time with or without notice.
SMS Assist is an Equal Opportunity Employer (EOE) that welcomes and encourages all applicants to apply regardless of age, race, color, religion, sex, sexual orientation, gender identify and/or expression, national origin, disability, veteran status, marital or parental status, ancestry, citizenship status, pregnancy or other reasons prohibited by law.