As a Data Analyst II, your primary objective is to turn raw data into insights that help guide business decisions. You will leverage SQL, Python, and Tableau to develop and maintain data-driven dashboards, automate key reporting processes, and conduct in-depth analyses that inform sales, finance, operations, and product strategies. While you will work closely with data engineers to ensure smooth data flowspotentially within AWS Redshift, Databricks, or other cloud environmentsyour focus will be on interpreting data, identifying trends, and translating these findings into actionable recommendations. This role demands strong analytical skills, effective communication, and a proactive approach to continuous improvement within the data analytics function.
Accountabilities
- Data Analysis & Reporting
- Develop advanced SQL queries to combine and analyze data from Salesforce, financial systems, operational logs, and other sources.
- Design and maintain Tableau dashboards, providing clear visual insights for cross-functional stakeholders.
- Use Python for data wrangling, automation, and deeper statistical analyses when necessary.
- Collaboration & Stakeholder Engagement
- Work closely with sales, finance, operations, and product teams to gather requirements and deliver targeted analytics solutions.
- Present findings and recommendations in a clear, concise manner to both technical and non-technical audiences.
- Collaborate with data engineering teams to troubleshoot data quality issues and optimize data pipelines.
- Data Integrity & Process Optimization
- Ensure data accuracy and consistency across various reporting platforms, investigating discrepancies and proposing solutions.
- Continuously refine data models and analytical frameworks to support business growth and evolving needs.
- Maintain comprehensive documentation of analytics processes, methodologies, and dashboards for future reference.
- Continuous Improvement & Innovation
- Stay updated on industry best practices, emerging technologies, and new analytical tools.
- Identify opportunities for workflow automation, new data sources, and advanced analytical techniques to enhance overall efficiency.
- Support the data management team in both day-to-day operations and larger strategic initiatives.
Requirements
- Proficiency in SQL for complex querying, data manipulation, and performance optimization.
- Advanced Tableau skills for creating user-friendly dashboards and visualizations.
- Working knowledge of Python, especially for data analysis (e.g., Pandas) and scripting.
- Familiarity with AWS services (e.g., S3, Redshift) or Databricks is a plus.
- Solid understanding of data modeling and ETL concepts.
- Ability to communicate insights effectively to both technical and non-technical stakeholders.
- Experience with Agile methodologies and collaborative tools is beneficial.
Qualifications
- Bachelor's degree in a relevant field (e.g., Computer Science, Data Analytics)
- Minimum two years of experience in data analytics or a closely related field.
- Proven track record of developing impactful dashboards and data solutions in Tableau.
- Strong SQL skills, with exposure to large datasets and complex joins/aggregations.
- Python programming experience for scripting, automation, or advanced analytics.
- Demonstrated ability to work in cross-functional teams and translate data insights into strategic recommendations.
- Ability to quickly learn and apply enterprise AI tools and technologies to support technical workflows and business objectives
