Company:
Sigmaways Inc
Location: Elk Grove
Closing Date: 02/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
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
Share this job
Sigmaways Inc