Azure Data Engineer

Location: United States
Work arrangement: Remote
Job type: Contract

About the Role

We are looking for a hands-on Data Engineer who lives in SQL and knows Snowflake well. You will design and build scalable data models and pipelines using Azure Data Factory, Coalesce and dbt, and keep them fast, tested and reliable. You will also work with business stakeholders to turn requirements into working data solutions. Healthcare data experience is a plus.

Primary Skills

Snowflake, Coalesce, Azure Data Factory (ADF), SQL, Python and dbt.

What You Will Do

• Design and build scalable data models and data pipelines




• Develop and manage Azure Data Factory pipelines for data ingestion, transformation, orchestration and Snowflake integration




• Build scalable Snowflake data models with Coalesce, using automation and metadata-driven development




• Find and fix performance bottlenecks in Snowflake queries and dbt models




• Optimize Snowflake warehouse configurations and query performance




• Design data quality frameworks and testing strategies




• Create reusable dbt packages and macros




• Manage CI/CD pipelines for dbt deployments




• Profile data, including primary and unique keys, cardinality, data types, precision, scale and data skew




• Work with business stakeholders to translate requirements into technical solutions in an Agile team

What You Bring

• Strong SQL skills, including complex SQL workloads




• Hands-on Snowflake experience, including data modeling, warehouse optimization, query tuning and troubleshooting




• Hands-on experience with Coalesce




• Strong experience developing and managing Azure Data Factory pipelines




• Experience with dbt, including advanced features such as macros, packages and custom materializations




• Strong Python experience




• Experience working in an Agile development environment

Nice to Have

• Healthcare application or data experience

How to Apply

Email your resume to jobs@rishiwrites.com with “Azure Data Engineer, Remote” in the subject line.

Looking for more opportunities? Browse other open positions.

Frequently Asked Questions

1. Is this job remote?

Yes. It is a remote role.

2. Which country is it open to?

The United States.

3. What type of job is it?

A contract role.

4. Which tools are most important?

Snowflake, Azure Data Factory, Coalesce, dbt, SQL and Python.

5. Is Coalesce experience required?

Yes. Hands-on Coalesce experience is required.

6. What dbt experience is needed?

Advanced features such as macros, packages and custom materializations.

7. Will I tune performance?

Yes. Snowflake queries, dbt models and warehouse configurations.

8. Does the role include data quality work?

Yes. You will design data quality frameworks and testing strategies.

9. Will I manage CI/CD?

Yes, for dbt deployments.

10. Is Python required?

Yes. Strong Python experience is required.

11. Is healthcare experience required?

No. It is preferred.

12. Will I work with business teams?

Yes. You will translate business requirements into technical solutions.

13. What development method does the team use?

Agile.

14. How many years of experience are required?

The posting does not state a minimum. Strong hands-on experience with the listed tools is required.

15. How do I apply?

Email your resume to jobs@rishiwrites.com.