Data Analyst

Valiant Technologies LLC; Denver (CO); Sur place; USD 70 000 - 95 000; Plein temps

Résumé du poste

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.

Qualifications

• 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.

Responsabilités

• 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.

Connaissances

SQL

Excel

Power BI

Tableau

Looker

Python

R

ETL/ELT

Data quality

Dashboards

Cloud data platforms

SQL Server

PostgreSQL

BigQuery

Formation

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

Outils

SQL Server

Oracle

MySQL

PostgreSQL

Snowflake

Azure Synapse

AWS Redshift

Google BigQuery

Description du poste

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Position Overview:

The Data Analyst will be responsible for collecting, analyzing, interpreting, and presenting business data to support strategic decision-making and operational improvements. The ideal candidate will have strong SQL skills, experience with data visualization tools, and the ability to transform complex datasets into meaningful business insights. This role involves developing reports and dashboards, identifying trends, validating data quality, and collaborating with business stakeholders to deliver actionable analytical solutions.

Data Analytics Technologies & Technical Expertise:

Strong proficiency in SQL, including complex queries, joins, subqueries, CTEs, and window functions.

Hands-on experience with Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, charts, and advanced formulas.

Experience with data visualization tools such as Power BI, Tableau, or Looker.

Knowledge of Python or R for data analysis, statistical analysis, and automation.

Experience with data cleaning, transformation, validation, and reconciliation.

Understanding of data warehousing concepts, ETL/ELT processes, and data integration.

Experience working with relational databases such as SQL Server, Oracle, MySQL, or PostgreSQL.

Knowledge of statistical methods, trend analysis, forecasting, and data modeling.

Familiarity with cloud data platforms such as Snowflake, Azure Synapse, AWS Redshift, or Google BigQuery.

Experience developing interactive dashboards, reports, and KPI scorecards.

Understanding of data governance, data quality, and metadata management.

Knowledge of business intelligence and reporting best practices.

Key Data Analysis Responsibilities:

Collect, extract, organize, and analyze data from multiple business sources.

Write and optimize SQL queries to retrieve, transform, and validate datasets.

Develop interactive dashboards and reports using Power BI, Tableau, or similar tools.

Identify business trends, patterns, anomalies, and performance gaps through data analysis.

Perform data cleaning, profiling, reconciliation, and quality checks.

Translate business requirements into analytical reports, dashboards, and KPIs.

Collaborate with business stakeholders to understand reporting needs and deliver actionable insights.

Prepare recurring and ad hoc reports for management and operational teams.

Perform root cause analysis to investigate data discrepancies and business performance issues.

Support ETL processes and coordinate with data engineering teams to improve data accuracy.

Document data definitions, reporting logic, analytical findings, and business rules.

Present analytical results and recommendations to technical and non-technical stakeholders.

Experience & Professional Competencies:

4+ years of experience in Data Analytics, Business Intelligence, Reporting, or a related field.

Strong hands-on experience writing SQL queries and performing data analysis.

Experience building dashboards and reports using Power BI or Tableau.

Proficiency in Excel and data manipulation techniques.

Understanding of statistical analysis, data modeling, and business reporting.

Experience working with large datasets and multiple data sources.

Knowledge of Python or R for analytical tasks is preferred.

Strong analytical thinking, attention to detail, and problem-solving abilities.

Excellent communication and presentation skills with the ability to explain complex data findings.

Academic Qualifications & Preferred Certifications:

Bachelor's degree in Computer Science, Information Technology, Statistics, Mathematics, Data Analytics, or a related field.

Master's degree in Data Science, Business Analytics, or a related discipline is preferred.

Relevant certifications such as Microsoft Certified: Power BI Data Analyst Associate, Tableau Desktop Specialist, Google Data Analytics Professional Certificate, or similar credentials are an advantage.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.