Sr Data Engineer

Robert Half • West Des Moines, IA

426d

About The Position

The Sr Data Engineer position at Robert Half involves managing and organizing large volumes of data, focusing on rebuilding the On-Prem data warehouse and transitioning to cloud-based solutions. The role requires expertise in various data analysis tools and techniques, particularly within the Azure ecosystem, to ensure efficient data handling and reporting.

Requirements

• Possess a minimum of 5 years of experience as a Data Engineer or a related role
• Proficient in Cloud Technologies, with a particular emphasis on Azure Data Factory and Azure Data Lake
• Demonstrate expertise in Data Warehousing and Data Warehousing - Mart
• Able to use Business Intelligence and Data Warehousing (BI DW) tools and strategies effectively
• Show a strong understanding of Data Architecture
• Proficient in SQL Stored Procedures and Stored Procedures
• Possess experience with SSIS - SQL Server Integration Services and SSIS ETL
• Able to efficiently use SQL server management studio
• Experienced in SSRS - SQL Server Reporting Services
• Proficient in SQL Server, SQL Server, and SQL Server
• Able to perform SQL Server Analysis and has experience with SSAS - SQL Server Analysis Services

Responsibilities

• Manage and maintain On-Prem data warehouses to ensure efficient and accurate data handling
• Utilize SSAS (SQL Server Analysis Services) for data analysis, breaking up large volumes of data into more easily analyzed parts
• Implement and maintain fact and dimension tables as part of the data architecture
• Use data factory tools and techniques for managing and manipulating data
• Employ SSIS (SQL Server Integration Services) as an ETL tool for data extraction, transformation, and loading
• Maintain and manage on-prem SQL servers for efficient data storage and retrieval
• Develop and implement stored procedures for managing and manipulating data
• Prepare for transitioning to cloud-based data management, specifically Azure
• Utilize cloud technologies, Azure Data Factory, and Azure Data Lake for data management and analysis
• Apply business intelligence and data warehousing techniques for data analysis and reporting

Benefits

• Medical insurance
• Vision insurance
• Dental insurance
• Life insurance
• Disability insurance
• 401(k) plan

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Administrative and Support Services
• Education Level: No Education Listed