Job Description:
This position is for a Cloud Data / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise.
Major Responsibilities:
• Experience designing and developing Enterprise Data Warehouse solutions.
• Demonstrated proficiency with Data Analytics, Data Insights
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process
• Leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend and SnowSQL) to develop data pipeline solutions to ingest and exploit new and existing data sources.
• Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.
Skills:
• 10+ years - Enterprise Data Management
• 10+ years - SQL Server based development of large datasets
• 5+ years with Data Warehouse Architecture, Snowflake experience preferred
• 3+ years' experience in Finance / Banking industry - some understanding of Securities and Banking products and their data footprints.
• 2+ years Python coding experience
• Experience with pyspark (good to have, should understand the architecture)
• Proficient with Data Visualization tools
• Hands-on experience with Snowflake utilities such as SnowSQL and SnowPipe
• Working knowledge of MS Azure configuration items with respect to Snowflake.
• Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing
• Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
• Previous experience leading an enterprise-wide Cloud Data Platform migration with strong architectural and design skills
• Capable of discussing enterprise level services independent of technology stack
• Experience with Cloud based data architectures, messaging, and analytics
• Superior communication skills
• Cloud certification(s)
• Any experience with Regulatory Reporting is a Plus
...transformations, and business rules into dbt models (SQL) on Snowflake.Design and implement staging, core, and mart layers using standard... ...phases.Experience & Skills7+ years of experience in Data Engineering / ETL / DW, with 2+ years working with dbt (Core or Cloud)....
...less than 20; (5) Contract: 1-2 years; Benefits: (1) Salary: up to RMB 30,000rmb/month after tax or more; (2) Paid holidays: 1 week's Christmas holiday, 2 weeks winter holiday, 3 days' sick leave, 2 days' paid leave all public holidays, 4 weeks summer holiday; (...
...Company Description Job Description Operations Administrator to operate smoothly and effectively, supporting colleagues who deliver... ..., to producing documents, maintaining records and supporting school-level projects, you will help ensure that colleagues have the...
...used vehicles in the United States, is seeking an experienced Automotive Mechanic to join our skilled team. You will diagnose and repair a wide range of vehicle issues while ensuring high customer satisfaction.The ideal candidate is technically skilled, detail-oriented...
...premier real estate, insurance, and mortgage agency serving Eastern Maine since 1974, is seeking a Remote Personal Assistant at entry level. The role offers full-time or part-time options with 100% remote work and flexible hours to fit around school, family, or other...