Business Intelligence Developer

Job Description

WHO WE ARE Basis Technologies delivers software and services to automate digital media operations for more than 1,000 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 in an office location, 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 Basis' Product team guides the innovation and development of our comprehensive tech platform, Basis. This team blends focus, collaboration, and creativity to fulfill our mission in creating a transformative tool that makes work more streamlined and fulfilling for those who power the ad tech industry. Customer experience is at the forefront of this team’s work—and also includes market research, cross-departmental stakeholder collaboration, user testing, communicating feature requests to engineers and designers, monitoring impact of new feature rollouts, measuring returns on product investments, and more. Together, they leverage their diverse industry experience and talent to brainstorm new ideas, iterate on old ones, and create the best possible product for our customers. The Business Intelligence Team lives within the Product department and is responsible for unlocking the vast amount and huge potential of Basis data to evolve the company's key metrics that generate actionable insight to empower data-driven decisions. This team focuses on solving complex business problems and communicates solutions through data insight storytelling.

WAYS YOU’LL CONTRIBUTE

• Creating and providing expertise on using analytic solutions for a variety of use cases such as: self-service analytics, extracts, reports, dashboards and alerts.
• Partnering with technical product managers and business analysts to analyze requirements and user stories to design analytic products (data models, dashboards, reports, extract, widgets, etc.)
• Understanding how requirements incorporate the customer’s needs and ensure solutions developed are traceable to business objectives.
• Understanding and execution of the SDLC process including version control and continuous testing.
• Assessing current analytics environment and understand how solutions impact existing architecture or how architecture should be developed to support analytic solutions.
• Understanding QA Process and be able to participate in multiple levels of testing (unit, regression, system, etc.)
• Managing the document library of solutions in coordination with team members.

WHAT YOU BRING TO THE TABLE

• 3-5 years of experience writing high-performance SQL to solve complex business problems.
• 3-5 years of progressive experience in BI and analytics solution design and development.
• 2+ years of experience with data visualization and reporting.
• Advanced knowledge of data management, business intelligence and analytic solution delivery including OLAP concepts, semantic layer, and reporting solutions.
• Solid understanding of data warehousing, ETL process, data quality, data governance, and metadata management.
• Data modeling knowledge with data marts and data warehouses. Knowledge of ETL design and data flows is preferred.
• Experience with data visualization, dashboard design, reporting, self-service BI, data KPIs, predictive, prescriptive, and descriptive analytics solutions.
• Experience with the full lifecycle of a software and analytics project from start to finish. This includes environment coordination, deployment to production, and relevant communications.
• Strong SQL and data extraction skills. – ability to extract and manipulate data from common database systems (Snowflake, Postgres, MySQL, SQL Server, Oracle, etc.)

BONUS POINTS

• Bachelor's Degree preferred, or equivalent experience.
• Some direct experience with ETL/ELT tools is preferred.
• Big Data systems (Hive, Impala, etc.)
• Preference given to individuals with enterprise platform/SaaS experience or digital advertising industry knowledge.

OUR TECH STACK

• Snowflake
• Ruby
• Java, Python
• React.js
• Kubernetes
• Docker
• Kafka
• PostgreSQL/NoSQL
• AWS

$84,000 - $117,000 a year Our salary ranges are determined by role, level, and location. Individual salary is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Your recruiter can share more about the specific salary range for your location during the hiring process. The total compensation package for this position may also include commission or bonus, company equity, and competitive benefits. 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 2023, 2022, 2013 Built In, Best Workplaces 2023, 2022, 2021 Crain's Best Companies to Work for in Chicago 2022, 2021, 2020, 2014, 2013, 2012, 2011 Crain's Best Companies to Work for in New York 2022, 2021, 2014 Dallas Morning News, Top Workplaces 2021, 2019, 2015 Denver Post, Top Workplaces 2022, 2021, 2020 Denver Business Journal's Largest Employers 2022, 2021, 2020 Fortune Magazine, Best Workplaces 2022, 2021, 2020, 2015, 2014 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 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 reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application processes. If you need assistance or an accommodation due to a disability, you may contact us at [email protected]. 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 . Apply for this job