This website uses cookies to ensure you get the best experience. Learn more

Data Architect II

Preferred Location: US-GA-Alpharetta, US-MA-Boston, US-WA-Seattle, US-CA-San Francisco

EY is a global leader in assurance, tax, transaction and advisory services. Technology is at the heart of what we do and deliver at EY. Technology solutions are integrated in the client services we deliver and are key to our innovation as an organization.

Fueled by strategic investment in technology and innovation, Client Technology seeks to drive growth opportunities and solve complex business problems for our clients through building a robust platform for business and powerful product engine that are vital to innovation at scale. As part of Client Technology, you'll work with technologists and business experts, blending EY's deep industry knowledge and innovative ideas with our platforms, capabilities, and technical expertise. As a catalyst for change and growth, you'll be at the forefront of integrating emerging technologies from AI to Data Analytics into every corner of what we do at EY. That means more growth for you, exciting learning opportunities, career choices, and the chance to make a real impact.

The selected candidate
  • Develops large and complex data architecture, composed of models, policies, rules or standards that govern which data is collected and how it is stored, arranged, integrated and put to use in data systems, including the design, build and management of data infrastructure to address business requirements
  • Creates sound project plans with the business by engaging with multidisciplinary teams, and by identifying, managing and mitigating risk
  • Develops relationships across the business to understand data requirements, applies deep technical knowledge of data management to solve business problems in areas where solutions may not currently exist, necessitating new solutions/ways of working/technologies and proactively articulating these to the business

Your key responsibilities include
  • Create and maintain conceptual, logical and physical database models
  • Document 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 designs
  • Maintain highly effective and consistent communication within the team, peers, and the leadership team
  • Reverse engineer SQL code and modify it to solve problems/issues
  • Contribute to the definition and implementation of data governance practices
  • Design both data structures and data integration practices
  • Work closely with the infrastructure teams to create a 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

Skills and attributes for success
  • Understanding of business process reengineering and business modeling concepts, business systems development and analysis
  • Hands-on experience in designing and implementing hybrid cloud solutions on Azure
  • Experience working with newer versions of SQL Server (2014 and newer)
  • Experience applying SAFe/Scrum/Kanban methodologies
  • Ability to exercise judgment in solving technical, operational, and organizational challenges
  • Expert programming, performance tuning and troubleshooting skills
  • Demonstrate proactive approach to identifying issues and presenting solutions and options, and where appropriate, leading to resolution
Minimum Qualifications
  • 5+ years demonstratable work experience as a Data Architect using data modeling tools such as Erwin, Toad or ER/Studio
  • 2-3 years T-SQL coding experience on large projects working with newer versions of SQL Server (2014 and newer)
  • Must possess expert T-SQL programming, performance tuning and troubleshooting skills
  • Create database objects and T-SQL scripts
  • Experience designing data warehousing solutions
  • In-depth understanding of database structure principles
  • Seamlessly able to translate business requirements to technology requirements
Preferred Qualifications
  • Erwin Data Modeling experience
  • Accounting and/or Tax knowledge
  • Familiarity with Microsoft Azure, Azure SQL, Azure Data Flow & Azure Data Factory
  • Expertise with No-SQL databases such as Azure Cosmos DB
  • B.S. or M.S. in Computer Engineering, Computer Science, Data Analytics, Data Science, or related field preferred
What we look for
  • Strong analytical skills and problem-solving ability
  • A self-starter, independent-thinker, curious and creative person with ambition and passion
  • Excellent inter-personal, communication, collaboration, and presentation skills
  • Customer focused
  • Excellent time management skills
  • Positive and constructive minded
  • Takes responsibility for continuous self-learning
  • Takes the lead and makes decisions in critical times and tough circumstances
  • Attention to detail
  • High levels of integrity and honesty

What working at EY offers

We offer a competitive remuneration package where you'll be rewarded for your individual and team performance. Our comprehensive Total Rewards package includes support for flexible working and career development, and with FlexEY you can select benefits that suit your needs, covering holidays, health and well-being, insurance, savings and a wide range of discounts, offers and promotions. Plus, we offer:
  • Support, coaching and feedback from some of the most engaging colleagues around
  • Opportunities to develop new skills and progress your career
  • The freedom and flexibility to handle your role in a way that's right for you

EY is committed to being an inclusive employer and we are happy to consider flexible working arrangements. We strive to achieve the right balance for our people, enabling us to deliver excellent client service whilst allowing you to build your career without sacrificing your personal priorities. While our client-facing professionals can be required to travel regularly, and at times be based at client sites, our flexible working arrangements can help you to achieve a lifestyle balance.

About EY

As a global leader in assurance, tax, transaction and advisory services, we're using the finance products, expertise and systems we've developed to build a better working world. That starts with a culture that believes in giving you the training, opportunities and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime.

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

Make your mark.

Apply now.

EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, national origin, protected veteran status, disability status, or any other legally protected basis, in accordance with applicable law.

Apply Now

Share this