Data Warehouse Engineer

Employer
Busey
Location
Creve Coeur, Missouri
Salary
Open
Posted
May 04, 2023
Closes
Jun 04, 2023
Type
Full Time

WHAT YOU'LL BRING

Duties:

  • Design, develop, and maintain data warehouse ETL processes to ensure accurate and timely data availability for business intelligence and analytics.
  • Define and implement efficient database architecture, including data modeling, indexing, partitioning, and performance tuning.
  • Collaborate with cross-functional teams to gather requirements, define data integration and transformation strategies, and deliver data solutions.
  • Assist in migrating existing on-premise data infrastructure to cloud platforms (e.g., AWS, Azure, or Google Cloud Platform).
  • Monitor and troubleshoot data pipeline performance, ensuring data quality, and addressing any data-related issues.
  • Stay up-to-date with the latest data engineering best practices, tools, and technologies to continuously improve and optimize data warehouse processes.
  • Develop and maintain technical documentation, including data flow diagrams, data dictionaries, and system specifications.

Knowledge:

  • Proficiency in SQL and experience with various database management systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server).
  • Solid understanding of data warehouse concepts, including star schema, snowflake schema, and dimensional modeling.
  • Experience with ETL tools such as Microsoft SQL Server Integration Services (SSIS).
  • Knowledge of cloud platforms and experience in cloud migration, specifically with AWS, Azure, or Google Cloud Platform.
  • Strong programming skills in languages such as Python, Java, or Scala.
  • Knowledge of data visualization tools such as IBM Cognos, Tableau, or Power BI.

Ability:

  • Excellent problem-solving skills, attention to detail, and ability to work effectively both independently and in a team environment.
  • Strong communication skills, with the ability to explain complex technical concepts to non-technical stakeholders
  • Ability to lead and influence discussions across a variety of stakeholders to achieve results and proactively address sources of conflict
  • Self-starter with great communication skills (verbal and written)

WHY IT MATTERS

The Data Warehouse Engineer is the foundational role of Busey's Business Intelligence program; ensuring the organization's data is stored in a centralized location and can be easily accessible. This role focuses on creating and maintaining data warehouse integrations, defining data architecture, and ensuring data accessibility.

EDUCATION & TRAINING

  • Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field. A Master's degree is preferred.
  • Minimum two years of experience in the technology industry, knowledge of the Financial Industry is a plus.
  • 3+ years of experience in data engineering, ETL development, and database management.
  • Certifications in data engineering, database management, or cloud platforms is a plus.
  • Requires knowledge of Microsoft Office.

WORK ENVIRONMENT

Duties are performed in an office setting and include physical demands such as the manual dexterity and skill to operate standard office equipment. Reasonable accommodations may be made to enable people with disabilities to perform the essential functions of this position.

The above statements are intended to describe the general nature of work being performed by people assigned to this job. They are not intended to be considered an exhaustive list of all responsibilities, duties, and skills of the people so classified.

Busey believes that diversity and inclusion among our teammates is critical to our success as a company, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool.

Equal Opportunity Employment is a priority for Busey and all qualified applicants will receive consideration regardless of race, color, religion, national origin, genetic information, sex (including pregnancy), age, sexual orientation, gender (including gender identity and expression), marital status, military status, veterans status, citizenship status, disability, order of protection or any other characteristic protected by applicable law or other non-merit based factors.



Similar jobs

Similar jobs