About the Data Warehouse Engineer Role at Robert Half

Join Robert Half's esteemed client in Malvern, Pennsylvania, as a Data Warehouse Engineer in this exciting Contract-to-Permanent position. This role is perfect for seasoned professionals passionate about leveraging cutting-edge cloud data technologies like Azure and Snowflake to drive business success in the financial services industry. Located in the heart of Malvern, PA, you'll contribute to optimizing data processes, migrating legacy systems, and ensuring seamless data workflows. With a hybrid schedule requiring 4 days onsite per week (no negotiations), this opportunity offers stability, growth, and hands-on experience with modern data warehousing solutions. Robert Half specializes in connecting top talent with innovative roles, and this position exemplifies our commitment to career advancement in high-demand tech fields.

As a Data Warehouse Engineer, you'll play a pivotal role in transforming raw data into actionable insights, supporting production environments, and facilitating critical migrations from tools like Talend to Azure Data Factory. Ideal for those with expertise in ETL processes, Python automation, and financial compliance, this role demands critical thinking and collaboration. Malvern, PA, known for its proximity to Philadelphia and thriving tech scene, provides an ideal backdrop for professionals seeking impactful work in data engineering.

Key Responsibilities

Core Development and Optimization

• Develop, configure, and optimize Snowflake-based data solutions tailored to dynamic business requirements, ensuring scalability and performance in a financial services context.

• Utilize Azure Data Factory to design, implement, and streamline efficient ETL (Extract, Transform, Load) processes, handling large-scale data movements with precision.

• Maintain and enhance Azure Fabric-based solutions for robust data warehousing, enabling advanced analytics and reporting capabilities.

Production Support and Migrations

• Deliver hands-on production support by continuously monitoring and managing data workflows, tasks, and pipelines to minimize downtime and ensure reliability.

• Extract, analyze, and refactor existing code from Talend, facilitating smooth system migrations to modern cloud platforms.

• Collaborate closely with cross-functional teams on the strategic migration from Talend to Azure Data Factory, sharing best practices and mitigating risks.

Automation and Problem-Solving

• Leverage Python scripting to automate data processing tasks, enhance efficiency, and build custom tools for complex workflows.

• Stand up and configure data repository processes, ensuring seamless performance and data integrity across environments.

• Apply critical thinking to tackle intricate data challenges, supporting enterprise-wide transformation initiatives while adhering to financial services compliance standards.

Required Qualifications

To excel in this Data Warehouse Engineer role, candidates must possess:

• Proven strong background in Azure ecosystem, including Azure Data Factory and Azure Fabric.
• Deep expertise in Snowflake for data warehousing and analytics.
• Hands-on experience with data integration, ETL processes, and production support in high-stakes environments.
• Familiarity with Talend for code extraction and migration projects.
• Strong Python scripting skills for automation and data manipulation.
• Experience in financial services, with knowledge of industry compliance and data governance standards.
• Excellent problem-solving abilities and critical thinking for complex data scenarios.
• Bachelor's degree in Computer Science, Information Technology, or related field; advanced certifications in Azure or Snowflake preferred.
• Ability to work 4 days onsite per week in Malvern, PA.

Robert Half values diverse experiences and encourages applicants with 5+ years in data engineering to apply directly.

Why Join Us?

At Robert Half, we offer more than just a job—we provide a pathway to long-term success. This Contract-to-Permanent role transitions to full-time, offering job security and comprehensive benefits including health insurance, 401(k) matching, paid time off, and professional development stipends. Work with cutting-edge technologies in a collaborative financial services environment, surrounded by Philadelphia's tech hub. Enjoy Malvern, PA's excellent quality of life with access to top-rated schools, parks, and commuting ease. Competitive salary estimated at $110,000-$140,000 annually reflects market rates for skilled Data Warehouse Engineers in the region. SEO-optimized for careers in data engineering, Snowflake jobs, Azure Data Factory roles, and ETL specialist positions in Pennsylvania. Apply now to elevate your career with Robert Half—where innovation meets opportunity. (Word count: 812)