Description

You will lead the design and implementation of a new data warehouse to replace stored procedure-based data retrieval.

This role is on-site.

Responsibilities

• Analyze existing database structures to extract data from disparate sources.
• Design and implement a normalized data warehouse using dimensional modeling.
• Develop reporting solutions for financial, demographic, membership, and payment data.
• Plan and execute the full implementation lifecycle over a one-year period.
• Train the internal team on new data warehousing processes.

Required Skills

• 5+ years of experience in database architecture or data engineering.
• Expertise in T-SQL and SQL development.
• Proven experience designing and implementing data warehouses.
• Deep understanding of dimensional modeling, including fact and dimension tables.
• Hands-on experience with SSAS, SSRS, and Power BI.
• Strong analytical skills for mapping complex data relationships.
• Must be a US Citizen.

Preferred Skills

• Advanced SQL development skills for long-term project extension.

Key Skills

Education

Any Graduate