SSIS Developer/Architect Sr(36598)

Posted 5 Days Ago
Be an Early Applicant
Phoenix, AZ, USA
In-Office
Senior level
HR Tech • Information Technology • Professional Services • Consulting
The Role
Designs and implements enterprise BI solutions using the Microsoft BI stack (SSIS/SSAS/SSRS). Imports and validates third-party data, develops T-SQL/stored procedures, recommends data-mart designs, improves reports/dashboards, mentors developers, and collaborates with architects and business stakeholders to translate requirements into BI specifications.
Summary Generated by Built In
Company Description

IDEALFORCE has a Contract position available immediately for a SSIS Developer/Architect Sr to join our customer in Phoenix Arizona. This is an ONSITE position. Please find below additional details about this job. Kindly respond with your most up to date resume if you would like to pursue this opportunity. Only AZ candidates are considered for this role.

Job Description

• Develops advanced BI applications using the MS BI stack including SSAS, SSIS, T-SQL/stored procedures

• Analyzes and improves existing dashboards, reports and reporting systems

• Analyzes and perform integrity checks data coming in from 3rd parties in flat file and other formats

• Responsible for importing data from various sources and providing summary reports regarding data integrity, completeness, etc.

• Works closely with the Enterprise and Solutions Architects team and provides technical design recommendations on the data mart structures which support analytical applications

• Provides and owns the technical details for implementation and maturing of BI solutions

• Works with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions

• Identifies problem trends and corrective actions and documenting these through modification of existing best practices guidelines

• Provides expertise and guidance to other developers in the use of the toolset

Qualifications

• Develops advanced BI applications using the MS BI stack including SSAS, SSIS, T-SQL/stored procedures

• Analyzes and improves existing dashboards, reports and reporting systems

• Analyzes and perform integrity checks data coming in from 3rd parties in flat file and other formats

• Responsible for importing data from various sources and providing summary reports regarding data integrity, completeness, etc.

• Works closely with the Enterprise and Solutions Architects team and provides technical design recommendations on the data mart structures which support analytical applications

• Provides and owns the technical details for implementation and maturing of BI solutions

• Works with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions

• Identifies problem trends and corrective actions and documenting these through modification of existing best practices guidelines

• Provides expertise and guidance to other developers in the use of the toolset

Requirements

• BS Degree CS or MIS or equivalent experience in related roles

• 8+ years of experience delivering solutions utilizing the entire Microsoft BI stack (SSIS, SSRS, etc.)

• 8+ years of experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers and user defined functions

• 8+ years of Microsoft SQL Server database development (TSQL) experience

• Must be able to build Business Intelligence solutions in a collaborative, agile development environment

• Knowledge of current Microsoft .NET technologies including C#, VB.NET, ASP.Net, and SharePoint desired

• Working knowledge of Team Foundation Services 2012

• Working knowledge of Share Point 2010 and Performance Point

• Demonstrated ability to use discretion and make sound decisions

• Ability to excel in a collaborative and distributed team environment

• Ability to work with a minimal amount of direction while being pro-active in keeping their management informed of project related issues

• Ability to work under pressure

• Ability to respectfully question ideas and share a point of view with others in support of the business requirements and needs

• Ability to effectively communicate with various levels of employees ranging from entry level to senior leadership

• Ability to manage multiple projects at the same time and shift priorities quickly

• Experience working on an Agile/Scrum team preferred

• Proven strong problem-solving skills, troubleshooting, and root cause analysis

• Excellent written and verbal communication skills

Additional Information

- "All your information will be kept confidential according to EEO guidelines". - All candidates who are authorized to work in US are encouraged to apply. - Candidates must clear the Background check prior to commencing the assignment. 

THIRD PARTY CANDIDATES:

Email your candidate/s resume to pete dot tylor at idealforce.com along with the following details: Rate, Current location and Availability.

Disclaimer :

 The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

Skills Required

  • Bachelor's degree in Computer Science, MIS, or equivalent experience
  • 8+ years delivering solutions using the Microsoft BI stack (SSIS, SSRS, SSAS)
  • 8+ years SQL Server/T-SQL programming including creation and optimization of stored procedures, triggers, and user-defined functions
  • 8+ years Microsoft SQL Server database development (T-SQL)
  • Experience importing data from various sources and performing data integrity and completeness checks
  • Ability to build Business Intelligence solutions in a collaborative, agile development environment
  • Experience providing technical design recommendations for data mart structures and BI implementation details
  • Demonstrated ability to mentor and provide guidance to other developers
  • Working knowledge of Microsoft .NET technologies (C#, VB.NET, ASP.NET)
  • Working knowledge of Team Foundation Server 2012
  • Working knowledge of SharePoint 2010 and PerformancePoint
  • Experience working on an Agile/Scrum team
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
39 Employees
Year Founded: 2008

What We Do

Idealforce is a premier talent acquisition solutions provider that helps corporations find top-performing talent through innovative ways and technologies. The company offers unparalleled talent acquisition and management services, helping businesses find quality talent cost-effectively while assisting talented individuals in finding the best employers where their skills are recognized and rewarded.

Similar Jobs

inKind Logo inKind

Account Executive

eCommerce • Fintech • Food • Mobile • Social Impact
Easy Apply
Remote or Hybrid
USA
170 Employees
100K-160K Annually

eClinical Solutions Logo eClinical Solutions

Training Specialist (Contractor)

Cloud • Healthtech • Professional Services • Software • Pharmaceutical
Easy Apply
Remote or Hybrid
United States
400 Employees
90-100 Annually

CrowdStrike Logo CrowdStrike

Program Manager

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
10000 Employees
86K-135K Annually

Opendoor Logo Opendoor

Transaction Coordinator

eCommerce • Fintech • Real Estate • Software • PropTech
Hybrid
Tempe, AZ, USA
1600 Employees

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account