Senior Data Analyst: Dashboards, Data Modeling & SQL Pro

VSG Business Solutions LLC; Dallas (TX); Hybrid; USD 120,000 - 170,000; Full time

Job summary

VSG Business Solutions LLC in Dallas/Miami hybrid is seeking a data professional to conduct complex analyses, build dashboards, and maintain dbt models across staging, intermediate, and mart layers.

You will write SQL, use Python or R for data manipulation, ensure data quality, and collaborate with senior leaders to translate questions into actionable metrics. This role offers hybrid work with onsite interviews and exposure to cloud data platforms.

Qualifications

• Proficient SQL for data transformation and analysis.
• Experience with Python or R for advanced data manipulation.
• Experience building dbt models and maintaining data pipelines.

Responsibilities

• Conduct complex data analyses and derive insights for business objectives.
• Create and maintain dashboards and reports for stakeholders.
• Build and optimize dbt models across staging, intermediate, and mart layers.
• Write and optimize SQL for data transformation and analysis.
• Design data validation and testing processes (dbt tests, source freshness checks).
• Maintain data docs, dictionaries, and 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.
• Support visualization best practices and complex visualizations (Power BI).
• Investigate trends and anomalies, presenting findings to senior analysts.

Skills

SQL

Python

R

Power BI

dbt

Data Modeling

GitHub

Airflow

NiFi

Cloud (AWS/Azure)

ETL

Pandas / NumPy

Tools

dbt

Power BI

SQL

Python

R

GitHub

Apache Airflow

Apache NiFi

AWS

Azure

Snowflake

S3

Lambda

Glue

Appflow

Athena

Job description

VSG Business Solutions LLC in Dallas/Miami hybrid is seeking a data professional to conduct complex analyses, build dashboards, and maintain dbt models across staging, intermediate, and mart layers.

You will write SQL, use Python or R for data manipulation, ensure data quality, and collaborate with senior leaders to translate questions into actionable metrics. This role offers hybrid work with onsite interviews and exposure to cloud data platforms.