IT Specialist

i-Link Solutions; New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

i-Link Solutions is seeking an IT Specialist - Expert to guide data migration, design scalable data warehouse workflows, and improve data integration across enterprise systems.

The role emphasizes ETL/ELT optimization, data governance, and automation using Python, R, and VBA, with emphasis on Tableau dashboards and collaboration with business and tech teams.

Qualifications

• 1+ 84 months of experience in data engineering, architecture, governance, or data quality for financial reporting.
• 18+ 84 months overall experience in SQL and relational databases (RDBMS).
• 3+ 84 months of compiling, computing, and validating financial data using advanced formulas and models.
• 4+ 48 months building and maintaining data workflows and pipelines from business requirements.
• 3+6 36 months automating data ingestion and reporting using Python, R, or Excel VBA.
• 3+6 36 months data visualization using BI tools, prefer Tableau.
• 2+24 months cloud-based data platforms, preferably Snowflake.
• Bachelor's degree in a quantitative discipline (CS, stats, finance, or related).

Responsibilities

• Guide the migration of enterprise data processing and ETL workflows to Snowflake and Informatica platforms.

Job description

Client: State of NY

Agency: Department of Financial Services

Job Title: IT Specialist - Expert

Task ID: HBITS-08-14978

Position Duration: 30 Months

Client: State of NY

Agency: Department of Financial Services

Description

• Guide the migration of enterprise data processing and ETL workflows to Snowflake and Informatica platforms.
• Design, implement, and maintain scalable data warehouse workflows.
• Develop and optimize ETL/ELT processes to improve data integration, performance, and reliability.
• Perform data validation, reconciliation, and quality assurance to ensure the accuracy, completeness, and integrity of enterprise data.
• Establish, implement, and monitor data governance standards, data quality controls, and compliance with organizational policies and regulatory requirements.
• Develop automation solutions and reusable data processing tools using Python, R, and VBA to improve operational efficiency and reduce manual effort.
• Design, develop, and maintain complex scripts, stored procedures, and workflows supporting enterprise reporting and analytics.
• Analyze, troubleshoot, and resolve complex data integration, transformation, and performance issues across multiple systems.
• Collaborate with business and technology teams to translate business requirements into technical solutions, and to understand Client's cloud data architecture, data integration strategies, and best practices.
• Develop and maintain technical documentation, including data flow diagrams, process documentation, data dictionaries, and system specifications.
• Evaluate emerging technologies and recommend enhancements that improve the organization's data management capabilities, security, scalability, and operational efficiency.
• Creates and maintains interactive Tableau dashboards for scalability, manageability, extensibility, performance, and re-use;
• Works with team members to create useful reports and dashboards that provide insight, improve/automate processes, or otherwise add value to the team;
• Supports the R&I Data Steward in administering the data stewardship program and coordination with various data users and data owners.

Mandatory Qualifications

• 1 84 Months of Experience in Data Engineering, Architecture, Data Governance, or Data Quality Assurance for Financial Reporting.
• 2 84 Months of Experience in SQL and Relational Database Management Systems (RDBMS), including querying complex datasets.
• 3 84 Months of Experience in Compiling, Computing, and Validating Financial Data using advanced statistical formulas and model calculations.
• 4 48 Months of Experience in Building and Maintaining Data Workflows and data pipelines using database tools, specifically translating business requirements into technical specifications.
• 5 36 Months of Experience in Automating Data Ingestion and Reporting using programming languages such as Python, R, or Excel VBA.
• 6 36 Months of Experience in Data Visualization utilizing Business Intelligence software, preferably Tableau.
• 7 24 Months of Experience in cloud based data platforms, preferably Snowflake.
• 8 Bachelor's Degree in a quantitative discipline (Computer Science, Statistics, Finance, or related field).

Required Documentation

• Résumé
• Copy of Candidate Identification

(i.e., Driver's License/Green Card/Visa and Passport if applicable)

• Any documents referenced in the above Requested Qualifications

(i.e., professional certifications, degrees, etc.)

i-Link Solutions requires a Bachelor's Degree or its equivalent in Computer Science, Computer Information Systems, Information Systems or a closely related field of study for all positions.

i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability