Software Architect - Gonzer Associates, L. J.
New York, NY
About the Job
L.J. Gonzer Associates is looking for individuals to join our pool of qualified candidates for potential assignment as a Software Architect. The Software Architect will perform the following tasks:
- 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, ETL.
- 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.
- Support the BI Data Warehouse using TIBCO Spotfire, IBI/Tibco Data Migrator.
- 7 years of Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in Insurance industry.
- 7 years of experience with designing and implementing ML, Predictive and AI systems.
- 7 years of experience with TIBCO Spotfire Analyst, Web Player using IronPython, Java Scripts, and R.
- 7 years of experience in developing, documenting, maintaining end to end ETL data pipeline using IBI Data Migrator (or similar tools).
- 2 years of experience in developing data warehouse in Workers' Compensation Insurance industry (Medical Billing, Claims, DBL, PFL, Underwriting, Premium and payroll).
- 7 years of experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation.
- 4 years of experience in implementing data governance programs including solid knowledge of (data management, data quality, and data lineage).
- Bachelor's Degree in Computer Science.
- Master's Degree in Computer Science or Data Science.
Source : Gonzer Associates, L. J.