Wipfli
Data Engineer II
Wipfli, Little Ferry, New Jersey, us, 07643
At Wipfli, people countThe 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.Under the direction of the Information Leader, the Data Engineer II 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 be responsible for designing, building, and deploying Business Intelligence (BI) solutions. You will work closely with operational and business teams to turn data into critical information and knowledge that can be used to make sound organizational decisions.Responsibilities
Participate with business stakeholders, IT teams, and vendors in documenting user stories and requirements, validating both business and technical requirements, and understanding data needs to deliver scalable solutions.Develop data models, perform ETL operations, and ensure data accuracy and integrity.Translate requirements into effective data insights (visualizations, reporting, etc.) leveraging design best practices and team standards using approved tools.Document models, code, and projects to ensure reproducibility and easy handover, while also following best practices in Continuous Integration and Continuous Deployment to ensure seamless and efficient development cycles.Test BI solutions rigorously to ensure their reliability, effectiveness, and scalability.Develop in data technologies such as Microsoft Power BI, T-SQL, Microsoft Azure Data Factory, Databricks.Familiarity within Data Warehouse, Data Lake and Data Lake House architectures.Provide support and continuous improvement for solutions deployed by the Information Team.Participate in the execution of project life cycle activities in accordance with the Information Team scrum processes and 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.Qualifications
Requires a Bachelor’s Degree in IT or an IT related major, or an equivalent combination of education and job-related experience.Requires 3-5 years of job-related experience.Proficient in Microsoft T-SQL, SSAS, DAX, Power BI, Word, Excel, Outlook, PowerPoint and Azure DevOps (will train).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.Strong written, verbal and presentation skills are very important for this position.Preferred: Experience with data visualization and a strong understanding of user interface and user experience design, coupled with the ability to effectively translate user needs into technical requirements.Preferred: Experience in financial and/or professional services industry.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, 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 hr@wipfli.com.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: $80,200 to $120,200. 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.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.
#J-18808-Ljbffr
Participate with business stakeholders, IT teams, and vendors in documenting user stories and requirements, validating both business and technical requirements, and understanding data needs to deliver scalable solutions.Develop data models, perform ETL operations, and ensure data accuracy and integrity.Translate requirements into effective data insights (visualizations, reporting, etc.) leveraging design best practices and team standards using approved tools.Document models, code, and projects to ensure reproducibility and easy handover, while also following best practices in Continuous Integration and Continuous Deployment to ensure seamless and efficient development cycles.Test BI solutions rigorously to ensure their reliability, effectiveness, and scalability.Develop in data technologies such as Microsoft Power BI, T-SQL, Microsoft Azure Data Factory, Databricks.Familiarity within Data Warehouse, Data Lake and Data Lake House architectures.Provide support and continuous improvement for solutions deployed by the Information Team.Participate in the execution of project life cycle activities in accordance with the Information Team scrum processes and 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.Qualifications
Requires a Bachelor’s Degree in IT or an IT related major, or an equivalent combination of education and job-related experience.Requires 3-5 years of job-related experience.Proficient in Microsoft T-SQL, SSAS, DAX, Power BI, Word, Excel, Outlook, PowerPoint and Azure DevOps (will train).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.Strong written, verbal and presentation skills are very important for this position.Preferred: Experience with data visualization and a strong understanding of user interface and user experience design, coupled with the ability to effectively translate user needs into technical requirements.Preferred: Experience in financial and/or professional services industry.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, 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 hr@wipfli.com.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: $80,200 to $120,200. 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.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.
#J-18808-Ljbffr