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

Gcom Software - New York, NY

Full-time - Senior

New York, NY

Professional, Scientific, and Technical Services

About the position

The Expert Software Architect (Data Modeling) at Voyatek is responsible for providing guidance and implementation support for data marts and data warehouse projects, particularly within the insurance industry. This role involves establishing best practices for data modeling, maintaining documentation, and developing ETL processes and BI dashboards. The architect will also operationalize predictive models and ensure adherence to application development standards.

Responsibilities

• Provide recommendations and guidance for new data marts and improve existing ones.
• Participate in data warehouse projects throughout the project lifecycle.
• Establish best practices and procedures for data modeling design.
• Create and maintain documentation for data warehouse and data mart processes.
• Plan, create, modify, maintain, test, and implement code for data extraction processes, ETL processes, and BI dashboards.
• Develop and maintain Spotfire systems, including prediction models and automation services.
• Operationalize prediction models and automate data extraction processes.

Requirements

• 84+ months of experience providing guidance to large teams in the software architecture 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 ML, 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, 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 or related field.
• Master's Degree in Computer Science or Data Science.

Benefits

• Equal employment opportunities without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender, gender identity or expression, sexual orientation, marital status, religion, age, disability, genetic information, military service, or any other characteristic protected by law.