What are the responsibilities and job description for the Data Engineer / Developer (ETL, Talend, HDInsight) position at POWERHOUSE INSTITUTE?
Data Engineer / Developer (ETL, Talend, HDInsight)
NOTE: This is a full-time employment opportunity (No C2C, subcontractor or 1099 engagements, please.) The candidate MUST be a U.S. Citizen or Permanent Resident and must be able to complete/pass/hold a public trust investigation. This is a remote opportunity, EDT/EST time zone work schedule.
Daily Responsibilities
- Provide engineering and administrative support for data integration solutions, databases and systems, including Talend, Spark, and HDInsight.
- Talend coding, Spark coding, Azure Blog Storage configurations, read and removal of databricks from Talend code, Nexus, JIRA, Confluence, Gitlab configurations for Talend code.
- Receive, transform, and test data files using data analytics tools.
- Provide data engineering, maintenance, and modernization support for EDM production systems. Analyze data problems and recommend potential data integrity solutions via a Data Quality Analysis Report.
- Ensure EDM service resiliency through improved technology and best practices.
Requirements
- Must be a U.S. Citizen or Permanent Resident, as mandated by our government client.
- Must be able to complete/pass/hold a public trust investigation.
- 7 years of experience in data warehouse architecture, ETL design and development.
- ETL development experience with Talend, Spark, and/or HDInsight.
- Experience in building framework-based data integration using the above tools.
- Experience in building Talend based ETL workflow to ingest, transform and aggregate data.
- Extensive experience in ETL methodology for performing data profiling, data migration, Extraction Transformation and Loading.
- Solid experience in implementing complex business rules by creating reusable transformations and robust mappings using various transformations.
- Experience in writing complex SQLs to analyze and troubleshoot the issues/problems.
- Experience with data analysis, data architecture, data cleansing and data quality.
- Technical experience with Industry standard CICD methods, Azure preferred.
- Excellent analytical skills, attention to detail, and strong problem-solving abilities.
- Excellent communication and collaboration skills.
- BS/BA degree in Computer Science, Information Sciences, or related IT discipline.
Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs. The annual salary range for this position is $90,481 - $137,165.
Our Comprehensive Benefits Package Includes:
- 401K Retirement Plan
- Health Insurance Plans (Medical, Dental, and Vision) - Open Access
- Long Term, Short Term, and Life Insurance Benefit (Company paid benefit)
- Generous Paid Time Off
- Paid Holidays
- FSA - Flexible Spending Account for Medical and Dependent Care
- Discount Programs for Consumer Products and Wellness Services
-------------------------------------------------------------------------------------------------------------------------------------------
Powerhouse Institute, Inc. is a Management Consulting and Technology Solutions company. Our people bring a great mix of expertise and commitment to deliver solutions and solve problems.
Our services include Management Consulting, Enterprise Architecture, Solutions Architecture, Cloud Solutions, Cloud Migration, Data Analytics, Cyber Security, IT Services, and Training.
Powerhouse Institute, Inc. is an Equal Opportunity Employer. Powerhouse Institute, Inc. does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.
