Job Description
Fortune Brands Innovations Data Management team is responsible for designing, developing, and enhancing analytics data models. The Data Modeler will work in Agile POD engagements (3-5 members) and Data Vault 2 data model developments for FBIN.
RESPONSIBLIITIES:
- Collaborate & execute analytical projects from solution design and data integrity evaluation through solution documentation and implementation. Collect, document, and review functional and non-functional requirements.
- Define and document the logical and physical data models. Identify the various source systems data elements and data transformations that must occur to support the creation of models for reporting & analytics.
- Consult on PII data and model necessary data preparation to encrypt, mask, secure, etc. data.
- Review design and specifications with the technical team. Address any design or information gaps during the build process. Act as a member of the QA review team for design and code reviews.
- Collaborate with users to determine the appropriate requirements, technical specifications, and performance measures (KPI). Closely work with other team members to ensure data, processes, models, and integrations are complete and aligned to requirements and models.
- Document all designs and specifications. Document metadata information. Develop early prototypes for the application as necessary. Support the development of complex logic or functions as necessary. Remain accountable for the quality of all data modeler deliverables with appropriate testing.
- Support the development of new analytical and data products and services and the enhancement of current processes and offerings.
Qualifications
- 3+ years of data analytics modeling/data analysis industry experience, including data discovery, data profiling and data preparation experience.
- Bachelor’s degree in data science, Mathematics, Statistics, Computer Science or related field
- Proven analytical skills to resolve technical problems effectively, identify and implement process improvements, and think creatively.
- Intermediate level skill set in SQL programming (Transact SQL). Snowflake experience a plus.
- Familiar with languages (dbt, Python). Knowledge in dbt a plus.
- Proficient in Data Discovery, Data Profiling and Data preparation.
- Intermediate level experience working with Data Modeling tools (ERWin, SQLDBM, etc.). Experience with SqlDBM a plus.
- Experience in an Agile development cycle.
- Data Vault 2 methodology development experience nice to have. CDV2P certification a plus.
- Demonstrated ability to communicate ideas and analysis results effectively both verbally and in writing to both a technical and non-technical audience.
- Excellent problem-solving, analytic, organization, communication, interpersonal and presentation skills.
Hiring Pay Range: $90K-$105K
*Actual pay will vary based on qualifications and other factors
See more jobs at Fortune Brands
Apply for this job