Position Overview: We are seeking a highly skilled Data Engineer with a strong focus on database engineering to join our growing team. In this role, you will be responsible for the design, implementation, and optimization of our database systems, ensuring they are robust, scalable, and aligned with our data architecture strategy. The ideal candidate will have a deep understanding of database technologies, data modeling, and data pipeline development, with a proven track record of managing complex data environments.
Key Responsibilities:
- Database Design & Architecture: Design and implement highly available, scalable, and secure database architectures that meet the needs of the organization. Work closely with data architects to align database solutions with overall data strategy.
- Data Modeling: Develop and maintain logical and physical data models, ensuring data integrity, performance, and compliance with best practices. Optimize schema designs to support efficient data storage, retrieval, and processing.
- ETL/ELT Pipelines: Design, build, and maintain efficient ETL/ELT processes to ingest, transform, and load data from various sources into our databases. Automate data workflows to support real-time and batch processing requirements.
- Performance Tuning: Monitor and optimize database performance, including query tuning, indexing strategies, and resource allocation. Identify and resolve performance bottlenecks to ensure optimal database performance.
- Data Governance & Security: Implement and enforce data governance policies, ensuring compliance with data privacy and security standards. Manage database access controls, encryption, and other security measures.
- Database Operations: Oversee database operations, including backup and recovery, disaster recovery planning, and routine maintenance. Collaborate with DevOps teams to implement CI/CD pipelines for database changes.
- Collaboration & Communication: Work closely with data scientists, analysts, software engineers, and other stakeholders to understand data requirements and deliver solutions that meet business needs. Communicate complex technical concepts to non-technical audiences.
- Continuous Improvement: Stay up-to-date with the latest database technologies, trends, and best practices. Continuously seek opportunities to improve database performance, scalability, and reliability.
Qualifications:
- Education: Bachelor’s degree in Computer Science, Information Technology, or a related field. A Master’s degree is a plus.
- Experience: Around 3+ years of experience in database engineering, data engineering, or a related role, with a strong focus on database design, optimization, and management.
- Technical Skills:
- Proficiency in SQL and experience with one or more RDBMS (e.g., PostgreSQL, MySQL, SQL Server, Oracle).
- Experience with NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB) is a plus.
- Strong understanding of data modeling techniques, including normalization, denormalization, and star/snowflake schemas.
- Experience with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery) and data lake architectures.
- Proficiency in ETL/ELT tools and frameworks (e.g., Apache Airflow, Talend, Informatica).
- Knowledge of cloud platforms and services (e.g., AWS, Azure, GCP) for database deployment and management.
- Familiarity with scripting languages (e.g., Python, Bash) for automation and data processing.
- Soft Skills:
- Strong problem-solving skills and attention to detail.
- Excellent communication and collaboration skills.
- Ability to work independently and manage multiple tasks in a fast-paced environment.
Preferred Qualifications:
- Experience with big data technologies (e.g., Hadoop, Spark, Kafka).
- Certification in database management or cloud platforms.
- Experience with CI/CD pipelines and infrastructure as code (IaC) tools.
What We Offer:
- Competitive salary and benefits package.
- Opportunities for professional growth and development.
- A collaborative and inclusive work environment.
- Flexible work arrangements, including remote work options.