Lead Data Warehouse Engineer

Responsibilities

Architecting and maintaining the Operational data stores (ODS), Enterprise Data Warehouse (EDW) and associated data intelligence environments including data lakes, data marts, and metadata repositories

Designing and implementing high performance data movement pipelines using multiple ETL tools with batch and real-time event data streams (Informatica, Databricks, Azure Event Hub, SQL Packages, etc.)

Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks

Gathering business and information requirements from various product owners across various functional units

Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models.

Conducting design review sessions and communicating design artifacts with stakeholders.

Ensures database features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability.

Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders

Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks

Leading and coordinating the design and operationalization of Master Data Management and Data Governance initiatives including custom developed solutions.

Working with other members of the project team to support delivery of additional project components associated with cloud data platform.

Problem-solving of Data warehouse and ODS application issues and production errors, including high level critical production issues that require immediate attention.

Perform other duties as assigned including major new project initiatives.

Job Type: Contract

Pay: $50.00 - $90.00 per hour

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Schedule:

• 8 hour shift

Work Location: Remote