Lead Data Modeler

We are seeking to hire a Lead Data Modeler for our direct client with expertise in database analysis and modeling along with thorough understanding of advanced database concepts including data modeling, relational DBMSs, SQL programming, with a working knowledge of web services, e-commerce systems, data warehouses, and operational data stores.Responsibilities:Create the architecture, design, and implementation of database schema for systems underlying interactive web and mobile apps being developed in-house for our tens of thousands of subscribersDefine the development tasks and estimates for completion (including story writing)Work with the testing team and API developers to refine, validate the implementationParticipate in the scrum team ceremonies: stand-up, planning, grooming, demo, retroData Analysis: working with Product Owners, BSAs, API developers, QA testers, and DBAs to extrapolate logical and physical data requirements from systems design documents that are frequently system behavior-focused (such as wire frames), taking them through from inception to production release and ongoing maintenance.Data Modeling: applying logical and physical data modeling best practices and concepts, often leading the logical data design in new systems; primarily working with traditional OLTP systems but also able to work in data warehouse OLAP systems and cloud-based, non-structured data systems.Required Qualifications:B.S. in Computer Science5-10 years working in a database environment designing.Understanding of the data modeling concepts like Star Schema, Snowflake Schema.Experience with Agile methodologies, working inside one or more scrum teamsExperience in creating data models in cloud environments like GCP, AWSExperience in migrating on-premise ETLs to GCP using cloud-native tools like BigQuery.Experience in building and/or working with data marts.High competency in entity-relationship analysis from requirements to diagrammingDemonstrable experience designing and refactoring large database schemas over timeKnowledge and application of normalization and denormalization strategiesAble to follow and promote source code control best practices in SVN, GitHub, or similarProgramming languages such as PSQL, Java, Python, .NET/C#Exceptional communication, organization, and time management skillsStrong analytical problem-solving skills with a high attention to detailTrack record as a self-starter, results-oriented, and delivery-focused contributor