SQL Server Developer/Data Engineer

· Design and create data marts and data cubes optimized for analytical queries.

· Define dimensional models and star schemas for efficient data retrieval.

· Implement aggregation strategies to support fast querying of large datasets.

· Collaborate with business analysts to identify key metrics and dimensions for reporting and analysis.

· Ensure data consistency and accuracy across data marts and cubes.

· A minimum of two (2) years of relevant experience in authoring and monitoring data pipelines.

· The possession of a bachelor’s or advanced degree (master’’s or PhD) in computer science, engineering, information systems, math or technology-related field. Additional qualifying experience may be substituted for the required education on a year-for-year basis. Successful completion of a data engineering bootcamp plus an additional year of experience may be substituted for the degree requirement.

· Two (2) years of Database Expertise: Strong proficiency in designing, developing, and optimizing databases for data visualization projects.

· Two (2) years of Data Modeling: Solid understanding of data modeling techniques, normalization, and database design principles.

· Two (2) years of ETL Processes: Experience in designing and implementing ETL (Extract, Transform, Load) processes to prepare data for visualization.

Desirable Skills:

· All desirable skills are not expected to be fulfilled but distributed among the three (3.0) FTE.

· Four (4) years of experience in SQL Proficiency: Expertise in writing complex SQL queries, stored procedures, and database functions for data retrieval and manipulation.

· Two (2) years of experience writing SAS.

· Three (3) years of experience designing, developing, or implementing Microsoft Business Intelligence solutions.

· Three (3) years of experience using SQL Business Intelligence (BI) tools (SSAS, SSIS, SSRS).

· Three (3) years of experience with GIS or spatial analysis.

Two (2) years of Domain-specific knowledge in healthcare