At Wipfli, people count

　　The way you think makes you different. At Wipfli, we embrace that.

　　Our inclusive culture provides a space for everyone to have a voice. Our growing number of DEI resource groups celebrate diversity and champion awareness throughout Wipfli.

　　We’re also focused on helping you achieve success with balance. From hybrid schedules and flexible time off to training programs and mental wellness initiatives, we take care of our team.

　　If you want to be in an environment where you can grow, feed your curiosity and make a difference, Wipfli is the place for you.

　　Position Overview

　　Under the direction of the Information Leader, the Data Warehouse Engineer - Senior interacts with business stakeholders, gathers information, analyzes business and technical requirements, develops, tests, and implements data-oriented solutions, in accordance with firm policies and procedures.

　　This role will emphasize the design, development, and maintenance of the firm’s internal data warehouse/data lake house. Collaborating with key business capability owners and internal data developers/architects to inform ongoing design and enhancement activities will be a key component of this role.

　　Responsibilities

　　A command of Databricks, Data Lake medallion architectures, Data Warehouse Star Schemas, and other data warehouse concepts

　　Design and document necessary conceptual and logical data models to support business requirements

　　Collaborate with Data Architect to influence underlying data structures, security, and development practices

　　Collaborate with Data Engineers to inform design for Power BI Data Flows and self-serve data models

　　Collaborate and/or act as a liaison with business stakeholders, IT, and vendors to gather, document user stories/requirements, and validate business and technical requirements, work through process improvements, and identify potential solutions.

　　Create and maintain necessary documentation to support deployed solution. After-hours support may be necessary.

　　Manage the execution and continuous improvement of project life cycle activities in accordance with the Information Team scrum processes using tools such as Microsoft Azure DevOps

　　Achieve/maintain proficiency in required skills identified by the Information Team to effectively deliver defined products

　　Collaborate with team members to evolve products and internal processes

　　Mentor other Engineers and other IT associates as needed.

　　Qualifications

　　Requires ten or more years of job-related experience

　　Must have: Hands on experience with Databricks (Python or Scala, SQL), strong understanding of Unity Catalog, advanced SQL skills, experience with Azure Data Factory, and dimensional modeling.

　　Preferred: Experience implementing medallion data architectures, CI/CD tooling (ex. Azure DevOps Pipelines), automated testing frameworks (ex. PyTest), MS SQL Server, Azure Synapse, and PowerBI.

　　Requires a bachelor's degree in IT or an IT related major, or an equivalent combination of education and job-related experience

　　Proven IT implementation success, project leader success, business process/architectural mapping success, vendor liaison experience, system life cycle management, proficiencies in business process or infrastructure design

　　Strong written, verbal and presentation skills are particularly important for this position

　　Ability to plan, prioritize, and organize work effectively

　　Ability to work under pressure and time deadlines

　　Ability to analyze business challenges and recommend solutions

　　Ability to comprehend application-related concepts with a demonstrated ability to learn and apply technical thinking

　　Ability to work in an agile Scrum Team

　　Comfortable working in a virtual environment

　　Preferred: Experience in financial and/or professional services industry.

　　Requires a valid driver’s license

　　Wipfli is an equal opportunity/affirmative action employer. All candidates will receive consideration for employment without regards to race, creed, color, religion, national origin, sex, age, marital status, sexual orientation, gender identify, citizenship status, veteran status, disability, or any other characteristics protected by federal, state, or local laws.

　　Wipfli is committed to providing reasonable accommodations for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or participate in our recruiting process, please send us an email at [email protected]

　　Alyanna (Ally) Graham, from our recruiting team, will be guiding you through this process. Visit herLinkedIn (https://www.linkedin.com/in/alyanna-graham-05435b122) page to connect!

　　Wipfli supports equal pay for equal work and values each candidate’s unique experiences and skill sets. The estimated pay range for this position is: $90,000 to $146,000. Compensation within the range is determined by a variety of factors including, but not limited to, location, individuals' skills, experience, training, licensure and certifications, business needs and applicable employment laws.

　　Individuals may be eligible for an annual discretionary bonus, subject to participation rules and based on a variety of factors including, but not limited to, individual and Firm performance.

　　Wipfli cares about our associates and offers a variety of benefits to support their well-being. Highlights include 8 health plan options (both HMO & PPO plans), dental and vision coverage, opportunity to enroll in HSA with potential Firm contribution and an Employee Assistance Program. Other benefits include firm-sponsored basic life and short and long-term disability coverage, a 401(k) savings plan & profit share as well as Firm matching contribution, well-being incentive, education & certification assistance, flexible time off, family care leave, parental leave, family formation benefits, cell phone reimbursement, and travel rewards. Voluntary benefit offerings include critical illness & accident insurance, hospital indemnity insurance, legal, long-term care, pet insurance, ID theft protection, and supplemental life/AD&D. Eligibility for all benefits programs is dependent on annual hours expectation, position status/level and location. Wipfli offers flexibility for many positions to be performed remotely; please discuss your work preferences with your recruiter during the interview process.

　　#LI-REMOTE #LI-AG1

　　Don’t See Your Dream Job? Connect With Us!

　　Don't see a current position posted for your area of interest, specialty, or are not ready to formally apply at this time?

　　Use theJoin Our Talent Community (https://careers.wipfli.com/talentcommunity/signup) feature to forward your information to a member of our recruiting team. We will reach out to you very soon and will also keep you posted on any new positions as they become available.

　　Job LocationsUS

　　Job ID 2023-5853

　　Category Technology

　　Remote Yes