HBITS IT Specialist

2 weeks ago

Albany, NY, United States KNOWLEDGE BUILDERS Full time
Job Description

Project/Program:
WCB Data Management for various WCB projects as necessary

The position is required to provide data management expertise supporting the continued development and maintenance of WCB systems. Working as part of a DevOps environment, the position will be responsible for the development and maintenance of ETL/ELT pipelines in Azure ADF and/or data migration processes, T-SQL and SQL scripts. In addition, the resource will review business requirements documents, analyze and profile source data, maintain scripts in source control repository, performance tune scripts, review and troubleshoot data quality alerts, prepare source to target mapping documents and execute data manipulation language (DML) scripts. The duties will be performed against both cloud-based and on-premises databases.

Day-to-Day Tasks:
- Generate and publish data definition language (DDL) from physical data model to Azure cloud-based and/or on-premises SQL Server databases.
- Design and develop ELT/ETL processes for the migration of data using various ETL tools, mainly MS ADF.
- Manage, monitor and troubleshoot Azure Data Factory pipelines.
- Identify and troubleshoot data quality issues.
- Develop and execute complex queries and procedures using T-SQL and SQL.
- Manage and maintain scripts and code in source control repository.
- Interact with the development team and business users to understand business process flow and business rules.
- Design and document data models, data migration and data quality requirements and solutions.
- Provide knowledge transfer to other data management team members.

Mandatory Qualification:
IT Specialist -
Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.

Expert -
84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

Requested Qualifications:
- 84 months experience developing logical and physical relational data models for OLTP databases.
- 60 months experience using erwin Data Modeler to create and maintain logical and physical data models.
- 84 months experience in complex T-SQL and SQL development against SQL Server.
- 60 months experience identifying and troubleshooting data quality issues.
- 48 Months experience developing and managing Azure Data Factory ELT/ETL processes.
- 48 months experience using source control and release technologies such as Git and Azure DevOps.

  • Specialist - HBITS-04-03388

    2 weeks ago

    Albany, NY, United States Elite Enterprise Resources Full time

    Specialist - HBITS-04-03388 Albany , New York , United States | Contract Apply with Linkedin Apply with Indeed Apply Specialist - Job ID #HBITS-04-033 Albany, NY, United States/ 2 Year Contract APPLICATION CLOSING DATE: 03-31-2016 SPECIALIST APPLY ONLINE FOR IMMEIDATE CONSIDERATION - https://elitehasjobs.recruiterbox.com -Experience in the usage and support...

  • NYS DPS HBITS-07-14454 Expert IT Specialist

    2 days ago

    Albany, NY, United States Voyatek OnDemand Full time

    Opportunity Details Full Time NYS DPS HBITS-07-14454 Expert IT Specialist (.NET) Albany, NY Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the WIC...

  • NYS DPS HBITS-07-14454 Expert IT Specialist

    1 week ago

    Albany, NY, United States Voyatek OnDemand Full time

    Opportunity Details Full Time NYS DPS HBITS-07-14454 Expert IT Specialist (.NET) Albany, NY Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the WIC...

  • NYS DPS HBITS-07-14454 Expert IT Specialist

    4 days ago

    Albany, NY, United States Voyatek OnDemand Full time

    Opportunity Details Full Time NYS DPS HBITS-07-14454 Expert IT Specialist (.NET) Albany, NY Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the WIC...

  • NYS DPS HBITS-07-14454 Expert IT Specialist

    4 days ago

    Albany, NY, United States Voyatek OnDemand Full time

    Opportunity Details Full Time NYS DPS HBITS-07-14454 Expert IT Specialist (.NET) Albany, NY Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the WIC...

  • NYS DPS HBITS-07-14454 Expert IT Specialist

    1 week ago

    Albany, NY, United States Voyatek OnDemand Full time

    Opportunity Details Full Time NYS DPS HBITS-07-14454 Expert IT Specialist (.NET) Albany, NY Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the WIC...

  • NYS DPS HBITS-07-14454 Expert IT Specialist

    7 hours ago

    Albany, NY, United States Voyatek OnDemand Full time

    Opportunity Details Full Time NYS DPS HBITS-07-14454 Expert IT Specialist (.NET) Albany, NY Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the WIC...

  • NYS OCM HBITS-07-14456 Expert IT Specialist

    4 days ago

    Albany, NY, United States Voyatek OnDemand Full time

    Opportunity Details Full Time NYS OCM HBITS-07-14456 Expert IT Specialist (Tester) Albany, NY Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the...

  • NYS OCM HBITS-07-14456 Expert IT Specialist

    2 days ago

    Albany, NY, United States Voyatek OnDemand Full time

    Opportunity Details Full Time NYS OCM HBITS-07-14456 Expert IT Specialist (Tester) Albany, NY Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the...

  • IT Specialist

    6 days ago

    Albany, NY, United States MVP Consulting Inc Full time

    HBITS-07-14445 WCB, IT Specialist, Expert 24 month contract Virtual interview Selected candidates are expected to work in Albany office, 2-3 days per week Day to Day tasks to be performed by candidate include: Generate and publish data definition language (DDL) from physical data model to Azure cloud-based and/or on-premises SQL Server databases. ...