Sr. Data Analyst - Tableau Developer

We need to output HTML fragment with sections: headings

for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real content. We must not repeat job title. Must not include Job ID etc. Must preserve all substantive info, no invented details. Remove boilerplate like EEO, legal, application instructions, etc. Also remove duplicated lines. We need to parse the posting. Location line: "Location: 4910 Tiedeman Road, Brooklyn Ohio". That's location info. Should we include? Possibly as a paragraph under About the role? The instruction: "Do NOT repeat the job title as a heading (the page already shows it) and do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short

or drop it." So location is minor metadata; we can put in a short

. Job Description paragraph: "As part of Key’s second line-of-defense Compliance Risk Management function, the Risk Evaluation and Assurance Program (the “REA Program”) has the responsibility for evaluating Key’s ongoing compliance with applicable laws and regulations through the execution of compliance and operational risk monitoring and testing across Key’s lines of business, products, and functional activities. This role will be responsible for designing, developing, and maintaining Tableau dashboards and reporting solutions that support regulatory compliance, risk management, control monitoring, and executive decision-making. The ideal candidatde possesses strong data visualization skills, experience working with large and complex datasets, and an understanding of governance, risk, and compliance processes. This individual will work closely with REA, Risk Management, Internal Audit, Data Analytics, and Technology partners to transform data into actionable insights that support effective risk oversight and regulatory compliance." We can treat that as About the role (or overview). Use

About the role

then

with that text. Essential Job Functions: list of bullet points. We'll put under

Responsibilities

with

• each bullet. We need to extract bullet points from "Essential Job Functions". The text after that heading includes many sentences separated by periods but not bullet list. We need to turn each distinct duty into a list item. The instruction: Use
  • for any list of duties/requirements/benefits. So we need to parse duties. Let's list them: - Work within a team of risk evaluation and assurance professionals, working to design, develop, and maintain Tableau dashboards, scorecards, and self-service reporting solutions to provide an independent second-line-of-defense approach to risk-based monitoring, testing, and analytics. - Demonstrate strong collaboration skills by partnering with business teams to gather reporting requirements and translate them into scalable analytical solutions. - Explore and analyze data to identify trends and outliers, evaluate compliance with internal policy/procedures and/or regulatory requirements, and assess root cause(s) of any issues identified. - Develop data models and data visualization standards that support regulatory reporting, compliance monitoring, control testing, risk assessments, and issue management activities. - Ensure data accuracy through validation, reconciliation, and quality assurance procedures. - Optimize Tableau workbooks for performance, usability, scalability, and maintenance. - Connect Tableau to multiple data sources, including SQL Server, cloud-based data warehouses, data lakes, and enterprise reporting repositories. - Develop and support automated reporting processes and recurring management reporting packages. - Create technical documentation, data dictionaries, and user training materials. - Support audits, regulatory examinations, and management inquiries related to compliance reporting and analytics. - Working knowledge, as well as ability and interest in maintaining, and continuously developing knowledge of banking products (e.g. – lending, deposits, etc.) and ability to understand its applicability to data analytics, testing, and monitoring strategies. - Ability and interest in developing knowledge of financial services industry source systems (e.g. loan origination/servicing, deposits, etc.), operations/process flows, banking regulations, and compliance frameworks. We'll include these as li. Next: Required Qualifications: list of bullet points. We'll put under

    Requirements

    or

    Qualifications

    . The instruction says we can use headings like Requirements, Qualifications, Skills. We need to decide. Probably combine qualifications and required qualifications into a Requirements section. We'll include bullet list. Required Qualifications text: - Bachelor’s Degree in Information Technology/Systems (IT / MIS), Business Analytics, Computer Science, or other related quantitative or IT field of study. - Minimum 2 years of practical and functional experience in data analysis and reporting typically achieved through work as a: business, data, operations, compliance, or risk analyst; internal auditor; or role that includes significant aspects of the listed essential job functions. - Strong SQL skills, including complex joins, aggregations, window functions, and performance optimization. - Skill and ability to work with big data and navigate data warehouse(s) and retrieving, combining, and analyzing data. - Experience with retrieving and a proficient understanding of banking products and transactional data and customer information data. - Autonomous, self-motivated, and flexible with the ability to adapt quickly to change or shifting priorities in a fast-paced environment. - High ethical standards, strong critical/strategic thinking, detective, analytical, and problem-solving skills. - Strong interpersonal skills, effective communication (verbal and written) with the ability to develop and maintain strong, collaborative relationships in a team environment and with mid- to senior-level management and internal clients. - Required Technical Skills: Tableau Desktop, Tableau Server / Tableau Cloud, SQL, Data Visualization and Dashboard Design, Microsoft Excel We can treat the last as part of qualifications or maybe a Skills section. But we can include under Requirements. Preferred Skills/Competencies: list. - Knowledge of financial services industry source systems (e.g. loan origination/servicing, deposits, etc.), operations/process flows, banking regulations, and compliance frameworks. - Advanced knowledge, professional certification, or expertise in database querying, data transformation, data visualization, and/or analytical software or programming languages (e.g. SAS, SQL, ACL, Tableau, etc.) - Preferred Technical Skills: Python, SAS, BigQuery, Power BI, ETL and Data Integration Tools We can put under

    Preferred Skills

    or Skills. Compensation And Benefits: includes base salary range and incentive compensation, plus benefits link. Also mentions flexible workspace approach. We need to include Pay and Benefits sections if actual content. The posting states: "This position is eligible to earn a base salary in the range of $80,000.00 - $150,000.00 annually. Placement within the pay range may differ based upon various factors, including but not limited to skills, experience and geographic location. Compensation for this role also includes eligibility for incentive compensation which may include production, commission, and/or discretionary incentives. Please click here for a list of benefits for which this position is eligible. Key has implemented an approach to employee workspaces which prioritizes in-office presence, while providing flexible options in circumstances where roles can be performed effectively in a mobile environment." Thus we have Pay info (salary range, incentive). Benefits: they say "Please click here for a list of benefits" but not listing them. Since we cannot invent details, we should not create a Benefits section unless the posting actually states them. It only references a link; we cannot list benefits. So we should not create a Benefits section because we don't have the actual benefits listed. However we could include a short paragraph referencing that benefits info is available via link? The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." The link is not substantive; it's a reference. We could include a sentence: "Benefits information is available via the provided link." But that's adding interpretation. Might be okay to include as a short p under Benefits? But they said never create Benefits sections unless the posting actually states them. Since they didn't state benefits, we should not create a Benefits heading. However we could include the compensation info under Pay heading. The Schedule: they mention flexible workspace approach: "Key has implemented an approach to employee workspaces which prioritizes in-office presence, while providing flexible options in circumstances where roles can be performed effectively in a mobile environment." That's about work arrangement, not schedule. Could be considered Schedule? Not exactly. There's no explicit schedule (e.g., full-time, part-time). So we should not create Schedule section. Thus we will have sections: About the role, Responsibilities, Requirements (or Qualifications), Preferred Skills, Pay. Possibly also Location as a short p before sections. We must not repeat job title. Use

    for each section heading. We need to output only HTML fragment, no /, no markdown. Let's craft. First, maybe a

    for location:

    Location: 4910 Tiedeman Road, Brooklyn, Ohio

    Then About the role:

    About the role

    ...

    Responsibilities:

    Responsibilities

    ...
    Requirements:

    Requirements

    ...
    Preferred Skills:

    Preferred Skills

    ...
    Pay:

    Pay

    ...

    We need to ensure we preserve all substantive info. Let's copy the About the role paragraph exactly as given, fixing typo "candidatde" maybe keep as is? It's a typo in source; we should preserve as is? The instruction: preserve ALL substantive information; do NOT invent or summarize away detail. The typo is part of the source; we should keep it exactly. So we keep "candidatde". Also keep quotes and punctuation. Now Responsibilities list items: need to ensure we capture each bullet exactly as in text. Let's copy them. I'll list them: 1. Work within a team of risk evaluation and assurance professionals, working to design, develop, and maintain Tableau dashboards, scorecards, and self-service reporting solutions to provide an independent second-line-of-defense approach to risk-based monitoring, testing, and analytics. 2. Demonstrate strong collaboration skills by partnering with business teams to gather reporting requirements and translate them into scalable analytical solutions. 3. Explore and analyze data to identify trends and outliers, evaluate compliance with internal policy/procedures and/or regulatory requirements, and assess root cause(s) of any issues identified. 4. Develop data models and data visualization standards that support regulatory reporting, compliance monitoring, control testing, risk assessments, and issue management activities. 5. Ensure data accuracy through validation, reconciliation, and quality assurance procedures. 6. Optimize Tableau workbooks for performance, usability, scalability, and maintenance. 7. Connect Tableau to multiple data sources, including SQL Server, cloud-based data warehouses, data lakes, and enterprise reporting repositories. 8. Develop and support automated reporting processes and recurring management reporting packages. 9. Create technical documentation, data dictionaries, and user training materials. 10. Support audits, regulatory examinations, and management inquiries related to compliance reporting and analytics. 11. Working knowledge, as well as ability and interest in maintaining, and continuously developing knowledge of banking products (e.g. – lending, deposits, etc.) and ability to understand its applicability to data analytics, testing, and monitoring strategies. 12. Ability and interest in developing knowledge of financial services industry source systems (e.g. loan origination/servicing, deposits, etc.), operations/process flows, banking regulations, and compliance frameworks. Check for any missing: The original also had "Working knowledge, as well as ability and interest in maintaining, and continuously developing knowledge of banking products (e.g. – lending, deposits, etc.) and ability to understand its applicability to data analytics, testing, and monitoring strategies." That's item 11. Item 12: "Ability and interest in developing knowledge of financial services industry source systems (e.g. loan origination/servicing, deposits, etc.), operations/process flows, banking regulations, and compliance frameworks." Now Requirements list: - Bachelor’s Degree in Information Technology/Systems (IT / MIS), Business Analytics, Computer Science, or