Data - SSIS Data Warehouse Programmer

Senior Business Intelligence/ETL Developer

Salary: $100,000 to $130,000 + Bonus + Work life balance

Short-term: Strong SSIS development experience

Long-term: Moving to Azure and to Snowflake

Role Run-Down: The Senior Business Intelligence Developer is responsible for designing, developing, and supporting business intelligence ETL solutions. The position will also assist with data analysis, constructing technical designs, developing ETL applications, communicating with team members and business stakeholders, and supporting existing ETL applications. This position will also lead and coordinate the work activities of offshore development and support resources.

Responsibility: Works on multiple, complex projects as technical lead and coordinates the work of other technical ETL resources.

Other roles may include:

  • Responsible for the design, development, and support of ETL applications
  • Assist with data analysis
  • Provide off-hour/weekend ETL support (on a rotating basis)
  • Providing guidance and direction to offshore ETL support/development resources
  • Interacting with other BI team members, offshore team members, and cross-IT staff on support and project activities
  • Assist with task identification and effort estimates for ETL development
  • Assist with risk and issue identification
  • Other duties as assigned
  • Required Skills and Experience:
  • 4-year degree in Computer Science
  • At least 4 years of ETL application development experience
  • At least 2 years of ETL design experience
  • Design and development experience utilizing scheduling/automation tools
  • Experience leading other developers
  • Strong communication skills
  • Strong written and verbal skills
  • Strong problem solving and analytical skills
  • Strong ETL design skills
  • Excellent ETL development skills utilizing an ETL tool (i.e. SSIS, Informatica, etc.)
  • Excellent SQL skills
  • Strong understanding of Dimensional Modeling techniques
  • Strong understanding of SDLC best practices with an emphasis on DW/BI practices
  • This position must pass a post-offer background and drug test
  • Preferred Skills and Experience:
  • Experience with Microsoft Orchestrator
  • MS SSIS experience
  • Cognos FM, Transformer experience
  • MS SQL Server database experience
  • Azure SQL, DW, ADF, ADLS experience with Data Storage, Analysis
  • Data modeling experience
  • Experience leading offshore resources
  • ITIL certification

Back to top