Remote Data Warehouse Engineer

Description:

• Design and architect scalable and efficient data warehouse solutions, including data models, schemas, and storage structures.
• Develop and maintain ETL (Extract, Transform, Load) processes to extract data from source systems, transform it to meet business requirements, and load it into the data warehouse.
• Design and implement dimensional and normalized data models to support reporting, analytics, and business intelligence applications.
• Integrate data from diverse sources, including databases, applications, APIs, and flat files, ensuring data consistency and integrity.
• Optimize data warehouse performance for query speed, concurrency, and scalability, tuning SQL queries, indexing strategies, and partitioning schemes.
• Implement data quality checks and validation rules to ensure the accuracy, completeness, and consistency of data in the warehouse.
• Monitor data warehouse performance and health, proactively identifying and addressing issues to minimize downtime and optimize resource utilization.
• Document data warehouse architecture, processes, and best practices, and collaborate with cross-functional teams to ensure alignment and transparency.

Requirements:

• Bachelor's degree or higher in Computer Science, Engineering, or related field.
• Strong background in data engineering, with hands-on experience in designing, building, and maintaining data warehouse solutions.
• Proficiency in SQL and database technologies such as PostgreSQL, MySQL, SQL Server, or Oracle.
• Experience with data warehouse platforms and technologies such as Amazon Redshift, Google BigQuery, Snowflake, or Microsoft Azure SQL Data Warehouse.
• Familiarity with ETL tools and technologies such as Apache Airflow, Talend, Informatica, or AWS Glue.
• Strong problem-solving abilities and analytical thinking, with a keen attention to detail and a passion for tackling complex technical challenges.
• Excellent communication and collaboration skills, with the ability to work effectively in cross-functional teams and communicate technical concepts to non-technical stakeholders.

Benefits:

• Competitive salary: The industry standard salary for Data Warehouse Engineers typically ranges from $140,000 to $210,000 per year, depending on experience and qualifications. Exceptional candidates may be eligible for higher compensation packages.
• Comprehensive health, dental, and vision insurance plans.
• Flexible work hours and remote work options.
• Generous vacation and paid time off.
• Professional development opportunities, including access to training programs, conferences, and workshops.
• State-of-the-art technology environment with access to cutting-edge tools and resources.
• Vibrant and inclusive company culture with team-building activities and social events.
• Opportunities for career growth and advancement within the company.
• Exciting projects with real-world impact across diverse industries.
• Chance to work alongside top talent and industry experts in the field of data warehouse engineering.