Overview
On Site
USD 120,000.00 - 150,000.00 per year
Full Time
Skills
Software development methodology
Data profiling
Extract
transform
load
Technical analysis
Data warehouse
Business intelligence
Requirements elicitation
Acceptance testing
Relational databases
Flat file
Web services
Data modeling
Cloud computing
Problem solving
Computer science
Information Technology
Data
SQL
Optimization
Testing
Collaboration
Dashboard
Leadership
Talend
Database
Utilities
Snow flake schema
Microsoft
Unix
Fluency
Scripting
Windows PowerShell
Normalization
Python
XML
XSLT
Amazon Web Services
Microsoft Azure
ROOT
Debugging
Scheduling
Job Details
Piper Companies is looking for a Data Engineer for an Investment Firm in Wayne, PA for a Hybrid, Full-Time opportunity.
Responsibilities of the Data Engineer:
Conduct data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
Provide business and technical analysis for initiatives focusing on Data Warehouse and Business Intelligence solutions
Collaborate with Business Intelligence Developers through dashboard and application development process for requirements gathering, feedback on proposed designs and models, and acceptance testing
Qualifications of the Data Engineer:
10 years' experience, with both hands-on and lead experience in supporting data warehousing solutions
Must possess the following technical skills:
o ETL Tools: Enterprise class ETL tool (Talend is plus)
o Databases & Utilities: Experience with enterprise relational databases (Snowflake experience preferred)
o Platforms: Microsoft / Unix
o Expertise and fluency in SQL language is required
Knowledge of scripting languages and job schedulers is required (Powershell, etc.)
Experience with various integration patterns (e.g. Flat Files, Web Services, etc.) is required
Knowledge of fundamental data modeling concepts (e.g. ER Diagrams, normalization, etc.) is required
Familiarity with Python, Snowflake, Talend, XML/XSLT, and Cloud Services (AWS or Azure) are preferred
Excellent troubleshooting and problem-solving skills; able to root cause and debug complex code in and efficient manner/with appropriate urgency
Bachelor's degree in computer science, information technology or another computer-based discipline
Compensation for the Data Engineer:
Salary of $120K - $150K
Hybrid Scheduling
Comprehensive Benefits Package: Medical, Dental, Vision, 401K, PTO
Responsibilities of the Data Engineer:
Conduct data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
Provide business and technical analysis for initiatives focusing on Data Warehouse and Business Intelligence solutions
Collaborate with Business Intelligence Developers through dashboard and application development process for requirements gathering, feedback on proposed designs and models, and acceptance testing
Qualifications of the Data Engineer:
10 years' experience, with both hands-on and lead experience in supporting data warehousing solutions
Must possess the following technical skills:
o ETL Tools: Enterprise class ETL tool (Talend is plus)
o Databases & Utilities: Experience with enterprise relational databases (Snowflake experience preferred)
o Platforms: Microsoft / Unix
o Expertise and fluency in SQL language is required
Knowledge of scripting languages and job schedulers is required (Powershell, etc.)
Experience with various integration patterns (e.g. Flat Files, Web Services, etc.) is required
Knowledge of fundamental data modeling concepts (e.g. ER Diagrams, normalization, etc.) is required
Familiarity with Python, Snowflake, Talend, XML/XSLT, and Cloud Services (AWS or Azure) are preferred
Excellent troubleshooting and problem-solving skills; able to root cause and debug complex code in and efficient manner/with appropriate urgency
Bachelor's degree in computer science, information technology or another computer-based discipline
Compensation for the Data Engineer:
Salary of $120K - $150K
Hybrid Scheduling
Comprehensive Benefits Package: Medical, Dental, Vision, 401K, PTO