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 subscribers
• Define the development tasks and estimates for completion (including story writing)
• Work with the testing team and API developers to refine, validate the implementation
• Participate in the scrum team ceremonies: stand-up, planning, grooming, demo, retro
• Data 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 Science
• 5-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 teams
• Experience in creating data models in cloud environments like GCP, AWS
• Experience 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 diagramming
• Demonstrable experience designing and refactoring large database schemas over time
• Knowledge and application of normalization and denormalization strategies
• Able to follow and promote source code control best practices in SVN, GitHub, or similar
• Programming languages such as PSQL, Java, Python, .NET/C#
• Exceptional communication, organization, and time management skills
• Strong analytical problem-solving skills with a high attention to detail
• Track record as a self-starter, results-oriented, and delivery-focused contributor