Data Analytics & Engineering - Data Analyst III

Pyramid Consulting, Inc; United States; Remote; USD 90,000 - 101,000; Full time

Job summary

Pyramid Consulting, Inc. is seeking a Data Analytics & Engineering - Data Analyst III for a 06+ months contract, remote in the U.S. This role emphasizes defining data needs, building automated dashboards, and scaling ETL pipelines to support campaigns.

Ideal candidates have 5+ years in SQL, BI tool experience (Tableau, MicroStrategy), Python and R, and a STEM degree. AI tools experience and strong communication are a plus.

Qualifications

• 5+ years of SQL experience (Oracle, Vertica, Hive, MySQL, etc.).
• Proficiency in building and operating distributed data systems.
• Experience in ETL design, implementation and maintenance.
• Familiarity with BI tools and report automation.

Responsibilities

• Collaborate with growth marketers, program managers, and analytics teams to define data and metrics requirements.
• Design, build, and maintain automated reporting and dashboards to facilitate data-driven decisions.
• Build and optimize ETL processes to support marketing campaigns at scale.
• Write high-quality SQL queries to analyze data from various database systems.
• Partner with stakeholders to identify and resolve data integrity issues across reporting and data infrastructure.

Skills

SQL

Data analysis

Python

R

Communication

Self-management

Education

BA/BS in STEM

Tools

Tableau

MicroStrategy

ETL tools

Job description

Immediate need for a talented Data Analytics & Engineering - Data Analyst III. This is a 06+months contract opportunity with long-term potential and is located in U.S(Remote).

Job ID: 26-32746

Pay Range: $65/hr - $73/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

• Collaborate with growth marketers, program managers, and analytics teams to define data and metrics requirements.
• Design, build, and maintain automated reporting and dashboards to facilitate data-driven decisions.
• Build and optimize ETL processes to support marketing campaigns at scale.
• Write high-quality SQL queries to analyze data from various database systems.
• Partner with stakeholders to identify and resolve data integrity issues across reporting and data infrastructure.

Key Requirements and Technology Experience:

• 5+ years of experience with SQL (Oracle, Vertica, Hive, MySQL, etc.).
• Proficiency in building and operating distributed systems for data extraction, ingestion, and processing.
• Experience in ETL design, implementation, and maintenance.
• Familiarity with Business Intelligence tools (e.g., Tableau, MicroStrategy) and report automation.
• Strong skills in Python and R.
• Ability to self-manage projects and set expectations.
• BA or BS degree in a STEM field.
• Experience in AI-centric organizations or using AI tools.
• Proven track record of building data pipelines and working with large datasets.
• Strong interpersonal skills, including effective written and oral communication.

Our client is a leading IT Industry, and we are currently interviewing to fill this and other similar contract positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.