Sr Data Architect

  • location: Jersey City, NJ
  • type: Permanent
  • salary: $150,000 - $170,000 per year

job description

Sr Data Architect

job summary:
seeking a full-time Data Architect who has the solid understanding and experience in the underlying database and data warehousing technologies. The Data Architect should have a strong database and data warehousing development background and will work closely with the IT architects and our engineering team to not only maintain and improve our existing Enterprise Data Warehouse, but also design and build our next generation data warehouse to accommodate ever growing needs for historical and real time data for analysis and reporting for our business user community.

location: Jersey City/Boston, New Jersey
job type: Permanent
salary: $150,000 - 170,000 per year
work hours: 8am to 4pm
education: Bachelors
Key responsibilities include:

  • Work with business and system analysts to analyze business requirements into data-aspect CSD
  • Develop source, target, and output mapping technical documents as required for data lineage and transformation and integration
  • Design logical and physical data models for analytics and reporting in compliance with the Enterprise Data Model standards Performance
  • Work with developers and DBA to identify performance bottlenecks in the data models and the queries, and to implement solutions
Qualifications for your role would include:

  • Bachelor's degree in Computer Science or related technical field, or equivalent experience
  • Minimum 8 years' experience with database design and architecture, data modeling, performance tuning, and mainstream business intelligence applications
  • Minimum 8 years' experience developing enterprise Data Warehouse solutions
  • Minimum 10 years' experience with Oracle database technologies, SQL, PL/SQL, Stored Procedures, Triggers, etc.
  • Experience with design and implementation of the dimensional database model
  • Ability to architect data warehouse environments
  • Ability to work with many different technical tools
  • Ability to design, model, build, and deploy BI solutions
  • Possessing good analytical and problem-solving abilities
  • strong understanding of how data schemas/structures satisfy and relate to business functions.
  • strong SQL development experience
  • Excellent verbal, written and interpersonal communication skills
  • A good team player - one who appreciate the value of a good team player to the success of the organization
  • Experience with Oracle RAC , Oracle Exadata and Oracle Golden Gate
Nice to have:

  • Extensive experience on Oracle platform
  • Experience with banking and financial industry reporting
  • Experience working with ERWIN data modeler
  • Experience level: Director
  • Minimum 8 years of experience
  • Education: Bachelors
  • Database Developer
  • Oracle
  • data architecture
  • Erwin
  • exadata
  • SQL Database developer

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up

related jobs

    Sales Data Architect

  • location: New York, NY
  • job type: Permanent
  • salary: $160,000 - $170,000 per year
  • date posted: 8/2/2021

    Sr. AEM Developer

  • location: New York, NY
  • job type: Permanent
  • salary: $145,000 - $165,000 per year
  • date posted: 6/4/2021