SSIS Developer/Architect Sr(36598)

Reposted One Month 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
HQ: Austin, TX
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

Sprinter Health Logo Sprinter Health

Patient Engagement Specialist I (Temporary) | $1,000 Bonus

Artificial Intelligence • Healthtech • Logistics • Social Impact • Software • Telehealth
Remote or Hybrid
United States
500 Employees

Bestow Logo Bestow

Business Systems Analyst

Big Data • Fintech • Information Technology • Insurance • Software
Remote or Hybrid
US
160 Employees
55-65 Hourly
In-Office or Remote
4 Locations
121228 Employees
130K-175K Annually

eClinical Solutions Logo eClinical Solutions

Director, elluminate Business Development

Cloud • Healthtech • Professional Services • Software • Pharmaceutical
Easy Apply
Remote or Hybrid
United States
400 Employees
125K-150K Annually

Similar Companies Hiring

Compa Thumbnail
Artificial Intelligence • HR Tech • Software • Business Intelligence
Irvine, California
75 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 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