Data Modelling Architect

Job Title:
Data Modelling Architect – Job
-07-14522

Location:

Albany, NY 12205 – Hybrid
Duration: 30 Months

Experience: 12+ Years (Passport Copy Mandatory)

• 72 months of experience in data modelling for underwriting and claims data marts and enterprise data warehouses within the insurance industry
• 72 months of experience developing and maintaining predictive systems using R or Python with TIBCO Spotfire
• 72 months of experience using TIBCO Spotfire Analyst, Web Player, and Business Author with Iron Python, R, and Java Script
• 72 months of experience designing, documenting, and maintaining ETL pipelines using IBI Data Migrator
• 72 months of experience in Oracle PL/SQL development, including stored procedures, triggers, and performance tuning
• 72 months of experience working in Agile/Scrum environments
• 72 months of experience with automated testing, build, and deployment tools such as TFS, Power Shell, and Visual Build Pro
• 72 months of experience with development tools including Visual Studio, Visual Studio Code, Git, Azure, and TFS
• 72 months of experience in workers’ compensation, disability benefits, insurance systems, and financial reporting
• Bachelor’s Degree

• Provide recommendations, guidance, and hands‑on implementation for new and existing data marts
• Participate in all phases of data warehouse and business intelligence project life cycles
• Establish and document best practices and standards for data modelling and architecture
• Create and maintain documentation for data warehouses, data marts, and ETL processes
• Design, develop, test, and maintain source system extraction processes
• Develop and maintain ETL pipelines and BI dashboards
• Build and support Spotfire analytics, prediction models, and automation services
• Automate data extraction and loading processes into the enterprise data warehouse
• Operationalize predictive models developed by data science teams
• Adhere to NYSIF standards for SDLC, project management, enterprise architecture, and IT governance

• Resume
• Copy of Candidate Identification (Driver’s License, Visa, or Passport as applicable)
• Supporting documents for qualifications such as certifications or degrees