Sr. Data Analyst

Akaasa Technologies; Dallas (TX); Ibrido; USD 90.000 - 140.000; Tempo pieno

Descrizione del lavoro

Akaasa Technologies is seeking a Sr. Data Analyst to join a hybrid team with 3 days in the office and 2 days remote.

The role focuses on data analysis of the Data Lake, developing dbt models, and delivering insights through Power BI dashboards in Snowflake environments across Dallas, TX or Miami, FL. Responsibilities include building dbt models, writing SQL, validating data, maintaining documentation, and guiding junior analysts while collaborating with stakeholders to translate business

Competenze

• Experience building and maintaining dbt models across layers.
• Proficient SQL for data transformation and analysis.
• Design and enforce data testing/validation (dbt tests, source freshness).
• Maintain dbt docs and data dictionaries.
• Translate business questions into metrics and dashboards.
• Manage dbt project version control (Git).
• Monitor data quality and troubleshoot pipelines.
• Advanced data cleaning: normalization, handling categorical variables, merging datasets.
• Experience with Python (pandas, NumPy) or R for data manipulation.
• Create interactive dashboards in Power BI with complex visualizations.
• Knowledge of data visualization best practices and custom visuals.
• Understand data models to support reporting needs.
• Familiar with AWS, Snowflake, Azure.
• Familiar with AWS Glue, AWS Appflow, Lambda, S3, Funnel, Athena.
• Support CI/CD workflows for dbt deployments.

Mansioni

• Partner with stakeholders to translate business questions into metrics and dashboards.
• Develop and maintain analytics data models to support reporting.
• Collaborate with data engineers to ensure data quality.
• Support CI/CD workflows for dbt deployments.
• Create and publish Power BI dashboards for business users.
• Document data lineage and data dictionaries.

Conoscenze

dbt models

SQL

Data testing

Documentation

Power BI

Git

Data quality

Python

R

Data storytelling

Data modeling

AWS

Snowflake

Azure

dbt CI/CD

Formazione

Bachelor's degree in a related field

Strumenti

dbt

Snowflake

Power BI

Python

R

SQL

AWS

Azure

Git

AWS Glue

AWS Appflow

Lambda

S3

Athena

dbt CI/CD

Descrizione del lavoro

POSITION

Sr. Data Analyst

Start date & Location

Hybrid with 3 days a week in office and 2 days remote

Dallas, TX or Miami, FL

REQUIRED SKILLS

Note: In this Sr Data Analyst role, You will work closely with analysis of data in our Data Lake and provide meaningful insights for Business Users Using dbt model, Power BI Dashboards and Datasets in Snowflake.

• Build and maintain dbt models (staging, intermediate, mart layers)
• Write and optimize SQL for data transformation and analysis
• Design and enforce data testing/validation (dbt tests, source freshness checks)
• Maintain documentation (dbt docs, data dictionaries, lineage)
• Partner with stakeholders to translate business questions into metrics/dashboards
• Manage version control workflows for dbt projects (Git-based)
• Monitor data quality and troubleshoot pipeline failures.
• Proficient in advanced data cleaning techniques, such as normalization, handling categorical variables, and merging datasets.
• Experience using tools like Python (pandas, NumPy) or R for complex data manipulation
• Ability to create interactive dashboards (Power BI), use calculated fields, and design complex visualizations that tell a compelling data story.
• Knowledge of best practices in data visualization and experience with custom visualizations.
• Understanding of how to create and maintain data models to support business reporting needs.
• AWS, Snowflake, Azure
• AWS Glue, AWS Appflow, Lambda, S3, Funnel, Athena
• Support CI/CD workflows for dbt deployments

Qualifications

• Bachelor's degree in a related field; advanced coursework or certifications preferred.
• Ability to articulate data-driven insights clearly to a diverse audience.
• Identifies issues in data and processes, proposing effective solutions.
• Builds strong working relationships across teams and functions.
• Provide guidance and support to Data Analyst 1 in their daily tasks.
• Upholds ethical standards and sets a positive example for junior team members.
• Manages complex challenges with poise, maintaining focus under pressure.
• Actively contributes to change initiatives and encourages innovation within the team.
• Collaborates effectively with other departments to achieve shared goals.
• Takes on leadership roles in projects, mentoring junior analysts and guiding team efforts.
• Holds self and others accountable for meeting deadlines and achieving quality outcomes.