Senior Analytics Engineer

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 as heading. Must not include Job ID etc. Must preserve all substantive info, not invent or summarize away detail. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, application instructions. So we need to extract relevant content. Let's parse the posting. First paragraph: "Faegre Drinker is a firm designed for clients and designed for you. We understand that our people are critical to our success and we are committed to investing in our paraprofessional, administrative and operations professionals. We are always looking for talented, service-focused individuals to join our flexible and high-performing culture. With technology tools and resources that support our hybrid work environment, our colleagues enjoy a culture of learning, support for work and personal goals, opportunities to give back to our communities, and competitive benefits and rewards programs. At Faegre Drinker, you will have the opportunity to share your expertise within and across teams and contribute to our success." That's about the firm, could be "About the role" or "About the firm". The instruction says use headings like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we can put "About the role" heading and include that description. Next: "Job Description Summary Faegre Drinker has an opportunity for a Senior Analytics Engineer to work with our Technology and Innovation team in our Chicago, Minneapolis, Philadelphia, New York City or Washington, D.C. office. You will be part of a dynamic team dedicated to contributing to the Gold semantic layer for the firm’s enterprise data lake and sets the standards that make the firm’s two primary consumption layers - Microsoft Power BI (the firm’s primary business intelligence platform) and Databricks AI/BI (Databricks AI/BI, including Genie conversational analytics) - trusted, consistent, and AI-ready. This position will work with other talented individuals who share a passion for doing great work in the best interest of our clients." That's also about the role. Could be part of About the role. Then "Job Description What you would do:" then bullet list (actually sentences separated by line breaks). Let's extract each duty: - Owns the Gold dimensional model (star schemas) across areas such as client, matter, timekeeper, and practice-group dimensions, producing curated, AI-ready data products - Leads delivery of executive dashboards and self-service analytics in Microsoft Power BI - Authors approved firm metric definitions once via Databricks Unity Catalog Metric Views to eliminate metric drift; implements definitions ratified by the firm’s data-governance cadence - Sets standards for modeling, Power BI, and Databricks Genie curation/grounding; mentors mid-level and junior Analytics Engineers - Partners with key stakeholders to ensure that Gold data products are consumable by the firm AI offerings, and resolves cross-system definitional questions in partnership with the governance cadence - Special projects and other duties as assigned These are responsibilities. Next: "What Is Expected" then list of abilities (soft skills). Those could be under Skills or Requirements? The instruction: Use headings for sections like Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide where each piece belongs. "What Is Expected" list includes abilities like problem-solve, communication, concentration, judgment, flexibility, relationships, confidentiality, supervision, independent work, teamwork. Those are more like skills/competencies. Could go under Skills. Then "What We Offer": list of benefits: flexible working environment, volunteer events, wellness programming, professional environment, variety of health plan options, dental, vision, 401(k), generous paid time off. That's Benefits. Then salary: "The anticipated initial annual salary range for someone who is hired into this position is $139,300 - $159,200. Actual initial salary may be above or below the above-identified range and will be based on the relevant skills, training, experience, and other job-related factors, including the location where the position is filled, in all cases consistent with applicable law. This is an exempt role and the initial salary range listed above is just one component of Faegre Drinker's total compensation and benefits package for professional staff, which includes, but is not limited to, a discretionary bonus; life, health, accident, and disability insurance; and a 401(k) plan." That's Pay (salary range) plus mention of benefits but we already have Benefits. Then "What Is Required": list: Bachelor’s degree in a related technical or quantitative discipline, or equivalent experience; 8+ years of analytics/data engineering experience; Expert-level SQL and dimensional modeling skills; Deep, hands-on Microsoft Power BI expertise (data modeling, DAX, enterprise dashboard delivery); Experience defining and governing business metrics/KPIs across multiple source systems; Ability to mentor and set technical standards for less experienced analytics engineers; Experience partnering with data engineers to translate Silver-layer structures, key-resolution logic, and source data constraints into Gold-layer dimensional models; Databricks AI/BI and Genie experience strongly preferred. That's Requirements/Qualifications. Could split: Requirements (education, experience) and Qualifications (skills). But we have both headings available. We need to decide. We have "Requirements" and "Qualifications" as possible headings. Usually Requirements are education/experience, Qualifications are skills. But we can also combine. The instruction: "Prefer a few substantive sections over many thin ones." So we might combine education/experience and skills into Requirements or Qualifications. But we have both headings; we could use Requirements for education/experience, Qualifications for skills. However we also have Skills heading separate. Might be redundant. Better: Use Requirements for education/experience, Qualifications for technical skills, Skills for soft skills? But we already have soft skills under What Is Expected. Could map that to Skills. Thus sections: - About the role (intro + summary) - Responsibilities (What you would do) - Requirements (education/experience) - Qualifications (technical skills: SQL, Power BI, Databricks, etc.) - Skills (soft skills: problem-solve, communication, etc.) - Benefits (What We Offer) - Pay (salary range) - Schedule? Not mentioned. No schedule info. So we omit Schedule. We must not create sections with placeholder text. Ensure each section has substantive content. Now we need to output HTML fragment with

headings and

• for lists,

  for prose. We must not include boilerplate: EEO, E-Verify, etc. Also remove "Apply now if you are ready to join the Faegre Drinker team!" and the E-Verify paragraph, equal opportunity, notice to recruiters. Also remove duplicated lines. We must preserve all substantive information. Let's capture all substantive content from the posting, excluding boilerplate. Let's list substantive paragraphs: Intro paragraph about firm (first paragraph). Keep. Job Description Summary paragraph (starting "Faegre Drinker has an opportunity...") Keep. Job Description What you would do: list of duties (6 items). Keep. What Is Expected: list of abilities (soft skills). Keep. What We Offer: list of benefits. Keep. Salary paragraph. Keep. What Is Required: list of requirements (education/experience, technical skills, Databricks preferred). Keep. We should also maybe include mention of offices locations (Chicago, Minneapolis, Philadelphia, New York City or Washington, D.C.) - that's in the summary paragraph. Now we need to format. We'll produce:

  About the role

  Faegre Drinker is a firm designed for clients and designed for you. We understand that our people are critical to our success and we are committed to investing in our paraprofessional, administrative and operations professionals. We are always looking for talented, service-focused individuals to join our flexible and high-performing culture. With technology tools and resources that support our hybrid work environment, our colleagues enjoy a culture of learning, support for work and personal goals, opportunities to give back to our communities, and competitive benefits and rewards programs. At Faegre Drinker, you will have the opportunity to share your expertise within and across teams and contribute to our success.

  Faegre Drinker has an opportunity for a Senior Analytics Engineer to work with our Technology and Innovation team in our Chicago, Minneapolis, Philadelphia, New York City or Washington, D.C. office. You will be part of a dynamic team dedicated to contributing to the Gold semantic layer for the firm’s enterprise data lake and sets the standards that make the firm’s two primary consumption layers - Microsoft Power BI (the firm’s primary business intelligence platform) and Databricks AI/BI (Databricks AI/BI, including Genie conversational analytics) - trusted, consistent, and AI-ready. This position will work with other talented individuals who share a passion for doing great work in the best interest of our clients.

  Then Responsibilities:

  Responsibilities

  • Owns the Gold dimensional model (star schemas) across areas such as client, matter, timekeeper, and practice-group dimensions, producing curated, AI-ready data products
  • Leads delivery of executive dashboards and self-service analytics in Microsoft Power BI
  • Authors approved firm metric definitions once via Databricks Unity Catalog Metric Views to eliminate metric drift; implements definitions ratified by the firm’s data-governance cadence
  • Sets standards for modeling, Power BI, and Databricks Genie curation/grounding; mentors mid-level and junior Analytics Engineers
  • Partners with key stakeholders to ensure that Gold data products are consumable by the firm AI offerings, and resolves cross-system definitional questions in partnership with the governance cadence
  • Special projects and other duties as assigned
  Then Requirements (education/experience):

  Requirements

  • Bachelor’s degree in a related technical or quantitative discipline, or equivalent experience
  • 8+ years of analytics/data engineering experience
  Then Qualifications (technical skills):

  Qualifications

  • Expert-level SQL and dimensional modeling skills
  • Deep, hands-on Microsoft Power BI expertise (data modeling, DAX, enterprise dashboard delivery)
  • Experience defining and governing business metrics/KPIs across multiple source systems
  • Ability to mentor and set technical standards for less experienced analytics engineers
  • Experience partnering with data engineers to translate Silver-layer structures, key-resolution logic, and source data constraints into Gold-layer dimensional models
  • Databricks AI/BI and Genie experience strongly preferred
  Then Skills (soft skills from What Is Expected):

  Skills

  • Ability to problem-solve
  • Excellent interpersonal, verbal and written communication skills, including the ability to communicate effectively in a virtual environment (e.g., via phone, web/videoconference)
  • Ability to concentrate on tasks, make decisions and work calmly and effectively in a high-pressure, deadline-orientated environment
  • Demonstrated ability to use good judgment in taking initiative while asking for direction or clarification and consulting others, as appropriate
  • Willingness to be flexible with time and adjust to a changing work environment
  • Ability to build and maintain positive relationships, both internally and externally, while maintaining a client service orientation
  • Ability to use sound judgment and discretion in dealing with highly confidential information
  • Ability to take direction and accept supervision
  • Demonstrated ability to work independently, organize and accurately prioritize work, be detail-oriented, understand when urgency is required and use good judgment in varied situations
  • Ability to work effectively with co-workers in a team oriented collaborative environment
  Then Benefits:

  Benefits