Vacancy expired!
- This group supports data analytics in the global marketing department
- This is more than a SQL writer; needs to have heavy SQL Server
- More on a DBA level – so need to be very polished
- The main focus is having experience in Microsoft SQL Server stack
- SSIS is REQUIRED
- Strong knowledge in SQL
- Outside of SSIS, working knowledge of SSAS, and writing MDX is a plus.
- They need at least 6 to 8 years of experience in Microsoft SQL Server and specifically in SSIS
- They Upgraded to 2016 from 2008
- DBA work
- Be able to write scripts removing and adding objects
- Mostly ETL work
- Lead the design and development for ETL processes at Intermodal using Microsoft BI Stack.
- Responsible for ensuring that the business models are aligned with the various project needs to achieve strategic goals. The architecture should cover databases, data integrations and the means to get to the data.
- Create logical and physical data models that support both user requirements as well as opportunity assessments.
- Program in T-SQL and other related language to support application development.
- Ability to write stored procedures, indexes, views with minimum guidance. Also able to fine tune existing long queries to enhance the current business models.
- Should be able to troubleshoot daily issues with SSIS job/packages on Production ensure delivery of critical data for business users.
- Should be able to cooperate with IT standards to follow Ticketing process for smooth movement of new development or existing enhancements across various environments. Should comply with IT documentation needs that NS follows right now.
- Expert in SSIS design and development techniques as well as able to understand existing packages and suggest further enhancements.
- Ability to work closely with various teams to gather requirements and get started with new projects immediately. This includes ability to keep some documentation regarding new and existing projects. Able to communicate or explain projects to non-technical people with ease
- Should be aware of other Microsoft techniques such as SSAS, SSRS, TFS for future or upcoming projects. Knowing DataStage or basic concepts for DataStage would be a plus.
- ID: #43224366
- State: Georgia Atlanta 30309 Atlanta USA
- City: Atlanta
- Salary: Up to $70
- Job type: Contract
- Showed: 2022-06-18
- Deadline: 2022-08-05
- Category: Architect/engineer/CAD