Abrazo Group is a resource provider focused on gaming, entertainment, automotive, technology, healthcare, and marketing industries. We partner with both new and established businesses to help them reach their target audiences and achieve growth. Our client based in the Greater Chicago Area is seeking a full-time Database Engineer.
Role Description
As a Database Engineer, you will be responsible for day-to-day tasks related to database administration, development, design, data modeling, and Extract Transform Load (ETL). You will collaborate with cross-functional teams to ensure data integrity, optimize database performance, and support business operations.
We are looking for a skilled Database Engineer with a strong background in database management and optimization, particularly with PostgreSQL. The ideal candidate will have experience in database archival and data lifecycle design. In addition, experience in data warehousing and ETL is highly desirable. Experience with Tableau for Data Visualization is highly desired. As a Database Engineer, you will play a crucial role in ensuring our data is efficiently managed, to optimize the performance of our digital products.
Requirements
- Design, deploy, and maintain database systems, with a primary focus on PostgreSQL, to ensure optimal performance, reliability, and scalability.
- Implement database monitoring, alerting, and optimizations to improve system efficiency and response times.
- Develop strategies and procedures for data lifecycle management, and data retention policies to meet business requirements.
- Collaborate with cross-functional teams to understand data requirements and ensure database solutions align with the organization’s data strategy.
- Troubleshoot database-related issues, identify bottlenecks, and proactively implement solutions to enhance database performance.
- Implement and maintain security measures to protect sensitive data and ensure compliance with data protection regulations.
- Develop and maintain documentation related to database design, architecture, and best practices.
- Stay up-to-date with industry trends, tools, and best practices related to database management and data engineering.
- Maintains scalable data pipelines and builds out new API integrations to support continuing increases in data volume and complexity.
Qualifications
- Proven Database Administration, Database Development, and Database Design skills
- Data Modeling and ETL (Extract Transform Load) experience.
- Strong problem-solving and analytical skills.
- Knowledge of database query languages (SQL, NoSQL)
- Tableau dashboard visualization and real-time collaboration experience
- Experience with data migration and integration.
- Understanding of database security and backup/recovery procedures.
- Bachelor's degree in Computer Science, Information Systems, or related field.
Nice-To-Have
- Familiarity with modern data warehousing platforms such as Redshift, Snowflake, BigQuery.
- Data orchestration experience with tools such as Airflow, Prefect, or Dagster.
- Knowledge of data modeling within a data warehouse: dimensional, data vault, etc.
- Experience with data integration tools such as Airbyte, Stich, FiveTran, etc.
- Experience with Tableau, Django / Python.