Lead Data Scientist

Key Skills

Python Programming, SQL, Big Data Technology, Vertica, Snowflake, Continuous Integration & Continuous Delivery - CI/CD, Amazon RedShift

Job Description

Numerator is a data and tech company bringing speed and scale to market research. Headquartered in Chicago, IL, Numerator has more than 2,000 employees worldwide. The company blends proprietary data with advanced technology to create unique insights for the market research industry that has been slow to change. The majority of Fortune 100 companies are Numerator clients.

Here at Numerator, we've made all corporate roles have maximum flexibility between office and remote work, except for rare situations when the role requires coming into an office regularly. In those situations, the recruiter of that role will clarify at the beginning of the process if that is the case. In fully remote situations, the company will provide technical equipment necessary to be successful in the role. In addition to maximum flexibility of return-to-office, the company also provides generous PTO, Internally Quiet Focus Time, and other recharge efforts to give time back to employees.

Job Description

Numerator is looking for a Data Engineer who is a Big Data enthusiast and has a passion for working with an interesting robust set of data. In this role, you will work in our platform to help ensure that our data quality is flawless.

As a company, we have millions of new data points every day that come into our system. You will be working with a passionate team of engineers to solve challenging problems and ensure that we can deliver the best data to our customers, on-time. You will be using the latest cloud data warehouse technologies to build robust and reliable data pipelines.

A major requirement for this role is to understand, author, and deploy production code, the ideal candidate should also be experienced with processing large quantities of data, building algorithms alongside software engineers, and delivering to production.

You will have a broad impact and exposure across Numerator as you help build out and expand our technology platforms across several software products. This is a fast-paced role with high growth, visibility, impact, and where many of the decisions for new projects will be driven by you and your team from inception through production.

What you get to do

• Develop expertise in the different upstream data stores and systems across Numerator
• Design, develop and maintain data integration pipelines for Numerators growing data sets and product offerings
• Collaborate with product and engineering teams to take requirements from prototype to production
• Build data validation testing frameworks to ensure high data quality and integrity
• Write and maintain documentation on data pipelines and schemas

Skills & Requirements

What we are looking for

• 3+ years of experience in building a data warehouse and data pipelines
• Knowledge of software engineering best practices across the development lifecycle, coding standards, code reviews, source management, build processes, testing, and operations
• Expert in SQL, including advanced analytical queries, window functions, CTEs and query optimization
• Advanced proficiency in Python (data structures, algorithms, object oriented programming, using APIs)
• Experience administering a cloud data warehouse (Redshift, Snowflake, Vertica)
• Experience with ETL tooling (especially Airflow) and data processing, and knowing how to transform data to meet business goals
• Experience with schema design and dimensional data modeling
• Amazon Web Services (or other cloud equivalent) experience
• Terraform and/or ansible (or similar) for infrastructure deployment
• Experience in CI/CD production pipelines
• Curious and interested in learning about the latest in data warehouse technology and willingness to mentor junior team members
• BS in Mathematics, Statistics, Computer Science, Engineering, Economics, Physics, or other behavioral and/or equivalent quantitative science.

Nice to have

• Knowledge of, and experience implementing data security and governance best practices
• Airflow -- Experience building and monitoring DAGs, developing custom operators and using script templating solutions
• Experience supporting production systems and developing on-call/incident management playbooks
• Kubernetes Experience
• Ability to work with team members located in multiple geographies and time zones.

What we offer you

More data than you could imagine to play with!

Data that matters and that is shaping the impact of billion dollar brands.

Brilliant, motivated and passionate colleagues with whom to spend your time.

An inclusive and collaborative company culture- we work in an open environment while working together to get things done, and adapt to the changing needs as they come.

Market competitive total compensation package.

Volunteer time off and charitable donation matching.

Regular hackathons to build your own projects and work with people across the entire company

Strong support for career growth, including mentorship programs, leadership training, access to conferences and employee resource groups.

Great benefits package including health/vision/dental, exceptional maternity leave coverage, unlimited PTO, flexible schedule, 401K/RRSPs matching and much more.

If this sounds like something you would like to be part of, we’d love for you to apply! Don't worry if you think that you don't meet all the qualifications here. The tools, technology, and methodologies we use are constantly changing and we value talent and interest over specific experience.

While this position can be remote, Numerator is only able to hire in many, but not all, states and provinces. In certain cases, if you are not located in a specific area where Numerator is able to hire, you may not be eligible for employment.