Senior Analytics Engineer

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.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.Job Description:What you would do:Owns the Gold dimensional model (star schemas) across areas such as client, matter, timekeeper, and practice-group dimensions, producing curated, AI-ready data productsLeads delivery of executive dashboards and self-service analytics in Microsoft Power BIAuthors approved firm metric definitions once via Databricks Unity Catalog Metric Views to eliminate metric drift; implements definitions ratified by the firm’s data-governance cadenceSets standards for modeling, Power BI, and Databricks Genie curation/grounding; mentors mid-level and junior Analytics EngineersPartners 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 cadenceSpecial projects and other duties as assignedWhat is expected:Ability to problem-solveExcellent 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 environmentDemonstrated ability to use good judgment in taking initiative while asking for direction or clarification and consulting others, as appropriateWillingness to be flexible with time and adjust to a changing work environmentAbility to build and maintain positive relationships, both internally and externally, while maintaining a client service orientationAbility to use sound judgment and discretion in dealing with highly confidential informationAbility to take direction and accept supervisionDemonstrated ability to work independently, organize and accurately prioritize work, be detail-oriented, understand when urgency is required and use good judgment in varied situationsAbility to work effectively with co-workers in a team oriented collaborative environmentWhat we offer:Flexible working environment for work-life successOpportunity to participate in firm-sponsored volunteer eventsWellness programming with personalized content and activitiesProfessional environment and the opportunity to work with experts at the top of their fieldsVariety of health plan options, as well as dental, vision and 401(k) plansGenerous paid time offThe 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.What is required:Bachelor’s degree in a related technical or quantitative discipline, or equivalent experience8+ years of analytics/data engineering experienceExpert-level SQL and dimensional modeling skillsDeep, hands-on Microsoft Power BI expertise (data modeling, DAX, enterprise dashboard delivery)Experience defining and governing business metrics/KPIs across multiple source systemsAbility to mentor and set technical standards for less experienced analytics engineersExperience partnering with data engineers to translate Silver-layer structures, key-resolution logic, and source data constraints into Gold-layer dimensional modelsDatabricks AI/BI and Genie experience strongly preferred.Apply now if you are ready to join the Faegre Drinker team!Faegre Drinker Biddle & Reath LLP participates in the federal government's E-Verify program. With all new hires, we provide the Social Security Administration and, when applicable, the US Department of Homeland Security with information from each new employee's Form I-9 to confirm work authorization.Faegre Drinker Biddle & Reath LLP is an Equal Opportunity Employer and is committed to providing equal employment opportunities to all employees and applicants for employment. We do not discriminate on the basis of race, color, religion, age, national origin, disability, sex, sexual orientation, gender, gender identity, gender expression, marital status, veteran or military status, or any other characteristic made unlawful by applicable federal, state or local laws. Equal employment opportunity will be extended to all persons in all aspects of employment, including retirement, hiring, training, promotion, transfer, compensation, benefits, discipline and termination.Notice to Recruiters and Staffing Agencies: Faegre Drinker Biddle & Reath (and any subsidiary) has an internal recruiting department and does not accept unsolicited resumes.SummaryLocation: New York City; Chicago; Washington D.C.; Philadelphia; MinneapolisType: Full time