Data Modeler \ Architect - job id 32097


Your Way To Work™

Data Modeler \ Architect

$108 - Per Hour IC - Self Incorporated or $96 w2

Midtown



How to Apply

logo

Jason Vu


logo

(646) 876-9536


logo

(212) 616-4800 ext-290




A Contract position at a global financial services firm.

Pay Options: IC - Self Incorporated or w2.

Contact Jason Vu. call (646) 876-9536 / (212) 616-4800 ext.290 or email jason@sans.com with the Job Code JV32097 or Click the Apply Now button ().

Location: Wall St..

Skills required for the position: DATA MODELING, ARCHITECTURE, SQL, DATA WAREHOUSING, WATERFALL, AGILE.


Detailed Info: you will be a member of the GRC Reporting, Analytics & Data Warehouse development team, with specific focus on developing Audit, Risk and Compliance integrated reporting and data analytics solutions. In this role you will be responsible for working with the stakeholders to analyze business data needs, the creation of data models that support reporting and data integration, and the implementation of these models on our data warehouse. In addition, you will be working closely with other members on the reporting development team (report authors, ETL developers, data analysts, etc.) to facilitate communication of client-specific business rules, processes, requirements and requests. To develop data models in support of integrated business reporting and data exchange. To implement data models on our data warehouse. To perform data profiling on source system data to ensure that source system data can be integrated and represented properly in our models. To assist ETL and report developers with best usage of the models. To provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues.

Development/Computing Environment: Bachelor's degree in Computer Science, Software Engineering, Information Technology, or related field required. At least 7+ years of experience in data development and solutions. At least 7+ years for SQL experience with the ability to write ad-hoc and complex queries to perform data analysis. Ability to create E-R data models (conceptual, logical and physical). Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal BI-Temporal models, etc.) Strong analytical skills, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements. Relevant and substantial work experience with business requirements definition and management (end to end), structured analysis, process design, use case documentation, UML process and use case definition. Experience with both Waterfall and Agile development methodologies. Understanding of IBM DB2, Informatica, and DB2 stored procedures a plus. Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels. Self starter. Proven ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever changing priority list and resolve conflicts to competing priorities..

The position offers competitive rate.


Job Id: 32097