Data Warehouse Engineer

at First Busey Corporation in Chicago, Illinois, United States

Job Description

Position SummaryThe Data Warehouse Engineer is a key technical role responsible for the design, development, maintenance, and optimization of data warehouse processes. This includes creating and maintaining ETL (Extract, Transform, Load) processes, defining database architecture, and assisting in cloud migration efforts. The Data Warehouse Engineer collaborates with cross-functional teams to deliver data solutions that support Business Intelligence and analytics, ensuring data is accurate, timely, and easily accessible
Duties & Responsibilities
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.
Education & Experience
Knowledge of:
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 to:
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)
Education and 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.

Busey values a diverse and inclusive workplace and strives to recruit, develop and retain individuals with exceptional talent. A team with diverse talent, working together, is essential to Busey's commitment of delivering service excellence. Busey is an Equal Opportunity Employer including Disability/Vets. Visit Busey.com/Careers to learn more about Busey's Equal Opportunity Employment.

EOE of Minorities/Females/Vets/Disability