Data Architect | Engineer | On-Prem

3 weeks ago


West Des Moines, United States Robert Half Full time
Job DescriptionJob Description

We are offering a contract to hire employment opportunity for a Data Architect | Engineer in WEST DES MOINES, Iowa, In this role, you will be taking a hands-on approach in rebuilding our On-Prem data warehouse before transitioning to cloud technologies. Your main tasks will be centered around data warehousing, with a specific focus on fact and dimension tables, and SQL Server Analysis Services (SSAS) tools.


Responsibilities:

• Design and manage the on-premises data warehouse, ensuring its smooth operation.

• Develop and implement stored procedures to enhance the efficiency of data operations.

• Utilize SSIS as an ETL tool to extract, transform, and load data.

• Work closely with the data engineer to solve complex data-related issues.

• Leverage your knowledge of SSAS to analyze large volumes of data and support business intelligence applications.

• Utilize the star schema data model for organizing large amounts of data into a hierarchical structure.

• Ensure the accurate processing and maintenance of customer credit applications and records.

• Monitor customer accounts and take appropriate actions based on the data analysis.

• Use Azure Data Factory and Azure Data Lake for cloud data processing and storage.

• Support the transition from on-premises data warehouse to cloud (Azure) platforms.

• Minimum of 5 years of experience in a similar role as a Data Architect or Engineer
• Proficiency in Cloud Technologies is mandatory
• Experience with Azure Data Factory and Azure Data Lake is required
• Expertise in Data Warehousing and Data Warehousing - Mart is necessary
• Familiarity with Business Intelligence and Data Warehousing (BI DW) is essential
• Strong understanding of Data Architecture is required
• Must have experience in SQL Stored Procedures and Stored Procedures
• Proficiency in SSIS - SQL Server Integration Services and SSIS ETL is a must
• Familiarity with SQL server management studio is mandatory
• Experience with SSRS - SQL Server Reporting Services is required
• Proficiency in Microsoft SQL Server, MS SQL Server, SQL Server, and SQL Server Analysis is necessary
• Experience with SSAS - SQL Server Analysis Services is required.

  • Des Moines, United States Robert Half Full time

    Job DescriptionJob DescriptionHands-On Technical SENIOR Data Warehouse / SENIOR Data Engineer / Azure Data Factory Data Engineer - Position WEEKLY HYBRID position with major flexibility! LOCATION : HYBRID WEEKLY in Des Moines. You must reside in the Des Moines area for weekly onsite . NO travel back and forth and not a remote position.IMMEDIATE HIRE...


  • Des Moines, United States Robert Half Full time

    Job DescriptionJob DescriptionHands-On Technical SENIOR Data Warehouse / SENIOR Data Engineer / Azure Data Factory Data Engineer - Position WEEKLY HYBRID position with major flexibility! LOCATION : HYBRID WEEKLY in Des Moines. You must reside in the Des Moines area for weekly onsite . NO travel back and forth and not a remote position.IMMEDIATE HIRE...

  • Test Data Architect

    4 weeks ago


    Des Moines, Iowa, United States WPS Health Solutions Full time

    Job Title: Test Data ArchitectAbout the Role:WPS Health Solutions is seeking a skilled Test Data Architect to join our team. As a Test Data Architect, you will be responsible for developing, maintaining, and managing our Test Data Architecture. This includes providing guidance to testing teams, working closely with internal clients, Subject Matter Experts...


  • Des Moines, United States Bankers Trust Company Full time

    Job DescriptionJob DescriptionThere are important qualities you look for in an employer – meaningful work, community engagement, competitive benefits, commitment to employee development, and so many more. At Bankers Trust, our team members experience an inclusive and community-focused culture and we’re proud of the premier workplace we’ve created. We...

  • Solution Architect

    2 weeks ago


    West Conshohocken, United States Tandigm Health Full time

    Solution Architect - Data and Application Engineering (hybrid in Conshohocken) Tandigm Health, a transformational leader in population health management, is looking for a Solution Architect - Data and Application Engineering in the greater Philadelphia area. We offer a competitive compensation and benefits package and are proud to share a culture of...

  • Data Engineer

    3 days ago


    West Des Moines, United States ITA Group Inc Full time

    Job DescriptionJob DescriptionPOSITION DESCRIPTIONThe Data Engineer works independently and alongside cross-functional team members to model, develop and support data solutions which allow stakeholders to make data-driven decisions through flexible and structured access to data. This role works under limited supervision and provides guidance to junior...


  • West Columbia, South Carolina, United States Amentum Full time

    Amentum is seeking a highly skilled Data Integration Architect to design and implement enterprise data integration architectures. This is a remote-telework role that requires US Citizenship. The ideal candidate will have a strong background in API-based integration, data engineering, and cloud data integration. Key responsibilities include designing and...

  • Software Architect

    2 weeks ago


    West Lake Hills, United States Dell Full time

    Software Architect - Embedded Engineering, Applied Data Science In the rapidly moving Artificial Intelligence era, few spaces are moving faster than the AI-enabled PC. As a leading provider of world-class technology, this means bringing more intelligence into the PC ecosystem, enabling superior performance, enhanced productivity, and delightful experiences...

  • Data Architect

    4 weeks ago


    West Chester, Pennsylvania, United States Insight Global Full time

    Job Title: Data ArchitectWe are seeking a skilled Data Architect to join our team at Insight Global. As a Data Architect, you will be responsible for building and optimizing data architectures and visualizations that drive strategic decision-making within the Trauma BU.Key Responsibilities:Design and implement data architectures using SQLCollaborate with...

  • Data Engineer

    1 month ago


    Des Moines, United States Robert Half Full time

    Job DescriptionJob DescriptionPosition: Data EngineerLocation: Des Moines, IA - HYBRIDSalary: up to $130K permanent position plus exceptional benefits *** For immediate and confidential consideration, please send a message to MEREDITH CARLE on LinkedIn or send an email to me with your resume. My email can be found on my LinkedIn page. *** Our clients...

  • Data Engineer

    3 weeks ago


    Des Moines, United States Robert Half Full time

    Job DescriptionJob DescriptionPosition: Data EngineerLocation: Des Moines, IA - HYBRIDSalary: up to $130K permanent position plus exceptional benefits *** For immediate and confidential consideration, please send a message to MEREDITH CARLE on LinkedIn or send an email to me with your resume. My email can be found on my LinkedIn page. *** Our clients...


  • West Mclean, United States Booz Allen Full time $96,600 - $220,000

    Azure Data Architect, LeadPlease make sure you read the following details carefully before making any applications.The Opportunity:For an organization to transform in today’s digital world, it needs to properly collect, store, and organize its data. Effective data management can enable more efficient operations, yielding more growth. As a data architect,...


  • Des Moines, Iowa, United States TEKsystems Full time

    Job Description:As a Senior Network Architect at TEKsystems, you will be responsible for designing, planning, implementing, supporting, and recovering network infrastructure in accordance with business requirements. This role requires a strong understanding of network engineering principles, including routing and switching, network automation, and data...

  • Data Engineer

    4 weeks ago


    Des Moines, Iowa, United States Kraken Crypto Exchange Full time

    Job Title: Data Engineer - Blockchain Data SpecialistAbout the Role:We are seeking a highly skilled Data Engineer to join our team at Kraken Crypto Exchange. As a Data Engineer, you will play a crucial role in extracting and organizing data from various blockchains, preparing it for downstream analysis.Key Responsibilities:Extract and organize data from...

  • Senior Data Engineer

    4 weeks ago


    Des Moines, Iowa, United States Dwolla Full time

    About the RoleWe are seeking a highly skilled Senior Data Engineer to join our team at Dwolla. As a key member of our engineering team, you will be responsible for designing, building, and maintaining our data pipelines and infrastructure.Key Responsibilities:Design and implement data pipelines using AWS services such as Redshift, Glue, and Athena.Develop...


  • Des Moines, United States RK Management Consultants, Inc. Full time

    Our client, a Fortune 500 company in the Agriculture and Manufacturing Industry , is looking to add a Sr. Software Engineer to their team. This is a Hybrid, contract position.*No C2C or C2H*Summary:As a Lead engineer /Architect Software Engineer, you will follow best practices and use independent problem solving to help support and expand our product line....

  • Senior Data Engineer

    1 month ago


    Des Moines, United States Robert Half Full time

    Job DescriptionJob DescriptionUSC or Green Card Only. Please no C2C inquiries.Local Des Moines, IA applicants only, pleaseSeize the opportunity to shape the digital future as our premier clients Senior Data Engineer! As the Senior Data Engineer, you'll spearhead the efforts to boost data authenticity and precision. Your realm of influence won't just...

  • Senior Data Engineer

    3 weeks ago


    Des Moines, United States Robert Half Full time

    Job DescriptionJob DescriptionUSC or Green Card Only. Please no C2C inquiries.Local Des Moines, IA applicants only, pleaseSeize the opportunity to shape the digital future as our premier clients Senior Data Engineer! As the Senior Data Engineer, you'll spearhead the efforts to boost data authenticity and precision. Your realm of influence won't just...


  • Des Moines, Iowa, United States Anaplan Full time

    About the RoleWe are seeking a highly skilled Solution Architect to join our team at Anaplan. As a key player in our growth, you will support our Global Presales Team in two ways: 1) Supporting Revenue and 2) Increasing Presales Productivity and Scalability.Your ImpactBuild domain and industry-specific models in Anaplan, collaborating with presales and...


  • Des Moines, Iowa, United States VTal Technology Solutions Full time

    We are seeking a skilled Cloud Infrastructure Architect to join our talented software team at VTal Technology Solutions. The ideal candidate will have experience in implementing and operationalizing AWS cloud infrastructure, providing technical leadership and influencing diverse teams to design and implement easy-to-use hybrid cloud environments.The project...