Senior Azure ETL Specialist (Data Architect)

p3 Human Capital; Washington (District of Columbia); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Relocation aid available

Job summary

A global business strategy firm is actively seeking a highly-skilled Senior Azure ETL Specialist to lead the design of data architecture solutions. This full-time position allows for remote or onsite work in Washington, D.C. Candidates should have at least 8 years of ETL development experience and a solid foundation in Azure Cloud technologies. This role offers an opportunity to make a significant impact on homeland security through innovative processes and reliable data integration solutions.

Qualifications

• 8+ years of experience with industry-standard ETL development techniques.
• 8+ years of experience with Oracle, Postgres, Cosmos, or SQL database technologies.
• 5+ years of experience with data integration.
• 3+ years of experience with Azure Cloud SaaS solutions.

Responsibilities

• Lead the design of data architecture solutions for ETL processes.
• Resolve routine data architecture-related issues in collaboration with teams.
• Establish processes to facilitate technological innovation.

Skills

ETL development techniques

Oracle

Postgres

Cosmos

SQL database technologies

Data integration

Azure Cloud SaaS solutions

Data Factory

Job description

• Full-time

Company Description

Born in the wake of "the great resignation", Alleghany-Greenbrier Human Capital, a subsidiary of HarrisFields Seach Partners, N.A., is a multi-discipline-focused direct-hire search firm, headquartered in the heart of the nation's capital.

Job Description

Allegheny-Greenbrier's client, a global business strategy and transformation-focused management consulting firm, is actively recruiting a highly-skilled senior-level Azure ETL Specialist. This is a direct-hire, full-time, and permanent (FTE) role. The selected candidate can either elect to work remotely or onsite in the Washington, D.C. metropolitan area. Relocation aid is available to a candidate with superior qualifications.

Qualifications

As a data architect on our domestic resilience team, you’ll use your extensive technical expertise to lead the design of data architecture solutions to build reliable ETL (Extract-Transform-Load) processes to facilitate data transfers between homogeneous or heterogeneous sources and target systems.

You’ll resolve routine data architecture-related issues in collaboration with business analysts and technology teams by setting up the system, testing it to ensure flawless operations, and correcting any issues. With your motivation to establish processes and facilitate technological innovation, you’ll make a lasting impact on homeland security.

You Have:

• 8+ years of experience with industry-standard ETL development techniques
• 8+ years of experience with Oracle, Postgres, Cosmos, or SQL database technologies
• 5+ years of experience with data integration
• 3+ years of experience with Azure Cloud SaaS solutions and managed services, including serverless, technologies such as Azure Data Factory
• Knowledge of disparate data sources and targets

Nice If You Have:

• Experience with data analysis and profiling of source data while developing and building robust ETL processes
• Experience with API management, development, and testing
• Knowledge of data validation, cleansing, transformation, consolidation, de-duplication, aggregation, de-aggregation, and enrichment
• Knowledge of how to build ETL processes for scale and performance

Additional Information

All your information will be kept confidential according to EEO guidelines.