Data Warehouse Architect

1 week ago

Lansing, MI, United States Damco Solutions Full time

We are seeking an experienced Data Warehouse Architect to join the Child Welfare Data Warehouse team. The ideal candidate will support the development of federal reporting systems (e.g., NYTD, AFCARS, NCANDS), ad-hoc analytics, ETL pipelines, and Business Objects reporting to facilitate data-driven decision-making across the department.

Position: Data Warehouse Architect 5
Location: Lansing, MI

Position : 1
Closing : 4/14/2025
Work : Hybrid
ddress : Lansing, MI
Projected start date : 05/05/2025
Responsibilities:

  • Collaborate with operational SACWIS/CCWIS developers to maintain data alignment between systems and the data warehouse.
  • Design, implement, and manage ETL processes for data extraction, transformation, and loading.
  • Build and maintain data warehouse applications including dashboards, reports, and data visualizations.
  • Support end-user and developer training, and provide ongoing technical support.
  • Work directly with agency requestors to understand data needs and build custom solutions.
  • ssist federal reporting teams with optimizing database queries and ensuring data accuracy.

Required Skills:
  • 3+ years of experience with Teradata Cloud (v17.20 preferred)
  • 3+ years of experience with Business Objects XI and/or Power BI
  • 3+ years performing ETL processes
  • Bachelor's Degree

Preferred Experience:
  • Federal reporting background (e.g., NYTD, AFCARS, NCANDS)
  • Experience working in a public sector or state government environment

Technical Environment:
  • Data Warehouse Platform: Teradata Cloud 17.20
  • Reporting Tools: Business Objects XI 4.2 SP4 (on Windows 2012), Power BI
  • ETL & BI: Data warehouse-based applications, dashboards, reporting, visualizations
  • Platform: Shared cloud platform with other State of Michigan departments

Interview Process: Virtual Interviews via MS Teams. A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of virtual interview to validate candidate.

Duration: 1 year with possible extension.
Remote or On-site: Accepting local candidates ONLY. Position will be hybrid, in office 2 days a week upon start and there is NO REMOTE ONLY option.

  • Data Warehouse Architect

    6 days ago

    Lansing, MI, United States Tech Tammina Full time

    Role: Data Warehouse Architect Location: Lansing, MI (Need locals) Duration: 12 months Rate: Market Responsibilities: • Responsible for complex Linux security model on DW ETL servers. (Servers are administered by another group, but our team is responsible for the security structure and authorizes user access to the groups and sudos) • Responsible for...

  • Data Warehouse Architect 5

    2 days ago

    Lansing, MI, United States Inficare Full time

    Title: Data Warehouse Architect 5 Location: Lansing. MI 48933 (Hybrid 2 days onsite) Duration: 1 year with possible extension. Interview Process: Virtual Interviews via MS Teams. Remote or On-site: Accepting local candidates to Michigan ONLY. Top Skills & Years of Experience: • 3+ years of experience with Teradata Cloud • 3+ years of experience with...

  • Data Warehouse Architect 5

    2 days ago

    Lansing, MI, United States InstantServe LLC Full time

    Roles and Responsibilities Responsible for complex Linux security model on DW ETL servers. (Servers are administered by another group, but our team is responsible for the security structure and authorizes user access to the groups and sudos) Responsible for Teradata security and access. Responsible for complex Common Batch Framework and Common Scheduler to...

  • ETL Developer

    6 days ago

    Lansing, MI, United States Maintec Technologies Full time

    ETL Developer (Data Warehouse Architect 3) Location: Lansing, MI - Onsite *** Exp Required - 10+ yrs Candidate should be in Michigan State or surrounding states (Illinois, Ohio, Indiana, Minnesota etc.) for this position Description: This position will serve as an ETL Developer responsible for supporting Master Data Management (MDM) initiatives and the...

  • ETL Developer

    1 week ago

    Lansing, MI, United States Maintec Technologies Full time

    ETL Developer (Data Warehouse Architect 3) Location: Lansing, MI - Onsite *** Exp Required - 10+ yrs Candidate should be in Michigan State or surrounding states (Illinois, Ohio, Indiana, Minnesota etc.) for this position Description: This position will serve as an ETL Developer responsible for supporting Master Data Management (MDM) initiatives and the...

  • Database warehouse Architect

    6 days ago

    Lansing, MI, United States Kyyba Full time

    Job Title: (Database warehouse Architect) Are you Database warehouse Architect seeking a dynamic and rewarding opportunity? Our client Public sector client is looking for a talented Database warehouse Architect to join their growing team in Lansing, MIAbout Kyyba: Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence...

  • Sr. Data Architect

    1 week ago

    Lansing, MI, United States ISC2 Full time

    Overview Your Future. Secured. ISC2 is a force for good. As the world's leading nonprofit member organization for cybersecurity professionals, our core values - Integrity, Advocacy, Commitment, Inclusion, and Excellence - drive everything we do in support of our vision of a safe and secure cyber world. Our globally recognized, award-winning portfolio of...

  • Sr. Data Architect

    6 days ago

    Lansing, MI, United States ISC2 Full time

    Overview Your Future. Secured. ISC2 is a force for good. As the world's leading nonprofit member organization for cybersecurity professionals, our core values - Integrity, Advocacy, Commitment, Inclusion, and Excellence - drive everything we do in support of our vision of a safe and secure cyber world. Our globally recognized, award-winning portfolio of...

  • Sr. Data Architect

    6 days ago

    Lansing, MI, United States ISC2 Full time

    Overview Your Future. Secured. ISC2 is a force for good. As the world's leading nonprofit member organization for cybersecurity professionals, our core values - Integrity, Advocacy, Commitment, Inclusion, and Excellence - drive everything we do in support of our vision of a safe and secure cyber world. Our globally recognized, award-winning portfolio of...

  • Data Warehouse Architect 3

    6 days ago

    Lansing, MI, United States Kyyba Full time

    Job Description Required Skills: Bachelor's degree or equivalent technical study 6+ Years Creating Data Warehouse BI applications including ETL/data mart development, reporting, dashboards and other information analysis and delivery system. Additional Skills: Experience with the Client PMM/SUITE/Agile methodology. SQL Assistant/Teradata Studio Experience...