Jobs
>
Harrisburg

    Sr Data Engineer - Harrisburg, United States - D&H Distributing

    D&H Distributing
    D&H Distributing Harrisburg, United States

    2 weeks ago

    Default job background
    Technology / Internet
    Description

    SUMMARY

    The Sr Data Engineer will need to be analytical, technically inclined, detail-oriented, visually focused, and a self-learner. As a Subject Matter Expert in technical requirements, this role is critical in supporting and implementing data projects and solutions, and effectively engaging with users and other IT staff. As a member of the Business Intelligence team, the individual will be able analyze the existing data warehouse database to ensure the efficiency and accuracy to business functions and operational reporting, as well as modify the ETL processes for a complex and maturing data warehouse. They should also:

    • Have an understanding of data modeling, have excellent analytical skills, and the ability to identify solutions to complex data problems.
    • Have an understanding or working experience with BI tools such as Cognos or Tableau
    • Be able to communicate appropriately with the team leadership.
    • Be able to interpret business requests and create technical requirements, including mapping documents to support the data ingestion and pipeline development process, and the execution of ETL jobs.

    ESSENTIAL DUTIES AND RESPONSIBILITIES

    • Interpret business requests and create technical requirements, including mapping documents to support the data ingestion and pipeline development process, and the execution of ETL jobs.
    • Supporting, optimizing and monitoring current data warehousing, data modeling, data integration, business intelligence and ETL processes on NETEZZA platform with CTAS, CBT, zone map and work-load management.
    • Provide assistance in troubleshooting and resolving data and system issues, stepping in when necessary to address outages and challenges.
    • Develops ETL's using mostly DataStage with some flavors of SSIS to facilitate Extraction, Transformation and Data Load from disparate systems.
    • Maintain methods and procedures for tracking data quality, completeness, redundancy, and improvement.
    • Develop and maintain SQL stored procedures and views as part of a star database schema on NETEZZA using WinSQL, NZLOAD, NZSQL and NZBACKUP utilities.
    • Need to have the ability to analyze and trouble issues across various applications from Access Tools(Cognos, Tableau and Excel), Data warehouse/Data Marts on Netezza Platform.
    • Knowledge of wrapper scripts for Netezza Loader (i.e. NZLOAD) and reporting using Shell scripting, PERL and NZSQL.
    • Have an understanding of scheduling tools such as: Active Batch, Tidal or similar
    • Troubleshoot issues such as connections, failed jobs, application errors, server alerts, space thresholds, etc. within predefined SLAs.
    • Actively participate in design discussions, code reviews, and project-related team meetings.
    • Develop processes that facilitate data transformation, manage data structures, metadata, dependencies, and workload management.
    • Collaborate with business users to understand functional and data requirements, contributing to the enhancement of data models and pipelines.
    • Apply expert-level analytical and problem-solving skills to troubleshoot and resolve technical issues.
    • Develop, maintain, and continuously enhance scalable data pipelines, while also developing new data source integrations to support the growing volume and complexity of data.
    • Proactively maintain and tune SQL code.
    • Identify and capture lessons learned, best practices, and information gained during performance of tasks.
    • Be part of a 24x7 on-call rotation for after hour and weekend production support.

    EDUCATION and/or EXPERIENCE

    Education

    • Bachelor's degree (B. A.) from four-year college or university; or one to two years related experience and/training; or equivalent combination of education and experience.

    Experience

    • 5-7 years' experience extracting and summarizing data from a variety of data source types using ETL tools
    • Experience in writing complex SQL using Netezza and SQL Server with a strong competency in T-SQL
    • Experience interfacing with business users and understanding their requirements
    • Experience with DataStage, QualityStage, DataDirector, SSIS, SSRS, Powershell, Active Batch
    • Experience with Tableau and Cognos a plus
  • Foot Locker Retail Inc.

    Data Platform Engineer

    2 weeks ago

    Foot Locker Retail Inc. Camp Hill, United States

    Data Platform Engineer (Foot Locker Corporate Services, Inc.) (Camp Hill, PA): Build enterprise level platform components to support product development from multiple teams and lines of business. Requires a Bachelor's Degree or foreign equivalent in Computer Science, Information ...

  • Apex Systems

    Senior Data Architect/Engineer

    1 week ago

    Apex Systems Harrisburg, United States

    Senior Data Architect/Engineer · Job Overview · The Commonwealth of Pennsylvania is looking for a Senior Data Architect/Engineer to join its team of analytics professionals to support its Pennsylvania Longitudinal Data System (PALDS) data integration services as well as system ...

  • Sumitomo Pharma

    Associate Director, Data Engineer

    1 week ago

    Sumitomo Pharma Harrisburg, United States

    Sumitomo Pharma America (SMPA) is focused on delivering therapeutic and scientific breakthroughs in areas of critical patient need spanning psychiatry & neurology, oncology, urology, womens health, rare disease, and cell & gene therapies. The companys diverse portfolio includes s ...

  • General Dynamics

    Data Engineer

    1 week ago

    General Dynamics Mechanicsburg, United States

    Responsibilities for this Position · Location: USA PA Home Office (PAHOME) · Full Part/Time: Full time · Job Req: RQ174972 · Type of Requisition: · Regular · Clearance Level Must Currently Possess: · Secret · Clearance Level Must Be Able to Obtain: · Secret · Suitabi ...

  • Actalent

    Quality Technician

    2 weeks ago

    Actalent Harrisburg, United States Full time

    Description: · Quality Tech: · • Perform raw ingredient testing (i.e. microbiological, physical, chemical and organoleptic testing) as required. · • Conduct testing for butterfat, total solids, standard plate counts, total coliform counts, homogenization efficiency, and titratabl ...

  • Actalent

    Quality Laboratory Technician

    1 week ago

    Actalent Harrisburg, United States Full time

    Description: · Quality Tech: · • Perform raw ingredient testing (i.e. microbiological, physical, chemical and organoleptic testing) as required. · • Conduct testing for butterfat, total solids, standard plate counts, total coliform counts, homogenization efficiency, and titratabl ...

  • Commonwealth of PA

    Environmental Engineering Specialist

    3 weeks ago

    Commonwealth of PA Dauphin County, PA, United States

    **THE POSITION**: · **DESCRIPTION OF WORK**: · - In this role, you will be responsible for assessing and validating low complexity test protocols and reports to ensure compliance with federal and/or state regulations, as well as plan approvals and operating permits. You will also ...

  • Tetra Tech

    Jr. Planner

    3 weeks ago

    Tetra Tech Harrisburg, United States

    Discover your full potential. At Tetra Tech, we are collaborating with industry-leading experts for a sustainable future for our world. We combine consulting and engineering with advanced analytics and technology to solve the world's most complex challenges. Our innovation hubs a ...

  • SCS Engineers

    Entry-level Field Technician

    1 week ago

    SCS Engineers Harrisburg, United States

    **What we are looking for** · A Field Technician operates and manages gas migration control/recovery systems including gas well monitoring and adjustment, troubleshooting, and system repairs. We are looking for a Field Technician to service the Harrisburg, PA area. · **How you ca ...

  • Penske Truck Leasing

    Diesel Mechanic/Technician I

    2 weeks ago

    Penske Truck Leasing Harrisburg, United States Full time

    What's the Job? · Ready to move your career forward? As an experienced Technician at Penske, you'll do exactly that. Here, you'll perform preventative maintenance and repairs of all levels on the newest and best maintained fleet of vehicles in the industry. You will help our cust ...

  • TE Connectivity

    Administrative Support-exec

    2 weeks ago

    TE Connectivity Harrisburg, United States

    The Executive Administrative Assistant will provide high-level direct support to members of TE Connectivity's Information Systems (TEIS) executive leadership team. This individual plays a central role in supporting the TEIS organization. We're looking for an individual who is a s ...

  • The Davey Tree Expert Company

    Design Field Technician 1

    2 weeks ago

    The Davey Tree Expert Company Harrisburg, United States

    Design Field Technician 1 | DRG Northeast | UAM Make Ready Engineering · **Additional Locations**: Wilkes-Barre, PA Region · **Primary Locations**:PA, Harrisburg, 600 N 2nd St, Suite 401, 17101 · **Requisition ID**:188953 · **Position Overview**: · This position is traveling thro ...

  • Commonwealth of PA

    Management Analyst 2

    3 weeks ago

    Commonwealth of PA Dauphin County, PA, United States

    **THE POSITION**: · **DESCRIPTION OF WORK**: · - As a member of the Inventory Management team, you will play a crucial role in overseeing and managing various material inventory programs and systems. You will actively contribute to the development and recommendation of inventory ...

  • Commonwealth of PA

    Photogrammetry Technician 1

    1 week ago

    Commonwealth of PA Dauphin County, PA, United States

    **THE POSITION**: · **DESCRIPTION OF WORK**: · This role is within the Bureau Construction, Engineering Automation and Services Division, specifically in the Photogrammetry & Surveys Section. Your main responsibilities will involve creating digital topographic maps, digital ortho ...

  • Terracon Consultants, Inc.

    Environmental Technician Iii

    2 weeks ago

    Terracon Consultants, Inc. Harrisburg, United States

    **Job Description**: · **General Responsibilities**: · Perform tests and sampling of environmental materials including air, groundwater, building materials, and noise. Operates field monitoring equipment. Assists with operation and maintenance of remediation systems. May assist w ...

  • Penske Truck Leasing

    Diesel Technician/Mechanic III

    2 weeks ago

    Penske Truck Leasing Harrisburg, United States Full time

    801 Katie Court Harrisburg, PA, 17109 · What's the Job? · Ready to accelerate your career while helping our customers move forward? As a Technician at Penske, you'll do exactly that. Here, you'll do preventative maintenance and minor repairs on the newest and best maintained flee ...

  • Commonwealth of PA

    Bridge Inspector

    2 weeks ago

    Commonwealth of PA Dauphin County, PA, United States

    **THE POSITION**: · **DESCRIPTION OF WORK**: · - As a member of the bridge inspection team, your role will involve providing assistance to the team leader in carrying out a range of technical tasks related to the inspection of bridges and other structures. These tasks will be con ...

  • Limitless Mobile LLC

    Wireless Roaming Coordinator

    2 days ago

    Limitless Mobile LLC Harrisburg, United States

    **Position**: Wireless Roaming Coordinator · **Location**: Harrisburg, Pennsylvania · **Reporting to**: Director, Roaming & Wholesale · **Role**: · - The Roaming Coordinator works as part of the Roaming & Wholesale team, which is responsible for establishing, launching, and manag ...

  • Herbert, Rowland & Grubic, Inc.

    Civil Resident Project Representative Ii

    5 days ago

    Herbert, Rowland & Grubic, Inc. Harrisburg, United States

    : · **HRG i**s an employee-owned, nationally recognized consulting engineering, planning, and infrastructure solutions firm. · We are actively seeking a **Civil Resident Project Representative II** to join our dedicated team of professionals in **Harrisburg, PA.** As a **Civil Re ...

  • Commonwealth of PA

    Bridge Inspection Team Leader

    1 week ago

    Commonwealth of PA Dauphin County, PA, United States

    **THE POSITION**: · **DESCRIPTION OF WORK**: · As the team leader, you will be responsible for overseeing and participating in the inspection of structures to assess any damage caused by accidents, water scouring, wear or corrosion, disintegration of concrete, and the condition o ...