Lead Data Architect

closerlook Chicago, IL

closerloook is looking to expand our Marketing Intelligence team. We’re looking for a leader in database architecture to lead our agency’s efforts to leverage proprietary and 3rd party data to generate insights that help our clients make the best choices for their marketing dollars. In this role, you’ll work with our leadership to define updates and needs for our systems and with our developers to implement the appropriate code to meet the needs of the agency and our clients. You will have the opportunity to work on meaningful changes and updates to our systems, and you’ll get to work in an agile-based environment that focuses on driving value through technology. You’ll also have the opportunity to be hands-on in the development work while applying your knowledge of architecture. 


  • In conjunction with leadership, develops and implements scalable data models that meets the agency’s data needs. This may include architecture to support marketing automation, CRM systems, data-oriented products, and data warehousing that empowers advanced analytics and machine learning/AI
  • Work closely with business and technology teams to develop functional and technical specifications for data requirements
  • Design and maintain roadmaps for data architecture based on the enterprise data strategy and emerging technologies and methods in the industry
  • Identify risks with the proposed data architecture solutions and develop mitigation plans
  • Ensure code development aligns with the data architecture solution and best practices
  • Estimate the work effort for data project tasks
  • Implement solutions for enhancements to database systems or new features as needed
  • Direct and supervise developers, overseeing and being involved in day-to-day database development tasks, break/fix routines, and larger development efforts
  • Serve as lead in-house expert on our database solutions
  • Work with team leaders and data analysts in resolving complex technical and operational issues
  • Manage the development and maintenance of system documentation, metadata, data standards, and data quality metrics for the data management system

Job Requirements

  • BS/BA degree in computer science, mathematics or related field. Advanced degree preferred.
  • Minimum of 7-10 years of experience in data development, with an emphasis in SQL development
  • Minimum of 2-5 years of experience in data architecture
  • Strong experience in translating business requirements to data solutions
  • Experience with developing data warehousing solutions that support BI/reporting platforms and advanced data science work
  • Prior experience with agile methodologies
  • Experience with change management and version control systems
  • Familiarity with web technologies preferred