Data Analyst - Wealth Regulatory

• Description:* Project: Regulatory project, the team is required to have some feeds to another tool. The timeline is until June 20
• Wealth regulation. P.I.E.R, trading information. P.I.E.R: Participant Information and Efficiency Report (P.I.E.R.) provides a monthly summary of a firm’s Insurance & Retirement Services (I&RS) utilization activity. This report displays the firm’s trading relationships and transactional volume activity totals by product. For products having a money settlement component, the report includes the firm’s gross settlement amount for a given month. Day-To-Day:
• Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness.
• Develop cross validation rules to ensure mapping accuracy by leveraging SQL.
• Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production.
• Self-sufficient and strong communication skills (must be able to work with external groups/departments).
• Provide support to ad-hoc queries from users
• Provide updates on daily scrum ceremonies Candidate Must-Haves: 1. 3-5 years of experience of a Data Analyst
• Experience with Data mapping and Data management
• Experience with Python (ability to code)
• Technologies required: SSIS/MS SQL Server, SSMS, T-SQL, Stored Procedures, Functions Candidate Nice-To-Haves:
• Markit EDM experience - Back end of SSIS (if they don't have they will teach)
• Wealth Management experience
  
  

À propos d'Aston Carter:

Veuillez noter : Des fraudeurs essaient de se faire passer pour des employés d'Aston Carter. Nous n'utiliserons jamais des services gratuits comme Gmail, Telegram ou WhatsApp pour communiquer avec vous et nouse ne vous demanderons jamais d'argent.

Aston Carter, une division d'Aerotek, est un fournisseur d'envergure mondiale de services de recrutement et de dotation de personnel pour les sociétés à la recherche de professionnels du milieu des affaires hautement spécialisés. Aerotek est une société en exploitation d'Allegis Group, un fournisseur multinational de solutions en matière de talent. Aston Carter s'engage fermement à offrir un service de premier ordre aux clients et aux professionnels du milieu des affaires dans un vaste éventail de disciplines, notamment la comptabilité, la finance, la gouvernance ainsi que la gestion du risque et de la conformité. Avec plus de 60 bureaux en Europe, Asie et Amérique du Nord, Aston Carter offre une expertise locale, régionale et mondiale pour répondre aux besoins uniques de ses clients. Reconnu best of staffing par nos clients et le talent que nous recrutons, Aston Carter s'engage à livrer un service hors pair a tous nos partenaires d'affaire.

About Aston Carter:

Please Note: Scammers are posing as Aston Carter. We'll never contact you via Gmail, Telegram, or WhatsApp and we'll never solicit money from you. Aston Carter is a distinguished global provider of recruitment and staffing services to companies requiring highly specialized business professionals. As a Best of Staffing® Client and Talent leader, Aston Carter has an unrivaled commitment to delivering first class service to clients and business professionals across a variety of disciplines, including Accounting and Finance as well as Governance, Risk and Compliance. With more than 60 offices across Europe, Asia Pacific and North America, Aston Carter provides local, regional and global expertise to drive value and meet our customers' unique needs. Aston Carter is a division of Aerotek. Aerotek is an operating company of Allegis Group, a global talent solutions provider. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.