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

Data Warehouse Architect 3

Full-time

TekWissen,LLC

Overview:

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. The below Client runs through fifteen executive departments which carry out the day-to-day administration of the federal government. Popular departments like Agriculture and Rural Development, Civil Rights, Environment, Health and Human Services, Natural Resources, Secretary of State. This Client has opportunities in a number of career pathways, including, but not limited to, business and administrative support, education and human services, IT and computers, medical and healthcare, natural resources, law enforcement and public safety, skilled trades and more. With positions in over 18 state departments, your perfect career fit is waiting for you at the client. This client is an Equal Opportunity Employer.

Job Title: Data Warehouse Architect 3
Location: Lansing, MI 48933
Duration: 11 Months
Job Type: Temporary Assignment
Work Type: Hybrid




Shift Timings: 08:00 AM To 05:00 PM

Job Description:

  • 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 operational ML applications with demonstrated proficiency in frameworks including Spark, Kafka, Kubernetes, SageMaker, DBT, Juniper Notebooks, Docker, SQL, and visualization tools such as Power BI/Tableau with the following track record:

Required Education: Bachelors Degree





Required Skills:

  • Minimum 4 years of hand-on experience is required in hydrating 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.
  • Minimum of 4 years 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.
  • Minimum of 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.

Preferred 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.

Roles and Responsibilities:

  • 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 client 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.

This role's responsibilities include:

  • 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.

Other Desired Skills:

  • Must have a BS in Computer Science / Data Science / Information Systems with an overall 4+ years of 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.
  • Experience of minimum 4 years 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
  • Demonstrated experience and expertise of minimum 4 years in programming/scripting languages including Python, R, Spark, etc.
  • 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

TekWissen Group is an equal opportunity employer supporting workforce diversity.

Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Data Warehouse Architect 3 in Lansing, MI vacancy
  •  ...Job Description Job Description Job Title: ( Data Warehouse Architect 3) 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... 
    Suggested
    Visa sponsorship
    Work visa

    KYYBA, Inc

    Lansing, MI
    25 days ago
  •  ...this, just make sure your candidates are aware and ok with this before submitting. The State of Michigan is looking for a Data Warehouse Architect 3 Max Bill Rate: -/hour Sub Vendors Allowed: Yes -Vendor submissions will close on 11/19 at 10 AM ET. Late submissions will... 
    Suggested
    Full time
    Work at office
    Local area
    Remote work
    Relocation

    Buzzclan

    Lansing, MI
    8 days ago
  •  ...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
    5 days 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
    5 days ago
  •  ...Data Warehouse Architect 5 - Solutions ArchitectLocation: Lansing MIRequired Skills (Must haves):1. Minimum 5 years experience in leading Data Architects...  ...integrity of Enterprise Data Platform in a large enterprise.3. Minimum of 3 years experience in driving RFP process of... 
    Suggested

    My3Tech Inc

    Lansing, MI
    2 days ago
  •  ...Data Warehouse Architect 5Location: Lansing MI (Hybrid) (Local Only)Position Type: Contract C2CClient: STATE OF MICHIGANGeneral Summary:DHHS is the...  ...Windows 2012 virtual platform.Top Skills & Years of Experience:3+ years of experience with Teradata Cloud3+ years of... 
    Permanent employment
    Contract work
    For contractors
    Local area

    Argyle Infotech

    Lansing, MI
    5 days ago
  • Job Summary: The Data Warehouse Architect 3 is a technical leadership role focused on designing, developing, and maintaining enterprise data pipelines and infrastructure within a cloud environment. This role requires expertise in data modeling, Lakehouse and Medallion... 
    Full time
    Work at office
    Relocation

    vTech Solution

    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...  ...9 - Data Engineer Lead/Data Warehouse Architect (Level 3) Location: Lansing, MI (Hybrid). Michigan residents... 
    Long term contract
    Relocation

    Govan Systems inc

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

    Kaav Inc.

    Lansing, MI
    2 days ago
  •  ...Data Warehouse Architect 5Job Location: Lansing, MI (Hybrid)ContractJob Description/Requirement:Minimum 12 years Teradata experience.Minimum 10 years SQL experience.Minimum 10 years shell scripting experience.Minimum 5 years Linux experience.Supporting the loading of... 

    Global Information Technology

    Lansing, MI
    5 days 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
    25 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
    25 days ago
  •  ...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 travel to Ann Arbor... 

    Value Innovation Labs

    Lansing, MI
    5 days ago
  • $50 - $80 per hour

     ...Job Title: Data Engineer Lead/Data Warehouse Architect - Hybrid Duration (Contract): 11 Months Client Location: Lansing, MI 48933 Location Preference: Hybrid Job Description: As a Data Engineer Lead/Data Warehouse Architect, you will be responsible... 
    Hourly pay
    Contract work
    Temporary work

    Smart IMS Inc

    Lansing, MI
    2 days ago
  • $70 - $80 per hour

    DescriptionKforce has a client that is seeking a Database Architect in Lansing, MI.Summary:The Database Architect leads, designs, and delivers...  ...as a Database AdministratorLead technical experience with 3 or more of the following:* Oracle* Microsoft SQL Server* PostgreSQL... 

    KForce

    Lansing, MI
    3 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
  •  ...Farmington Hills, MI We are looking for an experienced Database Architect to lead database architecture, design, optimization, and...  ...Administration experience. ~ Lead-level experience with at least 3 databases: Oracle, SQL Server, PostgreSQL, MariaDB, MySQL, Snowflake... 

    Yotta Systems Inc

    Okemos, MI
    2 days ago
  • Contract Based (.NET & Java (PEP)) Role:.NET & Java (PEP) Location: Michigan (OnSite) Hire Type: Contract Skills: .Net, Java, Blazer software, server/cloud computing, Payment Processing skills – Must Niveditha ****@*****.*** Contact ...
    Contract work

    Argyle Infotech

    Lansing, MI
    1 day ago
  • $55 - $60 per hour

     ...Onsite Competitive salary Opportunity for advancement Job Title: Data Architect II / Senior Enterprise Data Architect Location: Auburn Hills,...  ...data architecture, Master Data Management (MDM), Data Warehouse (DW), reporting, and analytics solutions. Required Skills and... 
    Hourly pay
    Contract work

    SelectMinds

    Lansing, MI
    2 days ago
  • $71.2k - $166.1k

    Job Description The Senior Data Migration Architect is a senior-level consulting professional responsible for leading the design, planning, execution, and governance of complex healthcare data migration initiatives supporting Oracle Health Millennium EHR/EMR implementations... 
    Temporary work
    Flexible hours

    Oracle

    Lansing, MI
    2 days ago
  • $150k - $220k

    Senior Data Architect Michigan Permanent $150,000 - $220,000 + Bonus Our client is a global Financial Services business looking for a Senior Data Architect to join the team permanently. Wouldn't it be great to work on AI projects that actually have a big impact? This is... 
    Permanent employment
    Immediate start

    Parker B Associates

    Lansing, MI
    2 days ago
  • Data Architect With Legacy Migration Experience This is Priya Sharma from US IT Solutions Inc. and we are Staffing Specialist working directly with all US States and Local and Commercial clients. We are known for our IT Services, Mobile development, Web development and... 
    Local area

    US IT Solutions Inc

    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
    8 days ago
  • Job Title Job Description Upon offer, candidate must be on the submitting vendor's W2. Yes Face to face interview required No Candidate must be authorized to work without sponsorship No Background Check No Drug Screen No End Client State Of Michigan Candidate Submit Limit...

    Argyle Infotech

    Lansing, MI
    2 days ago
  •  ...Job Description Job Description Job No: 10625MIPositionLead Data Engineer/ArchitectClient NameMichigan Department of Health...  ...transform, and prepare data for analytics and operational systems. - Architect and optimize data infrastructure, including storage solutions,... 
    H1b
    Work at office
    Local area
    Remote work
    Relocation
    Work visa

    AiQualTest LLC

    Lansing, MI
    4 days ago
  • $147.3k - $243.8k

    Job Description Data Platform Cloud Architect - Financial Services Industry (FSI) Oracle As the provider of the world's most complete, open, and integrated cloud applications and platform services, Oracle is dedicated to helping organizations innovate, transform, and... 
    Temporary work
    Worldwide
    Flexible hours

    Oracle

    Lansing, MI
    2 days ago
  • $90 per hour

     ...the organization. 2. Creates and maintains best practice and use case documentation for all databases used by the organization. 3. Maintains relationships with vendors that provide database related software and services to the organization. 4. Provides... 
    Full time
    Work at office

    RICEFW Technologies Inc

    Okemos, MI
    3 days ago
  • $75 per hour

     ...are seeking an experienced Lead Database Architect to lead the design, development, evaluation...  ...infrastructure, application development, cloud, and data engineering teams to deliver effective...  ...performance and reliability issues. 3. Cloud & Database Technologies... 
    Contract work

    AB2 Consulting, Inc.

    Okemos, MI
    5 days ago

Do you want to receive more vacancies?

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