What are the responsibilities and job description for the Data Warehouse/ETL/BI/API Developer position at Diversified Systems.com?
Hybrid (Onsite 1 day/wk)
Description:
DSI is searching for a Data Warehouse, ETL, Business Intelligence Developer and API Developer staff augmentation resource.
Responsibilities:
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.
Description:
DSI is searching for a Data Warehouse, ETL, Business Intelligence Developer and API Developer staff augmentation resource.
Responsibilities:
- Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) as necessary to connect legacy data stores, the data warehouse.
- Develops, maintains and optimizes al effort related to Data Warehouse (SSIS, Stored procedures, Views etc.).
- Creates data warehouse components using best practices methodologies.
- Builds and maintains through documentation of the data and how it is moved through layers.
- Perform data conversion from OLTP to DW using tools like SSIS/Data Factory.
- Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
- Ensure the stabilization and high performance of existing ETL processes.
- Troubleshoot and complex data related issues as well as provide support to production.
- Develop and deploy ETL job workflow with reliable error/exception handling and rollback.
- May be involved with manual testing.
- Perform other related duties as required.
- 4 year college degree or equivalent technical study with advanced study required.
- 6 years of ETL experience (Including SSIS or other ETL tools) required.
- 6 years of Data Analytics experience required.
- 6 years or Data Warehouse knowledge and experience required.
- 4 years experience with MS SQL Reporting Server (SSRS) required.
- 3 years experience with Power BI required.
- 3 years of Web API development experience required.
- 3 years experience working on SSRS required.
- Experience with Crystal Report will be beneficial.
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.
