- 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.
- 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.
- 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.
- 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
-
Business Intelligence Engineer
2 weeks ago
D&H Distributing Harrisburg, United StatesSUMMARY · ?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 ef ...
-
Service Account Manager
2 weeks ago
Carrier Harrisburg, United States**Country**: · United States of America · **Location**: · CAP27: ALC- Harrisburg 6345 Flank Drive, Harrisburg, PA, 17112 USA · Carrier is the leading global provider of healthy, safe and sustainable building and cold chain solutions with a world-class, diverse workforce with busi ...
-
Velocity Ventures Dauphin, United StatesDauphin is seeking to fill a Professorship in Numerical Methods in Fluid Mechanics (W3) (Ref. No. T) at the Department of Mechanical Engineering at the Technical University of Darmstadt. · About the Technical University of Darmstadt: · The Technical University of Darmstadt is kn ...
-
Private physics classes for engineering
3 days ago
beBee Handyman Mason City, IL, United States FreelanceI am studying a 1-year degree in robotics and artificial intelligence in Mason City, IL and I need to reinforce my physics skills. Type of classes · Individual classes · Level of classes · Engineering · Preferred profile of the teacher · Student · Approximate number of hours per ...
-
SAP Bobj Developer
2 days ago
JMA Resources Mechanicsburg, United States**Position Overview**: · **Supervisory Responsibilities**: · - None · **Responsibilities**: · - Collaborate with business users, analysts, and stakeholders to gather and understand reporting requirements. · - Design, develop, and deploy reports, dashboards, and ad-hoc queries usi ...
-
U.S. Army War College Carlisle Barracks, United States**Duties**: · - You will serve as the Emerging Technology, Data and Artificial Intelligence Post-Doctoral fellow. · - Conduct research on these topics and contribute to the development, planning, and teaching of core and elective courses in the Resident Education Program and asso ...
-
Director Cloud Engineering AWS
1 week ago
S&P Global Harrisburg, PA, United StatesAbout the Role: · Grade Level (for internal use): · 13 S&P Dow Jones Indices is seeking a Director, Cloud Engineering to be a key player in the Infrastructure Engineering team to manage network administration of AWS Cloud environment and low latency Real-time platform used for ...
-
Lube Field Technician
1 week ago
Cleveland Brothers Equipment Company Harrisburg, United StatesJob Description · Job DescriptionCleveland Brothers, the largest Cat dealer in Pennsylvania, northern West Virginia and western Maryland, has an immediate opportunity for a Lube Field Technician. · Join our service experts and be part of a team using the latest equipment and tool ...
-
Sr Data Engineer
2 weeks ago
D&H Distributing Harrisburg, United StatesSUMMARY · 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 effe ...
-
Engineer III
1 week ago
HNTB Harrisburg, United StatesPosition or Keyword (Leave blank to see all) · Location (Leave blank to see all) · Engineer III - Intelligent Transportation Systems (ITS) · Harrisburg , · Pennsylvania · Job Category: · Engineering Group · Full/Part Time: · Full time · Job Type: · Regular · What We're Look ...
-
Field Service Engineer
1 day ago
Carrier Harrisburg, United StatesCountry: · 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, sa ...
-
Principal Analyst, Steel
3 weeks ago
S&P Global Harrisburg, PA, United StatesAbout the Role: · Grade Level (for internal use): · 12 · The Role s : Principal Analyst, Steel & Ferrous Scrap Team Lead · S&P Global Commodity Insights, a premier sector-focused news and information provider, is looking to expand our Commodity Briefing Service team, part of ...
-
Principal Analyst, Steel
2 weeks ago
S&P Global Harrisburg, PA, United StatesAbout the Role: · Grade Level (for internal use): · 12 · The Role s : Principal Analyst, Steel & Ferrous Scrap · S&P Global Commodity Insights, a premier sector-focused news and information provider, is looking to expand our Commodity Briefing Service team, part of the S&P G ...
-
Lead Principal Verification Engineer
6 days ago
Renesas Harrisburg, United StatesRenesas · Lead Principal Verification Engineer · Harrisburg , · Pennsylvania · Apply Now · Renesas is looking for a Mixed-Signal Verification Engineer to join our team of engineers that support the development and release of several power management ICs for the portable mark ...
-
Principal Analyst, Steel
2 weeks ago
S&P Global Harrisburg, PA, United StatesAbout the Role: · Grade Level (for internal use): · 12 · The Role s : Principal Analyst, Steel & Ferrous Scrap Team Lead · S&P Global Commodity Insights, a premier sector-focused news and information provider, is looking to expand our Commodity Briefing Service team, part of ...
-
Area Sales Manager
1 week ago
ISOVOLTA Inc. Harrisburg, United StatesThe ideal candidate will be responsible for building out our sales and marketing strategy, sales forecasting reports, and sales pipeline. You will then monitor our sales performance with the goal of expanding our company's market share. Your collaborative nature and will help you ...
-
Business Intelligence Manager
2 weeks ago
Wolters Kluwer Harrisburg, United StatesLocation: US Remote · The Business Intelligence Manager role requires specialized depth and/or breadth of expertise, conceptual and practical knowledge of theories and principles in the discipline of business intelligence, and applies general knowledge of business and industry p ...
-
Diesel or Automotive Technician
1 week ago
Cleveland Brothers Equipment Company Harrisburg, United StatesJob Description · Job DescriptionAre you an Automotive or Diesel Technician looking for a change? · Cleveland Brothers Caterpillar is seeking highly skilled Automotive or Diesel Technicians for field positions working on Diesel engines or construction equipment as well as other s ...
-
Associate Director, Business Intelligence
6 days ago
Humana Harrisburg, United StatesHumana · Associate Director, Business Intelligence · Harrisburg , · Pennsylvania · Apply Now · Become a part of our caring community and help us put health first · The Associate Director, Business Intelligence for CPSS Data and Analytics will support the account services, en ...
-
Field Service Engineer
3 weeks ago
Carrier Harrisburg, United StatesCountry: 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, sustaina ...
Business Intelligence Engineer - Harrisburg, United States - D&H Distributing
Description
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:
ESSENTIAL DUTIES AND RESPONSIBILITIES
EDUCATION and/or EXPERIENCE
Education
Experience