Data Analyst

Robotic Technologies Automation; Denver (CO); On-site; USD 85,000 - 125,000; Full time

Job summary

Robotic Technologies Automation is seeking a Data Analyst to collect, analyze, and present business data to support strategic decisions. The role emphasizes strong SQL, data visualization, and dashboard development to deliver actionable insights.

The ideal candidate will transform complex datasets into meaningful business intelligence and collaborate with stakeholders to drive operational improvements. This position is based in Denver with on-site work expectations.

Qualifications

• 4+ years of experience in Data Analytics, BI, or related field.
• Strong SQL skills and data visualization experience.
• Experience building dashboards and reports with Power BI/Tableau/Looker.
• Proficiency in Excel and data manipulation techniques.
• Understanding of data modeling, statistics, and reporting.

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, Tableau, or Looker.
• Identify trends, anomalies, and performance gaps through data analysis.
• Perform data cleaning, profiling, reconciliation, and quality checks.
• Translate requirements into analytical reports, dashboards, and KPIs.
• Collaborate with stakeholders to deliver actionable insights.
• Prepare recurring and ad hoc reports for management and operations.
• Support ETL processes and coordinate with data engineering to improve accuracy.
• Document data definitions, reporting logic, and business rules.
• Present findings and recommendations to technical and non-technical audiences.

Skills

SQL

Power BI

Tableau

Looker

Python

R

Excel

ETL/ELT

Data Warehousing

Education

Bachelor's degree in Computer Science/IT/Statistics/Data Analytics

Master's degree in Data Science/Analytics (preferred)

Tools

Power BI

Tableau

Looker

SQL Server

Oracle/MySQL/PostgreSQL

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.