Senior ETL Report Developer

Solari•Tempe, AZ

1d•Remote

About The Position

The Senior ETL Report Developer assists and supports the discovery, development, and publication of all Solari data, reports, and dashboards to create actionable business insight which help answer business questions, drive business decisions, and improve operations across the Solari, Inc organization. Additionally, the Senior ETL/Report Developer will help drive data analytics design, architecture, and modelling as well as coordinate and work directly with business stakeholders in the collection and translation of specifications and requirements and provide mentorship to junior BI developers.

Requirements

6+ years of experience in the field, Required
Practical workplace coding experience in SQL (T-SQL).
Practical workplace coding experience with BI front-end reporting tools (Cognos, Power BI, Tableau).
Microsoft SQL Server 2016 or later
Cognos Analytics
Microsoft Office 365 Suite (Excel, Word, PowerPoint, Outlook, Teams)
Tableau Desktop/Server
JIRA
Microsoft Visual Studio
Ability to act professionally and maintain appropriate boundaries with clients and staff.
Ability to report to work as scheduled, meetings, training, and job-related activities prepared and as scheduled.
Ability to consistently demonstrate compassion and meet people with compassion; Excellence, every interaction deserves my best effort; and Ownership, which drives the company's success.
Maintains an open and accepting mindset by being an active learner, participating in discussions with others, trying new approaches and ideas, and being self-aware and self-reflective for continual personal, professional, and leadership growth.

Nice To Haves

Bachelor's degree in IT, Computer Science, or related field, Preferred
Certifications with MCSA, MTA

Responsibilities

Write T-SQL queries and stored procedures to return and manipulate data per business needs
Debug and troubleshoot queries, stored procedures, and data integration solutions
Develop SSIS packages for ETL into data warehouse
Optimize query performance tuning by database refactoring (making code more efficient and maintainable), normalizing table objects
Develop and build analytic reports/dashboards from conception to publication
Develop deep understanding of Solari's databases, identify appropriate data sources, relationships, and logic needed to produce consistently reliable reports
Update existing BI reports to accommodate business needs or to create new key performance metrics
Provide developer support for data requests
Performance troubleshooting at all levels (database query, report interfaces, etc.)
Creating documentation for end-user consumption, troubleshooting and auditing
Participate in the On-Call rotation as required.
Co-lead of BI team to identify data and reporting needs
Assist in writing business requirement documents
Works on large complex projects, which cross over multiple Solari business functions. Meets with appropriate technical staff, end users, and senior management.
Other duties as assigned

Benefits

Generous paid time off (PTO)
Health benefits (Medical/Dental/Vision) that start the first of the month following the hire date
Basic Life Insurance
Voluntary Life, Spouse, Child Insurance
Critical Illness w/free dependents
Critical Illness Spouse
Short Term & Long Term Disability- Starts first of the month after 90 days of employment
401K & 401K Roth - Starts first of the month after 90 days of employment
United Pet Care
LifeLock for identity theft
LYRA EAP Program- 25 free sessions for mental health per family member