Business Intelligence Engineer

2 weeks ago


Harrisburg, United States D&H Distributing Full time

SUMMARY

Please make an application promptly if you are a good match for this role due to high levels of interest.

​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


  • Harrisburg, United States D&H Distributing Full time

    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...


  • Harrisburg, United States Army National Guard Full time

    Job Description Intelligence is crucial to the security of our nation. By gathering information about an adversary's intentions, strengths, vulnerabilities, and capabilities, the military can plan, prepare, and defend against potential attacks. As a Human Intelligence Collector in the Army National Guard, you will earn a security clearance, then utilize...


  • Harrisburg, United States Carrier Full time

    Country: United States of America Location: CAP27: ALC- Harrisburg 6345 Flank Drive, Harrisburg, PA, 17112 USA At Carrier we make modern life possible by delivering groundbreaking systems and services that help buildings, homes and the cold chain become more healthy, safe, sustainable, and intelligent. Our global team of dedicated employees continues...


  • Harrisburg, United States Carrier Full time

    Country: United States of AmericaLocation: CAP27: ALC- Harrisburg 6345 Flank Drive, Harrisburg, PA, 17112 USAAt Carrier we make modern life possible by delivering groundbreaking systems and services that help buildings, homes and the cold chain become more healthy, safe, sustainable, and intelligent. Our global team of dedicated employees continues to set...


  • Harrisburg, United States Carrier Full time

    Country: United States of AmericaLocation: CAP27: ALC- Harrisburg 6345 Flank Drive, Harrisburg, PA, 17112 USAAt Carrier we make modern life possible by delivering groundbreaking systems and services that help buildings, homes and the cold chain become more healthy, safe, sustainable, and intelligent. Our global team of dedicated employees continues to set...


  • Harrisburg, United States META Full time

    Summary: You are a talented Graphics Engineer looking to build the next generation of games for VR. You have multiple years of experience with the Unity Editor (or other 3D game engines like Unreal) and can push pixels and perfect pipelines. Required Skills: Senior Graphics Engineer - BigBox Responsibilities: Collaborating with artists, designers, and...

  • Solutions Engineer

    6 days ago


    Harrisburg, United States Checkmarx Full time

    Description Who are we? Checkmarx is the enterprise application security leader and the host of Checkmarx One — the industry -leading cloud-native AppSec platform that helps enterprises build #DevSecTrust. Powered by the intelligence from our industry-leading AppSec security research team, and our AI-driven technology and services, our platform is designed...

  • Solutions Engineer

    7 days ago


    Harrisburg, United States Checkmarx Full time

    Description **Who are we?** **?** Checkmarx is the enterprise application security leader and the host of Checkmarx One the industry -leading cloud-native AppSec platform that helps enterprises build #DevSecTrust. Powered by the intelligence from our industry-leading AppSec security research team, and our AI-driven technology and services, our platform is...

  • Engineer III

    1 week ago


    Harrisburg, United States HNTB Full time

    At HNTB, you can create a career that is meaningful to you while building communities that matter to all of us. For more than a century, we have been delivering solutions for some of the largest, most complex infrastructure projects across the countr Engineer, Transportation, Systems, Transport, Construction, Design

  • Sr Data Engineer

    3 weeks ago


    Harrisburg, United States D&H Distributing Full time

    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...

  • Sr Data Engineer

    3 weeks ago


    Harrisburg, United States D&H Distributing Full time

    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...


  • Harrisburg, United States TestingXperts Full time

    Job Description We are looking for Sales Professionals from a software testing or IT services sales background, who will be responsible for driving sales of software testing/QA services. The ideal candidates will promote TestingXperts in the market and will build relationships with clients and partners promoting TestingXperts brand and offerings. Candidates...


  • Harrisburg, United States Employbridge Full time

    Business Development ManagerHarrisburg, PA Changing Lives One Day at a TimeWe're looking for a dynamic, savvy sales professional to join our rapidly growing team!Employbridge is the nation's leading logistics workforce specialist, providing all levels of logistics personnel from entry-level, skilled and managerial talent for the warehouse to senior...


  • Harrisburg, United States West Shore Full time

    As our nationwide growth accelerates, our Project Management Office (PMO) at our Corporate HQ in Mechanicsburg, PA plays a key role in driving forward our mission of Bringing Happiness to Every Home by critically analyzing business situations, developing solutions, and driving forward projects and programs. As a Senior Business Analyst at West Shore Home ,...


  • Harrisburg, United States Employbridge Full time

    Business Development ManagerHarrisburg, PA Changing Lives One Day at a Time We're looking for a dynamic, savvy sales professional to join our rapidly growing team!Employbridge is the nation's leading logistics workforce specialist, providing all levels of logistics personnel from entry-level, skilled and managerial talent for the warehouse to senior...

  • Business Analyst

    3 days ago


    Harrisburg, United States KCI Technologies Full time

    Overview Join us as we Rise to the Challenge At KCI, we’re building an enduring community that provides unparalleled value to our employee-owners. We make our mark designing and delivering our world-class solutions, so we invest deeply in supporting and developing our team. We reward integrity and commitment, and when we do well, you do well. Our...

  • Network Engineer

    7 days ago


    Harrisburg, United States Saxon Global Full time

    Apex Systems has an exciting, remote opportunity for a Network Engineer with our client, The Commonwealth of Pennsylvania! The selected candidate will be responsible for providing technical recommendations on network design builds, supporting network needs and projects, and integrating local and wide area network infrastructure and will have input into the...

  • Network Engineer

    5 days ago


    Harrisburg, United States Saxon Global Full time

    Apex Systems has an exciting, remote opportunity for a Network Engineer with our client, The Commonwealth of Pennsylvania! The selected candidate will be responsible for providing technical recommendations on network design builds, supporting network needs and projects, and integrating local and wide area network infrastructure and will have input into the...

  • Business Architect

    1 week ago


    Harrisburg, United States Info Matrix Corp Full time

    Info-Matrix Corporation is currently seeking an experienced Technical Architect to join our team. The Enterprise Architect creates enterprise architecture artifacts such as business and technical capability models, defines and documents standard patterns for solutions and formalizes application and technology standards, and provides architectural governance...


  • Harrisburg, United States Focused HR Solutions LLC Full time

    Network Engineer ***The candidate must be located within Pennsylvania at the start of the contract, but it would be management's preference if they were within an hour from the Greater Harrisburg Area. The position will be primarily telework, but occasional in-office attendance may be required depending on operational needs.*** Our direct client has an...