Data Engineer
Wayne, Pennsylvania
Employer: Piper Companies
Industry: Other
Salary: $120000 - $150000 per year
Job type: Full-Time
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
Keywords:
Data, Data analysis, Engineering, Data Engineering, Data Wrangling, Data Manipulation, Data Automation, SQL, MySQL, SQL Server, RDMS, Relational Databases, Relational Database Management Systems, DBA, Database Management, Schemas, Queries, Query, DA, Extract, Transform, Load, scripting, data reports, data visualization, benefits, medical, dental, vision, 401K, pto, vacation, hybrid, #LI-ZS1 , #LI-HYBRID
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
Keywords:
Data, Data analysis, Engineering, Data Engineering, Data Wrangling, Data Manipulation, Data Automation, SQL, MySQL, SQL Server, RDMS, Relational Databases, Relational Database Management Systems, DBA, Database Management, Schemas, Queries, Query, DA, Extract, Transform, Load, scripting, data reports, data visualization, benefits, medical, dental, vision, 401K, pto, vacation, hybrid, #LI-ZS1 , #LI-HYBRID
Created: 2024-05-05
Reference: 120136
Country: United States
State: Pennsylvania
City: Wayne
Similar jobs:
-
Data Engineer - Supply Chain Analytics
Insight Global in Collegeville, Pennsylvania -
Senior Big Data Engineer
Clarivate in Philadelphia, Pennsylvania -
Senior Data Center Engineer w/ Active TS/SCI clearance
General Dynamics Corporation in Dayton, Pennsylvania -
Databricks Data Engineer
Insight Global in Altoona, Pennsylvania -
Data Engineer
Saxon Global in [horsham, Pa], Pennsylvania -
Senior Data Platform Engineer - REMOTE
Ansys in Canonsburg, Pennsylvania -
Data Engineer
Veeva Systems in Philadelphia, Pennsylvania💸 $75000 - $130000 per year -
Principal Knowledge Graph Engineer, Drug Discovery Data Engineering and Solutions
Johnson & Johnson in Spring House, Pennsylvania -
AWS Data Engineer - Remote
Insight Global in West Chester, Pennsylvania -
Data Engineer
Experis in Philadelphia, Pennsylvania -
Data Center Critical Facilities Engineer - Elk Grove Village, IL - 12+ months
Open Systems Technologies in Work At Home, Pennsylvania -
Senior Application Data Engineer
Vanguard Group in Malvern, Pennsylvania -
Data Engineer
Piper Companies in Wayne, Pennsylvania💸 $120000 - $150000 per year -
Data Protection Platform Engineering Manager
Retail Business Services in Carlisle, Pennsylvania -
Senior Manager Data Engineering - Horsham, PA
UnitedHealth Group in Horsham, Pennsylvania -
Data Engineer Snaplogic
Veolia in Feasterville-Trevose, Pennsylvania -
Data Engineer
Piper Companies in Wayne, Pennsylvania💸 $120000 - $150000 per year -
Lead Data Engineer
Saxon Global in [horsham, Pa], Pennsylvania -
Knowledge Graph Engineer, Drug Discovery Data Engineering and Solutions
Johnson & Johnson in Spring House, Pennsylvania -
Data Engineer - Horsham, PA
UnitedHealth Group in Horsham, Pennsylvania