Etl Developer Jobs

Hand & Stone Franchise Corporation is currently seeking a ETL Developer

About Hand & Stone:

Hand & Stone is the fastest-growing massage and facial franchise in the United States. The Hand and Stone Brand was launched in 2004 by founder John Marco, and today now boasts over 550 open locations in the U.S. and Canada. We are the industry leader in providing quality, affordable membership-based massage and facial services.

Hand & Stone works hard to create a great culture for our corporate team and our system of franchises around the country. We value hard work, but we also recognize the humanity of each of our employees and do our best to meet our people where they are. We thrive on recognizing and rewarding our team for their accomplishments and continue to grow as a brand and regularly create new growth opportunities for our people.

Our Company Mission:

Hand & Stone Massage and Facial Spa is a brand built and supported by professionals, passionately dedicated to providing superior massage and facial experiences at an affordable price. Hand & Stone Franchise Corp. is dedicated to helping driven and motivated entrepreneurs pursue a balanced lifestyle with our supportive and fulfilling franchise opportunities.

What We Offer:

• Paid Time Off
• Professional training, development, and continuing education opportunities.
• 401(k) + match
• Health, dental, vision and a full suite of voluntary benefits.
• Free monthly massage or facial service
• High growth opportunities in a thriving brand.

The ETL Developer’s role exists to develop and maintain reporting databases using the Microsoft stack, primarily in Azure, ensuring high levels of data availability. They will also evaluate and advise on database technology components, such as software, hardware, and networking. Finally, the engineer will assist in implementing and maintaining reporting dashboards across the organization.

Responsibilities:

• Design and deploy data table structures, reports, and queries.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Provide data management support to users.
• Develop and maintain ETL processes.
• Create and maintain technical documentation.
• Assure security of data from external parties and for management of row-level-security within the organization.
• Other duties as assigned.
• Diagnose and resolve database access and performance issues.
• Produce ad-hoc queries that develop reports to support business needs.
• Create reports and data models using Power BI that meet business requirements.
• Develop and maintain database stored procedures, views, and functions that support reporting data models.
• Plan and coordinate backup and disaster recovery setup.
• Maintain data warehouse

Candidates MUST possess the following qualifications:

• 3+ years of development experience within the Microsoft/SQL stack
• Experience creating charts, graphs, dashboards in one or more of the following programs: Excel, SSRS, Power BI, Tableau, Qlik and/or similar programs.
• Excellent verbal and written communication skills
• 1+ year of experience developing Azure data solutions
• 1+ year of T-SQL experience
• Ability to coordinate and work cohesively with a development team (no ‘code-loners’)

Ideal candidates would possess these additional qualifications:

• Familiarity with cloud services (AWS, Azure (preferred), Google Cloud)
• Experience with SSAS, Tabular-based reporting, and Tabular Data Models
• Familiarity with Kimball methodologies of data warehousing
• Power Query ("M" language), and DAX language experience
• In-depth understanding of data management (e.g., permissions, recovery, security, and monitoring)
• Professional presentation skills and the ability to present to audiences of 10-15 people.
• Willingness to creatively engage with customers to come up with custom solutions
• Comprehensive grasp of data visualization methods and data modeling for effective report creation
• A broad understanding of data visualization methods and techniques
• Basic to intermediate experience with SSMS and SSIS
• Understanding of the difference between application database design and reporting database design
• Ability to design, construct, and maintain data warehouses
• Broad business experience with proficient ability to talk to executives in business terms

Hand and Stone is an Equal Opportunity Employer