Business Intelligence Developer

First Global Management Services•New York City, NY

14h•$102,000 - $118,000•Remote

About The Position

Building a Brand starts with a Story 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. Learn more at www.firstagency.com What You Would Get To Do 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

Requirements

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.
Detail oriented with a strong commitment to data accuracy and quality.
Creative problem solver who can translate complex concepts into intuitive visualisations.
Collaborative team player who works effectively with both technical and business stakeholders.
Self-motivated with ability to manage multiple priorities and deliver against deadlines.
Continuous learner who stays current with evolving BI technologies and best practices.
Clear communicator who can explain technical concepts to non-technical audiences.
Adaptable to changing business needs and requirements.
Curious and analytical thinker who looks beyond surface data to find deeper insights.

Nice To Haves

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 sector.
Understanding of AI and machine learning concepts as applied to business analytics.
Experience with Agile development methodologies.

Responsibilities

Design and build interactive dashboards and reports using BI tools such as Tableau, PowerBI, 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.

Benefits

Medical, Dental & Vision which includes the option of a high deductible health plan (HDHP) with a health savings account (HSA)
401 (k)
Five Flexible Spending Accounts Options
Generous Paid Time Off Allowance
Employee Assistance Program (EAP)
Life, Disability & Pet Coverages
Wellness Stipend
Complimentary access to Headspace, Teladoc, Maven, Rocket Lawyer, Mobilo & more
Aura Identity Theft Protection
Discretionary Bonus Structure
Global Opportunities: With a presence in 7 countries worldwide, including headquarters in London, New York, and Singapore, you may have the opportunity to work on exciting projects across different locations.