Description

You will design and maintain data warehouse solutions, focusing on ETL processes and visualization for business intelligence.

This role is remote.

Responsibilities

• Develop and schedule ETL solutions using SSIS and SSMS, managing dependencies and pre/post-processing tasks.
• Build and maintain complex data storage structures to support data warehouse functions and consistent formatting.
• Design and develop complex Tableau and Power BI dashboard visualizations using MDX queries.
• Monitor data warehouse and business systems performance to ensure data integrity.
• Research and troubleshoot reported problems to validate data results and logic requirements.

Required Skills

• 5+ years of experience writing T-SQL using SQL Server Management Studio.
• 5 years of experience with Business Intelligence development tools, specifically SSIS.
• 3+ years of experience in dashboard development using Tableau and Power BI.
• 3 to 5 years of experience in Data Analysis across Production, Development, and Staging environments.
• Expert knowledge of source control tools such as TFS or Visual Source Safe.
• Experience with OLAP cubes, DataMarts, and perspectives using SSAS.
• Bachelor's degree or equivalent education in Computer Science, Math, or a related science field.

Preferred Skills

• Strong understanding of data warehouse architecture and best practices.

Key Skills

Education

Any Graduate