What are the responsibilities and job description for the Data Engineer position at Top Stack?
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.
