Senior Data Warehouse Developer

Iconma

Jersey City, NJ

JOB DETAILS
SALARY
$15.49–$68.25 Per Hour
SKILLS
Analysis Skills, Ansible, Architectural Analysis, Architectural Design, Atlassian JIRA, Automation, Banking Services, Best Practices, Business Intelligence, Business Operations, CA Workload Automation AE (AutoSys Edition), Cloud Computing, Code Reviews, Communication Skills, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Customer Relations, Data Analysis, Data Management, Data Mart, Data Modeling, Data Partitioning, Data Processing, Data Quality, Data Sets, Data Warehousing, Database Administration, Database Analysis, Database Design, Database Extract Transform and Load (ETL), Debugging Skills, Distributed Databases, Distribution Channel, Documentation, Financial Services, Health Plan, IBM Product Family, Identify Issues, Informatica, Information Technology & Information Systems, Jenkins, Linux Operating System, MCP - Microsoft Certified Professional, Metadata, OLAP (OnLine Analytical Processing), Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Product Lifecycle, Python Programming/Scripting Language, Quality Management, Quality Metrics, Query Optimization, Requirements Management, SQL (Structured Query Language), Snowflake Schema, Software Development, Software Development Lifecycle (SDLC), Source Code/Configuration Management (SCM), Star Schema, Tableau, Team Player, Test Automation, Test Strategy, Unix Operating Systems, Unix Shell Programming, Use Cases, Validation Testing
LOCATION
Jersey City, NJ
POSTED
3 days 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?

About the Company

I

Iconma

ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.

  • Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
  • Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
  • Founded in 2000
  • 2000+ Employees

The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.

COMPANY SIZE
2,000 to 2,499 employees
INDUSTRY
Management Consulting Services
EMPLOYEE BENEFITS
401K, Employee Referral Program, Life Insurance
FOUNDED
2000
WEBSITE
https://www.iconma.com/