SQL Server Developer/Data Engineer

SQL Server Developer/Data Engineer

Remote

12 Months

Need Passport Number and 3 references from 3 different clients mandatory for the submission

Role:

·        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.

Mandatory Skills

·        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

Regards, 
Satya
Technical Recruiter

Key Business Solutions, Inc