Data Modeler

Company Description

At Fortune Brands Innovations, we believe that our innovation and success are fueled by the passion of our people and the strength of our teams. Together, we work to fulfill dreams of home by aligning around common goals, being agile in the face of change, holding ourselves accountable, and acting with integrity and transparency. We succeed when everyone belongs and strive to build a Home for All where all associates can be their true, authentic selves at work. Learn more about our culture here.

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

Additional Information

Fortune Brands Innovation (FBIN) is built on industry-leading brands and innovation within our operating segments: Plumbing, Doors and Security. We have an impressive track record of strong financial results, market outperformance and growth, which translates into career and professional growth opportunities for associates. Please visit our website at fbin.com to learn more.

Equal Employment Opportunity

FBIN is an equal opportunity employer. FBIN evaluates qualified applicants without regard to race, color, religion, sex, gender identity or expression, national origin, ancestry, age, disability/handicap status, marital status, protected veteran status, sexual orientation, genetic history or information, or any other legally protected characteristic.

Reasonable Accommodations

FBIN is committed to working with and providing reasonable accommodations to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application or interview process, please contact us at [email protected] and let us know the nature of your request along with your contact information.

Videos To Watch
https://www.youtube.com/watch?v=8dfcgDz6aQQ