Jobs via Dice
Enterprise Data Warehouse Consultant
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Brandon Consulting, is seeking an experienced consultant to drive enterprise data warehousing initiatives. Apply via Dice today!
The client's Enterprise Data Warehouse consolidates and retires multiple legacy data marts to eliminate duplication, establishing a single source of truth that increases BI efficiency and reduces maintenance costs. The hired consultant will focus on creating dashboards to facilitate claims/underwriting predictions. The consultant will operationalize prediction models created by data scientists, implement an enterprise data catalog, maintain full data lineage, and integrate financial transactions, cash flows, external auditors' requests, and accounting reporting into the NYSIF Enterprise Data Warehouse. The consultant will also recommend best practices and procedures for data marts and data warehouses.
Responsibilities
Provide recommendations, guidance, and actual implementation for new data marts, as well as improving and consolidating existing data marts.
Participate and contribute to DW/BI projects throughout the project lifecycle.
Establish written best practices, procedures, and provide guidance on DW/DM data model design.
Create and maintain up‑to‑date documentation for all supported DW/DM and ETL.
Plan, create, modify, maintain, test, and implement code for source system extraction processes, ETL processes, BI dashboards and reports.
Develop and maintain Spotfire systems, including prediction models and automation services.
Automate source system data extraction processes and load into the Data Warehouse.
Operationalize prediction models.
Adhere to NYSIF's application development standards, including project management methodology, SDLC, Enterprise Architecture standards, and IT governance process.
Support the BI Data Warehouse using TIBCO Spotfire and Information Builders software Data Migrator.
Qualifications
72+ months experience in data modeling for underwriting, claims data marts, and data warehouses in insurance (workers' compensation and disability).
72+ months experience developing and maintaining predictive systems in R or Python using TIBCO Spotfire/TERR.
72+ months experience with TIBCO Spotfire Analyst, Web Player, Business Authors, using IronPython, R, and JavaScript.
72+ months experience developing, documenting, and maintaining end‑to‑end ETL data pipelines (Information Builder International "IBI" Data Migrator).
72+ months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, advanced query optimization, database design, and implementation.
72+ months experience with Agile/scrum project management methodology.
72+ months experience in automated testing, building, and deployment tools (TFS, PowerShell, Visual Build Pro).
72+ months experience with development tools such as VS Code, Visual Studio, Git, Azure, and TFS.
72+ months experience developing systems in workers' compensation, insurance for WC, DBL, PFL, PBM accounting, and financial reporting using Western and Eastern methods.
Bachelor's degree required.
Required Documentation
Copy of candidate identification (i.e., Driver’s License / Visa and Passport if applicable).
Any documents referenced in the above qualifications (professional certifications, degrees, etc.).
Brandon Consulting Associates, Inc. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 29 years.
#J-18808-Ljbffr
The client's Enterprise Data Warehouse consolidates and retires multiple legacy data marts to eliminate duplication, establishing a single source of truth that increases BI efficiency and reduces maintenance costs. The hired consultant will focus on creating dashboards to facilitate claims/underwriting predictions. The consultant will operationalize prediction models created by data scientists, implement an enterprise data catalog, maintain full data lineage, and integrate financial transactions, cash flows, external auditors' requests, and accounting reporting into the NYSIF Enterprise Data Warehouse. The consultant will also recommend best practices and procedures for data marts and data warehouses.
Responsibilities
Provide recommendations, guidance, and actual implementation for new data marts, as well as improving and consolidating existing data marts.
Participate and contribute to DW/BI projects throughout the project lifecycle.
Establish written best practices, procedures, and provide guidance on DW/DM data model design.
Create and maintain up‑to‑date documentation for all supported DW/DM and ETL.
Plan, create, modify, maintain, test, and implement code for source system extraction processes, ETL processes, BI dashboards and reports.
Develop and maintain Spotfire systems, including prediction models and automation services.
Automate source system data extraction processes and load into the Data Warehouse.
Operationalize prediction models.
Adhere to NYSIF's application development standards, including project management methodology, SDLC, Enterprise Architecture standards, and IT governance process.
Support the BI Data Warehouse using TIBCO Spotfire and Information Builders software Data Migrator.
Qualifications
72+ months experience in data modeling for underwriting, claims data marts, and data warehouses in insurance (workers' compensation and disability).
72+ months experience developing and maintaining predictive systems in R or Python using TIBCO Spotfire/TERR.
72+ months experience with TIBCO Spotfire Analyst, Web Player, Business Authors, using IronPython, R, and JavaScript.
72+ months experience developing, documenting, and maintaining end‑to‑end ETL data pipelines (Information Builder International "IBI" Data Migrator).
72+ months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, advanced query optimization, database design, and implementation.
72+ months experience with Agile/scrum project management methodology.
72+ months experience in automated testing, building, and deployment tools (TFS, PowerShell, Visual Build Pro).
72+ months experience with development tools such as VS Code, Visual Studio, Git, Azure, and TFS.
72+ months experience developing systems in workers' compensation, insurance for WC, DBL, PFL, PBM accounting, and financial reporting using Western and Eastern methods.
Bachelor's degree required.
Required Documentation
Copy of candidate identification (i.e., Driver’s License / Visa and Passport if applicable).
Any documents referenced in the above qualifications (professional certifications, degrees, etc.).
Brandon Consulting Associates, Inc. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 29 years.
#J-18808-Ljbffr