Data Warehouse Analyst Teradata ETL BA

4 weeks ago

Lansing, United States DATAMAXIS Full time

Rate: Depending on experience

Work location: Remote

Required Skills/Experience:

  • 5+ years' experience working as a Data Analyst, Technical Business Analyst, Systems Analyst or Business Analyst experience in a Data Warehouse project environment

  • 5+ years' experience working with end users/customers to understand system and business issues and perform technical analysis to understand and develop requirements and solutions

  • 5+ years' experience with SQL; Teradata SQL Assistant, MS SQL Server including:
    o Understanding of data warehousing definition concepts like
    • Tables, Views
    • Stored procedures and macros
    o Experience using Teradata Utilities such as
    • MLOAD
    • BTQ
    • SQLA
    o Experience where there is involvement in working with any database related languages like SQL and their equivalent concepts like
    • Indexing
    • Joins
    • Sub queries
    • Volatile/temp tables
    o Experience in maneuvering existing lines of complex SQL code in identifying an issue reported by non-technical/technical users
    o Understanding of data in the terms of space and size and usage of the tables
    o Understanding of Datatypes related to the tables like Char, timestamps, etc.
    o Ability to understand and modify existing Views and their definitions to align and satisfy business requirements
    o Involvement in processes that involve batch jobs

  • Experience in teams that support applications that have their source as a Data warehouse.

  • Understanding of data visualization-reporting tools

  • 3+ years' experience developing test data and test scenarios

  • Ability to facilitate customer requirements gathering meetings/sessions

  • Must be able to work independently and not rely on State or other team members

  • Must be able to communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector.

Preferred but not Required Skills/Experience:

  • Experience with leading project work, providing direction for team members

  • Experience with Data Modeling/Database Design

  • Experience with Court applications or relevant court experience

  • Experience with JAD and Agile IT Development methodologies

  • Ability to clearly communicate with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan.

  • Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations.

  • Working with developers, facilitate modification of the logical design to create a physical design most suited to the reporting needs of the customer.

  • Ability to design applications taking into consideration data reconciliation, (to the source system) query/reporting performance, and analytical business value.

  • Experience with BI Query

  • Experience with Data Cleansing

  • Experience with Data Governance

  • Data Warehouse Developer

    3 weeks ago

    Lansing, United States DATAMAXIS Full time

    Rate: Depending on experience Work location: Lansing, MI (Hybrid) - 2 days onsite and three days remote. Required Skills: 5+ Years Teradata Utilities Experience 5+ years of SQL and ETL development 3+ Years SQL Assistant Experience 3+ Years Unix Shell Scripting Experience 3+ Years SQL and Performance Tuning 2+ Years Teradata Version 16/17 Experience 2+ Years...

  • Data Warehouse Developer

    3 weeks ago

    Lansing, United States DATAMAXIS Full time

    Rate: Depending on experience Work location: Lansing, MI (Hybrid) - 2 days onsite and three days remote. Required Skills: 5+ Years Teradata Utilities Experience 5+ years of SQL and ETL development 3+ Years SQL Assistant Experience 3+ Years Unix Shell Scripting Experience 3+ Years SQL and Performance Tuning 2+ Years Teradata Version 16/17 Experience 2+...

  • Data Warehouse Developer

    1 week ago

    Lansing, United States Datamaxis Full time

    Rate: Depending on experience Work location: Lansing, MI (Hybrid) - 2 days onsite and three days remote. Required Skills: 5+ Years Teradata Utilities Experience 5+ years of SQL and ETL development 3+ Years SQL Assistant Experience 3+ Years Unix Shell Scripting Experience 3+ Years SQL and Performance Tuning 2+ Years Teradata Version 16/17 Experience 2+...

  • Senior Architect

    1 month ago

    Lansing, United States Resource Informatics Group Full time

    Job Description The position functions as a senior information technology analyst responsible for developing, maintaining, and enhancing a variety of automated data warehouse applications. This position will also represent the team and coordinate team activities with other data warehouse teams on complex, multi-team projects. In addition, the position will...

  • Senior Architect

    5 days ago

    Lansing, United States Resource Informatics Group Full time

    Job Description The position functions as a senior information technology analyst responsible for developing, maintaining, and enhancing a variety of automated data warehouse applications. This position will also represent the team and coordinate team activities with other data warehouse teams on complex, multi-team projects. In addition, the position will...

  • Data Warehouse Developer

    4 weeks ago

    Lansing, United States DATAMAXIS, Inc Full time

    Data Warehouse Developer Located in Lansing MI Monday - Friday 8 - 5 Position must report to onsite work location in Lansing MI. Currently working a hybrid schedule of two days onsite and three days remote. Overall Position Description: The Data Warehouse developer position will perform application development tasks in support of building BI applications...

  • Data Warehouse Developer

    4 weeks ago

    Lansing, United States AB2 Consulting, Inc. Full time

    Job DescriptionJob DescriptionData Warehouse DeveloperLocated in Lansing MI Monday - Friday 8 - 5Position must report to onsite work location in Lansing MI. Currently working a hybrid schedule of two days onsite and three days remote.Overall Position Description:The Data Warehouse developer position will perform application development tasks in support of...

  • Data Warehouse Developer

    2 weeks ago

    Lansing, United States Optum Full time

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion,...

  • Data Warehouse Developer

    2 weeks ago

    Lansing, United States Optum Full time

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion,...

  • Data Warehouse Developer

    3 weeks ago

    Lansing, United States Optum Full time

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion,...

  • Data Warehouse Developer

    1 week ago

    Lansing, United States Optum Full time

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion,...

  • Data Warehouse Developer

    3 days ago

    Lansing, United States Optum Full time

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion,...

  • Health Services DW

    3 weeks ago

    Lansing, United States UnitedHealth Group Full time

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion,...

  • Health Services DW

    2 weeks ago

    Lansing, United States UnitedHealth Group Full time

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion,...

  • Data Warehouse Architect

    3 weeks ago

    Lansing, United States HRU Inc Technical Resources Full time

    The Data Warehouse Architect will be responsible for developing and changing BusinessObjects (XI R2) components as well as Informatica scripts to meet request of the business. This role will work as a member of a team of data warehouse professionals, under the direct leadership of the Data Warehouse Competency Center Team Lead. As the Data Warehouse...

  • Lansing, MI

    2 weeks ago

    Lansing, United States Saxon Global Full time

    This position will serve as an ETL Developer responsible for supporting Master Data Management (MDM) initiatives and the Information Services environments. The position develops Information Services needs as well as evaluating, recommending and supporting technological solutions and Data Management architecture and software. They work closely with agency...

  • Lansing, MI

    3 weeks ago

    Lansing, United States Saxon Global Full time

    This position will serve as an ETL Developer responsible for supporting Master Data Management (MDM) initiatives and the Information Services environments. The position develops Information Services needs as well as evaluating, recommending and supporting technological solutions and Data Management architecture and software. They work closely with agency...

  • Lansing, MI

    3 weeks ago

    Lansing, United States Saxon Global Full time

    This position will serve as an ETL Developer responsible for supporting Master Data Management (MDM) initiatives and the Information Services environments. The position develops Information Services needs as well as evaluating, recommending and supporting technological solutions and Data Management architecture and software. They work closely with agency...

  • Lansing, MI

    2 weeks ago

    Lansing, United States Saxon Global Full time

    This position will serve as an ETL Developer responsible for supporting Master Data Management (MDM) initiatives and the Information Services environments. The position develops Information Services needs as well as evaluating, recommending and supporting technological solutions and Data Management architecture and software. They work closely with agency...

  • Data Analyst

    2 months ago

    Lansing, Michigan, United States Atechstar Full time

    Job DescriptionData Analyst Responsibilities Managing master data including creation updates and deletion. Managing users and user roles. Provide quality assurance of imported data working with quality assurance analysts if necessary. Commissioning and decommissioning of data sets. Processing confidential data and information according to guidelines. Helping...