Data Analyst

Ampcus, Inc; McLean (VA); On-site; USD 70,000 - 95,000; Full time

Job summary

Ampcus, Inc is seeking a skilled Data Analyst in McLean, VA. The role involves managing data infrastructure, building dashboards, and executing marketing segmentation tasks. Candidates must have a strong background in data analysis and expertise with tools like Databricks, Snowflake, and Tableau.

The ideal candidate will effectively manage data pipelines, create automated dashboards, and support marketing campaign logic. This position is vital for ensuring data reliability and stakeholder satisfaction.

Qualifications

• Relevant experience in data analysis and infrastructure management.
• Proven abilities in dashboard creation and technical execution.
• Experience in audience validation and code governance for campaigns.

Responsibilities

• Manage data infrastructure, including pipeline creation and maintenance.
• Build and maintain automated dashboards for various stakeholders.
• Execute marketing segmentation tasks for email and APEX campaigns.

Skills

Data analysis

Infrastructure management

Dashboard creation

Familiarity with Databricks

Familiarity with Snowflake

Familiarity with Tableau

Familiarity with APEX

Tools

Databricks

Snowflake

Tableau

APEX

Job description

Job Title: Data Analyst

Location: Mclean, VA

Job Summary

We are seeking skilled Data Analysts to join our team. The role involves managing data infrastructure, building monitoring dashboards, and executing marketing segmentation tasks. The position requires technical expertise in data pipeline management, dashboard creation, and campaign logic maintenance.

Key Responsibilities

• Data Infrastructure Management - 2 DA Contractors
  • Ownership of pipeline creation, maintenance, documentation, and productionization.
  • Map data infrastructure to document SOT for each metric, upstream dependencies, and potential critical points of failure.
  • Own, update and optimize associated Databricks jobs and document ongoing maintenance plans.
  • Assess and productionalize Snowflake collab tables, develop transition documentation, and migrate to production.
  • Set up automated alerting for critical data dependencies and experience flows.
• Monitoring Dashboard & Maintenance - 2 DA Contractors
  • Build and maintain automated dashboards for product, BA, and leadership use.
  • Audit current Tableau suite to determine sunset vs optimization for existing dashboards.
  • Work with stakeholders to understand monitoring needs across teams & experiences.
  • Deliver monitoring proposal and build required dashboards, maintaining them for the contract duration.
• Marketing / Launch Segmentation - 2 DA Contractors
  • Technical execution, audience validation, and code governance for email and APEX campaigns.
  • Build, validate and maintain logic for email and APEX campaigns.
  • Conduct code reviews with the BA team to ensure accuracy.

Required Qualifications

Candidates should possess relevant experience in data analysis, infrastructure management, and dashboard creation. Familiarity with tools such as Databricks, Snowflake, Tableau, and APEX is essential.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.