Job Information
Massage Envy Senior Business Intelligence Developer/Data Architect in Scottsdale, Arizona
The Senior Business Intelligence Developer/Data Architect will be responsibible for, but are not limited to leading, and planning overall database and reporting design with existing and new tools and establish vendor data interchanges. The Senior Business Intelligence Developer/Data Architect will interact with the CIO and IT Support Manager, Direct contact with POS vendor, and Direct contact with Outside Consulting Firms.
Essential Functions
Ability to perform logical and physical database design
Become the database subject matter expert for our POS and Marketing platforms
Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role
In-depth understanding of database structure principles
Understanding of Data Warehouse design and structures
Reverse engineer existing POS data structures to enable data mining activities for business impact and planning
Act as the principal on developing and modifying MEF reports for the business
Develop/Use/Train Analysis Services Cubes as needed
Identify Risk in scripting and run POS vendor scripts against production servers
Ad-Hoc research for various requests as Operational and Legal issues come up
Monitor health of database servers for Franchisee Portal, Great Plains and Royalties
Assist Marketing vendors in database performance and data access on MEF server utilization and impact
Plan/Manage/Refresh DEV and QA virtual server environments
Advise on procedure implementation impacts on existing reporting and data interchange infrastructure
Handle feasibility of various requests on an instant basis, before work goes into creating a project.
Works with outside vendors to ensure data integrity and timely data delivery to meet project goals
Strong technical, logical, analytical and problem-solving skills
Ability to communicate effectively with non-technical end users
Maintains and increases professional and technical knowledge and currency by attending workshops, reviewing professional publications etc.
Ability to work independently, juggle multiple priorities, problem solve, and communicate with all
Identify, analyze, prioritize, resolve, and communicate reporting and data quality issues
Additional duties as required or requested by CIO
Education, Experience and Skills Required
Advanced MSSQL T-SQL
Advanced MSSQL Database Administration
Data Warehouse Design
Advanced SQL Server Integration Services
Advanced Server Administration
SQL Server Analysis Services
Experience with Web/REST API development
Experience using .NET Core 2.2 or 3
net experience a plus
NO SQL database
SQL Server with Dapper/Entity Framework or other ORM
Automated unit testing/integration testing
High attention to detail
Massage Envy Franchise LLC Benefits:
In addition to a great work environment, Massage Envy Franchise LLC offers Medical, Dental and Vision Benefits. Paid Life Insurance and 401K, Generous Paid Holidays, vacation, and sick time. At Massage Envy Franchise, LLC, we believe in helping people feel their best through total body care—a mission that touches everyone. And we know that investing in uniquely talented, fiercely passionate people is the key to achieving it. We work hard, we have fun, which is a key part of helping employees feel their best!
Massage Envy Franchising, LLC provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics.
Job ID: 2021-108921
External Company URL: www.massageenvy.com
Street: 14350 N. 87th St.
Post End Date: 3/3/2021
Telecommute: Yes