Smallarc - Chicago, IL

posted 4 months ago

Full-time
Chicago, IL
Professional, Scientific, and Technical Services

About the position

The Data Warehouse Architect position is a critical role within our organization, focusing on the design, development, and management of our data warehousing solutions. This position requires a deep understanding of data engineering principles, particularly in Oracle environments, and the ability to leverage advanced SQL and PL/SQL skills to solve complex business problems. The architect will be responsible for organizing and monitoring data jobs, ensuring failure recovery processes are in place, and optimizing data movement through effective shell scripting in a Linux environment. In this role, the Data Warehouse Architect will collaborate with various stakeholders to enhance our enterprise data warehousing capabilities. This includes designing and implementing data models, ensuring data integrity, and developing strategies for data enhancement. The architect will also play a key role in the BI Data Analyst function, utilizing SQL to analyze data and provide insights that drive business decisions. The ideal candidate will have a strong background in data warehousing, data engineering, and business intelligence, with a proven track record of delivering high-quality data solutions. The position is expected to last for a duration of 12 months or more, and the successful candidate will be part of a dynamic team that values innovation and collaboration. The role is based in Chicago, IL, and requires a commitment to excellence in data management and architecture.

Responsibilities

  • Organizing and monitoring data jobs in the data warehouse.
  • Implementing failure recovery processes for data jobs.
  • Developing and executing shell scripts in a Linux environment for data movement.
  • Utilizing PL/SQL for data engineering tasks and enhancements.
  • Designing and enhancing enterprise data warehousing solutions.
  • Collaborating with business stakeholders to analyze data and provide insights using SQL.
  • Ensuring data integrity and optimization in data warehousing processes.

Requirements

  • 12+ years of experience in data warehousing and data engineering.
  • Deep knowledge of PL/SQL and experience in development.
  • Proficiency in shell scripting and Linux environments.
  • Strong understanding of enterprise data warehousing concepts and design.
  • Experience in BI data analysis and solving complex business problems using SQL.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service