BI Developer in Raleigh, NC at Vaco

Date Posted: 11/20/2019

Job Snapshot

Job Description

BI Developer

*BI *SQL * Dashboards * Stored Procedures * BI Developer *SSRS *SSIS *ETL *Business Intelligence

Cool person, able to work in a small environment and be able switch between tasks quickly

We are looking for a candidate that has the ability to independently and logically walk through and understand existing SSIS / ETL packages. A solid understanding of data management best-practices and in-depth experience with Microsoft SSIS / SSRS is required. This candidate must be detail-oriented and have excellent problem-solving and communication skills.

We are looking for a BI Developer (and have a second role for a Data Analyst/ SQL Guru) to join our engineering team. The BI Developer should have experience in building dashboards proficiency in stored procedures. The day to day responsibilities include developing SSIS / SSRS with a strong understanding of Data Warehousing / ETL strategy and best practices. A demonstrable ability to develop SSIS packages and SSRS reports is necessary. The developer will be part of a high-performing business intelligence team and will be focused on comprehensively creating and improving existing data warehouse processes, optimizing reporting and improving data integrity throughout the organization.

Responsibilities:

  • Primary responsibility is to drive design, development and maintenance of data warehouse / ETL processes.
  • Works closely with the business intelligence team to understand the data needs / requirements of the organization and implement and support SSIS packages to fulfill those needs.
  • Create documentation outlining ETL processes.
  • Create and deploy Microsoft SSRS reports.

Requirements:

  • Deep understanding of SSIS/SSRS and BI Tools.
  • Deep experience with ETL and data warehousing practices.
  • B.S. Degree in Computer Science or related discipline.
  • At least 2 years of experience with Microsoft SQL databases, SSIS / SSRS development.
  • Demonstrated Experience with Microsoft SQL Server 2008 and above including managing databases and the use of Microsoft SSMS.
  • Demonstrated experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.
  • Demonstrated experience with Microsoft SSRS for creating and publishing reports.
  • Demonstrated experience around writing and troubleshooting T-SQL statements, creating stored procedures, views, and SQL functions.
  • Understands different data models like normalized, de-normalized, stars, and snowflake models.
  • 2+ years of experience with data analytics and development.
  • SSRS report development / deployment.
  • Strong SQL coding experience with performance optimization experience for data queries.
  • Strong critical / analytical thinking and problem-solving skills.
  • Ability to multi-task and thrive in fast paced, rapidly changing and complex environment.
  • Track record of gracefully managing multiple priorities (including a mix of operational responsibilities and projects) within an environment characterized by changing technical requirements.
  • Self-motivated and self-directed, able to work effectively both independently and as a team member.
  • Willingness to take direction and seek feedback, ability to participate in group planning processes, ability to prioritize and coordinate multiple assignments and initiatives.
  • Good written and verbal communication skills.
  • Ability to learn new skills quickly to make a measurable difference.

Preferred:

  • Experience creating and support OLAP / SSAS Cubes.
  • Experience creating PowerBI reports.

bi developer, business intelligence developer, ssrs, sql developer, etl, data warehouse sw, business intelligence, ssis, computer programming, sql, bi consultant



Job Requirements

bi developer, business intelligence developer, ssrs, sql developer, etl, data warehouse sw, business intelligence, ssis, computer programming, sql, bi consultant