JOB DESCRIPTION

This is an exciting opportunity for an experienced Senior Data Warehouse Engineer of large-scale data solutions. You will join a team delivering a transformative next-gen cloud hosted data platform. The ideal candidate will have a proven track record in implementing next-gen cloud data solutions and transformation pipelines for large scale organizations. We are seeking someone with deep technical skills in a variety of data warehouse related technologies to play an important role in developing and delivering early proofs of concept and production implementation. The successful candidate will have hands-on experience in a multitude of data domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud data warehouse and reporting solutions and management, design and build data warehouse models, ETL development, performance tuning, service delivery, incident tracking, and change management.

QUALIFICATIONS:

• Bachelor’s and/or Master’s degree in Computer Science, Computer Engineering or related field preferred.
• 8+ years of overall software development experience is required primarily with Data warehouse applications.
• 3+ years of hands-on development experience in Cloud-based data warehouse platform – primarily AWS Redshift
• 2+ yrs of development experience with ETL tools (Informatica, Azure Data Factory, etc)
• 3+ years of development experience with Python scripting experience.
• 3+ years of hands-on development experience with Relational DBs (MS SQL Server, PostgreSQL, Oracle, etc.); experience with complex stored procedures and functions using SQL.
• Strong knowledge and experience in OLAP data modeling & design.
• Demonstrated expertise in performance tuning in various DB environments with large volumes of data. · Experience building and scaling distributed, high available systems in cloud env (Azure / AWS).
• Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
• Communication and professional skills and the ability to navigate relationships across business units.

• 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 (Informatica, Azure Data Factory, SQL Packages, etc) with batch and real-time event data streams.
• 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.