Data Modeler

EY - Nashville, TN

Full-time
.

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
Collaborate with data architects for data model design approvals
Conduct data model reviews with project team members.
Contribute in the definition and implementation of data governance practices
Minimum Qualifications

3+ 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
Accounting and Tax knowledge/experience, within a Partnership Structure
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
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
Big Data Analytics experience
Data Warehouse design experience
Ernst & Young LLP, an equal employment opportunity employer (Females/Minorities/Protected Veterans/Disabled), values the diversity of our workforce and the knowledge of our people.