Data Insights Analyst - SQL, Dashboards & Automation

Machine Learning Technologies, LLC; Aurora (CO); On-site; USD 70,000 - 95,000; Full time

Job summary

Machine Learning Technologies, LLC in Aurora, CO, seeks an experienced Data Analyst to collect, analyze, and visualize business data to support decision-making. You will build interactive dashboards using Power BI and Tableau, perform SQL queries, and deliver regular reports to stakeholders.

The role involves collaboration with data engineers, business analysts, and management teams to identify trends, ensure data quality, and automate recurring reports for efficiency.

Qualifications

• Experience collecting, cleaning, validating, and analyzing large datasets.
• Ability to write complex SQL queries to extract data from relational databases.
• Experience developing dashboards and reports with Power BI and Tableau.

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 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 solutions.
• Prepare presentations and communicate analytical findings to stakeholders.
• Support BI and data-driven decision-making initiatives.

Skills

SQL

Excel

Python

Power BI

Tableau

Data reporting

Statistical analysis

Tools

Power BI

Tableau

Excel

Job description

Machine Learning Technologies, LLC in Aurora, CO, seeks an experienced Data Analyst to collect, analyze, and visualize business data to support decision-making. You will build interactive dashboards using Power BI and Tableau, perform SQL queries, and deliver regular reports to stakeholders.

The role involves collaboration with data engineers, business analysts, and management teams to identify trends, ensure data quality, and automate recurring reports for efficiency.