Data Analyst

Ethereum Technologies LLC; Denver (CO); On-site; USD 70,000 - 110,000; Full time

Job summary

Ethereum Technologies in Denver, CO seeks a Data Analyst to collect, analyze, and present business data to support strategic decisions and operational improvements.

The role emphasizes strong SQL, Excel, and data visualization skills, with experience in Power BI/Tableau and familiarity with Python or R for analysis and automation. You will develop dashboards, validate data quality, and collaborate with stakeholders.

Qualifications

• 4+ years of experience in Data Analytics, BI, or related field.
• Strong SQL skills with complex queries and window functions.
• Experience building dashboards in Power BI or Tableau.
• Proficiency in Excel: PivotTables, VLOOKUP/XLOOKUP, charts.
• Familiarity with Python or R for analysis and automation.
• Knowledge of data warehousing, ETL/ELT, and data integration.
• Experience with multiple relational databases and cloud platforms.
• Understanding of statistical methods and data modeling.

Responsibilities

• Collect, extract, organize, and analyze data from multiple sources.
• Write and optimize SQL queries to transform and validate datasets.
• Develop interactive dashboards and reports using Power BI or Tableau.
• Identify trends, anomalies, and performance gaps through analysis.
• Perform data cleaning, profiling, and quality checks.
• Translate requirements into analytic reports and KPIs.
• Collaborate with stakeholders to deliver actionable insights.
• Prepare recurring and ad hoc management reports.
• Support ETL processes and coordinate with data engineering teams.
• Document data definitions, reporting logic, and business rules.
• Present results to technical and non-technical audiences.

Skills

SQL

Excel

Power BI

Tableau

Python

R

Data wrangling

ETL/ELT

Education

Bachelor's degree in CS/IT/Stats

Master's preferred

Tools

SQL Server

Oracle

MySQL

PostgreSQL

Power BI

Tableau

Looker

Snowflake

Azure Synapse

AWS Redshift

BigQuery

Job description

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.