Data Architect - PP Copy Mandatory
Albany, NY, US • Posted 1 day ago • Updated 1 day agoFull Time
No Travel Required
On-site
$60 - $80/hr
Bits & Bytes Technology Solutions
Fitment
Dice Job Match Score™
📋 Comparing job requirements...
Job Details
Skills
- Accounting
- Dialog Manager
- Dimensional Modeling
- Documentation
- Data Governance
- Data Marts
- Data Warehouse
- Business Intelligence
- Compensation Management
- Performance Management
- Predictive Modelling
- Modeling
- Neo4j
- Oracle
- PL/SQL
- Microsoft SQL Server
- Microsoft Visual Studio
- Microsoft Windows
- Knowledge Transfer
- Linux
- Microsoft Azure
- Finance
- Git
- Insurance
- JavaScript
- Jupyter
- Underwriting
- Warehouse
- Reporting
- Project Management
- Query Optimization
- SAS Display Manager
- FOCUS
- Microsoft TFS
- Preventive Maintenance
- Dashboard
- Database
- Extract, Transform, Load
- Extraction
- Python
- Scripting
- Stored Procedures
- TIBCO Software
- TIBCO Spotfire
- Windows PowerShell
Summary
Title : Senior Data Architect
Location : Albany, NY ( Onsite )
Client : State of New York
Location : Albany, NY ( Onsite )
Client : State of New York
Job Description: Systems Architect (Senior)
Overview
- Agency: New York State Insurance Fund (NYSIF).
- Position Title: Systems Architect.
- Skill Level: Senior (60–84 months of experience).
- Engagement Length: 30 Months.
- Work Schedule: Full-time, 40 hours per week.
- Daily Hours: 8:00 AM to 4:30 PM.
- Location: 15 Computer Drive West, Albany, NY 12205.
- Telecommuting: Allowed up to 50% (maximum 5 days every two weeks).
Position Summary
The Systems Architect will continue the development of the NYSIF Enterprise Data Warehouse. The primary goal is to consolidate and retire multiple legacy Data marts to eliminate duplication and establish a "single source of truth," thereby increasing efficiency and reducing maintenance costs.
Key Responsibilities
- Data Warehouse Development: Provide recommendations, guidance, and implementation for new and existing Data marts.
- Predictive Modeling: Operationalize prediction models created by data scientists and focus on creating dashboards for claims/underwriting predictions.
- ETL & Reporting: Plan, test, and implement code for source system extraction, ETL processes, and Business Intelligence (BI) dashboards.
- Data Governance: Implement an enterprise data catalog and full data lineage.
- Documentation: Establish written best practices, procedures, and up-to-date documentation for all supported DW/DM and ETL systems.
- Financial Integration: Assist in integrating financial transactions, cash flows, and accounting reporting into the Enterprise Data Warehouse.
- Knowledge Transfer: Provide written knowledge transfer as required during the engagement.
Technical Environment
- Software: TIBCO Spotfire (Analyst, Web Player, Business Authors), IBI Data Migrator, Python, Jupyter Notebook, Oracle, Neo4j, Microsoft SQL Server, and Microsoft Windows/Linux.
- Languages/Scripts: R, Python, Iron Python, JavaScript, and Oracle PL/SQL.
- Tools: VS Code, Visual Studio, Git, Azure, TFS, PowerShell, and Visual Build Pro.
Mandatory & Requested Qualifications
- Data Modeling: 72 months of experience in designing underwriting and claims DataMarts/Data Warehouses within the Insurance industry (specifically Workers’ Compensation and disability).
- Predictive Systems: 72 months of experience maintaining predictive systems written in R or Python using TIBCO Spotfire/TERR.
- ETL Pipeline: 72 months of experience with end-to-end ETL data pipelines using IBI Data Migrator (TIBCO Data Migrator).
- Database Development: 72 months of experience in Oracle PL/SQL development, including triggers, stored procedures, and query optimization.
- Industry Expertise: 72 months developing systems for workers' compensation and insurance accounting (WC, DBL, PFL, PBM).
- Education: Bachelor’s Degree.
Additional Information
- Interview Format: Webcasting; the candidate is required to be on camera.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10324752
- Position Id: 14580
- Posted 1 day ago
Company Info
About Bits & Bytes Technology Solutions
At Bits & Bytes, we believe IT and ITES to be a conduit for a better business environment, both for humanity at a macro level and financial sheets at a micro level.
Based on confidence and trust, we've built valuable long-term relationships with our customers. Our demonstrated performance in technology fields has fostered these relationships, as has our industry specific expertise, product knowledge, and proven consulting and project management methodologies for every consumer and engagement.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs