IL
IT Specialist
i-Link Solutions Inc
🇺🇸 United States
On-site
2 days ago
- SQL
- Python
- VBA
- Oracle
- Data Visualization
- Tableau
- Business Objects
- Power BI
- SAS
- Excel
- Data Architecture
- Informatica
- Collibra
- Alation
- Snowflake
- Azure
2 days ago
Task ID: HBITS-08-15019
Position Duration: 30 Months
Client: State of NY
Agency: Department of Financial Services
Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018or email at nysreqs@ilinksolutions.com
Description
- Translate complex business requirements from data stakeholders into technical specifications for data pipelines and automated workflows.
- Build and maintain data warehousing workflows and data pipelines using SQL and cloud database tools.
- Compile, compute, analyze and validate data using advanced statistical formulas and model calculations.
- Elaborate high-level policies and business needs into technical requirements (user stories/system use cases) to guide platform implementation.
- Execute data profiling, build exception reports, and manage metadata/lineage using data platforms.
- Use programming language (Python/VBA/R) to automate data ingestion and reporting processes.
| 1 | 84 Months experience in Data warehousing, profiling, governance,modeling or data quality assurance for Financial Reporting. |
| 2 | 84 Months of Experience in SQL, Oracle and other Database Management Systems, including querying. Provide example(s) of independently problem solving and support to internal data stakeholders that resolved data issues in real time. |
| 3 | 84 Months of Experience with data visualization, dashboarding, using tools like Tableau, Business Objects, Power BI. |
| 4 | 84 Months of Experience in automating data tasks like ingestion, mapping, reporting, testing, validation, analysis, using programming languages such as SAS, Python, R, or Excel VBA. |
| 5 | 84 Months of Experience in providing governance, and technical support. Liaise with data vendors/solution providers, internal stakeholders, other technology teams (Data Architecture, Project Management team) to support data strategy and initiatives. Translate business requirements into technical specifications. |
| 6 | 84 Months of Experience with Data Cataloging Platforms (e.g., Informatica, Collibra, Alation) to execute data profiling, data quality, data mapping and manage lineage. |
| 7 | 84 Months of experience in writing documentation to capture requirements and logic, and encourage adoption of data catalog, data quality and data management processes and other data related initiatives (i.e., data platform/integration solutions). |
| 8 | 36 Months of Experience in cloud based data platforms, like Snowflake or Azure |
| 9 | Bachelor's Degree |
| 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.
Disclaimer: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
IT Specialist · i-Link Solutions Inc