BI / SSIS Developer

Other jobs >> General




BI / SSIS Developer

Location: Detroit, MI

Duration: Fulltime



Department: Operational Performance


Provide support to all phases of the application development process to include business analysis, application, architecture, design, development, integration and delivery for those business applications that support the administrative or operational functions of the company or the business applications needed to serve customers effectively. Provide business application maintenance and support.


Work closely with clients, business analysts and team members on moderately complex to complex programming projects. Define business processes and gather project requirements. Write software code, test, debug, and document and maintain computer applications. Identify coding errors through informal and formal testing methods. Ensure application integrity by applying SDLC concepts.

- Provide ongoing maintenance of applications.

- Document functions and changes to new or modified modules and test activities/results.

- Identify technical requirements, as needed. Create technical design specifications and assist in sizing technical requirements, as needed.

- Participate in project planning processes, as needed.

- Support identification of sources of data feeds and interfaces, as needed.

- Design new reports and interfaces using advance queries and software solutions. Maintain existing reports and process automation tools.

- Adhere to standards and procedures. Review modules for quality assurance.

- Evaluate existing applications and platforms and provides recommendations for improving application performance by conducting gap analysis, identifying feasible alternative solutions, and assisting in the scope of modifications.

- Evaluate new application packages and tools and perform research on best practices and provide recommendations for solutions, as needed.

- Provide technical coaching and mentoring to less-experienced team members.

- Other duties may be assigned.

Additional Department Job Specific Duties:

This position, under the Operational Performance Management (OPM) department, is primarily responsible for:

- Business application and SQL Server development and support.

- Business analysis, application architecture, design, development, integration and delivery.

- Application maintenance and support.

Conducts analysis of organizational needs and goals for the development and implementation of application systems. With general guidance and coaching, performs technical design and development of applications using existing and emerging technology platforms. Designs, codes, tests, debugs, documents, and maintains those applications. Ensures SDLC methodology is followed, conducts inspections and post implementation reviews. Competent to work at a high technical level for the entire application development life-cycle. Partners with business personnel to conduct analysis of organizational needs. Acts as a primary liaison with the user area for development and modifications to existing applications. Significant creativity is required.

This position has frequent customer interaction and the successful candidate must have proven abilities to extract and analyze requirements from customers at all levels of the organization. With general

guidance and coaching performs technical design and development of automation solutions using existing and emerging technology platforms. Other job requirements include testing, debugging, documentation, end-user training, and maintenance of those solutions. 3270 TSOB or Nasco transactions knowledge is a plus.

Minimum Requirements:

3 years of experience with SSIS package development.

- Advanced SQL Query language skills.

- Experience with developing end-user applications and interfaces.

- Experience in documenting user requirements, developing conceptual and detail design.

- Knowledge of Microsoft SQL Server 2016 database development and support.

- Experience with SQL Server Management Studio.

Department Preferences:

- Excel macros, MS Office suite, Visio, SharePoint, DB2 databases, other PC database tools, other PC development languages.

- Experience with other reporting and data analysis tools such as SSRS.

- C# application development experience.
  • 1
  • Negotiable
  • None
  • None
  • Re-98789
  • Permanent
  • 5

How to Apply: Please click here to create a free account and post your resume. Only logged in job seekers can apply for a job.

Find us at:

Never provide bank account, credit card details or any other financial information, or make any form of payment, when applying for a job. If you are ever asked to do this by a recruiter on Pure Jobs please click the Report button or contact us with the advertiser's company name and the title of the job vacancy. You should not send any money to anyone. A genuine employer with a job offer would never ask you to do this.

Report this job

Report a job

If you're concerned about a job advert, let us know and our quality team will investigate.

Your name(*)
Invalid Input

Your email address(*)
Invalid Input

Please select you reason(*)

Additional information(*)
Invalid Input

Invalid Input

Get new jobs for this search by email.

Also get an email with jobs recommended just for me.

Create Alert

Subscribe to updates from our blog