Share this Job

Title:  Business Intelligence Architect


Advanced Energy Industries, Inc. (NASDAQ: AEIS), enables design breakthroughs and drives growth for leading semiconductor and industrial customers. Our precision power and control technologies, along with our applications know-how, inspire close partnerships and innovation in thin-film and industrial manufacturing. We are proud of our rich heritage, award-winning technologies, and we value the talents and contributions of all Advanced Energy's employees worldwide.



The Business Intelligence Architect will work with business users and analysts to design and develop effective technical solutions for our organization's data and information needs. Along with this the role is also responsible for the monitoring and maintenance of the analytics environment and will be required to support other specialists within the team. This role is responsible for the integration of data from a variety of internal and external sources into a common warehouse data model, to support data and analytics activities across global business functions.

This is a technical role that involves implementing and defining changes to the warehouse data model and building scalable and efficient processes to populate or modify warehouse data. The successful candidate will have hands on data processing and data modeling experience in a “big data” environment.  



  • Work closely with business leaders in analyzing data to develop new insights and analysis to help continually improve our business and business model
  • Lead the design and implementation of efficient data pipelines (ETLs) to integrate data from a variety of sources into the Enterprise Data Warehouse
  • Lead the design and implementation of data model changes that align with warehouse standards
  • Lead the design and implementation of backfill or other warehouse data management processes
  • Lead the development and execution of testing strategies to ensure high quality warehouse data
  • Provide documentation, training, and consulting for data warehouse users
  • Perform requirement and data analysis to support warehouse project definition
  • Architect development of ETL processes, programs, and solutions as per established standards
  • Design, implement, monitor, enhance, and troubleshoot requirements and architecture specifications of data warehousing systems
  • Design and develop the logic for end-to-end data pipeline including performance optimization
  • Develop the end-to-end automation of data pipelines, making datasets readily-consumable by visualization tools and notification systems



  • Strong analytical, conceptual, and problem-solving abilities
  • Extensive knowledge of querying and designing efficient warehousing structures.
  • Expert knowledge with designing or architecting for highly complex ETL processing and warehousing. Hands-on data processing and data modeling experience in a big data environment
  • Expert knowledge of data leak - all data sources - building out data sets for uses cases.
  • Design and develop the logic for end-to-end data pipeline including performance optimization
  • Strong communication and collaboration skills
  • Expert knowledge and experience with Agile methodologies



  • Location: Denver, CO
  • Hybrid              




  • Expert level understanding of ETL fundamentals and building efficient data pipelines
  • Hands on experience in developing data pipelines using Azure Data Factory, Azure Logic Apps, Azure Functions, Azure Synapse, Azure Data Lake
  • Hands-on experience managing data projects from requirements gathering through deployment
  • Demonstrated extensive experience working with Azure data solutions and supporting environments involving Azure Synapse Analytics, Azure Databricks, Azure Data Factory, Azure Data Lake v2 and Power BI.
  • Solid demonstrable experience with
    • Azure Synapse Analytics or Azure Data Factory
    • Python, or other programming language
    • SQL scripting
    • Data Modeling and building data pipelines 


  • Working knowledge of data and analytics in Global Supply, Sales, and Finance.
  • Experience with setting up and improving the team’s development and deployment processes
  • Working knowledge/experience of SAP S/4 ERP business processes
  • Solid understanding of Kimball design methodologies (star schema)



  • 7+ years of experience in Data Engineering, Business Data Warehousing for Analytics & Insights, and BI roles
  • Master’s Degree (or a B.S. degree with relevant industry experience) in math, statistics, computer science, or equivalent technical field



COMPENSATION: As required by Colorado law under the Equal Pay for Equal Work Act, Advanced Energy provides a reasonable range of compensation for roles that may be hired in Colorado.  Actual compensation is influenced by an array of factors including, but not limited to, skill set, level of experience, and specific office location.  For the hires in the state of Colorado only, the starting pay for this role starts at $130,000.   Information regarding additional benefits offered by Advanced Energy is provided below.



As part of our total rewards philosophy, we believe in offering and maintaining competitive compensation and benefits programs for our employees to attract and retain a talented, highly engaged workforce.  Our compensation programs are focused on equitable, fair pay practices including market-based base pay, an annual pay-for-performance incentive plan, and discounted Employee Stock Purchase Plan. 


In addition to our competitive compensation practices, we offer a strong benefits package in each of the countries in which we operate.  In the U.S., we offer a rich benefits package that includes:


  • Medical - 4 different health care plan options, dental, and vision
  • Short and long-term disability and life insurance
  • Health savings and flexible spending accounts
  • Generous paid time off starting at 4 weeks, 7 holidays and 3 floating holidays
  • 8 Hours of paid volunteer time off
  • 8 weeks of paid parental leave for both Moms and Dads
  • Company matched 401(k)
  • Tuition reimbursement
  • Expanded mental health coverage and employee assistance programs  
  • Other voluntary benefits include pet insurance, identify theft, legal assistance, critical illness, and voluntary accident insurance


Advanced Energy is committed to diversity in its workforce including Equal Employment Opportunity for Minorities, Females, Protected Veterans, and Individuals with Disabilities


Job ID - 26872


Nearest Major Market: Denver