Lead Data Architect at closerlook, inc.

| Chicago
Sorry, this job was removed at 1:30 p.m. (CST) on Tuesday, November 3, 2020
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago

Lead Database Architect

 

closerloook is looking to expand our Marketing Intelligence team. We’re looking for a leader in database development and 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. As a core contributor to our product development efforts, 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 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.
  • Serve as our primary architect to ensure day-to-day changes and updates are in-line with the agency’s broader data vision, bring forward ideas and working to implement those ideas
  • Work closely with business and technology teams to develop functional and technical specifications for data requirements. 
  • Develop scalable information architecture to meet business requirements. 
  • Design and maintain roadmaps for data architecture based on the enterprise data strategy.
  • 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
  • Manage team of data developers
  • Oversee and be 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

 

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
  • Experience in GCP (Google Cloud Platform)
  • Familiarity with Azure
  • Advanced SQL Knowledge
  • Proficient in object-oriented development (Python, C#, Java, etc.)
  • Expertise data warehousing, performance turning, data security, auditing, and encryption
  • 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.

 

ABOUT CLOSERLOOK, INC.

closerlook is a new type of marketing agency that helps biopharma brands make a difference in the lives of patients and those who care for them.

We focus on what matters most—the combination of better patient outcomes and bigger business impact.

Learn more at closerlook.com

 

EQUALITY FOR ALL: AT THE HEART OF WHAT MATTERS

At closerlook, equality for all is a core value that’s at the heart of what matters. We believe in building a diverse and inclusive culture across race, age, gender identity, sexual orientation, religion, mental health, and physical ability. We celebrate our differences and champion diverse thinking to drive innovation — in a safe environment so everyone can be their authentic selves. By valuing and promoting our different backgrounds, perspectives, and experiences as strengths, we are positioned to best serve patients, healthcare professionals, and the communities around us.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • RLanguages
    • jQueryLibraries
    • ModemizrLibraries
    • ASP.NETFrameworks
    • Microsoft SQL ServerDatabases
    • Google AnalyticsAnalytics
    • MarketoLead Gen

Location

A favorite destination for locals and tourists alike, River North is a neighborhood of galleries, shops, niche businesses and a foodie paradise.

An Insider's view of closerlook, inc.

What are some social events your company does?

Funny you should ask, as I am one of the super-secret members of our super-secret MIRTH committee. Basically, we are fun planners. Let’s see, dip/chili/baking contests, random pancake breakfasts, team potlucks, beach day in the middle of winter, and one time we had a hobby horse competition. Oh, and who can forget beer o’clock every Friday?!

Liz

Office Manager

What projects are you most excited about?

We are putting a heavy focus on creating progressive web apps since a majority of our end users are mobile users. It allows regular webpages to behave like a native app on a mobile device to make the experience as seamless as possible. We are also focusing on tools for sales reps so they are able to quickly yet effectively engage HCPs.

Binish

Interactive Lead, Manager

What are closerlook, inc. Perks + Benefits

Culture
Partners with Nonprofits
Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
All new hires to closerlook will participate in a half day Unconscious Bias training. Currently being offered twice per calendar year to capture new hires.
Diversity manifesto
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
closerwe - our DEI group with our CEO as its Executive sponsor Women's Leadership - our empowerment group open to all of the women at closerlook Allyship - focused on building and being better alli
Hiring Practices that Promote Diversity
closerlook is committed to presenting hiring managers with candidate pools comprised of at least 50% diverse candidates and in we are 2021 launching a diverse internship program.
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
closerlook offers both a HDHP/HSA plan and a traditional PPO plan. We offer a generous contribution towards your HSA!
Life Insurance
Pet Insurance
Wellness Programs
onsite yoga, biometrics screenings and much more!
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Generous Parental Leave
Maternity leave is paid at 100% for 12 weeks, we also offer a 2 week parental leave. We are thrilled to offer a return to work program, allowing new parents to ease back to work on a modified schedule
Family Medical Leave
Employees who have been with the company for 12 months are eligible for 12 weeks of family medical leave.
Return-to-work program post parental leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Annual party celebrating our company's birthday, Summer Outings, Holiday Party.
Stocked Kitchen
Some Meals Provided
Happy Hours
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Promote from within
Mentorship program
More Jobs at closerlook, inc.21 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Operations
Project Mgmt
Sales
Content
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Content
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Sales
new
Chicago
Content
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Data + Analytics
new
Chicago