NYSIF HBITS-06-13685 Expert Software Architect (Data Modeling)

Voyatek - New York, NY

Full-time - Senior

New York, NY

About the position

The Expert Software Architect (Data Modeling) at Voyatek is responsible for providing recommendations, guidance, and implementation for data marts, as well as improving and consolidating existing data marts. This role involves participating in data warehouse projects throughout their lifecycle, establishing best practices for data modeling design, and maintaining documentation for data warehouse and data mart processes. The architect will also plan, create, modify, and implement code for data extraction processes, ETL processes, and BI dashboards, while adhering to NYSIF's application development standards.

Responsibilities

• Provide recommendations, guidance, and implementation for new data marts.
• Improve and consolidate existing data marts.
• Participate in data warehouse projects throughout the project lifecycle.
• Establish written best practices and procedures for data modeling design.
• Create and maintain documentation for all supported data warehouse and data mart processes.
• Plan, create, modify, maintain, test, and implement code for source system extraction processes.
• Develop and maintain BI dashboards and reports using R and Python.
• Automate source system data extraction processes and data loading into the data warehouse.
• Operationalize prediction models.

Requirements

• 84+ months of experience providing guidance to large teams or extensive industry experience in the field.
• 84 months of data modeling experience in designing and creating DataMarts and Data Warehouses using Star and Snowflake schemas in the insurance industry.
• 84 months of experience designing and implementing machine learning, predictive, and AI systems.
• 84 months of experience with TIBCO Spotfire Analyst and Web Player using Iron Python, Java Scripts, and R.
• 84 months of experience developing, documenting, and maintaining end-to-end ETL data pipelines using IBI Data Migrator or similar tools.
• 24 months of experience developing data warehouses in the Workers' Compensation Insurance industry.
• 84 months of experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization.
• 48 months of experience implementing data governance programs with knowledge of data management, data quality, and data lineage.
• Bachelor's Degree in Computer Science.
• Master's Degree in Computer Science or Data Science.

Benefits

• Competitive hourly wage range of $76.00 to $86.00 based on experience and qualifications.