Senior Data Engineer | Azure Databricks, Synapse, Snowflake, Python, SQL | Contract-to-Hire

View all jobs

Senior Data Engineer | Azure Databricks, Synapse, Snowflake, Python, SQL | Contract-to-Hire

Bethesda, MD

Recruiting Business Unit

In office

Contract

The Opportunity

Our client attracts people who think critically, communicate clearly, and execute with urgency. People who take ownership, solve problems independently, and thrive in environments where impact matters more than hierarchy.

They're a boutique tactical asset manager serving the independent broker-dealer and RIA market. As they continue investing in their data platform, they're looking for a Senior Data Engineer to help build the foundation that powers analytics, reporting, operational insights, and future AI initiatives.

This is a highly visible role where you'll work directly with business and technology stakeholders to design and implement scalable data solutions that support growth across the organization.

Location: Onsite, 5 days a week, Bethesda-MD

Senior Data Engineer | Azure Databricks, Synapse, Snowflake, Python, SQL | Contract-to-Hire | $120K-$140K

What You'll Do

• Design, build, and maintain scalable data pipelines that integrate data from internal systems, third-party platforms, APIs, and external data providers.
• Help design and develop a centralized Azure-based data lake and analytics platform.
• Build and optimize ETL/ELT processes using modern cloud data technologies.
• Develop trusted, business-ready datasets that support reporting, analytics, and operational decision-making.
• Design and maintain dimensional models, data marts, and curated datasets for downstream consumption.
• Partner with business stakeholders to understand reporting and analytics requirements and translate them into scalable data solutions.
• Support Power BI dashboards, operational reporting, and ad hoc analytical needs.
• Implement data quality, monitoring, validation, and governance processes to ensure reliable and accurate data.
• Contribute to data platform architecture decisions, performance optimization, and cloud cost management.
• Document data assets, processes, and technical designs to support long-term maintainability.

Required Qualifications

• 5+ years of experience in Data Engineering, Data Warehousing, or related disciplines.
• Strong SQL skills and experience developing complex queries, transformations, and data models.
• Professional experience with Python and modern ETL/ELT development.
• Hands-on experience with Azure Data Factory, Azure Databricks, Synapse Analytics, or similar Microsoft data technologies.
• Experience building and maintaining cloud-based data lakes, warehouses, or lakehouse environments.
• Strong understanding of dimensional modeling, star schemas, and data warehousing best practices.
• Experience integrating data from APIs, databases, flat files, and third-party platforms.
• Experience working directly with business stakeholders to deliver reporting and analytics solutions.
• Strong communication skills and ability to operate independently in a fast-paced environment.
• Experience in financial services, asset management, wealth management, or other regulated industries.

Preferred Qualifications

• Experience with Snowflake, dbt, or modern analytics engineering practices.

• Experience supporting Power BI or other business intelligence platforms.

• Experience with Airflow or similar orchestration tools.

• Experience working with Azure cloud services and cloud-based data architecture.

• Familiarity with data governance, security, and regulatory requirements.

• Experience building greenfield data platforms or leading cloud migration initiatives.

• We cut through the industry BS with brutal transparency and an obsession with execution. If you’re looking for a slow pace and low volume, this isn’t for you.

• If you want to drive, build, and scale, this is your shot. Please note, we are unable to provide visa sponsorship now or in the future.

Compensation

The base pay range for this role is $120,000 – $140,000 per year.

Ready to apply?

Powered by

First name *

Last name *

Email *

LinkedIn URL *

Location *

Resume *

Click to upload or drag and drop here

Cover letter

Click to upload or drag and drop here

Are you a current Midwestern employee?

Yes

No

Are you willing to work onsite, 5 days a week, in Bethesda-MD? *

Yes

No

Do you have experience in financial services, asset management, wealth management, or other regulated industries? *

Yes

No

By applying you agree to Gem's terms and privacy policy.

Save your info to apply to other roles faster & help employers reach you.

Apply and saveApply without saving

Req ID: R18