Description

Design and maintain scalable data architectures and business intelligence systems for multi-terabyte data warehouses.

Responsibilities

• Build and document data pipelines, applications, and BI systems, including semantic layers and metadata.
• Design redundant systems, disaster recovery policies, and data archiving procedures to ensure data integrity.
• Execute all phases of the software development life cycle (SDLC) for data warehouse projects.
• Diagnose and resolve performance issues and access constraints within the data warehouse.
• Coordinate with development and infrastructure teams to translate business requirements into technical specifications.

Required Skills

• 5+ years of experience designing, building, and supporting multi-terabyte data warehouses.
• 3+ years of experience in data architecting, large-scale data modeling, and data mining.
• 3+ years of experience with database and cloud platforms, specifically SQL Server and SSIS.
• Strong understanding of relational database structures, theories, and principles.
• Proficiency in business requirements gathering, analysis, and data processing flowcharting.
• Proven project management experience.
• Knowledge of applicable data privacy practices and laws.

Preferred Skills

• Experience with Azure, SSRS, PowerBI, Azure Data Studio, and Azure Data Factory.
• Familiarity with Microsoft Dynamics 365 data models.

Key Skills

Education

Any Graduate