Job Title: IT Specialist - Expert Task ID: HBITS-08-14978 Position Duration: 30 Months Client: State of NY Agency: Department of Financial Services Please call
(703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at
[email protected] 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 • Resume
• 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.
