Data Solution Architect and Modeler - job id 33609


Your Way To Work™

Data Solution Architect and Modeler

Market $$$ - Per Hour w2

Windsor, CT



How to Apply

logo

Susan Andaluz


logo

(646) 876-9558


logo

(212) 616-4800 ext-240




A Try & Buy position at Major player in retirement finance.

Pay Options: OPEN-STRAIGHT HOURLY PAY

Contact Assigned To Be. call (212)616-4800 / (212)616-4800 or email sans-all@sans.com with the Job Code AT33609 or Click the Apply Now button ().

Location: Windsor, CT.

Skills required for the position: DATA MODELING, ORACLE, SNOWFLAKE SCHEMA , SQL, ETL.


Detailed Info: Fluent in the tools and techniques required to develop Business Intelligence and Data Analytics capabilities including the development of Reporting Dashboards and system Interface development.

Strong competencies in Data Base Analysis, design and programming as well as system conceptualization, design and specification techniques and skillsets.

Designing, deploying, reviewing, and maintaining conceptual, logical, and physical data models; including transactional, business intelligence, and data warehousing (star/snowflake schema) models

Keen ability to analyze and recommend enhancements to tune SQL and ETL components to support analytics work streams.

Ability to identify and capture data lineage, re-engineer poorly performing ETL, and profile outcomes along with documentation and approach impacting short term and long term recommendations.

Strong background in multiplatform data architecture implementations.

Organize and oversee the integration of data and migration activities.

Familiar with using ER Studio to build and deploy models.

Leading a team of data engineers, data modelers, Business Analysts, and Data Analysts

Direct interface to a variety of business leaders


Development/Computing Environment: Databases: Oracle Database, SQL Server, DB2, HiveQL, Oracle, MS Access, IMS

Tools/IDEs: ER Studio/ErWin, SQL Server 2014 (SSMS, SSIS, SSAS, SSRS), Visual Studio, Business Objects, SQL Workbench

BI Software: Tableau, Cognos Analytics, Power BI, etc.

Platforms: Windows, IBM OS/MVS, UNIX, IBM OS/390

Techniques: Cataloguing and data lineage, reverse engineering data sources, data profiling and development of future state data architectures.

Knowledge & Experience:


At least 10 years of IT experience

Ability to research, reproduce, troubleshoot, and solve challenging technical issues

Ability to communicate technical concepts clearly and effectively

Ability and willingness to learn new technologies

Ability to work in agile environment and fill different roles within the team

Self-motivated with ability to multi-task and work under minimal supervision.

The position offers competitive rate for a contract and an opportunity for full scale compensation package for F/T empoyee position.


Job Id: 33609