UniFirst is seeking a 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
- Strong working knowledge around Azure Data Fabric, Data factory, ADLS Gen2, Azure Synapse Analytics (Dedicated and Serverless SQL pools)
- experience in programming and scripting languages – python, pyspark, Powershell, SQL
- 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.
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 . Azure data factory
- Integrate disparate data models into coherent enterprise and/or Lob data models
- Advise on tools to create data dictionaries and business glossaries to document data lineages, data definitions and metadata for all business-critical data domains
- Help identify and design solutions that allow performing root cause analysis to enable proactive issue resolution and data quality maintenance
- Develop strategies for flexibility, scalability, and define the future technical architecture direction for the business intelligence reporting environment
- On need basis, develop database solutions for SQL Server, including creating tables, stored procedures, custom user-defined functions, triggers, and indexes
Other
- Over all 10+ years of experience in delivering Data Warehouse solutions with robust architecture
- Work with business stakeholders to identify critical data (entities and attributes) and capture how users in various parts of the organization interpret data
- Responsible for aligning data solutions to business requirements by planning and managing data architecture work
- Collaborate across the organization to standardize a relevant data collection and aggregation strategy, data warehousing, and transactional data repository approach
- Strong analytical and problem-solving abilities.
