Senior Business Intelligence Developer

*Basis Technologies is aware of scams involving false advertisements for open positions at our company. The fraudulent job postings and emails are unauthorized. Basis would never ask candidates to download an app, purchase products or services, or conduct interviews over text or chat. For more information or if you have been targeted, please reach out to us at: talent.acquisition@basis.com.

WHO WE ARE 

Basis Technologies delivers software and services to automate digital media operations for leading agencies and brands. 

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. 

Basis Technologies is headquartered in Chicago, and our employees have the flexibility to work from headquarters, completely remote, or a hybrid of the two. Please note, we are hiring on a remote working basis only in the U.S. and Canada.

ABOUT THE TEAM

The Business Intelligence & Data Operations team works on data and reporting solutions using big data from our online programmatic ad-buying and automation platform to solve business problems and support decision-making. They work with a wide variety of groups within Basis including Product and Engineering, Customer Success, Sales, Operations, and Services. The team manages all aspects of custom reporting and analytics projects and advises on reporting capabilities available through our technology platform and API.

WAYS YOU’LL CONTRIBUTE

The Business Intelligence and Data Operations team is the ideal place for someone who thrives on working in a fast-paced growth environment, has a passion for working with data and technology, and is not afraid to take on some of the most complex challenges that Basis has to offer.

The Senior BI Developer will be responsible for developing, supporting, and implementing business intelligence solutions. Will need to assist in the build of new solutions for reporting and analytics, including model development, data visualizations, security, and governance. You will contribute by:

• Designing and maintaining complex ETL processes, data models, data storage, and monitoring systems.
• Designing and maintaining BI reports: spreadsheets, visualizations, web dashboards, self-service, etc.
• Creating and updating documentation for technical design, data sources, ETL processes and reporting solutions.
• Translating product requirements into technical designs and suggesting reporting solutions.
• Understanding the QA process and participating in multiple levels of testing.
• Collaborating with internal clients and Business Analysts, enabling them to understand and leverage our data.
• Identifying and executing improvements to technology, data models and BI tools.
• Learning about our data sets and understanding the KPIs that drive business success.
• Identifying and recommending BI product improvements to better data intelligence across Basis.
• Providing “Raving Fan” service to internal and external stakeholders by being highly responsive and sharing knowledge to improve the ability of others.
• Acknowledging and embracing diversity of thought and opinion, and approach with Beeps, clients and vendors, regardless of background, culture, and organizational level. Specific examples include, but are not limited to:
• Engaging actively in Diversity, Equity, and Inclusion (IDEA)
• Pursuing continuous IDEA Development
• Cultivating an Inclusive Work Environment

• 5 + years of experience in a similar role.
• Post-secondary computer science, engineering, mathematics, sciences, etc.
• Strong knowledge and experience with Relational Databases including SQL.
• Experience with Python language, and common data analysis libraries.
• Experience with data visualization tools (e.g. Power BI, Tableau, Datorama).
• Experience with ETL software (e.g. Pentaho, Talend, Tableau, Domo, etc.).
• Capable of working with engineers about technical design tradeoffs including platforms, frameworks, scalability and performance.
• Experience with entire development and project life cycles (SLDC) and doing so in a fast-paced workplace.
• Resourceful and self-reliant; a strong self-teacher with a passion for learning.
• Excellent communicator with an ability to clearly explain complex technical subjects.
• Passionate about problem-solving and engaging the team to arrive at a solution.

• Knowledge of the digital advertising industry (e.g. AdWords, DSP, ad serving).
• Experience using Airflow and CI/CD tools like Jenkins
• Experience with version control system (e.g. Git).

• Snowflake, MySQL, PostgreSQL, MongoDB
• Python, Pentaho
• JIRA, Confluence, Stash, Git

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 BASIS TECHNOLOGIES

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

We've been proudly recognized as:

Ad Age, Best Places to Work 2024, 2023, 2022, 2013

Built In, Best Workplaces 2024, 2023, 2022, 2021

Crain's Best Companies to Work for in Chicago 2023, 2022, 2021, 2020, 2014, 2013, 2012, 2011

Crain's Best Companies to Work for in New York 2023, 2022, 2021, 2014

Dallas Morning News, Top Workplaces 2023, 2022, 2021, 2019, 2015

Denver Post, Top Workplaces 2024, 2023, 2022, 2021, 2020

Denver Business Journal's Largest Tech Employers 2024, 2023, 2022, 2021, 2020

We provide a thoughtful perks and benefits package including a modified workweek, competitive 401k/RRSP matching, mental health support, a funded health savings account, paid sabbatical, generous parental leave, a flexible work environment and time off policy, and more. 

We are proud to be an equal opportunity employer and are committed to building teams 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.

Basis is committed to providing the best possible interview experience for all our candidates. If you have a disability or questions related to interview accessibility, please contact talent.acquisition@basis.com.

Information collected and processed as part of any job applications you choose to submit is subject to Basis' privacy policy that you can view here.