Data Warehouse Engineer - Remote at Mechanicode.io

Mechanicode, a leader in Cloud Digital Services, is excited to announce a new opening for a Data Warehouse Engineer. This role is perfect for someone with a solid background in data warehousing, data modeling, and database administration of scalable data management systems.

Key Responsibilities

As a Data Warehouse Engineer, you will:

• Manage large datasets and develop scalable data warehousing solutions.
• Create innovative ETL processes to integrate data from diverse sources into a centralized data warehouse.
• Optimize complex SQL queries for data extraction and business decision support.
• Ensure system scalability, security, performance, and reliability in developing database solutions.
• Analyze complex data sets to identify trends, patterns, and anomalies.
• Create reports and visualizations to make data comprehensible for all stakeholders.

Required Qualifications

• Must be a U.S citizen or green-card holder.
• 5+ years of professional experience in a relevant field.
• Ability to pass a background check and obtain a public trust security clearance.
• Proficiency with Python and SQL.
• Experience with data warehousing technologies such as Oracle, SQL Server, Snowflake, or AWS Redshift.
• Experience working with cloud providers like AWS or Azure.
• Expertise in Git operations including cloning, branching, and merging.

Preferred Qualifications

• AWS/Azure certifications are a plus.

Why Join Mechanicode?

Mechanicode is a remote-first company founded by a former USDS engineer with 13 years of experience. Our mission is to bring peace of mind with technology through efforts like our self-healing cloud infrastructure and automation-centric cloud solutions. Our environment promotes rapid development, improving both our client's experience and the developer's experience through Agile practices and continuous integration & deployment standards.

Interview Process

• Preliminary Technical Screen
• Hackerrank Assessment
• Hackerrank Review
• Client Interview

Salary and Benefits

The position offers a competitive salary range of $100k-$110k based on experience, with full remote work flexibility.

If you are driven, innovative, and see yourself thriving in a company passionate about leading cloud solutions and self-healing operations, then apply to join us as our new Data Warehouse Engineer!

This is a W2 position.