BI Developer

The BI Developer will be responsible for designing, developing, and maintaining business intelligence solutions that support data-driven decision-making across the consumer goods organization. The role will focus on creating interactive dashboards, data visualizations, and reports to provide actionable insights to teams such as marketing, sales, product management, and supply chain. The BI Developer will also ensure the integrity and accuracy of data, while optimizing processes to deliver timely and valuable insights.

The BI Developer will be based in Needham, MA. 

Key Responsibilities:

1. BI Solution Development:
• Design, develop, and maintain interactive reports, dashboards, and visualizations using BI tools such as Power BI, Tableau, or Qlik.
• Create custom reports and data models based on business requirements from various teams, such as marketing, sales, finance, and supply chain.
• Build and optimize queries to retrieve data from multiple sources, including databases, data warehouses, ERP systems, CRM systems, and other business tools.
2. Data Modeling and Integration:
• Design data models that integrate data from multiple internal and external sources, ensuring data is accurate, consistent, and reliable for reporting.
• Collaborate with data engineers and IT teams to ensure the smooth integration of data from multiple systems, such as SAP, Oracle, or other ERP platforms.
• Develop ETL processes to prepare data for reporting and analytics purposes, ensuring data is transformed and loaded into the appropriate data storage platforms.
3. Cross-Functional Collaboration:
• Work closely with stakeholders from sales, marketing, product management, and finance teams to understand business needs and translate them into BI solutions.
• Collaborate with data scientists and analysts to support advanced analytics initiatives, such as predictive modeling, consumer segmentation, and product performance analysis.
• Partner with IT teams to ensure the scalability, security, and performance of BI tools and platforms.
4. Data Analysis and Reporting:
• Analyze large datasets to provide insights into key business metrics, such as sales performance, product trends, consumer behavior, and supply chain efficiency.
• Develop ad-hoc reports to support business initiatives, such as product launches, promotional campaigns, and inventory management.
• Deliver insights that support decision-making, drive business strategies, and enhance operational efficiency.
5. Data Governance and Quality Assurance:
• Ensure data quality and consistency by implementing data validation checks and maintaining data governance policies.
• Collaborate with data governance teams to ensure compliance with data privacy regulations, such as GDPR and CCPA, and industry best practices for data management.
• Monitor BI tools and systems to ensure the accuracy and reliability of reports, dashboards, and data visualizations.
6. Training and Support:
• Provide training and support to end users on how to use BI tools effectively, ensuring they understand how to access and interpret data.
• Act as a subject matter expert for BI tools, offering guidance and troubleshooting support to non-technical users across the organization.

Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Business Analytics, or a related field.
• 3+ years of experience as a BI Developer or in a similar data-centric role.
• Proficiency in BI tools such as Power BI, Tableau, Qlik, or Looker.
• Strong SQL skills for querying and manipulating data from relational databases (e.g., SQL Server, MySQL, PostgreSQL).
• Experience in building and optimizing data models and ETL processes.
• Familiarity with cloud platforms such as AWS, Google Cloud, or Azure is a plus.

Preferred Skills:

• Experience in the consumer goods industry or a related sector, with a strong understanding of consumer behavior, market trends, and product performance metrics.
• Familiarity with ERP systems like SAP, Oracle, or Microsoft Dynamics.
• Knowledge of data visualization best practices and UX/UI principles for dashboard design.
• Strong analytical skills with the ability to interpret complex data and present actionable insights to non-technical stakeholders.

Key Competencies:

• Strong problem-solving skills with the ability to troubleshoot issues and optimize reporting processes.
• Excellent communication skills with the ability to collaborate with cross-functional teams and present findings to business leaders.
• Attention to detail with a focus on data accuracy and quality.
• Ability to work independently and manage multiple projects in a fast-paced environment.