Senior Data Engineer

Piper Companies is looking for a Senior Data Engineer for a client of ours that partners for all your real estate and financial needs in Horsham, PA.

Responsibilities for the Data Engineer:

• Write complex SQL queries to move data from various source systems (flat files, SQL Server databases, xls files, JSON files, etc) into the data warehouse
• Create reconciliation processes to ensure data is loaded into the data warehouse completely and accurately.
• Create Implement row and column-based security, error handling and logging processes in the data warehouse
• Work closely with the data modelers, data analysts, and QA team to ensure that the data is properly loaded into the data warehouse
• Exceptional analytical skills

• Exceptional knowledge of data warehousing concepts and best practices
• Strong oral and written communications skills,
• Meticulous and detail-oriented
• Must be a problem solver, critical thinker, self-motivated and possess integrity and a strong work ethic
• Ability to work independently on concurrent tasks and adhere to deadlines
• Ability to easily adapt to changing priorities
• Ability to meet high expectations for precision and accuracy
• High degree of initiative and intellectual curiosity

Qualifications for the Senior Data Engineer:

• 8+ years experience performing data engineering in a data warehouse environment
• Deep knowledge of database structures, normalization, de-normalization and entity relationships
• Deep knowledge of data warehouse concepts and best practices
• Strong data manipulation and data analysis skills
• Ability to work both independently as well as a team
• Experience working in an Agile environment
• Experience in a financial services industry preferred

Benefits for the Senior Data Engineer include:

• Comprehensive benefit package; Medical, Dental, Vision, 401k, and Paid Time Off

• No Sponsorship