Data analyst

Ampstek; Dallas (TX); On-site; USD 80,000 - 120,000; Full time

Job summary

Ampstek is seeking a BI Analyst to design and maintain dashboards in Tableau and Looker Studio, standardize KPIs, and validate data across systems. You will work with data/engineering on data availability and transformations, delivering concise executive insights from complex datasets.

Responsibilities include partnering with cross-functional teams to ensure reporting accuracy and dashboard usability, driving business decisions with data-driven recommendations.

Qualifications

• Experience building BI dashboards and data visuals.
• Ability to define and standardize KPIs and metrics.
• Strong data validation, reconciliation, and quality-check skills.
• Proficiency in SQL (Teradata) for data investigation.
• Experience analyzing revenue, spend, customers, product and operations data.
• Ability to create executive-level reports with clear insights.
• Collaboration with data/engineering on data sources and transformations.

Responsibilities

• Build and maintain BI dashboards in Tableau and Looker Studio.
• Define and standardize business KPIs and reporting metrics.
• Perform data validation, reconciliation and quality checks across source systems and reporting layers.
• Use SQL/Teradata to investigate data issues and answer business questions.
• Analyze revenue, spend, customer, product and operational data to identify trends and exceptions.
• Create executive reporting that converts complex data into concise business insights.
• Partner with data/engineering teams on source data availability, transformations, and reporting requirements.
• Improve dashboard usability and maintainability through reusable controls, filters, and standardized reporting structures.

Skills

Tableau

Looker Studio

SQL

Teradata

KPI definition

Data validation

Data reconciliation

Executive reporting

Data analysis

Dashboard usability

Job description

• Build and maintain BI dashboards in Tableau and Looker Studio.
• Define and standardize business KPIs and reporting metrics.
• Perform data validation, reconciliation and quality checks across source systems and reporting layers.
• Use SQL/Teradata to investigate data issues and answer business questions.
• Analyze revenue, spend, customer, product and operational data to identify trends and exceptions.
• Create executive reporting that converts complex data into concise business insights.
• Partner with data/engineering teams on source data availability, transformations, and reporting requirements.
• Improve dashboard usability and maintainability through reusable controls, filters, and standardized reporting structures.