DesPlainesRecruiter Since 2001
the smart solution for Des Plaines jobs

REMOTE W2 ETL Architect

Company: Insight Global
Location: Des Plaines
Posted on: October 14, 2021

Job Description:

Designing, developing, and supporting business intelligence ETL (Extract Transform Load) solutions. Assist with data analysis, constructing technical designs, developing Extract Transform Load (ETL) applications, communicating with team members and business stakeholders, and supporting existing Extract Transform Load (ETL) applications. Lead and coordinate the work activities of offshore development and support resources.


Logistics industry background
Bachelors degree, or foreign equivalent, in Computer Science, Information Systems or Business Administration

4 years of professional work experience in ETL application development

ETL design experience Using SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), SQL Server, SAP HANA, Margin Minder, TM1, Azure Data Factory (ADF), Azure Devops, GITHUB, TFS, ERWIN, Snowflake, Oracle, Cognos, Microstrategy and Power Bi

Experience designing and developing of schedule automation tools such as: Orchestrator, Opalis, Azure Logic Apps , Azure Automation and Azure Data Factory (ADF)

ETL design skills such as: Logical Data modeling and physical data modeling which ensures that tables and reports are designed in a manner to give better performance and results to end users

SQL skills such as: Database structures, Objects creation, Store Proc, Functions, Debugging, and problem solving

Experience with Dimensional Modeling techniques, such as: Slowly Changing Dimensions (Type 1 to 6), Roleplayed Dimension, Normalization for the development which ensures that one can preserve historical data for change in dimension and enables date reporting

Experience with SDLC (Software Development Life Cycle) and Data Warehousing and Business Intelligence best practices using Agile methodology.

Keywords: Insight Global, Des Plaines , REMOTE W2 ETL Architect, Other , Des Plaines, Illinois

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Illinois jobs by following @recnetIL on Twitter!

Des Plaines RSS job feeds