Summary of Responsibilities:
Responsibilities include participation in the full lifecycle of activities for data-related projects such as data warehousing, business intelligence, data analytics and data governance. This includes gathering requirements, data profiling and analysis, collaborating in information review sessions, test case development and identifying reporting needs and capabilities. Understands methodologies and technologies that depict the flow of data within systems and the business requirements and processes that need to be supported. Works under minimal supervision to contribute on a wide range of decisions, collaborating with peers, and escalating to the Manager when necessary.
Participates in interviews with business resources to gather data requirements and definitions, including movement and transformation requirements between systems. Translate business requirements into data/technical specifications.
Contributes to development of technical specifications and mapping documents.
Collaborates with ETL (extract, transform, load) developers and data modelers in the development of data models and implementation of best practices.
Contributes to development of scenarios for use in system integration and user acceptance testing.
Researches, develops findings, and presents recommendations on data related topics to development teams, internal customers and management.
Assists in troubleshooting data related issues.
Interprets data, analyzes results using statistical techniques and provides ongoing reports.
Assists in the development of the Enterprise Data Governance program.
Locates and defines new process improvement opportunities.
Filters and “cleans” data, locates and identifies data issues.
Performs other duties as assigned by management.
Demonstrated familiarity with ETL/Data Warehouse data modeling principles and development of best practices.
Proven experience in creating effective business requirement documents and communicating them to the appropriate parties.
Demonstrated excellent verbal and written communication skills with the ability to convey information to internal and external customers in a clear, focused and concise manner.
Proven ability to read a variety of correspondence, reports and forms. Must have the ability to prepare correspondence, reports and forms using prescribed formats and conforming to proper rules of punctuation, grammar, diction, and style.
Demonstrated ability to conceptualize and use new methodologies. Must have the ability to apply principles of logical thinking to define problems, collect data, establish facts, and draw valid conclusions.
Proven ability to develop relationships and work in a team culture that is committed to collaboration and service excellence.
Demonstrated familiarity with Business Intelligence and Reporting tools (Cognos, Tableau, Reporting Services, etc.).
Proven experience with coding SQL.
Demonstrated familiarity with project management methodologies such as waterfall and Agile.
Proven knowledge of the financial services industry is preferred.
Works in an office setting and remains continuously in a stationary position for long periods of time while working at a desk, on a computer or with other standard office equipment, or while in meetings.
Performs repetitive motions of the wrists, hands and/or fingers for continuous computer work.
Computer Skills and Knowledge of Hardware & Software Required:
Proficient in word processing, spreadsheets and database applications.
Familiarity with databases. DB2 a plus.
Working knowledge of Structured Query Language.
Certifications & Licenses (i.e., Series 6 & 63, CPA, etc.):