Lead Data Engineer - Reporting & Visualization in Philadelphia

Energy Jobline
Philadelphia, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Philadelphia, United States of America

Tech stack

Data analysis
Big Data
Google BigQuery
Information Engineering
Data Visualization
Database Queries
MicroStrategy
Performance Tuning
SQL Databases
Tableau
Technical Data Management Systems
Freeform SQL
Vertica
Looker Analytics
Data Pipelines
Database Tools and Utilities

Requirements

Advanced SQL expertise (Query Writing, Performance Tuning & Optimization)

Strong hands-on experience with BigQuery

Experience working with large-scale datasets

Strong SQL development and tuning experience on Vertica

Skills (Good to Have)

Reporting & Data Visualization

Tableau

Looker

Vertica Client Tools (SQL Workbench, DBeaver, vsql, etc.)

MicroStrategy Developer

MicroStrategy Web

MicroStrategy Workstation

Key Responsibilities

Write, optimize, and tune complex SQL queries on Vertica

Work efficiently with large datasets to support analytical reporting needs

Demonstrate strong understanding of MicroStrategy concepts including Attributes, Facts, and Hierarchies

Translate complex technical data into meaningful dashboards, reports, and visual insights

Optimize MicroStrategy reports for scalability and performance

Design, develop, and support data pipelines using cloud platforms

Ideal Candidate

10+ years of Data Engineering and Analytics experience

Strong expertise in SQL, BigQuery, and Vertica

Experience with enterprise reporting and visualization platforms

Ability to transform business requirements into actionable insights and reporting solutions

Apply for this position