We are seeking a results-oriented database engineer to help optimize the performance of our organization's databases. You will be enhancing our data storage capacity, writing new support programs and scripts, and troubleshooting database code.
To ensure success as a database engineer, you should exhibit knowledge of best practices in database management and experience in a similar role. A top-notch database engineer will be someone whose database optimization skills translate into the efficient flow of information throughout an organization.
Qualifications for a Data Warehouse Engineer:
Educational Background:
- Bachelor's Degree:** Typically in Computer Science, Information Technology, Engineering, or a related field.
Certifications:
- Microsoft Certified: Azure Data Engineer Associate
- AWS Certified Database - Specialty
- Certified PostgreSQL Professional
Experience:
- A minimum of 10 years of experience in data warehousing, ETL (Extract, Transform, Load) processes, and BI (Business Intelligence) solutions.
- Proficiency in designing and implementing ETL processes, preferably with tools like Microsoft SSIS.
Technical Skills:
- Strong SQL skills and an understanding of relational and columnar database structures.
- Familiarity with data modeling techniques such as star schema, snowflake schema, and denormalization.
- Knowledge of performance tuning and optimization techniques for large-scale data systems.
- Experience with BI tools like QlikView can be a plus.
- Understanding of big data technologies such as Hadoop, Spark, and Hive can be advantageous.
Soft Skills:
- Analytical mindset to translate business requirements into technical data solutions.
- Strong communication skills to interact with stakeholders, analysts, and other technical teams.
- Attention to detail and a commitment to data accuracy and integrity.
- Teamwork and collaboration skills, given the cross-functional nature of data projects.
- Maintaining and enhancing the performance of existing database programs.
- Assisting database development teams in designing new database programs that meet the organization's data storage needs.
- Monitoring databases and related systems to ensure optimized performance.
- Writing new support programs and scripts to increase data storage capacity.
- Reviewing database and user reports, as well as system information.
- Performing debugging procedures on database scripts and programs, as well as resolving conflicts.
- Mentoring database administrators and providing them with technical support.
- Adhering to best practices in securely storing, backing up, and archiving data.
- Documenting processes related to database design, configuration, and performance.
- Keeping abreast of developments and best practices in database engineering.
