Data Architect
About The Position
HAVI is a global, privately owned company focused on innovating, optimizing and managing the supply chains of leading brands. Offering services in marketing analytics, packaging, supply chain management and logistics, HAVI partners with companies to address challenges big and small across the supply chain, from commodity to customer. Founded in 1974, HAVI employs more than 10,000 people and serves customers in more than 100 countries. HAVI’s supply chain services are complemented by the customer engagement services offered by our affiliated company The Marketing Store. For more information, please visit HAVI.com. This is a hybrid role based at 345 N Morgan St, Chicago, IL 60607. Candidates must reside in the Chicago metropolitan area. Relocation assistance is not offered at this time. As a Data Architect, you will be responsible for our overall Data Platform design and implementation, including data platform strategy, data modeling and data governance practices. Data Platform – Defining and managing frameworks and standards for our Data Platform based on Databricks Lakehouse Data Modeling – Designing and updating data models Data Governance – Establishing and implementing Data Governance policies including compliance, privacy, quality and security
Requirements
- Experience: 6+ years experience in data modeling, Databricks Lakehouse design, data engineering, and data governance
- Strong Analytical Skills: Ability to analyze complex business requirements and translate them into data models
- Proficiency in Data Modeling Tools: Experience with ERwin, PowerDesigner, or other data modeling software
- Database and Data Platform Knowledge: Understanding of relational databases, SQL, data warehousing and Databricks Lakehouse concepts
- Data Integration: Experience designing and developing data integrations with various methods and tools including APIs
- Query and ETL/ELT Knowledge: Able to create and maintain complex SQL queries for performant data management. Knowledge of Python, PySpark and other scripting languages for development and automation
- Machine Learning and AI Integration: Experience with structuring databases and building pipelines that support AI and ML workloads
- Communication Skills: Ability to communicate effectively with both technical and non-technical stakeholders
- Problem-Solving Skills: Ability to identify and resolve data modeling issues
- Global Team: Able to work with teams from different time zones and review/supervise data engineering teams
- Data Security: Able to define and ensure compliance of data security standards within the company and when sharing data with external parties
- Bachelor's degree: In computer science, information technology, or a related field
Responsibilities
- Definition and implementation of Data Platform infrastructure jointly with our Cloud Infrastructure team
- Definition and maintenance of our Unity catalog implementation including catalogs, foreign catalogs, schemas and other aspects such as Delta Sharing
- Backup and Recovery requirements and activities as related to our Data Platform
- Business Needs Analysis: Understanding the organization's data requirements and translating them into effective data models
- Data Model Creation: Designing conceptual, logical, and physical data models using tools like Entity-Relationship Diagrams (ERDs) and data modeling software
- Database/Lakehouse Design: Defining how data is stored, accessed, and related within a database, data warehouse or Databricks Lakehouse
- Data Integrity: Ensuring data accuracy, consistency, and reliability through data quality rules and governance
- Collaboration: Working with database administrators, data analysts, and software developers to implement and maintain data models
- SQL Proficiency: Writing complex queries to retrieve and maintain data. Optimizing queries for a Databricks Lakehouse
- Performance Optimization: Tuning data models for optimal performance and scalability
- Documentation: Creating and maintaining documentation for data models, data flows, and data dictionaries
- Staying Updated: Keeping up with new technologies and best practices in data modeling
- Definition of Data Governance standards and practices in conjunction with our IT and Business leadership teams
- Compliance monitoring related to Data Governance
- Definition and monitoring of Quality definitions and practices related to Data
- Definition and monitoring of Security related to the Data Platform in conjunction with our Security and Cloud Infrastructure teams
Benefits
- Inclusive employee resource groups
- Generous medical, dental, vision and other great benefits
- Paid parental and medical leave programs
- 401(k) with a company match component and profit sharing
- 15 days of paid time off plus company holidays
- Hybrid work model with flexibility
- Tuition reimbursement and student loan repayment assistance
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
