Description

You will design and implement data warehousing and visualization solutions within an MS SQL Server and Power BI environment.

Responsibilities

• Design and develop ETL processes, SSIS packages, and automated data flows.
• Rewrite existing SAS solutions into SSIS and Power BI to meet modern coding standards and performance requirements.
• Create stored procedures, advanced T-SQL queries, reports, and interactive dashboards.
• Perform gap analysis, gather functional requirements, and maintain technical documentation, including data flows and diagrams.
• Debug, troubleshoot, and optimize existing processes and database queries.
• Parse multiple data formats including HL7, XML, and CSV.
• Mentor staff on database design, query optimization, and automation techniques.

Required Skills

• 8+ years of professional experience in data development or visualization.
• Advanced MS T-SQL for stored procedure creation and query optimization.
• Hands-on experience with Power BI and dashboard development.
• Proficiency in SAS for code conversion and logic rewriting.
• Experience with SSIS for ETL process development and automation.
• Ability to work with XML, CSV, and HL7 data formats.
• Knowledge of Python for data tasks.
• Bachelor's degree.

Key Skills

Education

Bachelor's degree