200+ applicants

Company

Original Job Post

Stagwell · 3 days ago

Data Analyst

New York, NY

Full-time

Hybrid

Entry, Mid Level

$104K/yr - $130K/yr

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Asset Management

Insider Connection @Stagwell

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Build tabular and/or visualization reports in the Business Intelligence tool that help to articulate answer business questions that drive actions that improve the bottom line

Provide teams and individual stakeholders with actionable insights based on data to support decision making efforts

Design analytics dashboards and KPI (Key Performance Indicator) reports for internal teams to identify critical data points and translate data into clear and coherent visualizations and reports for non-technical teams

Collaborate with and offer insights into different internal teams from Data Warehouse and Engineering to Operations, Sales, Marketing and Finance

Communicate and present on technical information with non-technical team members and stakeholders

Troubleshoot and resolve data issues using critical thinking

Organize and lead meetings with business and operational data owners to collect business requirements and iterate through designs after receiving feedback from end users

Coordinate and communicate between business users and the data warehouse organization, balancing requirements, and resources to solve business problems

Work closely with engineering and operations to document business processes that have an impact on data quality

Identify data discrepancies and data quality issues and work with other analytic team members and SMEs to ensure data consistency and integrity. Proactively identify opportunities to improve existing BI processes, communicating these opportunities to internal teams.

Work independently and with team members to understand and document database structure and business processes

Extract raw data from numerous data sources and aggregate it into cohesive data sets via ETL (extracting, transforming and loading) to ensure data is accurate and stable

Note: These statements are intended to describe the essential functions of the job and are not intended to be an exhaustive list of all responsibilities. Skills and duties may vary dependent upon your department or unit. Other duties may be assigned as required.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data AnalysisData WarehousingData GovernanceBusiness AnalysisMS SQL ServerTSQLMS WordMS ExcelPowerPointProblem-SolvingCollaborationSelf-MotivatedTableauSSRSPowerBIMicrosoft Dynamics CRMMicrosoft Dynamics AXData Dictionary

Required

Bachelor’s degree or the equivalent experience in statistics, math, computer science, physics, finance, business administration, economics or a related field

Minimum 5 years of professional experience in technical data analysis, data warehousing, and data governance processes with proven business analysis experience

Experience with MS SQL Server and writing TSQL views, stored procedures, and functions

Passionate about data and analyzing business needs

Excellent computer skills and highly proficient in the use of MS Word, MS Excel, PowerPoint

Experience creating visually and verbally engaging presentations, for key stakeholders that tell a clear story using data and concepts

Comfortable working in a collaborative setting with business senior executives

Self-motivated requiring minimal supervision with a positive can-do attitude