Data Warehouse Architect

  • Location
    Lakeville, Minnesota
  • Category:
    IT - IT
  • Job Type:
    Direct Hire
  • Job reference:
    US_EN_8_864973_2885293

Data Warehouse Architect

Seeking a Data Warehouse Architect for a large client in Lakeville, MN. This is a Hybrid role that will have the responsibility to coordinate the technical execution of enterprise data warehouse solutions and services. The ideal candidate will have the opportunity to be promoted to lead the Data Engineering team.

Responsibilities:

  • Plan and execute deliverables
  • Main responsibilities include, analysis, designing and solution blueprint and develop and support
  • Identify alternative approaches and code efficient and effective solutions for difficult problems
  • Responsible for investigating, analyzing and understanding data contents of source data systems
  • Works directly with leadership to ensure requirements are met for data warehouse development projects including Business Mangers, BI Analysts and IT Leadership.
  • Communication throughout the team with the ability to problem solve in a challenging environment
  • Ability to Collaborate with a team who has a diverse set of skills and qualifications
  • Requirements

  • Bachelor’s Degree in CS, Engineering, information management or related discipline
  • 9+ years of full software Development Life Cycle experience
  • 7+ years of experience with any ETL tool with complex transformation business rules implementation
  • 5+ years of experience working on data warehouse projects using dimensional modeling
  • 3+ years of experience with writing Oracle SQL queries as well as complex inquiries
  • 3+ years’ experience with IBM Data Stage
  • Experience in supporting transition into a cloud platform.
  • Strong communication skills as well as ability to present to large group
  • Preferred System experience

  • Snowflake in Cloud
  • Oracle SQL/ DD:/DML scripting
  • Unix/ Linux Shell Scripting
  • Cognos and Tableau
  • Azure Cloud Platform using Azure Data Factory, Databricks and other MS tools


  • Equal Opportunity Employer/Veterans/Disabled

    To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.parkerlynch.com/candidate-privacy

    The Company will consider qualified applicants with arrest and conviction records