The Enterprise Data Architect will be focused on developing and maintaining data models, data warehousing, and strategy to fuel operational planning, execution, and insights. This will be executed by taking a lead on designing data models for cross functional use in the rapidly growing consumer goods industry. The position requires detailed documentation of all requirements specifications, design, testing/QA cases, user permission level management, and deployment.
A successful candidate will demonstrate strong communication and analysis skills by creating plans and timelines for model delivery, define maintenance and upgrade windows, and forming strong business relationships to drive the direction of the date environment to fully utilize capabilities of insights
CORE JOB DUTIES AND RESPONSIBILITIES
- Evaluate current data architecture and databases and how it currently drives operations.
- Plan end-to-end model for data consumption and analysis.
- Code new data architecture, integrating existing databases.
- Use ETL (extract, transform, load) best practices in the creation of the databases.
- Research and discover new methods to acquire data.
- Monitor databases and report on effectiveness and accuracy, updating as needed.
- Maintain compliance documents related to data storage and security.
- Maintain security of the database, and create standards to ensure that the system is safe.
- Develop maintenance and upgrade windows to minimize effect on operations.
- Preserve a repository of all data architecture artifacts.
JOB SKILLS AND REQUIREMENTS
- 8-10 years of professional experience working with a wide variety of data sets to drive enterprise reporting and decision making.
- History of developing enterprise master data models.
- Extensive knowledge of the AWS environment.
- Extensive knowledge of Data Warehousing, Relational Database Design, and ETL.
- RDMSs (relational database management systems) or foundational database skills.
- Data analysis with complex ERP systems.
- Extensive knowledge of applicable data privacy practice and laws.
- Experience working in manufacturing and consumer goods is a plus.
- Bachelor’s degree in Business, Finance, Information Systems, Engineering, or relevant work experience.
- Extensive technical knowledge of current network hardware, protocols, and Internet standards.
- Excellent hardware troubleshooting experience.
- Competence with testing tools and procedures for voice and data circuits.
- Knowledge of applicable data privacy practices and laws.
- The ability to be stationary/sitting regularly.
- The ability to be able to be in constant standing/moving position.
- The ability to perform various physical activities, including lifting, standing, and squatting.
6 Core Values of a Surterra Employee
Integrity - We operate in a regulated and unchartered industry. Act and make decisions that stand up to scrutiny and reflect our position as a sophisticated, credible and respected leader. Be honest, trustworthy, dependable, and honorable. Demonstrate sound moral and ethical ways of interacting.
Collaboration - We are a collection of the best talent at all levels. Learn and grow from this diversity: welcome healthy debate and proactively seek other perspectives and points of view to find the best solution while not resting on consensus. Proactively ensure the right people have the right information at the right time. Work as a team vs. an individual performer.
Agility - We are growing incredibly fast in a new industry. Be open to change, be ready to pivot on the moment’s notice, and act with a sense of urgency to take advantage of opportunities. Then be ready to do it again. Quickly –and calmly -respond and adapt to the unexpected. Modify and streamline processes, find more efficient ways of doing your job. Work efficiently across markets, time zones, and functions.
Intentionality - Intentionality requires action –it makes your intentions happen. Good thoughts are meaningless without action. It is initiative directed by the purpose to move our business forward. Intentionality is doing things important to you, even when not easy. Transformational change happens with intentionally.
Alignment - Together, we must understand and believe in our vision, mission, business and team goals and priorities. When we make a decision, even when we don’t have consensus we all align behind that decision and execute. We don’t revisit decisions unless we have material new data or circumstances.
Accountability - Make the best proactive and reactive decisions given the available information and the wisest counsel. • Own your decisions, actions and outcomes, and promptly correct mistakes. • Be reliable, honor commitments and do not finger point, off-load responsibilities, or criticize co-workers. Look after co-workers and team’s success.