Solution Architect

Job description

Join our Core Business Services (CBS) team and you will help support the important business enablement functions that keep our organization running strong. As a CBS professional, you will work across teams to provide the knowledge, resources and tools that help EY deliver exceptional quality service to our clients, win in the marketplace and support EY’s growth and profitability. Major teams within CBS include Finance, Information Technology, Human Resources, Enterprise Support Services, Brand Marketing and Communications, Business Development, Knowledge and Risk Management.

With so many offerings, you have the opportunity to develop your career through a broad scope of engagements, mentoring and formal learning. That’s how we develop outstanding leaders who team to deliver on our promises to all of our stakeholders, and in so doing, play a critical role in building a better working world for our people, for our clients and for our communities. Sound interesting? Well this is just the beginning. Because whenever you join, however long you stay, the exceptional EY experience lasts a lifetime.

Job Summary:

 

 

This position will develop data models including dimensional models for analytics and reporting, address data migration issues, formulate plans for data governance and data lineage, enhance metadata, and serve as the technical data steward for enterprise/solution data. The Solution Architect will be responsible for ensuring data quality and optimal data movement from a holistic perspective across all subject areas, projects, and system implementations

 

 

Essential Functions of the Job:

·  Create data models and supplemental documentation for the existing platforms and ongoing for all new implementations
·  Contribute to the development of an Enterprise Logical Data Model from which logical and physical data models would be developed
·  Provide suggestions for improving performance, data integrity, and system quality
·  Work closely with the teams to create enhanced data models for dimensional design as required by tools such as MicroStrategy, Tableau, and Power BI.
·  Devise standards to be implemented within the environment for database consistency while reducing redundancy and increasing integrity
·  Participate on project teams to ensure the end to end vision of data movement is optimized and results in the highest quality of data for operational and analytical use
·  Serve as the data expert across all subject areas stored in the platforms
·  Work closely with the architects and programmers to ensure database objects are adhering to standards
·  Perform design reviews for modifications and additions to the existing platforms
·  Provide expertise in the area of Data Governance and Data Lineage
·  Document data flow between systems and ensure accuracy
·  Conform data as necessary to integrate data from multiple systems
·  Mentor others in proper data modeling and best practices
·  Lead or direct the work of others
·  Rarely requires guidance, even on most complex systems analysis

 

 

Analytical/Decision Making Responsibilities:

 

·  Considers the art of the possible, compares various architectural options based on feasibility and impact, and proposes actionable plans
·  Demonstrates strong analytical and technical problem-solving skills
·  Ability to analyze and operate at various levels of abstraction
·  Ability to balance what is strategically right with what is practically realistic

 

 

Knowledge and Skills Requirements:

 

 

Experience of managing IT programs/projects with personal accountability for delivering to time and cost for large, complex programs/projects

·  Familiarity with data design/mechanisms used to efficiently store and retrieve data in a cloud environment
·  Management skills to manage one or more large, complex projects simultaneously
·  Track record of customer focus, based on openness, trust, and delivering on promises
·  IT background with experience across the systems development life cycle with experience in all program/project phases – plan, initiate, elaborate, design, build, test, implement
·  Must be familiar with EYs architectural practices

Strong team working skills across matrixed client, supplier and geographically dispersed virtual teams

·  Strong communication and interpersonal skills (includes negotiation)
·  Excellent facilitation, communication and data analysis skills
·  Excellent written and verbal communication skills – must be able to communicate fluently in English both verbally and in writing
·  Honed diplomatic skills, be excellent at networking, building working relationships with diverse and cross functional teams

Demonstrates strong leadership and team management skills:

·  Outstanding leadership and organizational skills

 

Other Requirements:

The role may also require the periodic allocation of additional time on the job to support multiple demands and escalating issues or to accommodate teams or staff in other time zones. 

·  National travel may be required
·  Must be able to operate in a virtual environment
·  Must be flexible to conduct business in hours that are flexible with a global team
·  Able to complete multiple projects and meet deadlines in a fast-paced environment
·  Receives limited supervision and ability to make decisions on day-to-day tactics
·  Expected to act autonomously in line with strategy and plans
·  Must have excellent time management skills.

 

 

Job Requirements:

 

 

Education:

·   A degree in Computer Science or a related discipline; or equivalent work experience

Experience:

·  7+ years work experience in physical and logical relational database modeling is required.
·  7+ years work experience in architecting data solutions is required.
·  6+ years work experience in dimensional modeling is required.
·  6+ years work experience in data warehousing is required.
·  6+ years work experience with a data modeling tool such as ERWIN is required.
·  3+ years work experience with project leadership is required.