Data Engineer

Ardmore, PA 19003

Posted: 11/03/2025 Employment Type: Direct Hire Position Category: Information Technology Job Number: 18308 Work Location: Hybrid

Job Description

Our client, an organization located in Center City, Philadelphia has retained Top Stack to assist them in hiring a Data Engineer  to join their team. This is a hybrid (Tues/Wed/Thurs in office and Mon/Fri work from home), full-time, salaried position with a competitive base, annual bonus, and a comprehensive benefits package.
In this role, there would be a strong focus on data engineering and SQL. You would be building and maintaining robust data pipelines, ETL processes, and scalable data models to support analytics and reporting across the organization.


RESPONSIBILITIES:
  • Design, develop, and maintain ETL processes using SSIS and Python, ensuring accuracy and efficiency of data.
  • Develop and optimize SQL scripts, stored procedures, and queries for large, complex datasets in SQL Server data warehouses.
  • Collaborate with stakeholders to define data requirements, build data models, and deliver analytical solutions that drive decisions.
  • Support and enhance Tableau dashboard and SSRS reports, ensuring data consistency and usability.
  • Monitor, troubleshoot, and optimize existing workflows and data pipelines for performance and reliability .
  • Identify opportunities to improve data quality, architecture and BI processes.
  • Provide documentation and communicate project progress and updates to BI leadership and business stakeholders.
  • Support both FP&A and Business Intelligence teams in day-to-day operations, analysis, and reporting.
  • Utilize proprietary AI tools to enhance reporting accuracy, streamline workflows, and uncover new insights.
REQUIREMENTS:
  • Strong proficiency in SQL – complex joins, stored procedures, indexing and query optimization.
  • Hands-on experience with SSIS for ETL and data ingestion.
  • Strong foundation in Microsoft Excel; familiarity with pivot tables, advanced formulas, and data modeling.
  • Experience with Tableau for reporting and visualization is a plus.
  • Exposure to SSRS and SSAS is a plus.
  • Exposure to Python for data analysis or automation is a plus.
EDUCATION AND EXPERIENCE:
  • Bachelor's Degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
  • 3-5 years of relevant experience in business intelligence or data development roles.
  • Familiarity with service-based industries and/or financial systems (e.g., general ledger) is a plus.
  • Understanding of data warehousing concepts, such as star/snowflake schema design is a plus.
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Ardmore, PA

Ready to embark on a new career adventure? Explore exciting job opportunities in the vibrant Ardmore, Pennsylvania area! Nestled in Montgomery County, Ardmore offers a perfect blend of suburban charm and urban convenience. With renowned landmarks like the Lower Merion Historical Society and local theaters such as Ardmore Music Hall, this area is rich in culture and entertainment. Indulge in the diverse cuisine along Lancaster Avenue or catch a game at the nearby Citizens Bank Park to cheer on the Philadelphia Phillies. Ardmore also boasts easy access to recreational areas like Merion Golf Club and the lush trails of Haverford Reserve. Don't miss out on the chance to grow your career in this dynamic and enchanting region!