ETL Report Developer

Summary

Solari, Inc. is a nonprofit organization operating crisis contact center and related support services. The ETL Report Developer collaborates with end users to develop data systems, data warehouse solutions, reports, and dashboards that support business insight and operational decision-making. The role also provides data support, performance troubleshooting, documentation, and assistance with cross-functional business intelligence projects.

Responsibilities

• Write T-SQL queries and stored procedures to return and manipulate data
• Debug and troubleshoots queries, stored procedures, and data integration solutions
• Develop SSIS packages for ETL into data warehouse
• Optimize query performance tuning by database refactoring
• Develop and build analytic reports/dashboards from conception to publication
• Develop deep understanding of Solari's data sources, data relationships and logic needed to produce consistently reliable reports
• Update existing BI reports to accommodate changing business needs
• Provide support for data and reporting requests
• Performance troubleshooting at all levels (database query, report interfaces, etc.)
• Creating documentation for end-user consumption, troubleshooting and auditing
• Participates in the On-Call rotation as required
• Identify data and reporting needs
• Help gather and write reporting requirement documents
• Assist with other BI work on complex, cross-business functional projects
• Other duties as assigned

Skills

• Remote (Must physically reside in AZ, CO, FL, IL, MA, MN, OH, OK, OR, PA, TX, VA, or WA)
• * Thought: Understanding the Business – **Tech Savvy**
• * Thought: Understanding the Business – **Customer Focus**
• * Self: Being Flexible and Adaptable – **Manages Ambiguity**
• * Results: Focusing on Performance – **Ensures Accountability**
• * Self: Being Authentic – **Courage**
• * People: Building Collaborative Relationships – **Collaborates**
• * 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
• * Minimum: ​Associate Degree​
• * **3-5 years of experience** in the field, Required
• * **Experience/Training Specifications:** Strong T-SQL coding experience; understanding complex stored procedures, views, data aggregation/manipulation through table joins, database design, normalization and de-normalization techniques
• * Strong BI front end reporting tools coding experience with Cognos Analytics, Power BI, Tableau Desktop/Server/Public
• * Possesses strong analytical and troubleshooting skills
• * Demonstrated attention to detail on ensuring the accuracy and efficiency of individual work
• * Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences
• While performing the job duties in the office or at a home office, the employee is frequently required to stand, walk, sit, and use hands; they 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. Exposure to noise typical with office operations. Ability to hear and speak. Employees must maintain a stable and secure private home internet with a minimum of 50Mbps download and 5Mbps upload, and an average jitter less than 20% of latency
• Education Specifications: Degree in Information Technology, Computer Science, or related field preferred
• * Bachelor's degree in IT, Computer Science, or related field, Preferred
• * Preferred: Certifications with MCSA, MTA

Qualifications

Must Haves

• Remote (Must physically reside in AZ, CO, FL, IL, MA, MN, OH, OK, OR, PA, TX, VA, or WA)
• * Thought: Understanding the Business – **Tech Savvy**
• * Thought: Understanding the Business – **Customer Focus**
• * Self: Being Flexible and Adaptable – **Manages Ambiguity**
• * Results: Focusing on Performance – **Ensures Accountability**
• * Self: Being Authentic – **Courage**
• * People: Building Collaborative Relationships – **Collaborates**
• * 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
• * Minimum: ​Associate Degree​
• * **3-5 years of experience** in the field, Required
• * **Experience/Training Specifications:** Strong T-SQL coding experience; understanding complex stored procedures, views, data aggregation/manipulation through table joins, database design, normalization and de-normalization techniques
• * Strong BI front end reporting tools coding experience with Cognos Analytics, Power BI, Tableau Desktop/Server/Public
• * Possesses strong analytical and troubleshooting skills
• * Demonstrated attention to detail on ensuring the accuracy and efficiency of individual work
• * Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences
• While performing the job duties in the office or at a home office, the employee is frequently required to stand, walk, sit, and use hands; they 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. Exposure to noise typical with office operations. Ability to hear and speak. Employees must maintain a stable and secure private home internet with a minimum of 50Mbps download and 5Mbps upload, and an average jitter less than 20% of latency
• Education Specifications: Degree in Information Technology, Computer Science, or related field preferred
• * Bachelor's degree in IT, Computer Science, or related field, Preferred
• * Preferred: Certifications with MCSA, MTA

Benefits

• Friendly work environment
• Generous paid time off (PTO)
• Health benefits (Medical/Dental/Vision) that start the first of the month following the hire date
• Convenient office locations and Hybrid Schedule
• On-site fitness room free to all employees (Tempe Office)
• 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