Senior Data Warehouse Consultant

Albany, NY, US • Posted 15 hours ago • Updated 15 hours ago
Contract W2
30 Months
Travel Required
On-site
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

  • Data Warehouse
  • ELT
  • Extract, Transform, Load

Summary

Position Overview

We are seeking a highly experienced Senior Data Warehouse Consultant to support Company. The ideal candidate will have strong expertise in enterprise data warehousing, ETL/ELT development, SQL-based data integration, database modernization, and business intelligence solutions. The consultant will work closely with business stakeholders, State Agency teams, and technical resources to design, develop, and implement scalable data solutions that support critical business operations and reporting needs.

Required Qualifications

  • 7+ years of experience working with State Agency/business subject matter experts, ITS teams, and COTS vendors to analyze requirements and design enterprise data warehouse, application integration, and master data management solutions.
  • 7+ years of experience designing, developing, and implementing enterprise data warehouse solutions, including data modeling, ETL/ELT processes, automated data ingestion, data transformation workflows, workflow orchestration, and scheduling.
  • 7+ years of hands-on experience developing data integration and business intelligence solutions using SQL in State Agency environments.
  • 6+ years of experience conducting database comparative analysis for new transactional databases, data warehouses, and modernization of existing database environments.
  • 5+ years of experience applying analytical reasoning, data interpretation, and problem-solving techniques to support business objectives.
  • 3+ years of experience implementing automated process controls, including error handling, logging, monitoring, and recovery mechanisms.
  • 3+ years of experience working in enterprise environments and collaborating with business analysts, developers, architects, and other cross-functional teams.

Key Responsibilities

  • Gather and analyze business and technical requirements from stakeholders.
  • Design and implement enterprise data warehouse architectures and data integration solutions.
  • Develop and optimize ETL/ELT processes and automated workflows.
  • Build and maintain SQL-based data integration and reporting solutions.
  • Evaluate and modernize existing database and data warehouse environments.
  • Implement monitoring, logging, and recovery processes to ensure data reliability and system performance.
  • Collaborate with technical and business teams to deliver scalable, high-quality data solutions.
  • Prepare technical documentation, data models, and architectural artifacts.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10109859
  • Position Id: 8988124
  • Posted 15 hours ago

Company Info

About Neotecra, Inc

Neotecra is a leading provider of staffing, consulting, and solutions in the disciplines of information technology, engineering, administrative, finance and accounting. We give our clients the power to address their challenges and gain a competitive edge in the global market.

Our client base includes a wide spectrum of companies ranging from small start up companies to Fortune 1000 industry leaders. We develop a strong relationship with our clients and are committed to provide the highest level of customer satisfaction.

Leadership

Neotecra was founded by an experienced group of professionals based in the U.S and India with diverse and wide ranging experience in the areas of finance, project management, software architecture & development and human resource management. The leadership group is small, tight-knit and focused on attaining client objectives.

Team

Our constantly expanding team consists of talented professionals with experience gained from developing and delivering client focused solutions. We have formed our team with deliberate care so that as a client, you get what you see. Our skills cover a variety of hardware, software and operating environments and are constantly upgraded to meet the latest challenges in technology. Our consultants embed a balanced combination of technical, analytical and communication skills. We lay great stress on ongoing professional development and utilize a number of tools to hone our skills.

Capabilities

Neotecra is committed to providing innovative software solutions to its clients and recognizes the importance of technology. Our seasoned software professionals have expertise in a wide range of technologies including:

  • Cyber security
  • Cloud
  • Business Intelligence
  • Data Analytics
  • Mobile/ Web Development
  • AI and Machine Learning

Services include on-site and off-site development, project consultancy, requirements gathering and system architecture. We undertake long-term projects on a contract basis with reputable clients. Our goal is to clearly understand our client's need and provide them with real and lasting solutions that meet and exceed their expectations.

Our Commitment

At Neotecra, we understand that delivering client-focused solutions involves not only development of the optimal solution using the most appropriate tools and technologies but also implementation of the solutions developed in the client environment. Given the fact that product and project life cycles are constantly growing shorter, we understand that setting and meeting aggressive implementation schedules is a must for realizing planned payoffs for projects. Further, maintaining the highest standards of quality is a prerequisite for avoiding time and cost overruns. We are committed to devote all resources towards meeting your targets. We spend considerable time in the planning and design stages and then provide appropriate resources to the engagement.

Contact the job poster
HK

Hema Katkuir

Recruiter @ Neotecra, Inc
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

It looks like there aren't any Similar Jobs for this job yet.

Search all similar jobs