Data Analyst: Insights, Dashboards & SQL Expert

Artifintech; Aurora (CO); On-site; USD 70,000 - 100,000; Full time

Job summary

Artifintech is seeking an experienced Data Analyst to collect, analyze, and visualize business data to support decision-making. The candidate should demonstrate strong SQL, Excel, Python, Power BI, Tableau, data reporting, and statistical analysis skills.

The role involves building dashboards, creating KPIs, and delivering daily to monthly reports for stakeholders, with collaboration across data engineers and business teams. Equality and merit-based hiring are emphasized.

Qualifications

• Strong experience collecting, analyzing, interpreting, and visualizing business data
• Proficient in writing complex SQL queries to extract and manipulate data from relational databases
• Develop interactive dashboards and reports using Power BI and Tableau, and perform data reporting and statistical analysis

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.

Skills

SQL

Excel

Python

Power BI

Tableau

Data analysis

Statistics

ETL

Tools

Power BI Desktop

Tableau Desktop

SQL Server

Excel (Advanced)

Python (pandas)

Job description

Artifintech is seeking an experienced Data Analyst to collect, analyze, and visualize business data to support decision-making. The candidate should demonstrate strong SQL, Excel, Python, Power BI, Tableau, data reporting, and statistical analysis skills.

The role involves building dashboards, creating KPIs, and delivering daily to monthly reports for stakeholders, with collaboration across data engineers and business teams. Equality and merit-based hiring are emphasized.