• EY
  • $106,390.00 -159,250.00/year*
  • Iselin , NJ
  • Information Technology
  • Full-Time
  • 115 Elmhurst Ave

Data Architect


Requisition # ISE001AU

Post Date Jul 09, 2019


Essential Functions of the Job:

  • Creation, optimization and maintenance of conceptual, logical and physical database models

  • Documentation of functional requirements and system specifications into the data architecture and detailed design specifications for current and proposed designs

  • Document and adhere to development standards and best practices in database and database objects design

  • Definition of robust architecture for building new applications and releases, leveraging and enhancing existing building blocks, or creating new reusable components

  • Demonstrate proactive approach to identifying issues and presenting solutions and options, and where appropriate, leading to resolution

  • Maintaining highly effective and consistent communication within the team, peers, and the leadership team.

  • Strong working experience designing ETL solutions

  • Hands-on experience in designing and implementing hybrid cloud solutions on Azure

  • Expert-level knowledge of SQL Server 2014, 2016 and Azure SQL Database

  • Experience applying SAFe/Scrum/Kanban methodologies

  • Ability to exercise judgment in solving technical, operational, and organizational challenges

  • Experience with large scale data warehousing environments.

  • Experience/understanding of business process reengineering and business modeling concepts, business systems development and analysis

  • Experience with Microsoft stack.

  • Experience with change management procedures (CI/CD)

  • Strong analytical and problem solving skills

  • Conduct data model reviews with project team members.

  • The senior role will be required to provide mentoring and leadership to more junior team members

  • Lead the data architecture for the decision support systems () including rules, policies, standards and models that govern and define the type of data collected and how it is used, stored, and managed

  • Work closely with the infrastructure teams to create a scalable, robust physical environment to support data services

  • Evaluate new and existing (internal and external) technologies and services in support of data services and data analytics objectives

Minimum Qualifications

  • 10+ years demonstratable work experience as a Data Architect using data modeling tools such as Erwin, Toad or ER/Studio

  • 5 years experience in a data analysis

  • Experience designing data warehousing solutions

  • In-depth understanding of database structure principles

  • Self-starter requiring minimal supervision and possesses excellent organizational and interpersonal skills

  • Excellent communication and presentation skills

Preferred Qualifications

  • Erwin Data Modeling experience

  • Familiarity with Microsoft Azure, Azure Sql, Azure Data Flow & Azure Data Factory

  • Expertise with No-SQL databases such as Azure Cosmos DB

  • Experience with Data Governance

  • Global experience, working with remote teams in different time zones

  • Experience with Client & Business Stakeholder interactions

  • Familiarity with multiple tools and can learn rapidly

EY provides equalemployment opportunities to applicants and employees without regard to race,color, religion, sex, sexual orientation, gender identity, national origin,protected veteran status, or disability status.

Associated topics: data analyst, data analytic, data warehouse, data warehousing, database, database administrator, mongo database administrator, sql, sybase, teradata

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...