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 TEAMThe 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 CONTRIBUTEThe 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

WHAT YOU BRING TO THE TABLE

• 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