Sr. BI Developer

About Ovative Group:Ovative Group is the premier independent media and measurement firm in the United States. We help trailblazers in fast-growing, customer-centric organizations across industries reinvent their marketing and measurement programs. We leverage our media, measurement, and consulting capabilities to help brands like Domino's, Facebook, The Home Depot, CVS, Disney, and UnitedHealth Group transform their media and marketing programs. Our proprietary approach to measuring and optimizing marketing investment decisions, Enterprise Marketing Return (EMR), is disrupting the industry and setting the gold standard for customer and marketing strategy, activation, and measurement. Recognized eight consecutive years on Star Tribune’s list of Top 150 Workplaces and five years on Inc. 5000’s list of the fastest-growing private companies in America, we pride ourselves in always overdelivering for our clients, our teams, and our communities.   About the Role:We are seeking a Senior BI Developer to join our rapidly growing product and engineering development team. Our company specializes in enterprise-level media measurement and optimization across various industries. In this role, you will take a leadership position within a cross-functional team responsible for gathering technical requirements, identify opportunities for automation, working with lead engineers to architect solutions, and collaborating with visualization engineers to design and build scalable, automated dashboards. You will play a pivotal role in guiding the team and working closely with internal and client stakeholders throughout the entire reporting design lifecycle, from concept to deployment.The ideal candidate must bring experience in iterative programable reporting development practices, deep knowledge of version control (e.g., GitHub), and both conceptual and pragmatic problem-solving skills. Your outstanding attention to detail and strong written and oral communication skills will enable you to work directly with business users, understanding their objectives and translating them into technical requirements. As a valuable team member, you will have the opportunity to mentor junior team members, contribute to innovative ideas, and drive the adoption of cutting-edge technologies within the team and foster your own professional growth.Responsibilities:• Lead the design, development, testing, and deployment of robust programmable reporting templates that can be deployed across all our clients, meeting their business goals and configurable to support automation.• Lead effort in identifying opportunities for automation with a focus on the operational stability and scaling of solutions• Engage directly with Product Managers and stakeholders to understand their business goals, gather requirements, and translate into detailed, actionable technical requirements• Research, write and edit documentation and technical requirements, including reporting dashboard designs, evaluation plans, test results, technical manuals and formal recommendations and reports• Evaluate trade-offs between scale, robustness, performance and customer impact to ensure we build the right solutions that scale• Ensure solutions adhere to SDLC and DevOps best practices, maintaining high standards of quality and security across all phases of development.• Mentor and level up the skills of your teammates through collaboration and by sharing your expertise• Ensure adherence to and advancement of reporting software and product engineering best practices, including code quality, documentation, testing, security, deployment, and performance.• Evaluate and integrate new technologies, tools, and frameworks to optimize the reporting software development process.• Troubleshoot complex reporting software issues and provide effective solutions.• Provide guidance, mentorship, and contribute to architectural decisions, code reviews, and project direction.• Foster a culture of continuous learning to keep your team current with emerging technology and report engineering trends.Requirements:• 5+ years building enterprise products in reporting/BI, data, and/or analytics space• 1+ years building programmable reporting/BI solutions using SDKs or APIs (Tableau SDK, Tableau REST API, Power BI REST API)• Proficient with programmable data visualization/BI tools including ownership of back-end technology• Proficient with creating scalable reports/dashboards through automation of reporting tools.• Proficient with writing, updating, and optimizing SQL queries to develop visualization datasets• Proficient with code management systems like GitHub• Proven experience with the Software Development Life Cycle (SDLC), notably DevOps, ensuring software quality and security across all phases.• Strong knowledge of security best practices and compliance, with the ability to integrate these into the development process for data protection and regulatory adherence.• Experience working with technical and business teams – including presenting technical requirements to non-technical audiencesPreferred:• Experience in a digital marketing role or agency• Experience with Python, or other data processing and analysis tools• Experience with software tooling including orchestration systems (Airflow/Dagster), cloud computing environments (GCP/Azure), and data processing/lake houses (DBT/Big Query/Databricks)• Experience with statistics• Experience with user-experience and design conceptsPay TransparencyAt Ovative, we offer a transparent view into three core components of your total compensation package: Base Salary, Annual Bonus, and Benefits. The salary range for this position below is inclusive of an annual bonus. Actual offers are made with consideration for relevant experience and anticipated impact. Additional benefits information is provided below.For our Manager positions, our compensation ranges from $79,000 to $132,000, which is inclusive of a 20% bonus.Benefits Of Working At Ovative GroupWe provide strong, competitive, holistic benefits that understand the importance of your life inside and out of work.Culture:Culture matters and we’ve been recognized as a Top Workplace for eight years running because of it. We demand trust and transparency from each other. We believe in doing the hard and complicated work others put off. We’re open in communication and floor plan. We’re flat – our interns sit next to VPs, our analysts work closely with senior leaders, and our CEO interacts with every single person daily. Put together, these elements help foster an environment where smart people can support each other in performing to their highest potential.Compensation and Insurance:We strive to hire and retain the best talent. Paying fair, competitive compensation, with a large bonus incentive, and phenomenal health insurance is an important part of this mix.We’re rewarded fairly and when the company performs well, we all benefit.Tangible amenities we enjoy:• Access to all office spaces in MSP, NYC, and CHI• Frequent, paid travel to our Minneapolis headquarters for company events, team events, and in-person collaboration with teams.• Flexible paid vacation policy• 401k match program• Top-notch health insurance options• Monthly stipend for your mobile phone and data plan• Sabbatical program• Charitable giving via our time and a financial match program• Shenanigan’s DayWorking at Ovative won’t be easy, but if you like getting your hands dirty, driving results, and being surrounded by the best talent, it’ll be the most rewarding job you’ll ever have. If you think you can make us better, we want to hear from you!