Data Analyst

Ethereum Technologies; Aurora (CO); On-site; USD 65,000 - 90,000; Full time

Job summary

Ethereum Technologies seeks an experienced Data Analyst to collect, analyze, interpret, and visualize business data for informed decision-making. The role requires strong SQL, Excel, Python, Power BI, and Tableau skills, plus data reporting and statistical analysis to deliver actionable insights for stakeholders.

You will create dashboards, reports, and KPIs, collaborate with data engineers and management, and automate recurring reports to improve efficiency.

Qualifications

• Experience collecting, cleaning, and validating large datasets.
• Ability to write complex SQL queries for data extraction and manipulation.
• Proficiency in building interactive dashboards and reports.

Responsibilities

• Collect, clean, validate, and analyze large datasets from multiple sources.
• Write complex SQL queries to extract and manipulate data from relational databases.
• Develop interactive dashboards and reports using Power BI and Tableau.
• Perform data analysis to identify trends, patterns, and insights.
• Create daily, weekly, and monthly reports for business stakeholders.
• Perform data cleansing, transformation, and validation to ensure data accuracy.
• Work with business teams to understand reporting requirements and objectives.
• Develop KPIs, metrics, and performance reports to track business performance.
• Use advanced Excel functions, Pivot Tables, VLOOKUP, XLOOKUP, and Power Query.
• Perform exploratory data analysis to identify trends and anomalies.
• Automate recurring reports and improve reporting efficiency.
• Collaborate with data engineers, business analysts, and management teams.
• Identify data quality issues and recommend solutions.
• Prepare presentations and communicate analytical findings to stakeholders.

Skills

SQL

Excel

Python

Power BI

Tableau

Data Reporting

Statistical Analysis

Tools

Power BI

Tableau

Power Query

Job description

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

We are looking for an experienced Data Analyst responsible for collecting, analyzing, interpreting, and visualizing business data to support organizational decision-making. The candidate should have strong experience in SQL, Excel, Python, Power BI, Tableau, data reporting, and statistical analysis.

Roles and Responsibilities

• Collect, clean, validate, and analyze large datasets from multiple sources.
• Write complex SQL queries to extract and manipulate data from relational databases.
• Develop interactive dashboards and reports using Power BI and Tableau.
• Perform data analysis to identify business trends, patterns, and insights.
• Create daily, weekly, and monthly reports for business stakeholders.
• Perform data cleansing, transformation, and validation to ensure data accuracy.
• Work with business teams to understand reporting requirements and business objectives.
• Develop KPIs, metrics, and performance reports to track business performance.
• Use advanced Excel functions, Pivot Tables, VLOOKUP, XLOOKUP, and Power Query.
• Perform exploratory data analysis (EDA) to identify trends and anomalies.
• Automate recurring reports and improve reporting efficiency.
• Collaborate with data engineers, business analysts, and management teams.
• Identify data quality issues and recommend appropriate solutions.
• Prepare presentations and communicate analytical findings to stakeholders.
• Support business intelligence and data-driven decision-making initiatives.

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.