Data Engineer

Job Description: We are looking to add a Data Engineer to join our Information Technology team in West Des Moines, IA. Offering a forward-thinking, innovative, and vibrant company culture, along with the opportunity to share your unique potential, there really is no place like Holmes! Essential Responsibilities: Design and Implement Complex Pipelines: Design, build, and optimize ETL/ELT workflows from multiple sources, enhancing performance and reliability. Azure Data Factory, Alteryx, Fabric, dbt, SQL, and other tools. Advanced Data Transformations: Implement transformations, aggregations, and custom logic to meet business requirements. Data Modeling and Storage Optimization: Contribute to data modeling efforts, recommending storage solutions and structures that support analytical requirements. Pipeline Monitoring and Optimization: Proactively monitor pipelines, perform root cause analysis for performance issues, and implement improvements. Mentorship and Guidance: Provide guidance to junior engineers on best practices in data extraction, transformation, and loading. Qualifications: Education: Bachelor's degree in computer science, data science, technology, information systems or engineering preferred. Experience: 3-5 years of professional experience in data, analytics, or platform engineering or related work-related experience strongly preferred. Skills: Experience building ETL/ELT dataflows using tools like dbt, Alteryx, Azure Data Factory, or Microsoft Fabric. Skilled in working with diverse data sources (structured and unstructured), including delimited, fixed width, databases, and blob storage. Familiarity with APIs or RPA for third-party data collection; Salesforce experience is a plus. Knowledge of source control, cloud data storage, and platforms such as Snowflake or Azure preferred. Technical Competencies: Possesses strong business and technology knowledge to understand business needs, make informed decisions, and deliver effective technology solutions, including related processes and procedures. Demonstrates excellent problem-solving skills to efficiently identify issues, determine root causes, and propose and implement effective solutions or improvements. Here's a little bit about us: In addition to being great at what you do, we place a high emphasis on building a best-in-class culture. We do this through empowering employees to build trust through honest and caring actions, ensuring clear and constructive communication, establishing meaningful client relationships that support their unique potential, and contributing to the organization's success by effectively influencing and uplifting team members. Benefits: In addition to core benefits like health, dental and vision, also enjoy benefits such as: Paid Parental Leave and supportive New Parent Benefits — We know being a working parent is hard, and we want to support our employees in this journey! Company paid continuing Education & Tuition Reimbursement — We support those who want to develop and grow. 401k Profit Sharing — Each year, Holmes Murphy makes a lump sum contribution to every full-time employee's 401k. This means, even if you're not in a position to set money aside for the future at any point in time, Holmes Murphy will do it on your behalf! We are forward-thinking and want to be sure your future is cared for. Generous time off practices in addition to paid holidays — Yes, we actually encourage employees to use their time off, and they do. After all, you can't be at your best for our clients if you're not at your best for yourself first. Supportive of community efforts with paid Volunteer time off and employee matching gifts to charities that are important to you — Through our Holmes Murphy Foundation, we offer several vehicles where you can make an impact and care for those around you. DE&I programs — Holmes Murphy is committed to celebrating every employee's unique diversity, equity, and inclusion (DE&I) experience with us. Not only do we offer all employees a paid Diversity Day time off option, but we also have a Chief Diversity Officer on hand, as well as a DE&I project team, committee, and interest group. You will have the opportunity to take part in those if you wish! Consistent merit increase and promotion opportunities — Annually, employees are reviewed for merit increases and promotion opportunities because we believe growth is important — not only with your financial wellbeing, but also your career wellbeing. Discretionary bonus opportunity — Yes, there is an annual opportunity to make more money. Who doesn't love that?! There's No Place Like Holmes! You'll love what you do and who you do it with when you join Holmes Murphy! Not only can you create connections, experience the energy, and seize the opportunities we have, but you can also: Grow Your Career – An abundance of opportunity awaits! Our independence gives our growing and dynamic organization the freedom to create an environment where talent mobility thrives — whether that means career progression, expanding your skill set, or transferring to another Holmes Murphy office. Learn... On Us – We believe in building the best experts in the industry, supported through a variety of benefits like continuing education and tuition reimbursement. Share in Our Success – Our privately held structure allows us to share our collective success in ways that matter. One of the many ways is through our 401(k)-profit share, which is distributed to all employees regardless of their own contributions! Take Time to Recharge – We offer generous time off, including a Health Matters Day, Celebrate Day (for your birthday!), Diversity Day, Volunteer Time Off, and paid parental leave. And yes, we encourage you to take time away!