Bachelor's degree in business, Statistics, Computer Science, or a related quantitative field preferred.
Advanced proficiency in Microsoft Excel, including VLOOKUP and pivot tables; 2+ years of experience desired.
Expertise in Power BI development, including data modeling and DAX expressions.
Strong ability to analyze data, identify trends, and create clear narratives from numbers.
Exceptional analytical and problem-solving skills with a keen attention to detail.
Strong written and verbal communication skills, particularly in presenting to executives.
Ability to manage multiple projects and meet tight deadlines in a fast-paced environment.
Responsibilities
Design and maintain accurate monthly, quarterly, and annual reports using advanced Excel functions.
Extract, clean, and transform data from various sources to ensure accuracy and consistency.
Conduct ad-hoc analyses and special projects to support business initiatives with data-driven recommendations.
Create visually appealing charts and infographics in Excel and PowerPoint to communicate insights.
Build professional PowerPoint decks with effective design and embedded media.
Collaborate with operational teams to gather reporting requirements and define metrics.
Identify opportunities to enhance reporting processes and automate routine tasks.
Develop and manage interactive dashboards in Power BI to monitor key performance indicators.
Benefits
Fully onsite position at the 34th Street office in New York City, Monday through Friday.
Full Job Description
POSITION SUMMARY:
Sr. Business & Data Analyst
This position is in our Operations Center of Excellence directly supporting senior leadership, operation executives, and external customers for all business-related reporting. This position is fully onsite at our 34th Street office in New York City, Monday through Friday
Responsibilities include:
Design, develop, and maintain accurate and timely monthly, quarterly, and annual reports using advanced Excel functions (pivot tables, complex formulas).
Extract, clean, and transform data from multiple sources to ensure data accuracy, consistency, and integrity across all reports.
Conduct ad-hoc analyses and special projects as needed to support specific business initiatives and provide data-driven recommendations.
Design visually appealing charts, graphs, and infographics in Excel and PowerPoint to communicate key insights.
Build professional, brand-compliant PowerPoint decks with effective slide design, animation, and embedded media.
Partner with operational and cross-functional teams to gather reporting requirements, define metrics, and translate business needs into effective analytics solutions.
Identify opportunities to enhance existing reporting processes and automate routine tasks to improve efficiency and reduce manual effort.
BI Dashboard Development: Create, optimize, and manage interactive and visually compelling dashboards and reports in Power BI to monitor key performance indicators (KPIs) across various business functions.
Qualifications:
Preferred bachelor's degree in business, Statistics, Computer Science, or a related quantitative field experience
Advanced proficiency in Microsoft Excel (VLOOKUP, pivot tables, Power Query a plus). 2+ Years of experience desired
Demonstrated expertise in Power BI development, including data modeling, DAX expressions, and data visualization.
Ability to understand data, identify trends, and translate numbers into clear narratives.
Exceptional analytical and problem-solving abilities with meticulous attention to detail.
Strong written and verbal communication skills, including experience presenting to executive audiences.
Ability to manage multiple projects simultaneously, prioritize tasks, and meet tight deadlines in a fast-paced environment.
