Senior Data Analyst

Come for the Challenge. Stay for the Experience. At HCVT, we believe every challenge presents an opportunity to positively impact our clients and people. Talented and ambitious individuals who seek limitless professional opportunities thrive at HCVT. Our team is known for its technical skill and ability to help clients address complex business issues all while investing in and supporting our people to provide a rewarding employee experience. What We Do and Who We ServeWe offer Tax, Audit, Advisory, and Business Management services to our clients, which include private and public companies, high-net-worth individuals, and family offices. We also specialize in serving clients across the following industries: Private Equity, Real Estate & Hospitality, Media & Entertainment, High-Net-Worth Individuals, Manufacturing & Distribution, Professional Services Firms, Technology, Healthcare, Nonprofit Organizations, and Affordable Housing.    We Live Our Core Values Our values guide us in our day-to-day interactions with our clients and each other—Integrity at our Core; Building Success Together; Passion for Excellence; and Diversity, Equity, & Inclusion. We are focused and committed to the needs of our clients and our team.  Discover How Far You Can Go. Opportunities abound at HCVT. Our firm has experienced steady growth since its founding in 1991 and continues to expand its client service offerings, creating new opportunities for professionals to grow their careers. We make significant investments in training and provide interesting, diverse, and intellectually stimulating client engagements for our teams to work on—the kind of work that helps you develop and refine your skills to advance in the profession.  Hybrid WorkAt HCVT, we embrace a hybrid work model that offers a balance between in-office collaboration and remote convenience.  Our teams work a minimum two days a week in the office, unless noted otherwise in the job description, complemented by in-person trainings, meetings, and team-building activities to foster your growth and deepen team connections. These trainings and events may take place outside of your home office location.
Apply today and find out why so many come for the challenge—and stay for the experience. We look forward to meeting you! 
Our advisory team is dedicated to providing data-driven insights and strategic direction to our clients. We are a dynamic and innovative group that values expertise, collaboration, and a commitment to excellence.
As a Senior Data Analyst in our Advisory practice, you will be responsible for creating high-quality reports and analysis, finding data-driven insights our clients can leverage to make better business decisions. The ideal candidate will have a strong foundation in data analytics and business analysis, as well as extensive experience working with databases, data warehouses, SQL, Power BI, Excel and other common analytics tools.
Work hours will match working hours in the U.S. [13:00-22:00, dinner break (one hour between 17:00-18:00)] The working hours can be flexible during the day, but you will work with your US team to ensure some of your work hours overlaps with your US team’s schedule.  

As a Senior Data Analyst in our Armenia office, you will be responsible for the following:

• Design, develop, and maintain executive reporting dashboards in Power BI, Tableau, and Looker, summarizing key business insights for clients.
• Extract, clean, and transform data to prepare for reporting, using SQL and Snowflake, Big Query, and other data warehouse tools.
• Create advanced analyses and forecasting models in Excel, including revenue projection models, customer cohort models, expense projections, and other key reports.
• Suggest KPIs for clients to track, based on their long-term goals and operating targets. 

To be successful, these are the skills, qualities and experience you will need:

• Bachelor’s degree in Data Science, Computer Science, Business, or a related field.
• 5+ years of experience in data analysis, business intelligence, or a related field.
• Proven experience as a business analyst.
• Advanced proficiency in SQL for data extraction, manipulation, and analysis, including CTEs, variables, subqueries, window functions, and advanced SQL aggregation functions.
• Expertise in Power BI, including advanced DAX, and preferably M for data modeling and reporting.
• Excellent knowledge of Excel, including advanced functions and data analysis.
• Experience in data visualization and dashboard creation.
• Familiarity with data warehousing concepts and ETL processes.
• Strong analytical and problem-solving skills.
• Strong attention to detail, and pride in creating high-quality work.
• Ability to clearly present complicated analytics to non-technical stakeholders.

Preferred Qualifications:

• Master’s degree in Computer Science, Engineering, or a related field.
• Basic knowledge of Python.
• Knowledge of Machine Learning models.

The ordinance requires employers to state, in all job solicitations, postings and advertisements, that the employer will consider applicants in a manner consistent with the requirements of the Fair Chance Initiative.
The ordinance requires employers to state, in all job solicitations, postings and advertisements, that the employer will consider applicants in a manner consistent with the requirements of the Fair Chance Initiative.