Job Description :
Hi,
Kindly find below JD.
Role: Microsoft BI (MSBI) developer
Duration: 12+ month
Location : Nashville, TN
Visa: USC, GC
MOI : Skype
The Business Intelligence Developer II, under the direction of the Director of Data Warehouse and Reporting, is responsible for producing quality analytical and reporting solutions that support the operations and strategic imperatives of the organization. As part of the Data Warehouse Team, this person will be responsible to move, integrate, and transform data into business insight using full Microsoft BI (MSBI) Stack – SQL/T-SQL, SSIS, SSRS, and SSAS. Knowledge and experience in Tableau will be a big plus.
This is a hands-on development-focused role. The preferred candidate will possess top-notch technical skills and experience in full stack MSBI development with a strong focus on customer service & quality.
Primary Responsibilities
Analyze business needs to produce data warehouse/business intelligence solutions in support of naviHealth’s BI strategy.
Produce quality & timely deliverables as part of data warehouse project team(s
Design and develop Data Warehouse ETL processes in SSIS & SQL Stored Procedures.
Design and develop Reports from Data Warehouse using SSRS & SQL Stored Procedures.
Perform peer reviews and take ownership to ensure quality of data in data warehouse.
Become expert in very short time in existing BI solutions to troubleshoot and correct issues.
Efficiently work in an Agile environment – both Sprint and KanBan.
Production support on a rotating basis.
Contribute to build team knowledge base
Able to take additional responsibility over time to perform design and development of Data Warehouse database schema(s) & structures.
Able to take additional responsibility over time to perform design and development of Data Warehouse Cubes – Dimensional, Tabular, Relational, and Multidimensional OLAP cubes.
Technical Skills:
7+ years of experience with ETL Design & development using Microsoft BI stack, including SQL and SSIS in Data Warehouse setting.
2+ years of experience in SSAS (Dimensional and Tabular), SSRS, DAX, MDX, and other components.
Must have expertise in SQL with additional expertise in one of SSIS or SSAS.
Understanding of quality assurance and data quality principals as applied to an ETL architecture is a plus.
Experience with Tableau solution development and integration with existing architecture and OLAP assets is a plus.
Familiarity with database design and architecture for data warehouse is a plus.
Experience with architecting, designing, implementing, managing and supporting OLTP, OLAP or Warehouse Database Management Systems is a big plus
Soft Skills:
Strong analytical, problem-solving, time management and organizational skills
Able to multi-task and follow through on assignments to completion
Ability to prioritize work with tight schedules and target dates
Proven ability to work effectively in a fast-paced environment as part of a high-performing team