Data Analyst

Title: Data Analyst

Department: IT

Supervises: N/A

Role Type: Full-time

Location: New York NY (Hybrid)

ABOUT THE COMPANY:

Anchin is a New York City based Certified Public Accounting and Consulting firm with a Long Island and Florida presence that provides expert financial advisory to companies across a diverse range of industries. We offer a full range of integrated accounting consulting and business management services from tax planning and audits to the most detailed analysis of acquisitions and financial restructuring.

Anchin is consistently recognized as one of the Best of the Best accounting firms in the country a Best Place to Work in New York City and New York State and a Best Accounting Firm to Work For Nationwide.

ABOUT THE POSITION:

We are looking for a highly capable Data Analyst who can turn data into clarity. This person will play a key role in the Information Technology Department at Anchin in helping the organization understand what is happening in our business why it is happening and what we should do about it. You will work closely with stakeholders across teams translate their questions into meaningful analysis and deliver insights that inform better decisions.

This is a role for someone who is both technically strong and intellectually curious. You should be comfortable working with large complex data sets be meticulous about data quality and take pride in presenting information in a clear and compelling way.

RESPONSIBILITIES:

• Design build debug and maintain queries views and stored procedures in MS SQL to extract transform and prepare data for analysis.
• Develop and enhance interactive dashboards in Power BI that provide clear actionable insights.
• Maintain and create new SSRS Reports.
• Gather requirements from business stakeholders and translate them into data models analyses and visualizations.
• Clean validate and reconcile datasets to ensure accuracy and reliability.
• Identify trends patterns and anomalies in data and explain their implications in plain language.
• Partner with business leaders to frame problems test assumptions and propose data driven recommendations.
• Document data definitions sources and logic to support transparency and repeatability.
• Provide excellent and timely service to internal customers.

QUALIFICATIONS:

Education:

• Bachelors degree in a relevant field such as data analytics data science mathematics or computer science.

What We are Looking for:

• Strong proficiency in MS SQL including the mutation of data schemas and the creation and maintenance of existing complex queries and stored procedures and performance tuning.
• Experience with the software development lifecycle and best practices.
• A cautious test-first approach when working with production databases.
• Deep experience with Power BI including data modeling DAX and dashboard design best practices.
• Demonstrated ability to gather clean analyze and interpret complex datasets.
• A structured analytical mindset with a problem solving orientation.
• Attention to detail paired with a practical sense of what matters most to the business.
• Comfort working independently while collaborating effectively with cross functional teams.

Experience:

• 3 to 5 years of experience in a data analyst or similar role.
• Experience working with financial operational or business performance data.
• Familiarity with data governance principles and documentation practices.
• Experience with SQL Server Reporting Services (SSRS) SQL Stored Procedures Version Control and Microsoft Excel are required.
• Experience with SharePoint is a plus specifically managing and organizing data assets within SharePoint including document libraries and lists.

Compensation:

• Competitive compensation in the range of $100000 to $120000 based on the individuals experience level.

Anchin provides comprehensive benefits which you can view here.

Attributes:

• Accountability: Follows through on commitments does what you say you will do even requiring some personal sacrifice.
• Communicates Effectively: Delivers messages in a clear and concise manner listens attentively.
• Strong Interpersonal Skills: Relates comfortably to all levels of people both internally and externally.
• Nimble Learner: Learns quickly when facing new situations willingly takes on the challenge of unfamiliar tasks.
• Technical Proficiency: Deals with technical issues comfortably and can complete work at a high level of proficiency.
• Technologically Proficient: Ability to apply technology solutions to work.
• Being Resilient: Shows confidence under pressure maintains a positive attitude despite adversity.
• Action Oriented: Proactively seeks out new and challenging work.
• Trustworthiness: Keeps confidences and develops a reputation for being honest and ethical.

Anchin is an equal opportunity employer who agrees not to discriminate against any employee or job applicant irrespective of race color creed alienage religion sex national origin age disability gender (including gender identity) marital status sexual orientation citizenship or any other characteristic protected by law. Anchin is committed to providing access equal opportunity and reasonable accommodation for individuals with disabilities in employment its services programs and activities. To request reasonable accommodation contact Anchin Recruitment Team at