Senior Data Analyst

Akaasa Technologies; Dallas (TX); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Akaasa Technologies in Dallas/Miami—hybrid—seeks a Senior Data Analyst to turn complex data into actionable insights and compelling dashboards. You will design dbt models, optimize SQL, and partner with leaders to tell data-driven stories.

Candidate will work with Python/R for data manipulation and build Power BI visuals, leveraging AWS/Snowflake/Azure and orchestrating data pipelines with Airflow/NiFi. Collaborative, results-driven professionals thrive here.

Qualifications

• 3+ years of experience in data analysis or BI roles.
• Experience designing and maintaining data models and dashboards.
• Strong SQL and scripting skills for data transformation.

Responsibilities

• Conduct complex data analysis and derive insights to support business objectives.
• Create and maintain advanced reports and dashboards for stakeholders.
• Build and maintain dbt models across staging, intermediate, and 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).
• Collaborate with stakeholders to translate business questions into metrics and dashboards.
• Manage version control workflows for dbt projects (Git-based).
• Monitor data quality and troubleshoot pipeline failures.
• Utilize Python or R for advanced data manipulation and modeling.
• Create interactive Power BI visualizations and complex visual narratives.

Skills

Complex data analysis

Dashboard storytelling

Stakeholder communication

Mentoring/leadership

Tools

dbt

Power BI

AWS

Snowflake

Azure

Airflow

NiFi

Glue

Lambda

S3

Athena

Git

Python

R

Shell Script

Job description

Senior Data Analyst

Location: Dallas or Miami- hybrid

Key Responsibilities

• Conduct more complex data analysis and develop insights that support business objectives.
• Create and maintain more advanced reports and dashboards for various stakeholders.
• 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
• Exceptional ability to influence and engage senior leaders with data-driven insights.
• Expert in resolving complex, high-stakes problems with innovative solutions.
• Extensive experience with data pipeline orchestration tools (e.g., Apache Airflow, Luigi) and data integration platforms (e.g., Apache NiFi, Glue).
• Skilled at supporting and managing multiple projects and meeting deadlines
• Experience with statistical analysis and predictive modeling.
• Identify trends, patterns, and anomalies in data sets and present findings to senior analysts.
• Contribute to the development of best practices for data management and analysis
• Ability to work with large and complex data sets.
• Experience with programming (e.g., Python, Shell Script, SQL), data modeling, and developing features within hyperscaler cloud environments.
• Basic understanding of GitHub.