ETL Developer/Data Warehouse Architect

Hybrid in Albany, NY, US • Posted 7 hours ago • Updated 7 hours ago

Contract Independent

Contract Corp To Corp

Hybrid

$60 - $70/hr

Tri-Force Consulting Services Inc

Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

Data Modeling
Data Validation
Extract
Transform
Load
Informatica
Migration
OBIEE
PL/SQL
Python
SQL
Tableau
Unstructured Data
Qlik

Summary

Job Title: Extract Transform Load Developer/Data Warehouse Architect

Location: 110 State Street, Albany, NY 12236 - Albany

Duration: 5 Years.

Note: (Hybrid Role) Work on-site at least one week per calendar year as directed by OSC; and report directly to the manager of Data Analytics & First New York or their designee.

OSC will provide the Consultant with all necessary IT equipment.

Work a 40-hour workweek during regular OSC business hours, between 8:00 a.m. And 5:00 p.m. ET Monday through Friday, excluding  State holidays.

Job Description:

The Consultant will collaborate with the Data Analytics & First New York units within the Office of the State Comptroller (OSC) to enhance the current data infrastructure and analytics environment. Key responsibilities include reviewing and analyzing existing ETL processes, designing data systems for both structured and unstructured data, and assisting in the implementation of data analytics architecture. The Consultant will be involved in migrating ETL environments, developing fact and dimensional models, and implementing data processes for newly acquired datasets. Additionally, the Consultant will assist in the design of Tableau/OBIEE dashboards and support data exchanges with external entities.

Minimum Qualifications:

Bachelor s degree (or equivalent) in Computer Science or related field.
4+ years of experience in ETL development, data modeling, and SQL.
Proficiency with ETL tools (e.g., Qlik, Informatica) and data analytics systems.

Preferred Qualifications:

Experience with Python, Tableau Server, and government data analytics.
Background in data validation, troubleshooting, and business requirements gathering.
Language/Structured Query Language ( PL/SQL );
Experience developing a data analytics ETL environment to support Tableau visualizations; and
Experience using ETL techniques to support a data analytics program for a government entity.

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: 10115907
Position Id: 8900889
Posted 7 hours ago

Company Info

About Tri-Force Consulting Services Inc

Since 2000, Tri-Force Consulting Services has been an MBE/SDB certified IT consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.