Data Warehouse Systems Architect

ZipRecruiter; City of Albany (NY); Remote; USD 125,000 - 150,000; Full time

Job summary

A reputable staffing agency is seeking a Data Warehouse Systems Architect based in Albany, NY. The ideal candidate will have over 84 months of experience in systems architecture and data warehouse solutions. They will provide recommendations and implement data marts, along with establishing best practices for ETL processes. The position is remote and offers a competitive rate of $65 on CTC.

Qualifications

• 84+ months of experience as a Systems Architect.
• Designed and implemented data warehouse solutions.
• Experience with predictive systems development.

Responsibilities

• Provide guidance for new data marts implementation.
• Contribute to DW/BI projects throughout their lifecycle.
• Establish best practices for data model design.

Skills

Data Mart implementation

ETL processes

Data Modeling

Oracle PL/SQL

R and Python programming

Information Builders Software

Tools

WebFOCUS

TIBCO Spotfire Analyst

ERwin

Job description

Overview

Role: Data Warehouse Systems Architect

Location: Albany, NY (Remote)

Duration: 06 Months Plus

Visa: Any visa except OPT & CPT. (As per EC requirement)

End Client: Confidential till resume selection

Rate: $65 on CTC.

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 generally provide guidance on DW/DM data model 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: Source system extraction processes for the Data Warehouse; ETL processes; BI dashboards and reports (R, Python).
• Extract business rules from existing Data Warehouse built with Information Builders software toolset: WebFOCUS, RSTAT, Data Migrator, and PMF.

Mandatory Qualifications

• Expert 84+ Months: Systems Architect - defines the architecture of a computerized system and provides guidance to large teams with extensive industry experience.
• 84-month experience in designing and implementing data warehouse solutions supporting statutory accounting/reporting, premium analysis for worker’s compensation and insurance industry.

Requested Qualifications

• 84-month experience in designing and implementing transactional systems supporting billing, collection, policy administration, and premium calculation for worker’s compensation and insurance industry.
• 84-months Data Modeling experience in designing and creating Data Mart/Data warehouse using Star & Snowflake Schemas in workers compensation Insurance and experience with ERwin.
• 84-months experience with developing and maintaining predictive systems written in R and Python using TIBCO TERR and Automation services.
• 84-months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Iron Python, JavaScript.
• 84-months experience with Information Builders Software Toolset [WebFOCUS, iWay WebFOCUS Developer Studio, Data Migrator, and RSTAT].
• 84-months experience in developing, documenting, and maintaining end-to-end ETL data pipeline using IBI Data Migrator.
• 84-months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation.
• 48-month experience in Active Batch and Visual Build Pro.
• 48-month experience with Innotas.

Notes

• Candidate with valid LinkedIn ID & Genuine references will have a strong point to get an interview.
• Please share your resume if above requirement match with you.
• Independent Consultants Only (as by EC).
• Mention your visa status & current location in the email.

Kind Regards

Mustafa Fouzan

Resource Manager

Resource Informatics Group, Inc (RIG) 400 E Royal Ln, Suite 218, Irving, TX 75039

Email: [e-mail] | cell: 972-366-5085 | Fax: [phone](F)

www.RIGUSINC.com | E-Verified Company

Stay Safe Stay Indoors Break the Viral Chain