Cloud Computing, Computer Workstations, Data Analysis, Data Management, Data Quality, Data Sets, Data Visualization, Database Extract Transform and Load (ETL), Identify Issues, Looker, MicroStrategy, Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Query Optimization, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Scalable System Development, Tableau, Web Programming
Job Title: Data Engineer & Analytics (BigQuery | SQL | Reporting | MicroStrategy)
Location: Philadelphia, PA
Employment Type: Contract
Job Summary
We are seeking an experienced Data Engineer & Analytics professional with strong expertise in Advanced SQL, BigQuery, Reporting, and Data Visualization. The ideal candidate will have experience building scalable data pipelines, optimizing SQL queries, working with large datasets, and developing high-performance reporting solutions using MicroStrategy, Tableau, or Looker.
Required Skills
- 7+ years of experience in Data Engineering and Analytics.
- Strong hands-on experience with Advanced SQL and query optimization.
- Experience working with Google BigQuery.
- Expertise in designing and optimizing ETL/ELT data pipelines.
- Experience handling and analyzing large-scale datasets.
- Strong understanding of reporting, analytics, and data visualization concepts.
- Ability to translate complex technical data into meaningful business insights.
Preferred Skills
- Tableau or Looker.
- Vertica and Vertica client tools (SQL Workbench, DBeaver, vsql).
- MicroStrategy Developer, Web, and Workstation.
- Experience optimizing MicroStrategy reports for performance and scalability.
- Experience building cloud-based data pipelines.
Key Responsibilities
- Develop and optimize complex SQL queries on BigQuery and Vertica.
- Design, build, and maintain scalable cloud data pipelines.
- Develop and optimize reports and dashboards for business stakeholders.
- Work with large datasets to deliver high-quality analytics solutions.
- Optimize reporting performance and ensure data accuracy.
- Collaborate with business and technical teams to gather reporting requirements and deliver actionable insights.
- Support data validation, troubleshooting, and production issue resolution.
T
Tech3pillars Technologies