Job Description

Job Title: Data Warehouse Architect
Job Number: 20724
Type of Employment: Perm Position

Our client is searching for an experienced Data Warehouse Architect to join their team.  This is an excellent opportunity to secure a permanent role

Opportunity Overview :
  • Develop and revise conceptual, logical, and physical data models for an Enterprise (i.e. Enterprise Data Architecture)
  • Build and maintain advanced understanding of data and analytic landscape of business including data sources, data and analytic assets and products, analytic tools and software, and master data
  • Define database structural requirements by analyzing business operations, applications, and programming.
  • Develops data models that conform to current standards.
  • Applies best practices to development and revision of data architecture standards.
  • Creates and revise data dictionary definitions, governance practices, and standards
  • Collaborates with security architects to ensure compliance with data security and privacy policies. 
  • Participate in Architectural strategies on the EDW migration to Cloud platform e.g. integration with Data Lake and other Azure services
  • Interviews business users to obtain requirements for enhancements and/or new analytic assets
  • Maps source system data to data warehouse models
  • Assists in the Development of data asset training and documentation
  • Develops and tests extraction, transformation, and load (ETL) processes 
  • Presents technical solutions to stakeholders and end users
Qualifications & Required skills:
  • Understands how data is used to support analytical and/or operational reporting
  • 5+ years of relevant experience including continuing to innovate data architecture design and deployment, and data modelling especially dimensional data modeling (OLAP)
  • Strong data modeling skills
  • Experience using Erwin or similar tools for developing and maintaining data models
  • Strong data analysis skills into source systems to profile source system data
  • Strong experience with SQL
  • Experience with Tableau reporting tools a plus but not required
  • Experience in agile development data projects a plus but not required
  • Relational and dimensional data modeling and database design skills
  • Ability to construct queries using a supported query tool
  • Understands BI tool architecture, functions, features
  • Experience with Cloud Data Warehouse platforms e.g. Snowflake, Azure Synapse
  • Experience with the Azure stack (Azure Data Factory, ADLS, Azure Databricks, Azure ML, Azure Synapse, and Azure SQL)
Work location and Additional Info:
Candidates in this role are eligible to work remote, hybrid or on site.

Overture Partners is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, national origin, disability, sexual orientation, gender identity or expression, marital status, genetic information, protected veteran status, or other factors protected by federal, state, and/or local law.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online