YOUR PARTNER FOR A STRONG CAREER IN TECHNOLOGY

Data Architect Sr in Wilmington, DE at APEX Systems

Date Posted: 1/25/2018

Job Snapshot

Job Description

Job #:  816211

 Our client, a multinational financial company, is seeking a Sr. Data Architect to join their team in Wilmington, DE. Candidates will be doing a combination of Data Architecture and Data Modeling. Experience with Erwin and ER/Stuidios is a must. Pluses: Hadoop, Mongo DB, Cassandra, Snowflake, NoSQL, financial industry experience. Please see the details below and send your information to kwinther@apexsystems.com if you are interested. 

 

Role: Sr. Data Architect

Location: Wilmington, DE

Requirements: 

•   Minimum 5+ years’ experience modeling complex databases using 3rd party modeling tools such as ERWin 9.2

•   Experience designing and building large financial services data warehouses with very strong data analysis skills

•   Have good knowledge of ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments.

•   5+ years of hands-on experience in data management, data warehousing, data transformation, metadata and reference data management and business intelligence tools.

•   5+ years of experience with advanced SQL query techniques using TOAD, SQL Navigator. Basic UNIX would be a Plus.

•   Previous experience as a hands-on Oracle DBA of large database is a plus.

•   Must have good understanding of leading 3rd party products in the relevant areas (e.g. Datastage, Business Objects, Microstrategy).

•   Significant experience with System Development Life Cycle (SDLC)

 Responsibilities:

•   Capture business requirements and rules, design the associated logical models, and create all required documentation to support, communicate, and validate the data model.

•   Design, build and maintain the logical and physical data models to support the business requirements in a dynamic, expanding business environment.

•   Map data elements of data sources into the domain data models.

•   Maintain documentation of data models, including relationships, constraints and metadata.

•   Publish and conduct model reviews with business and technical project teams.

•   Review database design changes with the team to determine the impact to the physical database and other systems.

•   Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues.

•   Participate in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization

•   Architect with an eye toward high performance, scalability, and high availability.
 

 

 

 

 

 

 

 

 

EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystemsinc.com or 844-463-6178.