Job Description
The Job/What You'll Do:
The Business Intelligence (BI) 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 ETL Report Developer is responsible for helping with the strategic design and implementation of data marts and data stores while ensuring high levels of data availability and compliance with corporate policies and procedures.
Responsibilities:
The Business Intelligence ETL Report Developer will have four essential job areas
Databases
Write T-SQL queries and stored procedures to return and manipulate data per business needs
Debugging and troubleshooting 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
Reporting & Visualization
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
User Support
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
Participates in the On-Call rotation as required
Projects
Working closely with 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
Knowledge, Skills, Abilities:
Is open to 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.
Strategically plans for diversity initiatives as they relate to Human Resources, including talent acquisition, development, and retention.
Actively promotes staff development by initiating and encouraging communication with employees about issues of diversity and discrimination.
Supports activities of Solari's Diversity and Inclusion Taskforce.
Ability to consistently demonstrate compassion and meet people with compassion; Effort, every interaction deserves my best effort; and Ownership, which drives the company's success.
Ability to act professionally and maintain appropriate boundaries with clients and staff.
Ability to report to work, meetings, training, and job-related activities prepared and as scheduled.
Education & Experience:
Must reside in one of the following states; AZ, CA, OK, TX, WA
3 - 5 years of experience in field, Required
Experience with BI front end reporting tools (Cognos, Power BI, Tableau), Preferred
Certification with MCSA or MTA, Preferred
Associates Degree in IT or related field, Preferred
NOTE: A comparable combination of education/experience and/or training will be considered equivalent to the education listed above.
Working Conditions:
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 10 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. Wireless (Wi-Fi) connection is not permitted for this position; you must be connected into your home internet modem/router with ethernet cabling (Cat5e or better - this can be provided to staff as needed)
Who We Are & What We Offer:
Solari is an award-winning nonprofit that operates a 24/7 crisis line serving statewide in Arizona and Oklahoma. Our mission is to Inspire Hope through our talented and compassionate staff.
Since 2007, Solari has been providing crisis contact center services and in that short time has helped thousands of individuals and families connect to the help they need. Additionally, in that short timeframe, Solari has grown to expand services to a peer-run Warm Line, Serious Mental Illness (SMI) determinations, mobile team dispatches, crisis transportation services, emergency room-based assessments, Department of Child Safety (DCS) rapid response and crisis stabilization services, telephone follow-up to those who need it, tragedy support lines and other in-kind services to the community.
Friendly work environment
401(k) with company match
Generous paid-time-off (PTO)
Health benefits (M/D/V) that start the first of the month following hire date
Competitive compensation
Convenient Tempe location and Hybrid Schedule
On-site fitness room free to all employees
And many more great perks!
Solari is proud to be an equal opportunity employer and does not unlawfully discriminate against any employee or applicant for employee per applicable federal, state, and local laws. At Solari, a diverse mix of highly talented, innovative, and dedicated people come together to make a lifetime impact on each of our Client's lives. All qualified applicants will receive equal consideration for employment.
We are focused on equality and believe deeply in diversity of race, color, ancestry, age, veteran status, marital status, creed, religion, sex, gender, gender identity, sexual orientation, religion, ethnicity, national origin, and other legally protected group status.
The Business Intelligence (BI) 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 ETL Report Developer is responsible for helping with the strategic design and implementation of data marts and data stores while ensuring high levels of data availability and compliance with corporate policies and procedures.
Responsibilities:
The Business Intelligence ETL Report Developer will have four essential job areas
Databases
Write T-SQL queries and stored procedures to return and manipulate data per business needs
Debugging and troubleshooting 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
Reporting & Visualization
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
User Support
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
Participates in the On-Call rotation as required
Projects
Working closely with 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
Knowledge, Skills, Abilities:
Is open to 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.
Strategically plans for diversity initiatives as they relate to Human Resources, including talent acquisition, development, and retention.
Actively promotes staff development by initiating and encouraging communication with employees about issues of diversity and discrimination.
Supports activities of Solari's Diversity and Inclusion Taskforce.
Ability to consistently demonstrate compassion and meet people with compassion; Effort, every interaction deserves my best effort; and Ownership, which drives the company's success.
Ability to act professionally and maintain appropriate boundaries with clients and staff.
Ability to report to work, meetings, training, and job-related activities prepared and as scheduled.
Education & Experience:
Must reside in one of the following states; AZ, CA, OK, TX, WA
3 - 5 years of experience in field, Required
Experience with BI front end reporting tools (Cognos, Power BI, Tableau), Preferred
Certification with MCSA or MTA, Preferred
Associates Degree in IT or related field, Preferred
NOTE: A comparable combination of education/experience and/or training will be considered equivalent to the education listed above.
Working Conditions:
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 10 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. Wireless (Wi-Fi) connection is not permitted for this position; you must be connected into your home internet modem/router with ethernet cabling (Cat5e or better - this can be provided to staff as needed)
Who We Are & What We Offer:
Solari is an award-winning nonprofit that operates a 24/7 crisis line serving statewide in Arizona and Oklahoma. Our mission is to Inspire Hope through our talented and compassionate staff.
Since 2007, Solari has been providing crisis contact center services and in that short time has helped thousands of individuals and families connect to the help they need. Additionally, in that short timeframe, Solari has grown to expand services to a peer-run Warm Line, Serious Mental Illness (SMI) determinations, mobile team dispatches, crisis transportation services, emergency room-based assessments, Department of Child Safety (DCS) rapid response and crisis stabilization services, telephone follow-up to those who need it, tragedy support lines and other in-kind services to the community.
Friendly work environment
401(k) with company match
Generous paid-time-off (PTO)
Health benefits (M/D/V) that start the first of the month following hire date
Competitive compensation
Convenient Tempe location and Hybrid Schedule
On-site fitness room free to all employees
And many more great perks!
Solari is proud to be an equal opportunity employer and does not unlawfully discriminate against any employee or applicant for employee per applicable federal, state, and local laws. At Solari, a diverse mix of highly talented, innovative, and dedicated people come together to make a lifetime impact on each of our Client's lives. All qualified applicants will receive equal consideration for employment.
We are focused on equality and believe deeply in diversity of race, color, ancestry, age, veteran status, marital status, creed, religion, sex, gender, gender identity, sexual orientation, religion, ethnicity, national origin, and other legally protected group status.
Exclusive remote jobs daily