Senior Data Warehouse Developer

ICONMA, LLC • United States, United States • 2h ago

Our client, a Banking company, is looking for a Senior Data Warehouse Developer for their Jersey City, NJ/Hybrid location. Responsibilities:

This role is responsible for architecting, designing, developing, and maintaining large scale data warehouse and analytics platforms to support enterprise reporting, analytics, and decision making needs. The position requires deep expertise in database design, data modeling, data engineering, and modern OLAP systems.

Design and implement robust, scalable ETL/ELT pipelines for ingesting data from internal and external sources; ensure strong data validation, quality checks, and observability.

Design and evolve data warehouse architectures and OLAP data platforms, supporting internal analytics use cases as well as client-facing and third-party reporting solutions.

Lead and contribute to database design, dimensional and analytical data modeling, and data mart development to support high performance analytics.

Architect, develop, and optimize OLAP workloads, including query performance, indexing, partitioning, and data distribution strategies.

Perform monitoring, tuning, and performance analysis across distributed database and analytics systems.

Design, extend, and maintain data marts, metadata frameworks, and semantic layers.

Ensure all data warehouse and data platform code is maintained using version control and CI/CD best practices.

Collaborate closely with business and technology stakeholders to define data requirements and ensure effective use of analytics platforms.

Work with cross functional development teams to manage dependencies, define test strategies, debug issues, and maintain high data quality standards.

Ensure software stability and reliability through comprehensive documentation, code reviews, automated testing, and operational best practices.

Requirements:

Bachelor's degree in an analytical or technical discipline such as Computer Science, Information Technology, Engineering, or related field.

10+ years of experience in technology/software development and delivery, with a strong focus on databases, data warehouses, and analytics platforms.

Prior experience in the Financial Services industry or other highly regulated, data intensive domains preferred.

Strong communication and stakeholder collaboration

Analytical thinking and problem-solving

Ability to work independently and deliver under tight timelines

Data Warehouse & Data Modeling expertise (OLAP, star/snowflake)

Strong Python and SQL development skills

Experience with distributed databases (Vertica / similar OLAP systems)

10+ years of hands on experience in database design, data modeling, and data engineering within large scale data warehouse or analytics environments.

Strong OLAP expertise, including hands on experience with modern analytical databases such as SingleStore, ClickHouse, or similar distributed OLAP platforms.

Deep understanding of data warehouse architecture, analytical data modeling (star/snowflake), and performance optimization techniques.

Expert level SQL skills, including writing and optimizing complex queries on large, high volume datasets.

Python is a must: strong experience using Python for data pipelines, automation, data processing, and backend services.

Solid experience with ETL/ELT tools and frameworks (e.g., Informatica or equivalent modern solutions).

Experience with Unix/Linux environments and shell scripting.

Strong knowledge of database performance tuning, monitoring, and troubleshooting.

Strong analytical, consultative, and communication skills, with the ability to collaborate effectively with both technical and business teams.

Proven ability to work independently and as a team player to deliver high impact results under demanding timelines.

Experience with MCP (Managed Control Plane / MCP based) services.

Experience with cloud native data platforms and managed database services.

Prior experience with scheduling tools such as Autosys.

Experience across the full DW/BI development lifecycle in at least one mission critical environment.

Familiarity with SDLC tools such as JIRA, Bitbucket, Ansible, Jenkins.

Hands on experience with BI and analytics tools such as Tableau, Alteryx, or equivalent platforms.

Experience in real time or near real time analytics systems.

Technical:

Data Warehouse

Python

SQL

IBM IFW (Information Framework), BDW (Banking Data Warehouse).

Why Should You Apply?

Health Benefits

Referral Program

Excellent growth and advancement opportunities

Similar Jobs

Oracle Fusion Supply Chain SME

ZOLL MEDICAL CORPORATION • Chelmsford, MA • 15min ago

IT & Engineering

Acute Care TechnologyThe Oracle Supply Chain SME is a key member of the IT Business Applications team, responsible for the design and support of Oracle Fusion Supply Chain modules. Oracle Fusion SCM SME is responsible fo...

15min ago

Go to Apply

Principal Solution Architect - Supply Chain Planning

Vertiv Corporation • Westerville, OH • 17min ago

IT & Engineering

Job Description Job Summary Vertiv is transforming and digitizing supply chain capabilities by re-engineering business processes and implementing advanced technologies/systems that powers world-class operations, customer...

17min ago

Go to Apply

Technician I Staging - Supply Chain

Catalent • Madison, WI • 19min ago

IT & Engineering

Technician I Staging - Supply Chain Position Summary: Work Schedule: Sunday - Wednesday, 2pm-12am 100% on-site (Madison, WI) Catalent, Inc. is a leading global Contract Development and Manufacturing Organization (CDMO)....

19min ago

Go to Apply

Supply Chain Technician

HCA Healthcare • Gainesville, FL • 20min ago

IT & Engineering

Do you want to join an organization that invests in you as a Supply Chain Technician? At HCA Florida North Florida Hospital, you come first. HCA Healthcare has committed up to $300 million in programs to support our incr...

20min ago

Go to Apply

Lead Software Engineer, Supply Chain Engineering

Chick-fil-A • Atlanta, GA • 21min ago

IT & Engineering

How We Work At Chick-fil-A Chick-fil-A, Inc. ('Chick-fil-A' or 'the Company') Staff members play a vital role in achieving our strategic goals by developing their skills, fostering inclusive teamwork, and embracing innov...

21min ago

Go to Apply

Pump Assembly Tech I

IDEX • West Jordan, UT • 22min ago

IT & Engineering

If you're looking for a special place to build or grow your career, you've found it. Whether you're an experienced professional, a recent college graduate or somewhere in between, IDEX is a place where you can apply your...

22min ago

Go to Apply

Materials Technician (Full-Time / Days)

Texas Health Resources • Dallas, TX • 23min ago

IT & Engineering

Materials Technician (Full-Time / Days) Bring your passion to Texas Health so we are Better + Together Work location: Texas Health Dallas, 8200 Walnut Hill Lane, Dallas, TX 75231 Work hours: Full-Time, Days, 40 hours, 8:...

23min ago

Go to Apply

Quality Engineer

Belcan • Indianapolis, IN • 25min ago

IT & Engineering

Quality Engineer Job Number: 364694 Category: -MFG & Supply Chain SBU Description: Job Title: Quality Engineer Pay Rate: $35.00-42.00/hour Location: Indianapolis, IN 46217 Area Code: 317 Shift: 1st Employment Type: D...

25min ago

Go to Apply

DevSecOps Engineer

SAIC • North Charleston, SC • 28min ago

IT & Engineering

Description ? SAIC is seeking DevSecOps Engineer to join our team. The DevSecOps Engineer can work at one of the following SAIC locations: San Diego, CA, Charleston, SC, or Panama City, FL. Role Overview: Role: Platform...

28min ago

Go to Apply

DevSecOps Engineer

SAIC • Arlington, VA • 29min ago

IT & Engineering

29min ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)