ETL Report Developer

We need to output HTML fragment with sections: h3 headings for sections present: About the role, Responsibilities, Requirements (or Knowledge, Skills, Abilities, Education & Experience?), Benefits, Pay, Schedule. We must only include sections if posting has real specific content. The posting includes location, description, responsibilities, knowledge/skills/abilities, education & experience, working conditions, who we are & what we offer (benefits). No explicit pay or schedule mentioned (except maybe hybrid schedule mentioned under "Who We Are & What We Offer": "Convenient office locations and Hybrid Schedule". That's schedule info: hybrid schedule. So we can include Schedule section with that detail. Pay: not mentioned, so omit. Benefits: there is a list of benefits under Who We Are & What We Offer. So include Benefits section. We need to not repeat job title as heading. Use

for each section heading. We need to use

• for any list of duties/requirements/benefits. Use

  for prose. We must preserve all substantive information, not invent or summarize away detail. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The posting includes EEO statements at end; we should remove those. Also remove "Who We Are & What We Offer:" heading? We'll incorporate benefits. We need to include location? Possibly as part of About the role? Could be a short paragraph. We need to include "The Job/What You’ll Do:" as prose maybe under About the role. Let's extract content: Location: Remote (Must physically reside in AZ, CO, FL, IL, MA, MN, OH, OK, OR, PA, TX, VA, or WA). The Job/What You’ll Do: The ETL Report Developer works collaboratively with Solari end users to develop data systems that provide accessible information for actionable business insight, driving business decisions, and improving operations across the organization. The ETL/Report Developer will provide enterprise-wide data warehouse expertise with emphasis on data design, access, usage, security, and quality of information assets. 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 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 Reporting & Visualization 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 User Support 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 Projects 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 Knowledge, Skills, Abilities: 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. Education & Experience: Minimum: Associate Degree Education Specifications: Degree in Information Technology, Computer Science, or related field preferred 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 Bachelor's degree in IT, Computer Science, or related field, Preferred Preferred: Certifications with MCSA, MTA 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 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. https://speed.cloudflare.com/ Who We Are & What We Offer: Solari is an award-winning nonprofit that operates a 24/7 crisis line serving statewide in Arizona, Oklahoma and Colorado. 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 Generous paid time off (PTO) Health benefits (Medical/Dental/Vision) that start the first of the month following the hire date Competitive compensation 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 We need to remove boilerplate: EEO statements at end (the long paragraph about equal opportunity). Also remove the URL maybe? It's part of working conditions; we can keep as part of description? It's a link; we could keep as plain text but maybe it's okay. It's not boilerplate; it's a requirement. We'll keep. We need to format sections: - About the role (maybe combine location and job description). Could have a paragraph with location and description. - Responsibilities: list items. - Knowledge, Skills, Abilities: could be a list? It's a mix of statements; we could put as

  • each bullet? The original has headings like Thought:..., Self:..., etc. We could keep as

    prose but better to list each bullet as

  • . However the instruction: Use
    • for any list of duties/requirements/benefits. For KSAs, it's a list of abilities; we can treat as list. - Education & Experience: also list. - Benefits: list. - Schedule: mention Hybrid Schedule. We must not include Pay. We must not repeat job title as heading. We must not include duplicated lines. Let's craft HTML. We'll start with

      About the role

      then

      containing location and job description. Then

      Responsibilities

      then
      with each responsibility item. We need to parse responsibilities into items: The posting says four essential job areas… then lists: Databases - 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 Reporting & Visualization - 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 User Support - 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 Projects - 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 We'll create
      • for each bullet. Knowledge, Skills, Abilities: we have statements: - 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. We'll list each as
      • . Education & Experience: - Minimum: Associate Degree - Education Specifications: Degree in Information Technology, Computer Science, or related field preferred - 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 - Bachelor's degree in IT, Computer Science, or related field, Preferred - Preferred: Certifications with MCSA, MTA We'll list each as
      • . Benefits: list from Who We Are & What We Offer: - Friendly work environment - Generous paid time off (PTO) - Health benefits (Medical/Dental/Vision) that start the first of the month following the hire date - Competitive compensation - Convenient office locations and Hybrid Schedule (but schedule we might separate) - 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