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