Data Warehouse/ETL/BI/API Developer - cyberThink, Inc
Mechanicsburg, PA 17050
About the Job
Job Description:
As a Data Warehouse/ETL/BI/API Developer, you will optimize, develop, and maintain integration solutions using SQL Server SSIS and the ETL Framework. Your responsibilities will include maintaining and optimizing all efforts related to the Data Warehouse, creating data warehouse components using best practices, and ensuring data consistency and integrity. You will also troubleshoot complex data-related issues, develop and deploy ETL job workflows, and provide support for production environments.
Key Responsibilities:
Required Skills, Experiences, Education, and Competencies:
The hourly range for roles of this nature are $40.00 to $60.00/hr. Rates are heavily dependent on skills, experience, location, and industry.
cyberThink is an Equal Opportunity Employer.
As a Data Warehouse/ETL/BI/API Developer, you will optimize, develop, and maintain integration solutions using SQL Server SSIS and the ETL Framework. Your responsibilities will include maintaining and optimizing all efforts related to the Data Warehouse, creating data warehouse components using best practices, and ensuring data consistency and integrity. You will also troubleshoot complex data-related issues, develop and deploy ETL job workflows, and provide support for production environments.
Key Responsibilities:
- Optimize, develop, and maintain integration solutions using SQL Server SSIS and ETL Framework to connect legacy data stores and the data warehouse.
- Develop, maintain, and optimize efforts related to the Data Warehouse, including SSIS, stored procedures, and views.
- Create data warehouse components using best practices methodologies.
- Document data processes and how data is moved through layers.
- Perform data conversion from OLTP to DW using tools like SSIS/Data Factory.
- Identify and analyze data discrepancies and quality issues to ensure data consistency and integrity.
- Ensure stabilization and high performance of existing ETL processes.
- Troubleshoot complex data-related issues and provide support to production.
- Develop and deploy ETL job workflows with reliable error handling and rollback mechanisms.
- Work on SSRS, with Power BI experience preferred and Crystal Reports being beneficial.
- Involve API development as needed and may participate in manual testing.
- Perform other related duties as required.
Required Skills, Experiences, Education, and Competencies:
- 4-year college degree or equivalent technical study with advanced study.
- ETL experience, including SSIS or other ETL tools.
- Data analytics experience and knowledge of data warehouse concepts.
- Proficiency in MS SQL Reporting Server (SSRS) and Power BI.
- Web API development experience is preferred.
- Strong problem-solving skills and the ability to work independently and as part of a team.
The hourly range for roles of this nature are $40.00 to $60.00/hr. Rates are heavily dependent on skills, experience, location, and industry.
cyberThink is an Equal Opportunity Employer.
Source : cyberThink, Inc