22 Jan
Data Warehouse Architect
Arizona, Tempe , 85280 Tempe USA

Vacancy expired!

head farmer - Excellent in our field. Headfarmer is a boutique recruiting firm specializing in the permanent and contract placement of the upper echelon of talent in the greater Phoenix area. We offer a unique process of " headfarming " which provides a level of professional support to both candidates and clients that exceeds recruiting industry standards.The Data Warehouse Architect is responsible for the design, development, and maintenance of the enterprise data warehouse and business intelligence applications and processes. This position will maintain and update business intelligence tools, databases, dashboards, systems, and/or methods as well as develop and enhance the data warehouse and corresponding ETL processes.Responsibilities:

  • Design, build and maintain an Enterprise Data Warehouse (EDW) architecture to ensure that the corporate data warehouse is accurate, scalable, performs efficiently and is available to the business as necessary with key focus on supporting reporting and dashboard needs for the value based care platform and Analytics
  • Develop and maintain ETL processes using multiple technologies including Microsoft SSIS, Java and other applicable tools
  • Develop and maintain OLAP cubes and other data warehouse structures
  • Design, create and optimize complex queries for data ETL processes
  • Work with Business Analysts and Functional Analysts in an iterative and agile methodology to deliver reports, dashboards and data
  • Develop, manage, schedule and document data operations and tasks, including extraction, movement, loading, archival, security, backup and aggregate table creation
  • Build complex data sets to meet business requirements
  • Identify, design, and implement internal process improvements; automate manual processes, optimize data delivery, re-design infrastructure for optimal scalability
  • Collaborate with product, data and design teams to assist with data-related technical issues and to support their data infrastructure needs
  • Work with data and analytics experts to achieve greater functionality in our data systems
  • Build and maintain processes supporting data transformation, data structures, metadata, dependency and workload management
Qualifications:
  • Bachelor's degree in Computer Science, Statistics, Informatics, Information Systems or a related quantitative field of study
  • 5+ years extensive hands-on experience in architecting, designing, configuring and implementing Data Warehouse solutions for a large group or organization
  • 3+ years' experience with data warehouse architecture standards, process, and methodology, with good knowledge of data integration, data quality, multi-dimensional design and ETL tools
  • 5+ years of relevant experience of SQL development/programming (preferred)
  • Experience building and optimizing 'big data' data pipelines, architectures and data sets
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
  • Proven record of manipulating, processing and extracting value from large, disconnected datasets
If your resume and qualifications meet this job description, please don't hesitate to contact Headfarmer. Someone will be in touch with you soon if we feel there is an appropriate match. Voted a Best Place To Work by the Phoenix Business Journal for 2015, 2016, 2017, and 2018 We're waiting for you on the Farm.

Vacancy expired!


Report job