Data + Design Business Intelligence Architect

Michael Best & Friedrich LLP; Milwaukee (WI); On-site; USD 78,000 - 83,000; Full time

Benefits offered by this job

401(k) with Company Contribution

Comprehensive health benefits

Professional growth opportunities

Job summary

A full-service law firm is seeking a Data + Design Business Intelligence Architect in Milwaukee. This role involves designing data pipelines and user-centric dashboards that help in marketing decisions, ensuring data integrity, and working closely with business teams to enhance usability. A bachelor's degree and 2-3 years of experience in data architecture or marketing analytics are required. The company offers competitive compensation ranging from $78,000 to $83,000 annually.

Qualifications

• 2-3+ years of experience in data architecture or business intelligence.
• Proficiency in Python and SQL for data transformation.
• Experience with Microsoft data stack and API development.

Responsibilities

• Design and maintain automated data pipelines for marketing analytics.
• Build APIs connecting marketing platforms with internal systems.
• Collaborate with Data Analysts to design user-centric dashboards.

Skills

Data architecture

Business intelligence

Marketing analytics

Python

SQL

API development

User experience design

Communication skills

Education

Bachelor’s degree in Computer Science, Statistics, Mathematics, Business, or related fields

Tools

Azure

Power BI

SQL Server

Power Automate

Job description

Data + Design Business Intelligence Architect

Join to apply for the Data + Design Business Intelligence Architect role at Michael Best & Friedrich LLP.

Michael Best is looking for a Data + Design Business Intelligence 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 most importantly, exceptional user experiences.

You’ll help architect and maintain a data infrastructure that supports revenue generation efforts, 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 compliance with privacy standards.
• Ensure the integrity and accuracy of data by identifying and correcting data quality issues.

Qualifications

• 2‑3+ years of experience in data architecture, business intelligence, or marketing analytics.
• Proficiency in coding languages such as 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 fields.
• Minimum of 2 years of relevant experience.

Other

• Valid authorization to work in the U.S.

Company

This is an opportunity to work with the best. We are Michael Best & Friedrich, LLP, 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. We work with companies in all kinds of industries, as well as trade associations, nonprofits, educational institutions, governments, family trusts, and high‑net‑worth individuals. Since our firm’s founding in 1848, we’ve continuously evolved to meet our clients’ changing needs and expectations.

Location

We have offices in Wisconsin (Green Bay, Madison, Milwaukee, Waukesha); Illinois (Chicago); Utah (Salt Lake City); Colorado (Denver, Broomfield); Texas (Austin); North Carolina (Charlotte, Durham, Raleigh, Wilmington); California (Los Angeles); Nebraska (Lincoln); and Washington DC. This position can be based in our Denver or Milwaukee office.

Why You Should Apply

At Michael Best, we are proud to offer a comprehensive and competitive Total Rewards package that provides a variety of resources designed to enhance our employees’ overall well‑being, both at work and at home. Competitive base pay, outstanding benefits, opportunities for learning and growth, programs designed to help you plan for the future, and perks that inspire your downtime are all part of our total compensation package.

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

Compensation for this position will range from $78,000 - $83,000, depending on experience and location.

To be considered for this position, please submit an application (including resume and brief cover letter) 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.

Referrals increase your chances of interviewing at Michael Best & Friedrich LLP by 2x.

Michael Best & Friedrich LLP and Michael Best Strategies LLC (collectively known as "Michael Best") are steadfastly committed to providing equal employment opportunity and maintaining a workplace for employees and applicants for employment that is free from discrimination based upon 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 applicable federal, state, or local law.

If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application process, please contact our Recruiting team at 414.225.4999 or [e-mail] to let us know the nature of your request and your contact information.