Sr. Data Modeler / Engineer

company banner
Software Guidance & Assistance
Architecture, Business Intelligence, Consulting, Data Architecture, Database, Database Administration, Data Modeling, Data Warehouse, DBA, Genetic, HTTP, Inquire, Management, Modeler, Modeling, Oracle, Project, SQL
C2H Independent, Contract Independent, Contract W2, Contract Corp-To-Corp, C2H W2, C2H Corp-To-Corp, Contract
Telecommuting not available Travel not required

Job Description

Software Guidance & Assistance, Inc., (SGA), is searching for a Database Engineer for a contract assignment with one of our premier financial services clients in New York, NY.

 

 

Responsibilities :

 

     

  • Represent the Data Engineering team in all data architecture, data modeling, and metadata management work teams

     

  • Provide senior level experience in modeling Enterprise grade data warehouses to the modeling work group

     

  • Be the Technology Lead for the metadata initiative and ensure the implementation of the metadata solution

     

  • Provide technical expertise to Data Warehouse implementation teams and interface with the industry vendors for technical support as needed

     

  • Develop strategies and solutions for reference data and master data management within the context of the Data Warehousing project

     

  • Perform data model design reviews and evaluations to ensure that the Group standards and best practices are being adhered to and the resulting physical databases meet project needs

     

  • Develop, maintain and enhance data modeling and database design documents, policies, procedures

     

  • Collaborate with the application developers, architects and project team on logical and physical database design and implementations

     

  • Provide expert level guidance on dimensional modeling, on maintaining data histories, and conformed dimensions

     

  • Prepare high quality documentation of design/architecture/database infrastructure documents;

     

  • Assist in ad hoc projects, assignments and responsibilities as necessary

     

  • Develop semantic data models for Business Intelligence

     

  • Responsible for maintaining and extending data standards

     

 

 

Required Skills :

 

     

  • Must be able to write comprehensive SQL for exploring and profiling data

     

  • Bachelors Degree in Computer Science or related field or at least 8+ years relevant work experience in Data/Database architecture that includes senior level experience in data modeling.

     

  • Master level experience in ER Studio including creation and use of macros to automate tasks.

     

  • Solid understanding of relation database technologies as well as data warehouse architectures

     

  • Experience in data modeling in a financial services provider organization is required. Must have understanding of credit related financial instruments.

     

  • Performance optimization and management for relational and dimensional models

     

  • Expertise as an application DBA

     

  • Experience in Oracle database administration tasks such as schema/user and object creation

     

  • Experience in large scale data warehouse architectures

     

  • Must have a solid understanding of ETL processing and Data Lineages.

     

  • Must have experience in managing metadata and supporting data governance initiatives

     

  • Must be self-motivated, able to work independently and highly responsible in maintaining time critical projects schedule

     

  • Effective verbal and written skills, including good presentation skills Desirables:

     

  • Performance optimization and management for relational and dimensional models

     

  • Experience with multi-terabyte environments and familiarity with best practices of data archiving and purging

     

  • Understanding of the emerging Big Data Paradigm

     

 

 

SGA is a Certified Women's Business Enterprise (WBE) celebrating over thirty years of service to our national client base for both permanent placement and consulting opportunities. For consulting positions, we offer a variety of benefit options including but not limited to health & dental insurance, paid vacation, timely payment via direct deposit. SGA accepts transfers of H1 sponsorship for most contracting roles. We are unable to sponsor for Right-to-Hire, Fulltime, or Government roles. All parties authorized to work in the US are encouraged to apply for all roles. Only those authorized to work for government entities will be considered for government roles. Please inquire about our referral program if you would like to submit a candidate for any of our open or future job opportunities. SGA is an EEO employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, age, marital status, pregnancy, genetic information, or other legally protected status. To view all of our available job postings and/or to learn more about SGA please visit us online at www.sgainc.com .


Company Information

Founded in 1981, Software Guidance & Assistance, Inc. is a privately-held, Certified Women’s Business Enterprise with over 30 years experience providing IT staffing to our diverse portfolio of clients across all industries with a strong presence in finance, insurance, utilities, and government vertificals.
Dice Id : sgainc
Position Id : 18-03986

Similar Positions at Software Guidance & Assistance

Data Analyst (and BI Developer)
  • New York, NY
  • 4 days ago
Technical Analyst
  • New York, NY
  • 4 days ago
Python Application Developer
  • New York, NY
  • 4 days ago
Java Developer
  • New York, NY
  • 4 days ago
Oracle Database Engineer / Architect
  • New York, NY
  • 4 days ago
Mid Level Java Engineer
  • New York, NY
  • 4 days ago
SQL Server DBA
  • Holmdel, NJ
  • 4 days ago
Data Engineer - Data Warehouse
  • Cary, NC
  • 4 days ago
Senior Business/Data Analyst
  • Charlotte, NC
  • 4 days ago