E*TRADE

Senior Analyst II, Data Engineering (BI Tools Admin and Automation)

Job Locations US-VA-Arlington | US-GA-Alpharetta
Posted Date 2 weeks ago(7/30/2020 4:25 PM)
Requisition ID
2020-15060
Professional Area
Technology

Who We Are

More than 30 years ago, E*TRADE pioneered the online brokerage industry by executing the first-ever electronic individual investor trade. While the landscape of our industry has changed dramatically, our culture of innovation and drive to make online trading accessible to everyone continues to drive us forward. We believe in challenging the status quo, fostering an environment of curiosity and learning, and, above all, putting our customers first.

About the Role

The Clearing Operations Technology team at E*TRADE plays a critical part in the daily completion of the trade vetting process and in cash movements between both customers and banks. This continuous process handles millions of transactions daily and depends on our backend batch systems which are spread across a wide range of platforms and technologies.  We are also undertaking an aggressive transformation to enhancing customer experience providing actionable recommendations to build a long-term customer relationship and hence need Data Analysts working with cross functional teams to improve our internal and external user experiences.  Candidate should have strong data analytics, ETL and Business Intelligence skillset to develop and administer quality systems solutions. This position requires extensive hands on ETL work, and BI tools administration capabilities. Data analytics experience, BI Reporting development, software systems integration and excellent SQL skill sets.

 

We need assistance to integrate various systems providing Data analytics for both external and internal Reporting, using technologies like:

  • ETL Platforms: DataStage or equivalent.

  • Business Intelligence Platforms: Business objects/Tableau including administration of these platforms.

  • Cloud Platforms: AWS with hands on experience in EC2, S3, Athena

  • Other Business Intelligence Platforms: Like Tibco Spotfire

  • Data Analytics/Predictive Analytics: SAP Predictive Analytics

  • Other Technologies used:  IBM MQ, ActiveMQ, and MSMQ

  • Host Platforms:  Unix/Linux (java) and Windows (Microsoft .NET)

  • 3rd Party Platforms (some exposure to vendor products preferred): SAP Business Objects/Crystal Reports, EMC Centera Archiving service, and BMC Control-M batch service

RESPONSIBILTIES

  • Candidate will be responsible for Developing ETL solutions, Data Analytics including Database solutions to align with the business strategy

  • Candidate will also be involved in developing Multithreaded applications and will need to be proficient in these areas

  • Candidate will be responsible for Administering the BI platforms both on-Prem and on the Cloud

  • Candidate will work with different LOB's to provide data driven insights in support of strategic direction and growth

  • Candidate will be required to perform as a strong, self-reliant team player able to develop and support operations applications using various technologies (to include Business Intelligence and Data Analytics along with Web and Database technologies) for both Windows and Linux platforms.

  • Candidate must be capable of working independently, demonstrate a strong capability for providing troubleshooting support and must be able to obtain technical resolutions based on business requirements/objectives provided without additional technical leadership or guidance.  He/she must demonstrate strong data analysis skills.  Excellent communication skills are required along with a firm understanding of the Software Development Life Cycle (SDLC) process.  

  • This candidate must provide availability for on-call support during non-core hours (on a team rotation basis), such as evenings or weekends, and must be able to provide responses to system generated email alerts, calls from either the network operations center or inquiries from business users.

  • Candidate should have good work ethics and technology skill sets

Qualifications

REQUIREMENTS

Basic

  • Should have excellent SQL skills (5+ years).
  • Should have 5+ years of Data Analytics experience
  • Should have 3+ years' experience in Business intelligence reporting like SAP Business Objects, and Tableau

Preferred

  • Administration Experience in BI tools is preferred
  • Firm understanding of Object-Oriented software design and development concepts
  • Should be proficient in multi-threaded applications.
  • Able to work on various projects/tasks simultaneously (i.e. multitasking) with minimal supervision.
  • Database development using MSSQL, Oracle and/or Sybase IQ
  • Linux based development using java and Perl scripting or similar technologies
  • Experience developing XML applications using XML, XPath, XSLT, and HTML content 
  • Understanding of object serialization for SOAP/XML and application development based on WSDL service specifications
  • Solid understanding of basic architecture strategies, Object Oriented models, and design patterns
  • Strong development skills in Batch oriented applications
  • Knowledge of developing for CISCO Data virtualization/Collibra is helpful.
  • To acquire business requirements directly from users and set forth communications
  • Able to construct functional requirements and technical plans
  • To support production systems under high demand and availability environments
  • To handle and deliver tasks under extreme pressure and tight timelines
  • Quick learning, self-starter, inquisitive, creative, and thinking out-of-the-box
  • Knows how to analyze data models and data query results to derive conclusions.
  • Able to be cross-trained and support applications owned by other team members.

 

We offer a competitive and comprehensive benefits package. Please visit https://www.etradecareers.com/why-work-at-etrade/employee-benefits/ to learn more about the opportunities.


E*TRADE Financial is an Equal Opportunity Employer who encourages diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, age, disability, citizenship, marital status, sexual orientation, gender identity, military or protected veteran status, or any other characteristic protected by applicable law.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.