Data Architect (Remote Optional)

| Chicago
WHO WE ARE 

Centro delivers software and services to automate digital media operations for more than 1,000 leading agencies and brands including Priceline, Sprint, RVA Media Group, and The Basement agency. 

Our comprehensive ad tech platform, Basis, supports the planning, reporting, and financial reconciliation of direct, programmatic, search, and social media, all in one place. 

We are deeply committed to building software that will change the ad tech industry for the better and are equally dedicated to building an inclusive culture of highly motivated individuals who create a positive and supportive environment together. We invest in our culture and support our employees so they can do their best work. 

Centro is headquartered in Chicago, with beautiful offices also in Toronto, Dallas, Denver, and New York to name a few. Post-COVID, many of us will be returning to one of our offices (by choice, not requirement -- we believe results matter more than where they are produced). This position and all of our employees have the flexibility to work in one of our office locations, completely remote, or a hybrid of the two.

ABOUT THE TEAM
 
Technology is at the core of what we do. Centro’s innovative Engineering team designs and develops new features and integrations for Basis, our industry-leading, comprehensive software solution. Our platform processes over 300 billion events per day and uses AI and machine learning to automate and simplify the entire digital campaign process.

This team is all about data—and in order to create value from the massive amount of data we collect, engineering leverages their dynamic Data Engineering, Data Science, and Business Intelligence teams to create insights that benefit the industry as a whole.
 
WAYS YOU’LL CONTRIBUTE
 
You can help transform the data created from these activities into actionable information. We aim to derive meaning from our data that enables us to run our business better, and also equips our clients to advertise smarter. The ways you will contribute to the team are by:

  • Leading data architecture, defining and scripting database schema for data warehouse, data marts and all intermediary transfer and transformation of data.
  • Serving as a subject-matter expert leveraging a deep and advanced understanding of the source application, the business processes involved and the data that's housed.
  • Acting as a liaison representing the data team enabling cross-functional collaboration in the effort to successful execution of enterprise-level initiatives and projects.
  • Creating, owning and maintaining artifacts such as source-to-target data mapping, transformation rules, data dictionary and other reference materials enabling smoother development, testing, maintenance and evolution of the data pipeline

WHAT YOU BRING TO THE TABLE

  • Expert level writing and interpreting SQL and interacts equally well with PostgreSQL, MySQL and Hive
  • Strong understanding of computer science fundamentals
  • Advanced skills in designing, building, testing, deploying, executing, and maintaining data extracts, transform and load (ETL) jobs to populate databases, data warehouse and data marts
  • Skillfully utilizes Python/PySpark in the creation of various transformation modules and reporting artifacts and is equally well-versed in the Apache Hadoop ecosystem to efficiently establish data architecture and design data pipelines
  • Ability to mentor other engineers and also educate new members of the team on the complex business model of the digital advertising business

BONUS POINTS

  • Bachelor’s degree or an advanced degree in Computer Science or Engineering
  • Maintains broad knowledge of current and emerging technologies, trends, issues, techniques and approaches in area of expertise
  • Excited by a fast-paced product development environment
  • Experiments with the above-mentioned different technologies and toolsets to advise on and recommend the right ones to achieve optimal solution
  • Having a passion and knowledge of AdTech industry

OUR TECH STACK

  • Python, Scala, PySpark
  • Hadoop, Kafka, Spark, Oozie
  • PostgreSQL, MySQL, Hive, Impala, SQL

ANYTHING ELSE? 

Don't think you have all the skills required for this role? That's okay, we recognize that experience can be built in many ways. If you have relevant skills that are not reflected in your resume, we welcome your candidacy and encourage you to share more in an optional cover letter, even if your experience doesn’t match our exact requirements.

LIFE WITH CENTRO 

We take care of our people and believe that Centro’s success depends on the growth and well-being of each one of our team members.

We provide a thoughtful perks and benefits package including competitive 401k/RRSP matching, mental health support, a funded health savings account, paid sabbatical, generous parental leave, a work from home stipend for employees in closed offices, and more. 

We are proud to be an equal opportunity employer are committed to building teams of Centrons that are diverse in thought, perspective, and culture. We celebrate all team members regardless of gender identity, sexual orientation, race or cultural background, religion, disability, and age. Our employee-led communities enrich our culture of uniqueness, inclusivity, and empowerment. 

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
    • JavaLanguages
    • JavascriptLanguages
    • RubyLanguages
    • SqlLanguages
    • ReactLibraries
    • ExpressFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • MariaDBDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • MixpanelAnalytics
    • PixelmatorDesign
    • SketchDesign
    • Aha!Management
    • ConfluenceManagement
    • JIRAManagement
    • TrelloManagement
    • WordpressCMS
    • SalesforceCRM
    • Oracle EloquaLead Gen

Location

The Chicago Loop is a great place to work, located in a central area of Chicago accessible to major public transportation, dining and shopping.

An Insider's view of Centro

How would you describe the company’s work-life balance?

Instead of balancing work and life, it’s about blending the two. As a parent, I may need to leave for part of the day or before 5. Everyone here understands and I don’t feel guilty. Even if I’m not sitting at my desk from 9-5, my work and my teams work will still be done on time. Centro is giving me the opportunity to live the best life I can.

Matt Klaers

Manager, Financial Reporting

How do you empower your team to be more creative?

There’s an incredible balance of freedom, drive, and fun that I’ve only experienced at Centro. On an engineering team retreat this summer, the plan was to code from 10 AM – 2 PM on a fun team-based competition and then go outside to enjoy the day. The team would not stop coding until 10 PM! Of course, this was followed by 6 hours of karaoke.

Mike

VP, software engineering

What are Centro Perks + Benefits

Centro Benefits Overview

While our people work to change an industry, we reward them with industry-leading perks. It’s not just about the free snacks and onsite yoga (although they help)—it’s about making sure Centrons feel happy, healthy and fulfilled when they come to work.

Culture
Volunteer in local community
Centro offers each employee one day per calendar year to use for community work or volunteering opportunities. Local offices regularly organizes group volunteer activities for employees.
Partners with Nonprofits
Centro partners with local non-profit organizations to support various causes and to organize group volunteer events for employees.
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Documented equal pay policy
Highly diverse management team
Unconscious bias training
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Sabbatical
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Happy Hours
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Lunch and learns
Promote from within
Online course subscriptions available
Customized development tracks
More Jobs at Centro25 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Marketing
Operations
Product
Project Mgmt
Sales
Operations
new
Chicago
Marketing
new
Chicago
HR + Recruiting
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
HR + Recruiting
new
Chicago
Sales
new
Chicago
Marketing
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Product
new
Chicago
Data + Analytics
new
Chicago