SQL Data Analyst – Top level expert in highly specialized applications systems analysis
CareWorks Tech - Ohio

This job posting is no longer available on CareWorks Tech. Find similar jobs: CareWorks Tech jobs

SQL Data Analyst – Top level expert in highly specialized applications systems analysis CareWorks Tech ( www.careworsktech.com/careers ) is currently seeking a Data Analyst for a long term consulting opportunity in Columbus, OH.

Skills Required:

* SQL *

ETL *

Entity Relationship Diagrams

* SQL Scripting

* Meeting Facilitation Nice to Have

* Informatica mappings

* Perl

Job Description:

* Analyst will be responsible for eliciting data and/or functional requirements from investment professionals and creating specifications for applications or data interfaces between various proprietary systems and our centralized data warehouse/analytics platform

* Assignments may be new work or maintenance of earlier work

* Analyst must be an excellent communicator and facilitator, able to run a meeting and quickly establish credibility with senior investment professionals by demonstrating rapid learning and mastery of new concepts and terms

* Analyst must be able to propose and advocate for appropriate solutions based on project constraints and inputs from multiple stakeholders with minimal supervision

* Successful candidates are self-motivated, focus on execution, prepare rigorously, have an informed opinion, offer and seek candid feedback, and collaborate with others to make the entire team more effective

* Analyst must be skilled at analyzing, extracting and modeling data using SQL, ETL tools and/or spreadsheets

* Analyst must have demonstrated experience in writing and reviewing technical specifications

* Analyst must demonstrate the ability to create and document logical data models based on business requirements; to write accurate and unambiguous business definitions; and to understand and map usage and transformation of data elements across different systems

* This is not a developer role but a programming background is helpful

* Analyst must be comfortable with technology and able to look at SQL code, Informatica mappings, Entity Relationship Diagrams, or PERL script and have some idea what is going on and provide meaningful feedback and guidance to developers and testers with regard to fit to requirements

* Technical proficiency with reading and writing complex SQL queries (any dialect is fine) will be essential to accomplishing data analysis in a timely manner

* Experience using ETL tools and/or SQL to get data in or out of poorly documented, complex proprietary systems or data services though batch files, APIs, messages or other methods would be directly relevant to position

* Knowledge of investment management, investment accounting, financial risk models, or securities operations (especially fixed income and derivatives) is preferred but candidates who have demonstrated self-learning and mastery of similarly complex business or technical domains should also apply

* Top level expert in one or more highly specialized phases of applications systems analysis

* Acts independently under general direction

* Provides technical consulting on the most complex projects

* Formulates and defines system scope and objectives through research and fact-finding to develop or modify the most complex information systems

* Devises and modifies procedures to solve the most complex problems considering computer equipment capacity and limitations, operating time, and form of desired results

* Prepares detailed specifications from which the most complex programs will be written

* Analyzes and revises existing system logic difficulties and documentation as necessary

* Has full technical knowledge of all phases of applications systems analysis

* May have quality assurance review responsibilities

The CareWorks Family of Companies is committed to providing career opportunity and growth to all Associates without regard to race, color, religion, sex, national origin, age, marital or veteran status, medical condition or disability.

CareWorks Tech - 15 months ago - save job - copy to clipboard