Please find the position details below: Job Title: Dimensional Data Modeler with Snowflake Location: Westlake TX or Smithfield RI (Hybrid – 2 weeks onsite, 2 weeks remote) Duration: Long term contract - budget to extend Interview Two Steps - Candidate will also be given a data set and asked to create a model prior to the interview. BU: WI Technology Special Instructions: Equity and finance reporting. Associate will need to look at the data and understand how the data is going to be consumed and model the data accordingly. BA will give requirement and the specs, and then the modeler will have to figure out how the data can be modeled to make sure multiple reports can use the data. Strong Dimensional Modeling, esp. in Snowflake – Must know answers to things like - facts available – advantage of each fact etc. SQL expertise and proficiency – Someone who knows about all SQL Joins and could deal with scenario based questions. (80% of candidates were good in data modeling but they weren't having exp on SQL side Required skills: Data Modeling Data Analysis Data Engineering Power Designer Finding patterns and 1:1 Commonalities SQL querying Nice to have: OLTP – Online Transaction Processing Your Expertise Strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both a project and enterprise level Dimensional Modeling with experience in crafting conformed dimensions that can be used across Business Units. Data Modeling Tool such as Powerdesigner, Oracle Designer or Erwin Experience working with Data Engineering and Data Analytics teams Ability to write SQL to query data (ideally ANSI SQL) General working knowledge of AI technologies, techniques, and trends No domain experience required Enterprise experience – they will be collaborating with many different people to get what they need and need to be intuitive about there process. Description Senior Data Modeler As the Senior Data Modeler supporting (WI), you blend deep data modeling knowledge and Data Architecture experience to build Data Models for multiple Key initiatives. You have a curiosity about coaching, mentoring, and developing associates. In an agile structure you will collaborate with other leaders to establish the standards for your CoE, influence the strategic decisions and build solutions to help scale our business. You will guide a team of data modelers who primarily work within autonomous squads across product areas. You are committed to staying hands-on, developing your own expertise and knowledge to bring the latest thinking to your role and to enable others with that knowledge. As a leader in the WI Data Modeling group, you will drive a spirit of innovation and data strategy by building and improving the data modeling and database design practice. You will work closely with the business and technical teams and build or assist in the creation of scalable, flexible, and detailed data models that will improve the WI product offerings and speed time to market. The Team WI Data Engineering data modeling team partners with the project teams to deliver practical & resilient data model and database designs that meet business needs while adhering to key standard methodologies. We drive adoption of enterprise and standard methodologies, and promote changes in process, standards, or technologies when necessary.
