| Datawarehouse / Data Analyst -- Must be local to Chicago at Chicago, Illinois, USA |
| Email: [email protected] |
| Datawarehouse / Data Analyst 12 month contract, can pay $55/hourly on c2c Top Skills - Must Haves Etl Sql Data warehouse Erpss Data technology design docs Top Skills' Details **Candidates need to be already local to Chicago** 1. Strong & thorough experience within Data warehouse Hands on experience working in a data warehouse environment. Being strong in Data Warehouse and being able to answer in-depth Data Warehouse technical Q's (see below) thoroughly will be key. Candidates will be DQd if they only can articulate surface level understanding. 2. Strong in SQL - Write complex SQLs to analyze/profile datasets and identify patterns. 3. ETL 4. Strong Soft-Skills and proactive Q's they will ask/highlight in the interview: Articulate data warehousing experience They will ask q's around & discuss Data warehouse concepts and in-depth technical DW. Candidates need to articulate this well and be thorough in details. Need to have put together technology design docs - they will ask q's about this. They are migrating their data warehouse from Oracle over to Snowflake. Candidates will need to be able to articulate how they have they have built the processes around data warehouse moves & etc. Secondary Skills - Nice to Haves Snowflake Snowflake Data Cloud Snowflake Cloud Job Description Notes from our Qual Call 3/22 with Vivek & Brad: Vivek & Brad will be supporting Chouling NT corporate risk data warehouse project. This person needs to be strong in SQL, Datawarehouse, ETL, and be local to Chicago. They will be doing Complex SQL - analyzing data sets & etc, data flow diagrams, ETL (python framework - ETL ingested). Great if they have Snowflake experience! They will be helping to validate data accuracy & quality. They need to have strong soft-skills - strong analytical & problem solving skills, ability to work & collaborate well with the IT & business, good communication & presentation skills. Business requirements are data requirements. Have to understand, query, profile data to come up with specifications. Strong SQL skills and data warehouse understanding Write complex SQL and analysis exiting data sets, look at processing and recommend solutions Strong analytics and data skills Gather data requirements, work independently, good understanding of data models and coming up with ETL specification Provide data flow diagrams, data models including structures, definitions. Good presentation/communication skills- both with technical and business partners Validate data accuracy, quality. Certify data before productionized Help address issues through dev pipeline. Once developed/productionized support issue, consult with team and provide solution Document design specifications Northern corporate warehouse program Phase 1- oracle to snowflake- done, now in Phase 2 Phase 2- data brought in, set up data warehouse processing and support downstream consuming like risk, reporting Work with existing data and enhance for downstream Snowflake is nice to have, main skill is SQL skills- develop and execute complex queries, analysis data sets Come up with data requirements. Document design, understand existing processes. Majority of work is understanding the processes and reconcile data with what is in warehouse NT beeline Job description: Job Description: Project and related application development are part the bank's providing management and regulatory reporting functionality in the areas of risk and compliance. Operational Risk Reporting application is beginning development and two Credit Risk application projects are nearing design phase. This position will work closely with these projects and follow-on risk application development participating in full project life cycle. The candidate would have the opportunity to be involved in the design and development of many aspects of the Corporate Risk Data Warehouse utilizing Oracle sql and pl/sql, data warehouse / ETL tools and Unix Scripts. In addition to design and development, this candidate is expected to be a lead technical resource for this division helping to set standards and practices for production support and maintenance of technical disciplines such as these that are new to this department. Ideally this candidate will also have previous well rounded experience with business application development as well as recent solid concentration on data warehouses, ETL processing and business intelligence tools. The data warehouse ETL processes will interface with numerous Northern Trust corporate transaction systems to gather information for the warehouse. Experienced both in the specific business domain and the software engineering domain. These candidates are not only technology intensive but also possess experience of the specific business area. Have worked on similar projects and have a proven history of delivering high impact business solutions in the specific business area. Responsible for the technical vision, high-level architecture, design, and implementation of complex systems and applications. Ability to interact and communicate effectively with senior level business teams to ensure optimal results. Aside from the business specific knowledge, the individuals will also possess a complete understanding and mastery of the enterprise software development lifecycle. Specifically, this candiate should be able to perform in the following activities: 1. Strong in SQL and Data warehouse concepts Hands on experience working in a datawarehouse environment a. Write complex SQLs to analyze/profile datasets and identify patterns b. Recommend solutions based on data analysis c. Demonstrate strong analytical and problem solving skills and be quick to identify design related concerns 2. Provide Data Requirements a. Collaborate with Subject Matter experts and Business partners in gathering data requirements b. Work independently and demonstrate strong understanding of existing Datamodel and ETL processes c. Experience providing data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping d. Identify ETL dependencies and help orchestrate a sequence of data loads in the ETL pipeline e. Demonstrate good communication and presentation skills with the ability to articulate data requirements, design concerns, etc. f. Demonstrate strong negotiation skills while working with developers, architects to solution the data needs. 3. Validate the accuracy, integrity and quality of Data developed 4. Support defects triage a. Participate in the SIT, UAT defects triage and help set up a defect resolution path b. Assess defects on their impacts and help set up priorities 5. Guide the production support team on unforeseen issues, ETL abends Additional Skills & Qualifications Great if they have Snowflake (snowflake cloud) experience Employee Value Proposition (EVP) Northern Trust Corporation (Nasdaq: NTRS) is a leading provider of wealth management, asset servicing, asset management and banking to corporations, institutions, affluent families and individuals. Founded in Chicago in 1889, Northern Trust has a global presence with offices in 24 U.S. states and Washington, D.C., and across 22 locations in Canada, Europe, the Middle East and the Asia-Pacific region. As of December 31, 2023, Northern Trust had assets under custody/administration of US$15.4 trillion, and assets under management of US$1.4 trillion. For more than 130 years, Northern Trust has earned distinction as an industry leader for exceptional service, financial expertise, integrity and innovation. Work Environment onsite hybrid 3 days a week in chicago at the 333 S. Wabash NT building Business Drivers/Customer Impact NT corporate risk data warehouse project. Operational Risk Reporting application is beginning development and two Credit Risk application projects are nearing design phase. Why is the position open(provide details) Net new need -- Keywords: information technology procedural language Datawarehouse / Data Analyst -- Must be local to Chicago [email protected] |
| [email protected] View all |
| Mon Apr 29 23:45:00 UTC 2024 |