Reporting Data Analyst

We need to output HTML fragment with headings

for sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We must not repeat job title. Must not include Job ID etc. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, application instructions. We need to parse the posting. Content: Intro: "We invite you to explore a future with us at PRA Group, a diverse and growing company that has a tangible impact on the global economy." Position Summary: paragraph describing role. Professional Experience: bullet list? Actually lines: "Intermediate-level experience in Data Mining, Data Analysis, Report building and SQL with strong data mining/data visualization capabilities Experience with creating dashboards using either Power BI, Tableau or Qlik Prefer someone with experience working with Excel and GitHub 1-3 years of professional work experience. Good understanding and curiosity regarding business as well as ability to communicate effectively with stakeholders" Education: "BA/BS in a Science, Technology, Engineering, Mathematics (STEM) or quantitative field Solid working experience with: Ability to write SQL code for intermediate query level functioning doing inner, left and right joins, etc. Importing/exporting data into SQL Server from various sources (text files, spreadsheets, Access DBs) Creating ODBC connections to SQL Server from Excel Spreadsheets or Access DBs so that end users can refresh reports directly in Excel or Access Creating/Modifying/Executing T-SQL Queries and Scripts Any experience with either Oracle or Microsoft Fabric is preferred Mining, cleaning, and managing large data sets and troubleshoot data issues identified Data preparation methods handling of missing data and general imputation" Key Responsibilities: list of duties. Salary Range: $73,900.00 - $110,900.00 plus description. Benefits: "In addition to base salary, PRA may offer additional benefits to include performance based bonus programs and/or equity programs depending on the position. PRA offers paid time off, medical, dental, vision, 401k match, life insurance, and other benefits to assist with the physical and mental wellbeing of our employees." Schedule: "This is a hybrid position working onsite in our office 3 days per week." We also have other statements: "All qualified applicants will receive consideration for employment regardless of age, race, color, sex, gender, religion, national origin, physical or mental disability, citizenship, or any other classes recognized by state or local law or any other characteristic protected under applicable federal, state or local law. We are a drug free workplace. To qualify, applicants must be legally authorized to work in the United States, and should not require, now or in the future, sponsorship for employment visa status." This is EEO/legal boilerplate; we should remove. Also: "As a global leader in acquiring and collecting nonperforming loans, PRA Group returns capital to banks and other creditors to help expand financial services for consumers. With thousands of employees worldwide, PRA Group companies collaborate with customers to help them resolve their debt. For more information, please visit www.pragroup.com." This is boilerplate about company; maybe we can keep as part of About the role? The instruction: remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The company description may be considered not boilerplate? It's generic but maybe we can keep as part of About the role. However we have a Position Summary already. Could combine. We need sections: About the role (maybe using Position Summary + company description). Responsibilities (Key Responsibilities). Requirements (maybe Professional Experience + Education?). Qualifications (maybe Education?). Skills (maybe specific technical skills). Benefits (benefits description). Pay (salary range). Schedule (hybrid 3 days). We must not create sections with filler like "commensurate with experience". We have actual salary range, so Pay section is okay. Benefits we have actual list. Schedule we have actual. We must not repeat job title as heading. No Job ID. We must preserve ALL substantive information; do not invent or summarize away detail. So we need to include all details from the posting, but we can reorganize into sections. Must not lose any detail. Let's extract all substantive sentences. Intro: "We invite you to explore a future with us at PRA Group, a diverse and growing company that has a tangible impact on the global economy." Position Summary paragraph: "Handles moderately complex issues and problems. Applies practical knowledge of principles and practices of area of specialty. Supports, but also leads simple to moderately complex projects and programs. Designs, develops, implements, and maintains data programming solutions for data quality and business rules analysis, hypothesis testing, champion/challenger testing, and product or strategy decision advancements. Maintains a technical process expertise through understanding of the software solutions, technical steps, and underlying data used to execute the decisioning. Subject matter expert on the input and output of data to support any research or advancements. Programs for the desired workflow of data decisions and hypothesis testing. Maintains a quality and control aspect of the data execution used for decision making. Is able to build data visualizations to report and inform others what is occurring in the underlying data. This is a hybrid position working onsite in our office 3 days per week." Note: The hybrid sentence appears also later; we should avoid duplication. We'll keep schedule separate. Professional Experience bullet-ish: "Intermediate-level experience in Data Mining, Data Analysis, Report building and SQL with strong data mining/data visualization capabilities Experience with creating dashboards using either Power BI, Tableau or Qlik Prefer someone with experience working with Excel and GitHub 1-3 years of professional work experience. Good understanding and curiosity regarding business as well as ability to communicate effectively with stakeholders" Education: "BA/BS in a Science, Technology, Engineering, Mathematics (STEM) or quantitative field Solid working experience with: Ability to write SQL code for intermediate query level functioning doing inner, left and right joins, etc. Importing/exporting data into SQL Server from various sources (text files, spreadsheets, Access DBs) Creating ODBC connections to SQL Server from Excel Spreadsheets or Access DBs so that end users can refresh reports directly in Excel or Access Creating/Modifying/Executing T-SQL Queries and Scripts Any experience with either Oracle or Microsoft Fabric is preferred Mining, cleaning, and managing large data sets and troubleshoot data issues identified Data preparation methods handling of missing data and general imputation" Key Responsibilities list: - Provide data mining, cleaning, and data analysis using database programming/mining tools. - Execution and troubleshooting of coding processes. - Conduct data analysis to identify the impact of process changes - Enhance the monitoring and control mechanisms to business processes to ensure we maintain compliance with policies and procedures. - Maintain documentation along with change management and testing documentation as required. - Support existing dashboards for activity performance as it relates to business processes being maintained by the department. - Research data issues and report and resolve discrepancies. - Assist other senior data leads in executing projects, ad-hoc request, or technical execution of changes when it comes to data or activities. Salary Range: "$73,900.00 - $110,900.00 PRA Group has an effective process for assessing market data and establishing ranges to ensure we remain competitive. Actual compensation is influenced by a wide array of factors including but not limited to skill set, level of experience, specific working location and market position. This posted salary range is a good faith and reasonable estimate, and PRA Group reserves the right to adjust this range depending on the qualifications and location of the selected candidate. In addition to base salary, PRA may offer additional benefits to include performance based bonus programs and/or equity programs depending on the position." Benefits: "PRA offers paid time off, medical, dental, vision, 401k match, life insurance, and other benefits to assist with the physical and mental wellbeing of our employees." EEO etc to remove. Company description after that: "As a global leader in acquiring and collecting nonperforming loans, PRA Group returns capital to banks and other creditors to help expand financial services for consumers. With thousands of employees worldwide, PRA Group companies collaborate with customers to help them resolve their debt. For more information, please visit www.pragroup.com." This is maybe not boilerplate but could be considered generic; but it's substantive about company. We could include in About the role. We need to avoid duplication: The hybrid sentence appears in Position Summary and also separate line "This is a hybrid position working onsite in our office 3 days per week." We'll keep schedule section only. We need to ensure we don't create sections with filler. All sections we create must have substantive content. Let's plan sections: - About the role: combine introductory sentence + Position Summary (excluding hybrid sentence) + maybe company description. - Responsibilities: list from Key Responsibilities. - Requirements: maybe combine Professional Experience and Education? But we have separate sections Requirements and Qualifications and Skills. We need to decide what goes where. The instruction: use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can allocate: - About the role: overview. - Responsibilities: duties. - Requirements: maybe mandatory experience/education. - Qualifications: maybe preferred qualifications. - Skills: specific technical skills. - Benefits: benefits. - Pay: salary range. - Schedule: hybrid. We must not create a section if content is vague/filler. We have concrete content for each. Let's extract: Requirements (mandatory): Professional Experience: "Intermediate-level experience in Data Mining, Data Analysis, Report building and SQL with strong data mining/data visualization capabilities", "Experience with creating dashboards using either Power BI, Tableau or Qlik", "Prefer someone with experience working with Excel and GitHub" (that's prefer, maybe qualifications), "1-3 years of professional work experience.", "Good understanding and curiosity regarding business as well as ability to communicate effectively with stakeholders". Also Education: "BA/BS in a Science, Technology, Engineering, Mathematics (STEM) or quantitative field". Also maybe "Solid working experience with: Ability to write SQL code for intermediate query level functioning doing inner, left and right joins, etc." etc. That seems more like skills. Qualifications (preferred): "Any experience with either Oracle or Microsoft Fabric is preferred", "Prefer someone with experience working with Excel and GitHub" (though we already used). Also maybe "Experience with creating dashboards using either Power BI, Tableau or Qlik" could be requirement or qualification. We'll decide. Skills: list of technical skills: SQL writing, importing/exporting data, ODBC connections, T-SQL, mining/cleaning large data sets, data preparation methods handling missing data and imputation, data visualization, Power BI/Tableau/Qlik, Excel, GitHub, etc. We need to avoid duplication. Let's try to allocate. Better approach: Keep sections simple: About the role, Responsibilities, Requirements (combining experience+education), Skills (technical), Benefits, Pay, Schedule. Omit Qualifications if we don't have distinct preferred qualifications beyond what's in Requirements/Skills. But we have some preferred qualifications: Oracle/Microsoft Fabric experience, Excel/GitHub experience. Could put those under Skills as "Preferred: experience with Oracle or Microsoft Fabric, Excel, GitHub". Or we could have Qualifications section for those. Given instruction to prefer few substantive sections over many thin ones, we could combine Qualifications into Skills or Requirements. But we have headings list includes Qualifications; we can omit if not needed. However we have some distinct preferred qualifications; we could put them under Skills as "Preferred skills". That might be okay. Thus sections: About the role, Responsibilities, Requirements, Skills, Benefits, Pay, Schedule. Now we need to ensure we don't lose any substantive info. Let's draft About the role: Paragraph: "We invite you to explore a future with us at PRA Group, a diverse and growing company that has a tangible impact on the global economy. Handles moderately complex