Lead Data Engineer - Reporting & Visualization in Philadelphia

Job Description

Required Skills (Must Have)

✅ 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