Senior Database Consultant

We need to output HTML fragment with sections: About the role? Actually the posting includes "What You'll Be Doing" is responsibilities. "Required Education, Experience, and Skills" is requirements/qualifications. "Preferred Education, Experience, and Skills" maybe also qualifications. "Who We Are" maybe about company but not required? Could be "About the company" but not listed as allowed headings. Allowed headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to map content. We have: Clearance: U.S. Citizenship required, Active Public Trust in DHS highly preferred. That's a requirement. What You'll Be Doing: responsibilities. Required Education, Experience, and Skills: list of required qualifications. Preferred Education, Experience, and Skills: preferred qualifications. Salary range: Pay section. Benefits: from Who We Are: list benefits. Schedule: maybe not present; we should not create schedule unless present. Not present. We need to avoid repeating job title as heading. No Job ID. We need to use

for section headings. We need

• for any list of duties/requirements/benefits. We need

  for prose. We must preserve all substantive info, not invent. We must remove boilerplate: EEO, legal, etc. Also remove "Who We Are" maybe we keep benefits but not the whole paragraph? We need to keep benefits details. The "Who We Are" includes description of company; that may be considered "About the role"? Not exactly. Could be "About the role" maybe not. But we could include a short paragraph about company under "About the role"? The instruction: Use

  for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have About the role (maybe a brief description of the role). Responsibilities (What You'll Be Doing). Requirements (maybe required education/experience). Qualifications (maybe preferred?). Skills maybe separate? But we can combine. We need to avoid filler sections. So we need to include sections only if there is real content. We have content for: Responsibilities, Requirements (required), Qualifications (preferred), Pay, Benefits. We could also have Skills section but we already have skills in requirements/qualifications. Might be redundant. Better to have Requirements (required) and Qualifications (preferred). Skills maybe not needed. Thus sections: Responsibilities, Requirements, Qualifications, Pay, Benefits. We need to include About the role? Not necessary if we don't have content. Could we put a short paragraph about role from first sentence? Actually "What You'll Be Doing:" is responsibilities. The initial sentence: "You will be working with an established team to create meaningful dashboards that support our customer's mission-critical decision-making." That's part of responsibilities. So we can include that in responsibilities. Thus we will not have About the role. Now we need to format. Responsibilities: list bullet points from "What You'll Be Doing:" plus maybe the sentence about learning new tools etc. Let's extract: - Working with an established team to create meaningful dashboards that support customer's mission-critical decision-making. - Environment is complex, with large datasets both in depth and breadth. - Role will always include learning something new, whether a tool or a new data domain. That's it. Requirements (required): list bullet points: - U.S. Citizenship required. - Active Public Trust in DHS or a component of DHS highly preferred. - Bachelor's degree plus 5+ years of overall technical experience, including analysis or development roles with databases, data integration, data mining, big data, data visualization. - At least three years developing dashboards using data visualization technologies, such as PowerBI, Qlik Sense, or Tableau. - Experience in data modeling, scripting, and ETL development within Qlik environments. - Strong SQL experience working with relational databases and large datasets. - Good communication skills, particularly in requirements definition and documentation of visualization artifacts. - Ability to learn new tools quickly as needed to provide new ideas for solving problems. - Ability and desire to work with other program staff and customers to reach design decisions within given constraints. - Excellent diplomacy and communication skills with both clients and technical staff. We could combine communication skills duplicates but keep as is. Qualifications (preferred): bullet points: - Demonstrated project experience in data visualization and analysis using Qlik Sense specifically, highly preferred. - Competence in Python, Spark, and PySpark. - Experience working with federal government clients. - Experience with AWS cloud services. Pay: we have salary range: $120,000 - $150,000, with disclaimer. We need to preserve all substantive info. So we can put a paragraph: "Our estimated salary range for this position is $120,000 - $150,000; this presented salary range is not a guarantee of compensation or salary. Offered salary is based on experience, geographic location, and possibly contractual requirements as appropriate to the role. Salary could fall outside of this range." Benefits: from Who We Are: list: - Generous and flexible time-off policy - Flexible work schedules and telework options, including remote work availability for eligible projects - Career development opportunities including a mentorship program, technical and management training through Dev University, hands-on learning through DevLab, tuition reimbursement, and paid training opportunities - Industry-leading benefits including a choice of two health plans that include dental and vision, flexible spending account, commuter benefits, life insurance, and more - 401K matching with a 5% matching contribution - Regular team and company social events including our annual party, happy hours, fitness challenges, and more - A focus on community engagement including company wide support activities, employer match for donations, and time off for volunteer efforts We should not include the introductory sentences about Dev Technology being a growing IT company etc. That's not benefits; maybe we could include a brief "About the company" but not allowed heading. Could we put that under Benefits? No. Better to omit that as it's not required. The instruction: Preserve ALL substantive information; do NOT invent or summarize away detail. So we must keep that company description too. Where to put it? Could be under "About the role"? Not exactly. But we could create a section "About the role" that includes company description? That seems off. However the instruction says we can use headings like About the role, Responsibilities, etc. It doesn't forbid other headings? It says use

  for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). The e.g. suggests those are examples but not exclusive? It says "Use

  for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule)." Likely they expect only those headings. So we need to fit company description somewhere. Could be under "About the role" as a description of the role and company? Might be acceptable. The "About the role" could include both role and company overview. Let's do that. Thus we will have sections: About the role, Responsibilities, Requirements, Qualifications, Pay, Benefits. About the role: include the company description paragraph(s) from "Who We Are" plus maybe the mission-critical decision-making sentence? But that is responsibilities. We'll keep responsibilities separate. Thus About the role: paragraph(s) describing Dev Technology: "Dev Technology is a growing IT company with an employee-centric culture that works on mission-critical projects for the federal government. We partner with our federal customers to deliver technology services and solutions, and to drive our client’s missions forward through innovation. We use Agile and DevSecOps principles to provide services including application development, biometrics and identity management, cloud and infrastructure optimization, IT and legacy modernization, and data management. As a Washington Post Top Workplace award winner for the past THIRTEEN years in a row, the Top Workplaces USA for the past five years, and a recipient of the Companies As Responsive Employers (CARE) Award for the past six years, Dev Technology employees enjoy:" Then we could list benefits after that? But we already have Benefits section. So we could stop before benefits list. So About the role ends before the list of benefits. Then Benefits section enumerates the list. Thus we need to split the Who We Are paragraph: first part up to "Dev Technology employees enjoy:" then the list of benefits. Let's extract: "Dev Technology is a growing IT company with an employee-centric culture that works on mission-critical projects for the federal government. We partner with our federal customers to deliver technology services and solutions, and to drive our client’s missions forward through innovation. We use Agile and DevSecOps principles to provide services including application development, biometrics and identity management, cloud and infrastructure optimization, IT and legacy modernization, and data management. As a Washington Post Top Workplace award winner for the past THIRTEEN years in a row, the Top Workplaces USA for the past five years, and a recipient of the Companies As Responsive Employers (CARE) Award for the past six years, Dev Technology employees enjoy:" Then the list. Thus About the role will be that paragraph (maybe as

  ). Benefits will be

  • list. Now we need to ensure we don't repeat content. Responsibilities we already have. Now we need to output HTML fragment only. Let's craft:

    About the role

    Dev Technology is a growing IT company with an employee-centric culture that works on mission-critical projects for the federal government. We partner with our federal customers to deliver technology services and solutions, and to drive our client’s missions forward through innovation. We use Agile and DevSecOps principles to provide services including application development, biometrics and identity management, cloud and infrastructure optimization, IT and legacy modernization, and data management. As a Washington Post Top Workplace award winner for the past THIRTEEN years in a row, the Top Workplaces USA for the past five years, and a recipient of the Companies As Responsive Employers (CARE) Award for the past six years, Dev Technology employees enjoy:

    Responsibilities

    • Working with an established team to create meaningful dashboards that support the customer's mission‑critical decision‑making.
    • Operating in a complex environment with large datasets in depth and breadth.
    • Continuously learning new tools or data domains as part of the role.

    Requirements

    • U.S. Citizenship required.
    • Active Public Trust in DHS or a component of DHS highly preferred.
    • Bachelor's degree plus 5+ years of overall technical experience, including analysis or development roles with databases, data integration, data mining, big data, data visualization.
    • At least three years developing dashboards using data visualization technologies such as PowerBI, Qlik Sense, or Tableau.
    • Experience in data modeling, scripting, and ETL development within Qlik environments.
    • Strong SQL experience working with relational databases and large datasets.
    • Good communication skills, particularly in requirements definition and documentation of visualization artifacts.
    • Ability to learn new tools quickly as needed to provide new ideas for solving problems.
    • Ability and desire to work with other program staff and customers to reach design decisions within given constraints.
    • Excellent diplomacy and communication skills with both clients and technical staff.

    Qualifications

    • Demonstrated project experience in data visualization and analysis using Qlik Sense specifically, highly preferred.
    • Competence in Python, Spark, and PySpark.
    • Experience working with federal government clients.
    • Experience with AWS cloud services.

    Pay

    Our estimated salary range for this position is $120,000