:Data Solutions – Data Developer

Experience with Dimensional Modeling must

Expert Knowledge with:

Good knowledge in following: (not required)

·  Know how to identify Dimensions

·  Know how to identify Measures

·  Know how to identify Grain

·  Understand Dimensional Hierarchies

·  Design Fact Tables (and dimensional tables)

·  Multivalued Dimensions

·  Bridge Tables

·  Understand Foreign Keys and Attributes

·  Creating and understanding SSIS Packages

·  Developing and understand ETLs

·  Developing Stored Procedures

·  Complex SQL writing

·  Work with stakeholders to support data infrastructure needs and resolve data-related issues

·  Develop and maintain scalable data pipelines and systems.

·  Assemble large, complex data sets that meet business requirements.

·  Collaborate with development, testing, and operations teams to streamline processes and improve productivity.

·  Monitor and troubleshoot infrastructure and application performance.

·  Develop and maintain comprehensive procedural documents, manuals and technical documents.

·  SSRS Reporting

·  PowerBI Reporting

·  Healthcare experience

·  Agile

·  Scrum

·  Project Management

·  Visual Studio – DevOps