Jr. Business Intelligence Analyst

• Work with business and technology partners to define measurement plans for Business Intelligence and Data Warehouse solutions combining disparate data types for Sales, Financial, Operational and Media performance.
• Assist in developing data cleansing rules
• Perform data QA to ensure dashboard integrity
• Analyze, map, and refine requirements then ensure the developed outcome meets the business needs
• Train business users on best practices for leveraging reports and dashboards
• Assist in development of data visualizations, including automated and ad hoc reports, dashboards, and analyses in MS Power BI to distribute data insights in an easily digestible manner to internal / external clients
• Ability to recognize and analyze data patterns and discrepancies

• Bachelor’s degree in related field
• Experience working with Google Cloud Platform products preferred (BigQuery & Dataprep)
• 1-2 years working primarily with Microsoft Power BI (connecting data from multiple sources, building visualizations and reporting dashboards)
• Proficient in DAX, M language
• Intermediate knowledge of Microsoft Excel (pivot, lookup, table creation)
• General understanding of digital advertising, digital media strategy, ad placement type, placement-level insight, and standard media metrics
• Experience managing and coordinating efforts across various teams/offices
• Excellent presentation skills & and attention to detail
• Excellent verbal, written and interpersonal communication skills.
• Self-starter, motivated and desire to grow within the organization.
• Ability to work independently and as part of a team
• Ability to manage multiple projects simultaneously while meeting deadlines

Zimmerman Advertising