What are the responsibilities and job description for the Data Warehouse/ETL/BI/API Developer position at cyberThink Inc?
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:
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.
- 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.
cyberThink is an Equal Opportunity Employer.
Salary : $40 - $60
