Tri-Force Consulting Services Inc. | IT Recruitment & Staffing Agency

ETL Developer/Data Warehouse Architect

Tri-Force Consulting Services Inc. | IT Recruitment & Staffing Agency  •  Albany, NY (Hybrid)  •  3 months ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description


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 110 State Street in Albany, NY 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 Tableauvisualizations; and


  • Experience using ETL techniques to support a data analytics program for a government entity.


If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction,
enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then
we would like to hear from you. We need exceptionally capable people for this role for our client,
so get back to us and tell us why you think you are a fit.

About Us:
Since 2000, Tri-Force Consulting Services (
https://triforce-inc.com
) 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.
Tri-Force Consulting Services Inc. | IT Recruitment & Staffing Agency

About Tri-Force Consulting Services Inc. | IT Recruitment & Staffing Agency

Tri-Force Consulting Services, Inc. - Pioneering IT Solutions in the Philadelphia Region

Website: https://triforce-inc.com

Schedule a Meeting: https://triforce-inc.com/request-meeting/

Since its establishment in 2000, Tri-Force Consulting Services, Inc. has emerged as a leading MBE/SDB-certified IT consulting firm in the Philadelphia region. Our unwavering commitment to delivering innovative, cost-effective solutions has propelled us to the forefront of the industry, enabling us to serve a diverse clientele across both government and commercial sectors.

Our Services

1. IT Staffing Solutions

Tri-Force specializes in providing tailored IT staffing solutions that include:

Contract Staffing

Contract-to-Hire

Full-time Placement

Our staffing services are designed to connect businesses with top-tier IT talent, ensuring they have the right expertise to drive their projects forward.

2. Software Development

We excel in developing robust software solutions that cater to a variety of needs:

Web Applications

Mobile Applications

Our team of experienced developers leverages the latest technologies to create high-performance, scalable, and secure applications that meet our clients' unique requirements.

3. Systems Integration

Our systems integration services ensure seamless connectivity and functionality across various IT systems. We help businesses streamline operations and improve efficiency by integrating disparate systems into a cohesive IT environment.

4. Data Analytics

Tri-Force offers comprehensive data analytics services to help organizations make data-driven decisions. Our expertise includes data mining, predictive analytics, and business intelligence, enabling our clients to unlock valuable insights and drive strategic initiatives.

5. System Automation

We provide system automation solutions that enhance productivity and efficiency. Automating repetitive tasks and processes, we help businesses reduce operational costs and improve overall performance.

Industry
IT & Software
Company Size
51-200 employees
Headquarters
Lansdale, PA
Year Founded
2000
Website
triforce-inc.com
Social Media