Michael Best & Friedrich LLP
Data + Design Business Intelligence Architect
Michael Best & Friedrich LLP, Madison, Wisconsin, United States
Data + Design Business Intelligence Architect
Michael Best & Friedrich LLP is looking for a
Data + Design BI Architect
to join our Marketing and Business Development team, with a focus on transforming complex revenue and marketing data into intuitive, actionable insights. This role is central to how we empower marketers and business developers with the tools they need to make data-driven decisions—through seamless data pipelines, smart integrations, and exceptional user experiences.
You'll help to architect and maintain a data infrastructure that supports revenue generation efforts as well as campaign performance tracking, customer segmentation, and strategic growth initiatives. Your work will directly influence how marketing and business development teams interact with data—making it accessible, engaging, and easy to act on.
Responsibilities
Design and maintain automated data pipelines that support business intelligence, marketing analytics, CRM integration, and campaign performance tracking.
Build and manage APIs that connect marketing platforms (e.g., Dynamics 365, ZoomInfo, LinkedIn, etc.) with internal systems.
Architect and optimize data models and datasets to support marketing KPIs, funnel analysis, and customer journey insights.
Collaborate with Data Analysts on the design and development of Power BI dashboards with a strong focus on user experience (UX)—ensuring they are intuitive, visually engaging, and tailored to marketing users and revenue generators.
Collaborate with marketers and business developers to understand their workflows and design data tools that enhance usability and decision-making.
Champion UX best practices in dashboard layout, interactivity, and storytelling to drive adoption and engagement.
Ensure data quality, governance, and privacy/compliance.
Ensure the integrity and accuracy of data by identifying and correcting data quality issues.
Job Requirements
2-3+ years of experience in data architecture, business intelligence, or marketing analytics.
Proficiency in Python and SQL with the ability to apply them in data transformation, automation, and dashboard development.
Experience with the Microsoft data stack: Azure, Power BI, SQL Server, Power Automate, etc.
Experience with API development and integration, especially with marketing and CRM platforms.
Proven ability to design user-centric dashboards that balance technical depth with visual clarity and ease of use.
Solid understanding of UX principles as they apply to data visualization and self-service analytics.
Excellent communication skills and the ability to work cross-functionally with marketing and business teams.
Education
Bachelor's degree in Computer Science, Statistics, Mathematics, Business, or related field.
Minimum of 2 years of relevant experience.
Other
Valid authorization to work in the U.S.
The Company This is an opportunity to work with the Best. We are Michael Best & Friedrich, LLP. We are a full-service law firm with more than 350 lawyers and technical professionals who work in collaborative, interdisciplinary practices to serve clients around the world.
The Location We have offices in Wisconsin (Milwaukee, Madison, Manitowoc, Waukesha); Illinois (Chicago); Utah (Salt Lake City); Colorado (Denver, Broomfield); Texas (Austin); North Carolina (Charlotte, Raleigh, Wilmington); California (Los Angeles); Nebraska (Lincoln); and Washington DC. This position can be located in any of our offices.
Why You Should Apply At Michael Best, we offer a comprehensive Total Rewards package that includes competitive base pay, outstanding benefits, opportunities for learning and growth, and programs designed to help you plan for the future.
Learning and Growth
Challenging and Dynamic Role
Professional Growth Opportunities
Performance Management and Coaching
Specialized Training Programs
Medical
Vision Care
Health Savings Accounts
Flexible Spending Accounts
Wellness Program
Employee and Family Assistance Program
Total Compensation
Competitive Base Pay
Annual Merit Review/Incentive Pay
Planning for the Future
401(k) with Company Contribution
Short Term Disability Plan
Long Term Disability Plan
Life Insurance
Critical Illness Insurance
Parental/Family Leave
Culture and Workplace
Respected organization with Collaborative Culture
Growing Firm with an Exciting Future
Contemporary Work Environment
Positive and Respectful Work Climate
Performance Recognition
To be considered for this position, please submit an application via our online portal.
Recruitment Agencies: Michael Best is not accepting unsolicited agency resumes for this position. Please do not forward resumes to our careers email address or any Firm employees. Michael Best is not responsible for any fees related to unsolicited resumes.
Michael Best & Friedrich LLP, Michael Best Strategies LLC, and Michael Best Consulting LLC (collectively known as "Michael Best") are committed to providing equal employment opportunity and maintaining a workplace free from discrimination on the basis of age, race, religion, color, disability, marital status, sex (including pregnancy), national origin, ancestry, ethnicity, sexual orientation, gender identity or expression, genetic information, veteran or military status, or any other status protected by law.
If you need a reasonable accommodation for any part of the application process due to a medical condition or disability, please contact our Recruiting team at 414.225.4999 or careers@michaelbest.com.
#J-18808-Ljbffr
Data + Design BI Architect
to join our Marketing and Business Development team, with a focus on transforming complex revenue and marketing data into intuitive, actionable insights. This role is central to how we empower marketers and business developers with the tools they need to make data-driven decisions—through seamless data pipelines, smart integrations, and exceptional user experiences.
You'll help to architect and maintain a data infrastructure that supports revenue generation efforts as well as campaign performance tracking, customer segmentation, and strategic growth initiatives. Your work will directly influence how marketing and business development teams interact with data—making it accessible, engaging, and easy to act on.
Responsibilities
Design and maintain automated data pipelines that support business intelligence, marketing analytics, CRM integration, and campaign performance tracking.
Build and manage APIs that connect marketing platforms (e.g., Dynamics 365, ZoomInfo, LinkedIn, etc.) with internal systems.
Architect and optimize data models and datasets to support marketing KPIs, funnel analysis, and customer journey insights.
Collaborate with Data Analysts on the design and development of Power BI dashboards with a strong focus on user experience (UX)—ensuring they are intuitive, visually engaging, and tailored to marketing users and revenue generators.
Collaborate with marketers and business developers to understand their workflows and design data tools that enhance usability and decision-making.
Champion UX best practices in dashboard layout, interactivity, and storytelling to drive adoption and engagement.
Ensure data quality, governance, and privacy/compliance.
Ensure the integrity and accuracy of data by identifying and correcting data quality issues.
Job Requirements
2-3+ years of experience in data architecture, business intelligence, or marketing analytics.
Proficiency in Python and SQL with the ability to apply them in data transformation, automation, and dashboard development.
Experience with the Microsoft data stack: Azure, Power BI, SQL Server, Power Automate, etc.
Experience with API development and integration, especially with marketing and CRM platforms.
Proven ability to design user-centric dashboards that balance technical depth with visual clarity and ease of use.
Solid understanding of UX principles as they apply to data visualization and self-service analytics.
Excellent communication skills and the ability to work cross-functionally with marketing and business teams.
Education
Bachelor's degree in Computer Science, Statistics, Mathematics, Business, or related field.
Minimum of 2 years of relevant experience.
Other
Valid authorization to work in the U.S.
The Company This is an opportunity to work with the Best. We are Michael Best & Friedrich, LLP. We are a full-service law firm with more than 350 lawyers and technical professionals who work in collaborative, interdisciplinary practices to serve clients around the world.
The Location We have offices in Wisconsin (Milwaukee, Madison, Manitowoc, Waukesha); Illinois (Chicago); Utah (Salt Lake City); Colorado (Denver, Broomfield); Texas (Austin); North Carolina (Charlotte, Raleigh, Wilmington); California (Los Angeles); Nebraska (Lincoln); and Washington DC. This position can be located in any of our offices.
Why You Should Apply At Michael Best, we offer a comprehensive Total Rewards package that includes competitive base pay, outstanding benefits, opportunities for learning and growth, and programs designed to help you plan for the future.
Learning and Growth
Challenging and Dynamic Role
Professional Growth Opportunities
Performance Management and Coaching
Specialized Training Programs
Medical
Vision Care
Health Savings Accounts
Flexible Spending Accounts
Wellness Program
Employee and Family Assistance Program
Total Compensation
Competitive Base Pay
Annual Merit Review/Incentive Pay
Planning for the Future
401(k) with Company Contribution
Short Term Disability Plan
Long Term Disability Plan
Life Insurance
Critical Illness Insurance
Parental/Family Leave
Culture and Workplace
Respected organization with Collaborative Culture
Growing Firm with an Exciting Future
Contemporary Work Environment
Positive and Respectful Work Climate
Performance Recognition
To be considered for this position, please submit an application via our online portal.
Recruitment Agencies: Michael Best is not accepting unsolicited agency resumes for this position. Please do not forward resumes to our careers email address or any Firm employees. Michael Best is not responsible for any fees related to unsolicited resumes.
Michael Best & Friedrich LLP, Michael Best Strategies LLC, and Michael Best Consulting LLC (collectively known as "Michael Best") are committed to providing equal employment opportunity and maintaining a workplace free from discrimination on the basis of age, race, religion, color, disability, marital status, sex (including pregnancy), national origin, ancestry, ethnicity, sexual orientation, gender identity or expression, genetic information, veteran or military status, or any other status protected by law.
If you need a reasonable accommodation for any part of the application process due to a medical condition or disability, please contact our Recruiting team at 414.225.4999 or careers@michaelbest.com.
#J-18808-Ljbffr