About the Role

Join Robert Half's esteemed client in West Des Moines, Iowa, as a Data Engineer - SQL Server on a long-term contract basis. This pivotal role is at the heart of transforming raw data into actionable insights that drive organizational decision-making and operational efficiency. As a Data Engineer, you will architect robust data pipelines, harness the power of Microsoft SQL Server, and pioneer modern data warehousing solutions. Located in the vibrant city of West Des Moines, Iowa, United States, this position offers a hybrid work model blending on-site collaboration with flexible remote options, ideal for professionals passionate about data engineering careers in the heartland.

In this role, you'll tackle complex data challenges, ensuring seamless data flow from extraction to analytics. Robert Half, a leader in staffing solutions, connects top talent like you with innovative projects. If you're seeking Data Engineer jobs in West Des Moines, IA, or SQL Server opportunities in Iowa, this is your chance to elevate your career while contributing to advanced data ecosystems.

Why Data Engineering at Our Client?

Our client's commitment to data-driven innovation sets it apart. You'll work on scalable data lakes and warehouses that power business intelligence, fostering efficiency across departments. With West Des Moines' growing tech scene, this role positions you at the forefront of regional opportunities in data engineering, ETL processes, and cloud-integrated solutions.

Key Responsibilities

Your day-to-day will immerse you in high-impact data engineering tasks:

• Develop, maintain, and optimize sophisticated data pipelines supporting business operations and advanced analytics initiatives.
• Execute comprehensive data extraction, transformation, and cleansing (ETL) processes to guarantee data accuracy, reliability, and usability.
• Collaborate cross-functionally with data scientists, analysts, and stakeholders to design and deploy state-of-the-art data warehouses and expansive data lakes.
• Leverage Microsoft SQL Server expertise to construct, manage, and scale relational database structures optimized for performance.
• Conduct in-depth analysis of diverse data sources, delivering strategic recommendations to enhance data quality, governance, and accessibility.
• Author detailed documentation encompassing data processes, ETL pipelines, system architectures, and operational workflows.
• Champion industry best practices for data storage, retrieval, security, and compliance to drive maximum efficiency and scalability.
• Proactively troubleshoot and resolve complex issues in data processing, integration, and pipeline orchestration.
• Continuously monitor emerging trends in data engineering, such as cloud-native tools, AI-driven ETL, and big data frameworks, to innovate solutions.

Required Qualifications

To excel, bring these qualifications to the table:

• Proven expertise in relational databases, with deep hands-on experience in Microsoft SQL Server including T-SQL, indexing, and performance tuning.
• Strong proficiency in ETL tools and frameworks like SSIS, Azure Data Factory, or similar for data pipeline development.
• Demonstrated success in data cleansing, quality assurance, and transformation processes ensuring enterprise-grade data integrity.
• Experience designing and implementing modern data warehouses (e.g., Snowflake, Redshift) and data lakes (e.g., Delta Lake, S3-based).
• Analytical mindset with skills in data source evaluation and optimization recommendations.
• Excellent collaboration skills, with the ability to work in agile teams and communicate technical concepts to non-technical stakeholders.
• Familiarity with data governance, security best practices (GDPR, CCPA), and version control (Git).
• Bachelor's degree in Computer Science, Information Systems, or related field; 5+ years of relevant experience preferred.
• Bonus: Knowledge of Python, Spark, or cloud platforms like Azure/AWS for hybrid data environments.

Robert Half seeks candidates with a passion for SQL Server data engineering and a track record of delivering scalable solutions.

Why Join Us?

Partner with Robert Half for unparalleled support in your contract journey. Enjoy a competitive estimated salary range of $95,000-$125,000 annually (equivalent hourly for contract), reflecting West Des Moines' market rates for seasoned Data Engineers. Benefit from long-term stability, professional networking via Robert Half's resources, and exposure to cutting-edge technologies.

West Des Moines, Iowa, offers an exceptional quality of life with low costs, excellent schools, and proximity to Des Moines' amenities. This role not only advances your skills in data pipelines and SQL Server but also positions you for full-time opportunities. Apply now for this Data Engineer - SQL Server position and shape the future of data at a forward-thinking organization. Robert Half: Empowering careers in data engineering across the United States.

(Word count: 852)