Data Analyst: SQL, BI Dashboards & Insights

Valiant Technologies LLC; Denver (CO); Vor Ort; USD 70.000 - 95.000; Vollzeit

Zusammenfassung

Valiant Technologies LLC is seeking a Data Analyst to collect, analyze, and present business data to guide strategic decisions. The role emphasizes SQL proficiency, dashboards, and collaboration with stakeholders to translate data into insights.

The ideal candidate will have hands-on experience with Power BI, Tableau, and Python or R, plus knowledge of data warehousing concepts and ETL/ELT processes.

Qualifikationen

• Four plus years of experience in Data Analytics or BI.
• Strong SQL skills with complex queries, joins, CTEs.
• Experience building dashboards/reports in Power BI or Tableau.
• Proficiency in Excel with Pivot Tables, VLOOKUP/XLOOKUP, formulas.
• Knowledge of Python or R for analytics.
• Experience with data cleaning, profiling, and quality checks.
• Understanding of ETL/ELT, data warehousing concepts.
• Familiarity with cloud data platforms and multiple data sources.
• Ability to translate business requirements into actionable analytics.

Aufgaben

• Collect, extract, organize, and analyze data from multiple sources.
• Write and optimize SQL queries for data retrieval and validation.
• Develop interactive dashboards and reports using Power BI, Tableau, or Looker.
• Identify trends, anomalies, and performance gaps; report findings.
• Perform data cleaning and reconciliation to ensure quality.
• Collaborate with stakeholders to deliver actionable insights.
• Prepare recurring and ad hoc management reports.
• Conduct root cause analysis for data discrepancies.
• Support ETL processes and coordinate with data engineering.

Kenntnisse

SQL

Excel

Power BI

Tableau

Looker

Python

R

ETL/ELT

Data quality

Dashboards

Cloud data platforms

SQL Server

PostgreSQL

BigQuery

Ausbildung

Bachelor's degree in CS/IT/Stats/Math/Data Analytics

Master's degree preferred

Power BI Data Analyst Associate

Tableau Desktop Specialist

Google Data Analytics Professional Certificate

Tools

SQL Server

Oracle

MySQL

PostgreSQL

Snowflake

Azure Synapse

AWS Redshift

Google BigQuery

Jobbeschreibung

Valiant Technologies LLC is seeking a Data Analyst to collect, analyze, and present business data to guide strategic decisions. The role emphasizes SQL proficiency, dashboards, and collaboration with stakeholders to translate data into insights.

The ideal candidate will have hands-on experience with Power BI, Tableau, and Python or R, plus knowledge of data warehousing concepts and ETL/ELT processes.