SQL/SSIS/SSAS/SSRS/MSBI Developer

18 Jun 2024

Vacancy expired!

SQL/SSIS/SSAS/SSRS/MSBI Developer

Atlanta, GA

24+ month contract

2 days onsite, 3 days remote (Hybrid Shift, MUST be comfortable with coming onsite)

Notes:
  • 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

Job Description:
  • 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.
Mostly the role requires the person to be fast paced and eager to learn new tools or techniques and ability to understand the clients business while working on technical side. This person will be the go-to guide for SQL server or ETL related questions as well as will be expected to handle different projects with ease with minimal supervisionAlso wants BI tools experience such as Tibco Spotfire and Tableau - wants a candidate savvy in BI reporting and capturing requirements. Thank You,

  • 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