LERMA/ is a multicultural advertising agency that channels creativity for good. Our Data & Analytics team empowers insight-driven creativity by transforming data into actionable intelligence. We close the gap between information and impact — turning numbers into narratives that inspire smarter strategies, more relevant storytelling, and measurable growth.
Role Overview
The Business Intelligence Intern supports the Data & Analytics team in developing and maintaining business intelligence solutions that power marketing insights for our clients.
This role provides hands-on exposure to modern analytics workflows in an agency environment. The intern will work closely with both the Business Intelligence and Digital Analytics teams to help validate data, support dashboard development, and assist with the preparation of marketing and digital analytics datasets used in reporting and analysis.
This position is designed as both a learning opportunity and a potential pipeline to full-time analytics roles, giving interns exposure to real marketing data, digital analytics data, analytics tools, and business decision-making.
What Will Your Day Look Like?
As a Business Intelligence Intern, you will support the Data & Analytics team across several areas of the reporting lifecycle. Responsibilities may include:
- Assist with data validation and quality assurance to ensure marketing and digital analytics data is accurate and consistent across reporting systems.
- Support the development and maintenance of dashboards and automated reports used by internal teams and client stakeholders.
- Perform basic SQL queries to explore datasets and help prepare data for analysis.
- Help document data definitions, reporting methodologies, and analytics workflows to support team knowledge sharing.
- Assist with cleaning and modeling datasets from marketing platforms, digital analytics tools, and other data sources.
- Collaborate with BI engineers and digital analysts to support reporting updates and data investigations.
- Participate in team discussions to understand how data informs marketing performance, user behavior, and business decisions.
What Do You Bring to the Table?
We are looking for curious problem-solvers who enjoy working with data and want to learn how analytics supports marketing and business strategy.
Preferred qualifications include:
- Current upper-level undergraduate student or early-career professional interested in data, analytics, or marketing technology.
- Foundational knowledge of SQL and basic statistics.
- Interest in working with data warehouses and business intelligence tools.
- Strong attention to detail and ability to spot inconsistencies in data.
- Comfort working with structured datasets and learning new technical tools.
- Strong communication skills and curiosity about how data supports business decisions.
- Ability to collaborate in a fast-paced, team-oriented environment.
Bonus but not required:
- Experience with dashboard tools (Looker Studio, Tableau, Power BI, or similar).
- Coursework or projects involving data analysis, reporting, or visualization.
- Familiarity with digital analytics platforms such as Google Analytics (GA4) or similar tools.
What You’ll Learn
During this internship, you will gain experience with:
- Understanding how modern marketing analytics and digital analytics ecosystems operate.
- Working with data warehouses and SQL-based analytics workflows.
- Building and maintaining client-facing dashboards.
- Ensuring data quality and reporting accuracy across marketing and web analytics data.
- Translating raw data into insights that support marketing strategy and user experience optimization.
Why Join LERMA/?
You’ll work alongside a collaborative analytics team that values curiosity, creativity, and continuous learning. At LERMA/, data plays a critical role in shaping meaningful marketing strategies, and interns have the opportunity to contribute to real projects that impact our clients and campaigns.