Business Intelligence Developer

FIRST is a leading global brand experience agency serving clients in various industries, including financial services, technology, new & traditional media, aerospace, healthcare, and professional services. FIRST has received numerous accolades, including being listed among the 2025 Most Innovative Marketing Agencies of the Year by Chief Marketer, named Top Agency of the Year 2024 by Event Marketer, highlighted as a Global Agency of the Year, over 100 Employees by C&IT, and listed among the "200 Top Marketing Agencies" in 2024, 2023, & 2022 by Chief Marketer.

The Business Intelligence Developer is a key role within FIRST’s Business Intelligence and Data Analytics function, reporting to the Director of Data and Analytics. You will be responsible for designing, developing, and maintaining dashboards, reports, and business intelligence solutions that transform FIRST's operational data into actionable insights. This role is central to empowering data-driven decision making across the organization and supporting FIRST's evolution into an intelligence-driven partner in the brand experiences sector.

Your Contributions

• Design and build interactive dashboards and reports using BI tools such as Tableau, Power
  
  BI, or similar platforms.
• Create visualizations that effectively communicate complex data insights to both technical and non-technical users.
• Develop standard and custom reports for internal performance tracking and client-facing analytics.
• Implement self-service reporting capabilities for business users across departments.
• Ensure dashboards and reports are optimized for performance, usability, and accessibility.
• Design, develop, and maintain ETL processes to integrate data from multiple sources.
• Create data transformation workflows that prepare raw data for analysis and reporting.
• Implement data quality checks and validation rules within ETL processes.
• Automate routine data processing tasks to ensure timely availability of information.
• Monitor and troubleshoot data integration issues to maintain data reliability.
• Contribute to the design and implementation of FIRST's data warehouse structure.
• Create and maintain dimensional models, fact tables, and reporting views.
• Implement data partitioning, indexing, and query optimization techniques.
• Support data governance initiatives through proper metadata management.
• Collaborate with data engineers to ensure alignment between data architecture and reporting needs
• Engage with business users to understand reporting requirements and analytical needs.
• Translate business questions into technical specifications for reports and dashboards.
• Provide guidance on best practices for data visualization and interpretation.
• Validate solutions with stakeholders to ensure they meet business objectives.
• Document business requirements and technical implementations for knowledge sharing.
• Research and evaluate emerging BI tools and technologies.
• Propose improvements to existing reporting processes and solutions.
• Develop standardized templates and components to accelerate dashboard development.
• Contribute to the establishment of best practices for BI development.
• Support the integration of AI capabilities into reporting solutions.

What We Are Looking For

Please be aware that we know experience does not always look like we describe it. If you believe you would be an excellent fit for this role, please apply - we would love to see how you could fit at FIRST.

• 3+ years of experience in business intelligence development.
• Bachelor's degree in computer science, Information Technology, Business Analytics, or related field.
• Strong proficiency with Tableau.
• Experience with SQL and data manipulation languages.
• Knowledge of ETL processes and tools.
• Understanding of data warehouse concepts and dimensional modelling.
• Demonstrated ability to translate business requirements into effective BI solutions.
• Experience working with financial and operational data in a business context.
• Certifications in relevant BI platforms or data technologies.
• Experience with Cloud-based data platforms.
• Knowledge of Python, R, or other programming languages for advanced analytics.
• Familiarity with the event management industry or professional services…