Business Intelligence Analyst

What You'll Do

• We are seeking a highly skilled and experienced Level II B2B Marketing Analyst to join our dynamic team. This role is pivotal in driving our business's marketing strategies through insightful analysis and data-driven decisions. The ideal candidate will be an expert in utilizing PowerBI, Snowflake, various Microsoft tools, ETL tools, and programming languages to analyze complex datasets, improve marketing outcomes, and contribute to strategic planning. You will be responsible for developing, maintaining, and improving advanced data models, executing data pipeline automation, and providing actionable insights to stakeholders. Your passion and curiosity for new and better ways to optimize our data pipelines and processes will be the foundation to your and the team’s success.
  
  

What Your Responsibilities Will Be

• Data Analysis and Reporting:
• Develop, maintain, and optimize complex data models in PowerBI.
• Utilize PowerBI for advanced visualizations and DAX calculations.
• Perform data exploration and analysis using Snowflake, implementing advanced SQL skills for data transformation and linear regression.
• Leverage Python for data manipulation and visualization, applying libraries such as Seaborn, NumPy, Pandas, MatPlotLib, and techniques in NLP and RegEx.
• Data Pipeline and ETL Processes:
• Design and implement ETL pipelines using tools like Snowpipe, DBT, Stitch, and PowerAutomate.
• Automate data flows and pipelines in PowerBI, ensuring efficient resource handling and reduced data model sizes.
• Apply CI/CD best practices for continuous integration and deployment in data projects.
• Collaboration and Communication:
• Work closely with cross-functional teams to understand business needs and deliver comprehensive analytics solutions.
• Develop and present findings, insights, and recommendations to executive teams through PowerPoint and other communication tools.
• Document processes, methodologies, and findings for knowledge sharing and best practice development within the organization.
• Process Improvement:
• Identify opportunities for process improvement and automation within data operations and analytics workflows.
• Utilize Power BI Service, Snowflake and other automation tools for enhancing and automating workflows and data processes.
• Project Management:
• Manage analytics projects from conception to completion, ensuring alignment with business objectives and timelines.
• Utilize Jira and Confluence for project tracking, documentation, and collaboration.
  
  

What You’ll Need To Be Successful

• Bachelor’s degree in Data Science, Computer Science, Information Systems, Business Analytics, or a related field.
• Minimum of 5 years of experience in a B2B marketing analytics or similar role, with a proven track record of leveraging data for business insights.
• Expertise in PowerBI, including data models, flows, pipelines, DAX, ERD modeling, and advanced visualizations.
• Advanced knowledge of:
• Power BI, DAX and M Query Language
• Snowflake and SQL, including data transformations, window functions, CTEs, and stored procedures
• Analytical programming languages like DAX, SQL, M Query Language, Python ( Seaborn, NumPy, Pandas, MatPlotLib, NLP, RegEx)
• Familiarity with project management and documentation tools (Jira, Confluence).
• Strong skills in executive communication, presentation building, collaboration, team playing, cross-team collaboration, and documentation.
• Exceptional ability in process improvement, automation, and asynchronous communication.
  

How We’ll Take Care Of You

Total Rewards

In addition to a great compensation package, paid time off, and paid parental leave, many Avalara employees are eligible for bonuses.

Health & Wellness

Benefits vary by location but generally include private medical, life, and disability insurance.

Inclusive culture and diversity

Avalara strongly supports diversity, equity, and inclusion, and is committed to integrating them into our business practices and our organizational culture. We also have a total of 8 employee-run resource groups, each with senior leadership and exec sponsorship.

Learn more about our benefits by region here: Avalara North America

What You Need To Know About Avalara

We’re Avalara. We’re defining the relationship between tax and tech.

We’ve already built an industry-leading cloud compliance platform, processing nearly 40 billion customer API calls and over 5 million tax returns a year, and this year we became a billion-dollar business. Our growth is real, and we’re not slowing down until we’ve achieved our mission - to be part of every transaction in the world.

We’re bright, innovative, and disruptive, like the orange we love to wear. It captures our quirky spirit and optimistic mindset. It shows off the culture we’ve designed, that empowers our people to win. Ownership and achievement go hand in hand here. We instill passion in our people through the trust we place in them.

We’ve been different from day one. Join us, and your career will be too.

We’re An Equal Opportunity Employer

Supporting diversity and inclusion is a cornerstone of our company — we don’t want people to fit into our culture, but to enrich it. All qualified candidates will receive consideration for employment without regard to race, color, creed, religion, age, gender, national orientation, disability, sexual orientation, US Veteran status, or any other factor protected by law. If you require any reasonable adjustments during the recruitment process, please let us know.