North Olmsted, Ohio, USA
21 days ago
Data Modeler

Company Description

Fortune Brands Innovations, Inc. is an industry-leading innovation company focused on creating smarter, safer and more beautiful homes and improving lives. Our driving purpose is that we elevate every life by transforming spaces into havens. We believe our work and our brands can have incredibly positive impacts for not just our business and shareholders, but for people and the planet, too. When you join Fortune Brands, you become part of a high-performing team who are empowered to think big, learn fast and make bold decisions. We support an inclusive and diverse culture where everyone is encouraged and empowered to be their authentic selves, and where our differences and unique perspectives are a key strength. Explore life at Fortune Brands 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.

Location: This role is a remote role eligible to work anywhere in the United States.

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.

Additional Information

Salary Range: Fortune Brands believes in fair and equitable pay. A reasonable estimate of the base salary range for this role is $90,000 - $110,000. Please note that actual salaries may vary within the range, or be above or below the range, based on factors including, but not limited to, education, training, experience, professional achievement, business need, and location.  

Additional Information :

At Fortune Brands, we support the overall health and wellness of our associates by offering comprehensive, competitive benefits that prioritize all aspects of wellbeing and provide flexibility for our teammates’ unique needs. This includes robust health plans, a market-leading 401(k) program with a company contribution, product discounts, flexible time off benefits (including half-day summer Fridays per policy), inclusive fertility / adoption benefits, and more. We offer numerous Employee Resource Groups to support inclusivity and our associates’ feeling of belonging at work.

Fortune Brands is a brand, innovation and channel leader focused on exciting, supercharged categories in the home products, security and commercial building markets. Our portfolio of brands includes Moen, House of Rohl, Aqualisa, SpringWell, Therma-Tru, Larson, Fiberon, Master Lock, SentrySafe and Yale residential.

Fortune Brands is headquartered in Deerfield, Illinois and trades on the NYSE as FBIN

Equal Employment Opportunity

FBIN is an equal employment opportunity employer and does not discriminate against any applicant based on race, color, religion, sex, gender identity or expression, national origin, ancestry, age, disability, 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 accommodation to applicants with disabilities. If 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. Resumes submitted to this email address will not be responded to.

Confirm your E-mail: Send Email