Must be local to the Greater Sacramento Area and able to work W2 through Ledgent Technology
There is no sponsorship for this role and is not 3rd party friendly
* Create the architecture, design, and implementation of database schema for systems underlying interactive web and mobile apps being developed in-house by ALLDATA 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.
Position 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
Desired Skills and Experience ("Snowflake" OR "Star Schema") AND "Data Modeling" AND "OLAP" AND "GCP"
All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. To the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.