Talent.com
Data Warehouse Architect- Lansing, MI

Data Warehouse Architect- Lansing, MI

Sunrise SystemsLansing, Michigan, United States
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.permanent
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

Job Title : Data Warehouse Architect 5

Location : Lansing, MI

Duration : 1 year with possible extension.

Top Skills & Years of Experience :

  • 3+ years of experience with Teradata Cloud
  • 3+ years of experience with Business Objects XI and / or Power BI
  • 3+ years performing ETL processes

General Summary :

CLIENT is the agency recognized by the (Client), Administration for client Dept as responsible for administering federal client programs under Titles IV-B and IV-E of the Social Security Act. The CLIENT mission includes a commitment to ensuring that children and youth served by the public systems are safe; to promote, improve and sustain a higher quality of life while enhancing their wellbeing; and to have permanent and stable family lives.

This position is assigned to support client team in developing Federal reporting, ad-hoc, ETL, and Business Objects reports that are critical to the success of the application such as NYTD, AFCARS, and NCANDS. Also, any other projects that need ETL support that add value to the Department and end users to get them the data they need for them to be more productive.

Tasks :

  • The Data Warehouse Architect will work with State and contract staff and the operational SACWIS / CCWIS system developers to ensure that the operational system database will support the data needs of the Child Welfare Data Warehouse, and the functionality needed to extract the needed data on a regular basis.
  • Work with State and contract staff to design and load the Child Welfare Data Warehouse database model to support the reporting and analytic needs of DHHS.
  • As the operational SACWIS / CCWIS project continues, work with State, contract, and the operational SACWIS / CCWIS contractor staff to make needed changes to the Child Welfare data warehouse that may evolve from the operational SACWIS / CCWIS system.
  • Work closely with State and contract staff to ensure that they are fully aware of the decisions and impacts involved in the supporting and / or enhancing the CLIENT Data Warehouse models and can support and extend them by the end of the contract.
  • Client Dept perform application development tasks in support of building business intelligence applications and integrating data warehouse resources into other CLIENT applications. In addition, they provide database expertise to other application developers in close collaboration with DBAs and other data management staff.
  • Creating data warehouse-based applications including reporting, dashboards and other information analysis, visualizations and delivery systems.
  • Extract, transform, and load systems to move data from the various operational systems in which it is collected to a cleansed, consolidated data warehouse.
  • Work with data warehouse Federal reporting team members and end user query developers to design and improve database queries.
  • Data warehouse Architects are also expected to be able to work with agency requestors to define and develop new queries and provide training and technical support to both client dept developers and end user query developers.
  • Working with end user requestors to understand their data needs and create and implement solutions to those needs.
  • Develop and present training classes for client developers to better understand how to use the Teradata and BI development tools to create and implement reporting solution using the data warehouse.
  • Provide one on one support for developers and end users to assist them in accomplishing their federal data reporting needs.
  • Client Enterprise Data Warehouse Environment

  • Teradata Cloud version 17.20
  • Shared platform with other client departments
  • Business Objects XI 4.2 SP4 on a Windows 2012 virtual platform.
  • serp_jobs.job_alerts.create_a_job

    Data Warehouse Architect • Lansing, Michigan, United States

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Senior Data Architect (MarTech)

    Senior Data Architect (MarTech)

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Architect (MarTech) to lead data strategy and architecture for a large-scale MarTech transformation. Key Responsibilities Lead current-state data assessment and def...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Principal Data Architect

    Principal Data Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Principal Data Architect responsible for shaping enterprise data strategy, architecture, and governance. Key Responsibilities Define and maintain enterprise data archite...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Cloud Architect

    Senior Cloud Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Cloud Architect.Key Responsibilities Translate complex business requests into actionable designs while managing ambiguity Achieve clarity for project delivery a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Lead Data Engineer

    Lead Data Engineer

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Lead Data Engineer to design, build, and manage enterprise-grade data pipelines.Key Responsibilities Design, develop, and optimize metadata-driven data pipelines in Fab...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Cloud Solutions Architect

    Cloud Solutions Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Cloud Solutions Architect, Remote.Key Responsibilities Architect, plan, and implement public cloud solutions in Azure and AWS Respond to RFPs and write technical conte...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Business Architect

    Senior Business Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Business Architect to lead enterprise-wide initiatives that align business strategy with technology capabilities. Key Responsibilities Architect and execute enter...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Cloud Architect

    Cloud Architect

    Fast SwitchMichigan Center, MI, United States
    serp_jobs.job_card.full_time
    This position serves as an Cloud Application Architect for the Michigan Center for Educational Performance and Information (CEPI). This position will serve as the technical expert on orchestrating t...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Business Warehouse Engineer

    Business Warehouse Engineer

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Business Warehouse (BW) Engineer to enhance and modernize their SAP analytics and data warehousing landscape. Key Responsibilities Analyze existing SAP BW on HANA archit...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Anaplan Solution Architect

    Anaplan Solution Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for an Anaplan Solution Architect.Key Responsibilities Design, build, and deploy Anaplan models and dashboards based on business requirements Collaborate with cross-function...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Cloud Architect (Onsite in Lansing MI)

    Cloud Architect (Onsite in Lansing MI)

    Codeworks L.L.CLansing, MI, US
    serp_jobs.job_card.full_time
    Codeworks is a locally owned and operated IT Services firm in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships. Our direct client is looking for an ex...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Architect, Cloud Performance

    Architect, Cloud Performance

    OracleLansing, MI, United States
    serp_jobs.job_card.full_time
    Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.As a member of the software engineering division, you will take an active role in the defi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    SAP BW-4HANA Architect

    SAP BW-4HANA Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a SAP BW / 4HANA Lead Architect to lead the implementation and optimization of their enterprise data warehouse. Key Responsibilities Define and manage the BW / 4HANA target st...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior Solutions Architect

    Senior Solutions Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Solutions Architect (Data).Key Responsibilities Designs and builds relational databases for data storage and processing Develops strategies for data acquisition...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Cloud Architect

    Cloud Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Cloud Architect.Key Responsibilities Design and implement cloud solutions tailored to client needs Collaborate with cross-functional teams to ensure seamless integrati...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Technical Sales Architect

    Technical Sales Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Technical Sales Architect focused on Developer Platform & Integrations.Key Responsibilities Enable pre-sales engineers on integration architecture and minimize customer...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Information Architect (Michigan)

    Information Architect (Michigan)

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for an Information Architect (Taxonomist).Key Responsibilities Develop and refine structured taxonomies, controlled vocabularies, and metadata schemas for internal content an...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Lead Azure Data Engineer

    Lead Azure Data Engineer

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Lead Azure Data Engineer.Key Responsibilities Designs and develops data solutions using Microsoft Azure technologies to meet business needs Manages IT controls and pro...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Data Architect

    Senior Data Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    Key Responsibilities : Lead the definition and execution of the Information Management roadmap Manage architectural runway for enterprise data models and advanced data analytics capabilities Pro...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Principal Cloud Architect

    Principal Cloud Architect

    VirtualVocationsLansing, Michigan, United States
    serp_jobs.job_card.full_time
    A company is looking for a Principal Architect.Key Responsibilities Develop and maintain the enterprise cloud and platform architecture framework Lead the design and implementation of enterprise...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Cloud Architect

    Cloud Architect

    InterSourcesLansing, MI, United States
    serp_jobs.job_card.temporary
    Duration : 12 Months Contract Position.Hybrid : 2 days Office / Week (Wednesdays and Thursdays).This position serves as an Cloud Application Architect for the Michigan Center for Educational Performan...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days