Software Architect Expert

---

Job description

New York State Insurance Fund(NYSIF) is seeking a Software Architect Expert

Day to Day task include:

Provide recommendations, guidance, and actual implementation for new data marts, as well as improving and consolidating existing Data marts.

Participate and contribute to data warehouse projects throughout the project lifecycle.

Establish written best practices, procedures and generally provide guidance on data modeling design.

Create and maintain up-to-date documentation for all supported DW/DM, ET.

Plan, create, modify, maintain, test and implement code in support of any of the following:

Source System extraction processes for the Data Warehouse.

ETL processes.

BI Dashboards and reports. (R, Python)

Develop and maintain Spotfire systems (including prediction models written in R, TERR and automation services)

Automation of source system data extraction processes and data loading of the Data Warehouse.

Operationalize prediction models.

Adhere to NYSIF's application development standards, including, but not limited to, project management methodology, SDLC (software development life cycle), Enterprise Architecture standards and the IT governance process. Support the BI Data Warehouse using TIBCO Spotfire, IBI/Tibco Data Migrator

Requested Qualifications:

84 months Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in Insurance industry

84 months experience with designing and implementing ML, Predictive and AI systems.

84 months experience with TIBCO Spotfire Analyst, Web Player using Iron Python, Java Scripts, and R

84 months experience in developing, documenting, maintaining end to end ETL data pipeline using IBI Data Migrator (or similar tools)

24 months experience in developing data warehouse in Workers' Compensation Insurance industry (Medical Billing, Claims, DBL, PFL, Underwriting, Premium and payroll)

84 months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation.

48 months experience in implementing data governance programs including solid knowledge of (data management, data quality, and data lineage )

Work hours and location:

Full time role with engagement length of 30 months

Daily work hours: 8:30 AM to 5 PM

Physical office location: 199 Church street, New York, NY 10007

Telecommuting options: Negotiable

Spruce Technology, Inc. is a mid-size, award-winning (Inc 5000, SmartCEO, Entrepreneur of the Year) technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing.

Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process.

All full-time employees are eligible for the following benefits:

Medical, dental, vision health benefits

Life Insurance and AD&D (paid by company)

401k, Flexible and Dependent Care Spending Account plans.

Paid-time Off or Paid Sick Leave (amount dependent on position level and if required by state).

<!– job description page –>