• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Snowflake ETL Engineer - remote role

In United States

Save this job

Snowflake ETL Engineer - remote role   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Snowflake ETL Engineer - remote role

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Chicago, IL United States

JOB DESCRIPTION:

Cloud ETL/SQL Developer - remote role  #LI-Remote Front Office Solutions is a new strategic business for Client, which provides a holistic digital + service offering for some of the most sophisticated institutional investors across the globe, including foundations, endowments, pension funds, corporations, insurance companies, central banks, and sovereign wealth funds. As asset owners engage in more complex, data-driven investment approaches to asset allocation, their demand for high quality data have skyrocketed. The Front Office Solutions software development team is committed to meeting that demand by building a world-class, cloud-native investment analysis product. We build software in fast cycles from idea to production using AWS tools and techniques, including DevOps methods and serverless systems. The development team, we strive to collaborate the business and product leaders to: • Promote team collaboration. • Contribute design and user experience insight. • Add a development perspective to product idea and feature feasibility. As Front Office Solutions continues to grow and attract complex asset owners with complex requirements, Client is heavily investing in the platform. Join us as we create the next generation of financial reporting tools for institutional investors. We have openings throughout the technology stack and software development lifecycle.   Qualifications: Description Your key responsibilities Snowflake: 2 years of Hands-on experience in Snowflake cloud data warehouse. Experience of designing warehouse and pipelines with Snowflake architecture, Data model. Well versed with Snowflake concepts like Snowpipe, SnowSQL, Cloud services, Data sharing, Reader accounts, Designing optimal virtual warehouses as per the business SLAs, optimized data distribution, clustering keys, usage of materialized views. Minimum of 6 years of Overall IT experience including experience as Technical lead in Data warehousing technologies including modern cloud data warehousing. Hands on Experience in ELT tools like Informatica, AWS glue or any other parallel ELT tools. Experience of semi-structured (XML, JSON) and unstructured data handling Knowledge of how to implement security features like SSO, column masking, role-based administration.   BI Reporting/ETL Experience: Should have designed and developed stored procedures, queries, ETL Process, views, Data models necessary to support BI Visualizations. Should be able to effectively handle reports performance and administration Strong knowledge of ELT/ETL concepts, design and coding. Candidate should be eager to learn advance technologies, new product updates etc., learn and train other team members Excellent analytical skills and communication skills (written, verbal and presentation). Additional knowledge of complex source system data structures preferably in Financial services (preferred) Industry and reporting related developments will be an advantage. Using warehouse data to generate reports to support business decision making and business performance monitoring. Generating and delivering quality reports to customers and performing quality assurance checks on reports. Develop, Customize, Deploy, maintain data visualizations as per client business requirements Should have thorough knowledge in creating dynamic visualizations with multiple concepts. Experience working with clients throughout various parts of implementation lifecycle Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements. Employee Status: Regular Job Level: Individual Contributor Job Type: Standard

Position Details

POSTED:

Oct 04, 2022

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16565472597686024

LOCATION:

United States

CITY:

Chicago, IL

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Snowflake ETL Engineer - remote role    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Cloud ETL/SQL Developer - remote role  #LI-Remote Front Office Solutions is a new strategic business for Client, which provides a holistic digital + service offering for some of the most sophisticated institutional investors across the globe, including foundations, endowments, pension funds, corporations, insurance companies, central banks, and sovereign wealth funds. As asset owners engage in more complex, data-driven investment approaches to asset allocation, their demand for high quality data have skyrocketed. The Front Office Solutions software development team is committed to meeting that demand by building a world-class, cloud-native investment analysis product. We build software in fast cycles from idea to production using AWS tools and techniques, including DevOps methods and serverless systems. The development team, we strive to collaborate the business and product leaders to: • Promote team collaboration. • Contribute design and user experience insight. • Add a development perspective to product idea and feature feasibility. As Front Office Solutions continues to grow and attract complex asset owners with complex requirements, Client is heavily investing in the platform. Join us as we create the next generation of financial reporting tools for institutional investors. We have openings throughout the technology stack and software development lifecycle.   Qualifications: Description Your key responsibilities Snowflake: 2 years of Hands-on experience in Snowflake cloud data warehouse. Experience of designing warehouse and pipelines with Snowflake architecture, Data model. Well versed with Snowflake concepts like Snowpipe, SnowSQL, Cloud services, Data sharing, Reader accounts, Designing optimal virtual warehouses as per the business SLAs, optimized data distribution, clustering keys, usage of materialized views. Minimum of 6 years of Overall IT experience including experience as Technical lead in Data warehousing technologies including modern cloud data warehousing. Hands on Experience in ELT tools like Informatica, AWS glue or any other parallel ELT tools. Experience of semi-structured (XML, JSON) and unstructured data handling Knowledge of how to implement security features like SSO, column masking, role-based administration.   BI Reporting/ETL Experience: Should have designed and developed stored procedures, queries, ETL Process, views, Data models necessary to support BI Visualizations. Should be able to effectively handle reports performance and administration Strong knowledge of ELT/ETL concepts, design and coding. Candidate should be eager to learn advance technologies, new product updates etc., learn and train other team members Excellent analytical skills and communication skills (written, verbal and presentation). Additional knowledge of complex source system data structures preferably in Financial services (preferred) Industry and reporting related developments will be an advantage. Using warehouse data to generate reports to support business decision making and business performance monitoring. Generating and delivering quality reports to customers and performing quality assurance checks on reports. Develop, Customize, Deploy, maintain data visualizations as per client business requirements Should have thorough knowledge in creating dynamic visualizations with multiple concepts. Experience working with clients throughout various parts of implementation lifecycle Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements. Employee Status: Regular Job Level: Individual Contributor Job Type: Standard


Please wait..!!