Overview
Data Warehouse Analyst – services to develop, test, and maintain databases and data transfer packages.
Duties
- A minimum of five years in data modelling, data mining, database standardization, deduplication and performance tuning.
- A minimum of five years developing Online Analytical Processing (OLAP) cubes using SQl Server Analysis Services.
- A minimum of five years developing SQL Server Integration Services packages performing Extraction, Transformation and Loading activities.
- A minimum of five years with dashboard and scorecard development.
- A minimum of five years with the development of reports using MS SQL Server Reporting Services (MS SSRS) and maintenance of enterprise reports using MS SSRS.
- A minimum of five years with business intelligence tools and systems, such as SSRS.
- A minimum of five years with MS SQL product inclusive of MS SQL 2016,2019, 2022.
- A minimum of five years with SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and linked servers.
- A minimum of five years with SQL relational databases, Online Transaction Processing (OLTP) and Decision Support System (DSS) serving in high performance, service-oriented, multi-tiered environments.
- A minimum of three years with software build and release management methodologies.A minimum of two years in a healthcare IT domain.
- A minimum of one year with Prenatal Risk Screening datasets.
- Skilled in performance tuning techniques for SQL queries and database systems to maximize efficiency.
- Familiarity with ETL tools like SSIS for data integration workflows.
- Ability to develop scripting solutions using Shell Scripting or other scripting languages for automation tasks.
- Experience with database security best practices, backup strategies, and disaster recovery planning.
- Excellent problem-solving skills with a detail-oriented approach to managing complex data environments. Join us in shaping the future of data management! We’re committed to fostering an energetic environment where your skills will directly impact organizational success while providing opportunities for growth in the evolving world of databases and data warehousing.
Pay: $60.00 - $65.00 per hour
Work Location: In person
