Business Intelligence Specialist

Summary

Be part of an amazing storyMacy's is more than just a store. We're a story. One that's captured the hearts and minds of America for more than 160 years. A story about innovations and traditions…about inspiring stores and irresistible products…about the excitement of the Macy's 4th of July Fireworks, and the wonder of the Thanksgiving Day Parade. We've been part of memorable moments and milestones for countless customers and colleagues. Those stories are part of what makes this such a special place to work.Job OverviewThe Business Intelligence Developer will develop reporting solutions that enable better decision-making across Marketing and partner teams. This role blends technical execution with emerging analytics trends, helping translate business questions into clear, accurate, and actionable outputs.Working within a cross-functional data environment, the BI Developer partners with analysts, developers, and stakeholders to support the end-to-end lifecycle of BI products, from dataset creation and data validation through dashboard delivery and maintenance. This position reports to the Director of Marketing Product Management, under the Vice President of Marketing Effectiveness.What You Will DoData & Dashboard DevelopmentSupport creation and maintenance of Power BI datasets, dashboards, and reportsWrite and refine SQL queries to extract, transform, and validate dataAssist in building semantic models and ensuring metric definitions are consistent and accurateContribute to dashboard UX, ensuring clarity, usability, and alignment to stakeholder needsPerform QA and validation checks to maintain data integrity across systemsMaintain and update existing dashboards to ensure continued relevance and performanceUnderstand and use AI and agentic solutions to improve report creation, validation, and maintenanceHelp document datasets, dashboards, and business logic for transparency and reuseCollaborate with Data Engineering teams to understand upstream data pipelines and dependencies, identifying root causes for data issuesBusiness Insights & PartnershipIdentify trends, patterns, and insights within datasets and communicate findings clearlySupport development of narratives and storytelling within dashboards and presentationsCollaborate closely with BI developers and business partners (e.g., marketing stakeholders)Keep ahead of emerging trends in data, analytics, business intelligence, as well as AI and agentic solutions in this areaSkills You Will NeedTechnical SkillsWorking knowledge of Power BI (data modeling, data integrity, DAX exposure, dashboard design)Foundational SQL skills for querying and data manipulationUnderstanding of data structures (tables, joins, schemas, metric logic)Well-versed in Excel and/or other BI tools (e.g., Tableau)Exposure to data pipelines or warehouse concepts is a plusAnalytical & Business SkillsStrong analytical thinking and attention to detailAbility to interpret data and identify meaningful insightsBasic understanding of business metrics and performance measurementStrong communication skills; able to explain data in simple, clear termsCuriosity and willingness to build domain knowledge in marketing/productWho You Are1-3 years of experience in business intelligence, analytics, or a related fieldExperience building dashboards or working with structured datasets preferredExposure to enterprise data environments in marketing, retail, or finance a plusAwareness of AI and agentic trends in reporting, analysis, and insightsRegularly required to sit, talk, hear; use hands/fingers to touch, handle, and feel. Occasionally required to move about the workplace and reach with hands and arms. Requires close vision.Able to work a flexible schedule, including days, evenings, weekends, and holidays, based on department and company needs.

Job Description

Be part of an amazing storyMacy's is more than just a store. We're a story. One that's captured the hearts and minds of America for more than 160 years. A story about innovations and traditions…about inspiring stores and irresistible products…about the excitement of the Macy's 4th of July Fireworks, and the wonder of the Thanksgiving Day Parade. We've been part of memorable moments and milestones for countless customers and colleagues. Those stories are part of what makes this such a special place to work.Job OverviewThe Business Intelligence Developer will develop reporting solutions that enable better decision-making across Marketing and partner teams. This role blends technical execution with emerging analytics trends, helping translate business questions into clear, accurate, and actionable outputs.Working within a cross-functional data environment, the BI Developer partners with analysts, developers, and stakeholders to support the end-to-end lifecycle of BI products, from dataset creation and data validation through dashboard delivery and maintenance. This position reports to the Director of Marketing Product Management, under the Vice President of Marketing Effectiveness.What You Will DoData & Dashboard DevelopmentSupport creation and maintenance of Power BI datasets, dashboards, and reportsWrite and refine SQL queries to extract, transform, and validate dataAssist in building semantic models and ensuring metric definitions are consistent and accurateContribute to dashboard UX, ensuring clarity, usability, and alignment to stakeholder needsPerform QA and validation checks to maintain data integrity across systemsMaintain and update existing dashboards to ensure continued relevance and performanceUnderstand and use AI and agentic solutions to improve report creation, validation, and maintenanceHelp document datasets, dashboards, and business logic for transparency and reuseCollaborate with Data Engineering teams to understand upstream data pipelines and dependencies, identifying root causes for data issuesBusiness Insights & PartnershipIdentify trends, patterns, and insights within datasets and communicate findings clearlySupport development of narratives and storytelling within dashboards and presentationsCollaborate closely with BI developers and business partners (e.g., marketing stakeholders)Keep ahead of emerging trends in data, analytics, business intelligence, as well as AI and agentic solutions in this areaSkills You Will NeedTechnical SkillsWorking knowledge of Power BI (data modeling, data integrity, DAX exposure, dashboard design)Foundational SQL skills for querying and data manipulationUnderstanding of data structures (tables, joins, schemas, metric logic)Well-versed in Excel and/or other BI tools (e.g., Tableau)Exposure to data pipelines or warehouse concepts is a plusAnalytical & Business SkillsStrong analytical thinking and attention to detailAbility to interpret data and identify meaningful insightsBasic understanding of business metrics and performance measurementStrong communication skills; able to explain data in simple, clear termsCuriosity and willingness to build domain knowledge in marketing/productWho You Are1-3 years of experience in business intelligence, analytics, or a related fieldExperience building dashboards or working with structured datasets preferredExposure to enterprise data environments in marketing, retail, or finance a plusAwareness of AI and agentic trends in reporting, analysis, and insightsRegularly required to sit, talk, hear; use hands/fingers to touch, handle, and feel. Occasionally required to move about the workplace and reach with hands and arms. Requires close vision.Able to work a flexible schedule, including days, evenings, weekends, and holidays, based on department and company needs.