Direct Hire or CTH!
Must be able to work without sponsorship
Hybrid schedule (onsite 3 days a week)
Our client is a leading provider of nutrition and healthy solutions with a focus on transforming healthy living for adults. They are currently looking for a Senior Data Engineer to join their team. This is a hybrid position requiring 3 days on site at their brand-new Fort Washington, PA office.
The Role of Senior Data Engineer will use their skills in T-SQL, Data Transformation, ETL, and Data Warehouse implementations to complete the ongoing legacy Datawarehouse implementation and migration project. The Enterprise Data Warehouse (EDW) is the corporate repository of integrated operational data. Our client is moving from on-premises management of its Data Warehouse and Business Intelligence to cloud Data Management and reporting. Working with EIS and offshore resources, this role will lead the development of the cloud DW while supporting the current DW environment.
This position will work with external data and system vendors to exploit cutting edge Data Management technologies and integrate/export data following the client’s security guidelines.
Working with IT and business resources, support the Data Warehouse strategy and Business Intelligence initiatives: • Lead development activities to migrate the current on-premises SQL Server DW to Snowflake on AWS. • Gather requirements for Data Warehouse improvements and translate them to high level design documents including Physical Data Models. Provide technical architecture vision and recommend strategy/solutions. • Design and develop transformation processes and data structures for the Data Warehouse following best practice procedures. • Lead resolution of Data Warehouse load issues. • Support the analytical needs of the business users. Build strong relationships to help identify opportunities to enhance the analytical capabilities of the Data Warehouse. • Partnering with business stakeholders and technical report developers, establish, maintain, and promote consistent methodology for reporting and analytics deployment. Perform ad hoc data analysis to meet business unit data validation needs. • Participate in Data Quality initiatives and lead the data transformation component design to improve and maintain high quality data. Support performance tuning. • Foster teamwork through cooperative interactions with co-workers. Where needed, ensure project integration by communicating activities and status to project manager, appropriate project team members, and business users.
• BS degree, preferably in Information Technology, Management Information Systems, Computer Science, or similar discipline. • Post-college training in Data Management and vendor tool use • 5-8+ years of Data Engineering and Warehousing
This role serves as the primary technical resource for managing and moving data in and out of the Data Warehouse. The candidate must:
Possess advanced T-SQL and SQL coding skills
Be well versed in Data Warehouse design concepts
Senior level Data Transformation skills
Have hands-on experience with ETL and ELT methodologies and tools.
Have experience with SQL Server 2016 and SSIS.
Experience with business reporting requirements analysis.
Familiarity with Data Management and Business Intelligence tools, such as Business Objects, Microsoft Power BI, QlikSense, Tableau, Looker, AWS S3 and Redshift, or Snowflake.
Demonstrated ability to clearly communicate with all levels within an organization.
Have experience leading small or offshore development teams
Understanding and experience with building and deploying Business Intelligence and analytics applications.
Familiarity with Financial, Sales, Marketing, and Logistics reporting environments.
Strong analytical skills, excellent communication
Preferred candidates will have experience with: • Analytics design and development is preferred.
• Hands on development experience with .Net or understanding of Microsoft Dev Stack is a plus.
• Comfortable working in a fast-paced team. Capable of grasping new concepts quickly and acting with a sense of urgency.