UniFirst is seeking a highly skilled DW Architect/ Developer to design, develop, and optimize enterprise-grade database solutions across both cloud (Azure) and on-premises environments to drive strategic decision-making.
Requirements
- Advanced proficiency in T-SQL, query tuning, and database design
- Strong experience with ETL tools (SSIS, Azure Data Factory) and data integration best practices
- Hands-on experience with hybrid (on-prem + cloud) data architectures
- Familiarity with Azure DevOps CI/CD pipelines for database deployments
- Good exposure to AI tools like Cursor AI Editor for development and testing
- Knowledge of scripting languages such as PowerShell or Python
- Experience with Azure Databricks, Spark, or other big data processing tools
Responsibilities
- Spearhead the design of the technical and information architecture for the data warehouse, including data lake/ operational data stores, staging area, data warehouse, data marts – on-prem SQL to Azure eco-system
- Provide technical direction and guidance to data engineers, BI architects, and other partners on data ingestion processes using Azure data fabric
- Work with business stakeholders to identify critical data (entities and attributes) and capture how users in various parts of the organization interpret data
- Develop database solutions for SQL Server, including creating tables, stored procedures, custom user-defined functions, triggers, and indexes
- Perform data evaluation, data profiling, and identification of potential problem areas and make appropriate recommendations
- Assist in the definition, documentation, and development of mapping rules for movement of data from disparate data sources and into the various components and subject areas of the BI environment
- Oversee and create data models, data flow diagrams, data mappings alongside with Product Support and SMEs in place
Other
- Bachelor’s degree in Computer Science, Information Systems, or related field (Master’s preferred)
- Over all 10+ years of experience in delivering Data Warehouse solutions with robust architecture
- Strong analytical and problem-solving abilities
- Excellent communication skills with both technical and non-technical stakeholders
- Proven ability to work in fast-paced, agile environments
