Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Warehouse Architect

Zenfreed, LLC

Job Description

Job Description

Data Engineering Lead excels in data modeling, Lakehouse, and ML products delivery using an agile DevOps framework with a mastery of distributed data architectures essential for data, analytical and operational ML applications with demonstrated proficiency in frameworks including DataBricks, Sagemaker, Spark, Kafka, Kubernetes, SQL, NoSQL DBs, Graph DBs, and visualization tools such as Power BI/Tableau.

The Data Engineer Lead serves as the primary State of Michigan technology lead engaging with the UoM proof of concept team to support best practice adoption within the state hosting environment and provides training to DAV data engineers.

Job Duties
  • Oversee the design, development, and maintenance of data pipelines that move, transform, and prepare data for analytics and operational systems.
  • architect and optimize data infrastructure, including storage solutions, orchestration frameworks, and ETL/ELT processes.
  • Ensure data quality, reliability, and security by establishing standards, monitoring systems, and implementing validation and governance practices.
  • Lead and mentor data engineering staff, providing technical guidance, reviewing designs/code, and supporting professional growth.
  • Collaborate with cross functional partners, such as data scientists, analysts, product teams, and business stakeholders, to ensure data solutions meet organizational needs and strategic goals
Requirements

4 years:

  • Hands-on experience is require in hydrting the enterprise Data Lake on a Cloud Service Provider (AWS, Azure, or Google) from relational, semi- structured and unstructured data sources by building Extract and Load Data Pipelines.
  • Hands-on experience is required in Transforming the datasets in a Data Lake on a Cloud Service Provider to deliver Data Products with traceability of their attributes / features to the Critical Data Elements in the systems of record.

2 years:

  • Experience is required in enforcing Data Sharing Policies to Data Products to ensure that User get to see only the version of the Data Product the User is entitled to get access to at the time of subscription.


Desired Skills
  • Proficiency desirable in DevOps tools including Github/Jenkins/Terraform/YAML/DAGs/Docker/Databricks/SageMaker etc. for building
  • Data/ML pipelines to extract/store data from multiple sources to parquet destinations.
  • Experience desirable in promoting Data Engineering Standards and Best Practices among the community of developers to influence the enterprise towards building scalable and supportable Data/ML Products delivery and their usage by the community of data, analytics, and ML product users.
  • Experience desirable in implementing Data Governance and Data Security tools available on a CSP to automate the enforcement of Data Sharing Policies at the point of subscription of a Data Product by a subscriber.

Other Desired Skills:

4 years:

  • Exerience in modeling and leveraging Relational data services with demonstrated proficiency in Python/Pysparks/SQL programming and tuning SQL queries to extract data from multiple sources ( relational DB, flat files, CSV, HTML, JSON, etc) sources into Lakehouse Medallion architecture in parquet formats 
  • Experience in designing and implementing data, analytics, and AI solutions for large enterprises by building data pipelines using the available data platform tools of any Cloud Service Provider (CSP) such as AWS/Microsoft/Google.
  • Programming/scripting languages including Python, R, Spark, etc.

Must have a BS in Computer Science / Data Science / Information Systems

Experience in designing and delivering Star-schema based operational data store is required to enable visualization of program activities and outcomes in a visualization tool such as Power BI.

Key Programming Languages: SQL, Python, R, Spark, Terraform Scripting, DAGs Scripting, YAML scripting, Docker Other Technologies, Concepts and Frameworks: Juniper Notebooks, NOSQL DB, Graph DB, Parquet DB, Lakehouse and Medallion Architecture concepts, Kafka, Kubernetes, Glue, Databricks, Power BI, Tableau, Redshift Spectrum, Sagemaker, DBT, Datahub, SageMaker, Machine Learning, GitHub, DevOps


Minimum Education
  • Bachelor's Degree


Location
  • Local candidates vs non-local : Open to candidates local to the Lansing Michigan area and those willing to relocate. Candidates that relocate must relocate before day one and be ready to be on-site from day one at their own expense (non-negotiable)
  • Position is a hybrid schedule with Wednesday and Thursday are REQUIRED in-office days. This is NON-NEGOTIABLE and there is NO remote only option.
  • Working hours Monday-Friday, approximately 8:00 a.m. to 5:00 p.m.   
Additional Requirements
  • Must be authorized to work in the United States; We are unable to offer sponsorships at this time
  • Must undergo a background check and drug screening for employment.


Employment Terms
  • This is a W2 position
  • 40 hrs per week
  • HYBRID schedule - Wednesday and Thursday are REQUIRED in-office days. This is NON-NEGOTIABLE and there is NO remote only option.


About Zenfreed

At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent.

We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.


Benefits

We understand a comprehensive benefits package is crucial to employment satisfaction. We offer medical, dental and vision coverage options for all employees. 

Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Data Warehouse Architect in Lansing, MI vacancy
  •  ...Title: Data Warehouse Architect 3 Duration: 6+ Month Contract; Highly possible for long-term extension Location: Lansing, MI 48933 Job Description: Data Engineer Lead/Data Warehouse Architect (Level 3) Data Engineering Lead excels in data modeling, Lakehouse... 
    Suggested
    Contract work

    ARK Solutions, Inc.

    Lansing, MI
    19 hours ago
  •  ...Job Title: Data Warehouse Architect 3- (Hybrid) Location: Lansing, MI Duration: 12 Months+ Pay Rate: $85/hr. On 1099 and $80/hr on W2 All Inclusive. Interview Type: Virtual and In-Person. 1st round is virtual, 2nd round is in-person. Note: Please include... 
    Suggested
    Work at office
    Local area
    Remote work
    Relocation

    GSK Solutions Inc.

    Lansing, MI
    19 hours ago
  •  ...Job Description: Data Engineer Lead/Data Warehouse Architect (Level 3) Data Engineering Lead excels in data modeling, Lakehouse and Medallion Architecture concepts, and data/ML products delivery using an agile DevOps framework with a mastery of distributed data architectures... 
    Suggested

    RICEFW Technologies Inc

    Lansing, MI
    19 hours ago
  •  ...Job DescriptionJob Description Job Title: (Data Warehouse Architect 5) About Kyyba: Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively... 
    Suggested
    Visa sponsorship
    Work visa

    Kyyba

    Lansing, MI
    4 days ago
  •  ...Data Warehouse Architect 5Location: Lansing MI (Hybrid) (Local Only)Position Type: Contract C2CClient: STATE OF MICHIGANGeneral Summary:DHHS is the agency recognized by the Department of Health and Human Services (DHHS), Administration for Children and Families (ACF)... 
    Suggested
    Permanent employment
    Contract work
    For contractors
    Local area

    Argyle Infotech

    Lansing, MI
    5 days ago
  •  ...Data Warehouse Architect 5 - Solutions ArchitectLocation: Lansing MIRequired Skills (Must haves):1. Minimum 5 years experience in leading Data Architects and working with Enterprise Architects to develop Data Landscape, Data Strategy, Data Architectural approaches using... 

    My3Tech Inc

    Lansing, MI
    3 days ago
  •  ...Job DescriptionJob Description Job Title: Data Warehouse Architect 5Job Location: Lansing, MI (Hybrid)Job Type: ContractJob Description/ Requirement:Minimum 12 years Teradata experience.Minimum 10 years SQL experience.Minimum 10 years shell scripting experience.Minimum... 

    Global Information Technology

    Lansing, MI
    5 days ago
  •  ...for complex Common Batch Framework and Common Scheduler to ensure current and reliable data is available for critical business processes and decision makingResponsible for Data Warehouse change management infrastructure and all promotions of code and ddl; performing build... 

    Samprasoft

    Lansing, MI
    13 hours ago
  •  ...Job Description Job Description Job Title: ( Data Warehouse Architect 5) About Kyyba: Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses... 
    Visa sponsorship
    Work visa

    KYYBA, Inc

    Lansing, MI
    20 days ago
  •  ...Job Description Job Description We are looking for Data Warehouse Architect in Lansing MI Hybrid. Please read the job description below and let me know if you are interested. Position: Data Warehouse Architect (Teradata) Location: Lansing, MI (Hybrid – Local... 
    Long term contract
    Local area

    Syntricate Technologies Inc

    Lansing, MI
    20 days ago
  •  ...Job Description WE ARE HIRING! | Data Warehouse Architect / Data Engineering Lead (Level 3) Location: Lansing, MI 48933 Work Mode: Hybrid – Wednesday & Thursday mandatory onsite Experience: 11+ Years Interview: Virtual & In-Person ✈️ Occasional... 

    Value Innovation Labs

    Lansing, MI
    3 days ago
  •  ...Data Engineer Lead / Data Warehouse Architect - State of Michigan DHHS - Hybrid Lansing, MI Long-term contract. Hybrid in Lansing, MI. Michigan residents or candidates willing to relocate. Apply through the Apply button. MI DHHS 168059 - Data Engineer Lead/Data... 
    Long term contract
    Relocation

    Govan Systems inc

    Lansing, MI
    19 hours ago
  •  ...Data Warehouse Architect 3 Data Engineering Lead excels in data modeling, Lakehouse and Medallion Architecture concepts, and data/ML products delivery using an agile DevOps framework with a mastery of distributed data architectures essential for data, analytical and... 
    Permanent employment
    Contract work

    MY HR

    Lansing, MI
    3 days ago
  •  ...Required qualifications Bachelor’s degree. The detailed JD specifies Computer Science, Data Science, or Information Systems. 4+ years building extract-and-load pipelines that ingest relational, semi-structured, and unstructured data into an enterprise data lake... 
    Contract work

    Crossword Staffing Solutions

    Lansing, MI
    2 days ago
  • $132.23k - $176.31k

     ...the trusted network for the AI‑powered world, connecting people, data, and applications through our expansive fiber network and...  ...today. The Role The Senior Lead Marketing Data Platform Architect is responsible for defining, governing, and evolving Lumen's marketing... 
    Full time
    Temporary work

    Lumen

    Lansing, MI
    2 days ago
  •  ...Competitive salary Opportunity for advancement Job Title: Data Architect II / Senior Enterprise Data Architect Location: Auburn...  ...data architecture, Master Data Management (MDM), Data Warehouse (DW), reporting, and analytics solutions. Required Skills... 
    Contract work

    Select Minds LLC

    Lansing, MI
    3 days ago
  •  ...Our client is looking a Data Engineer to lead excels in data modeling, Lakehouse and Medallion Architecture concepts, and data/ML...  ...transform, and prepare data for analytics and operational systems. · Architect and optimize data infrastructure, including storage solutions,... 
    Contract work
    H1b
    Work at office
    Local area
    Remote work
    Relocation
    Work visa

    IO Datasphere

    Lansing, MI
    2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse Architect. Be the first to apply!