Sr. Data Analyst with SQL

Company Name:
Open Systems Technologies

We are seeking a full-time Senior Data Analyst for our Purchase, NY office. The Senior Data Analyst will interpret and analyze data and transform it into information for all business areas to support decision making. Responsibilities span the full lifecycle activities including requirements analysis and design, development of analysis and reporting capabilities, and continuous monitoring of performance and quality control plans to identify improvements.
Essential Duties and Responsibilities:
? Perform Business and Data Analysis for end user report requests using SQL, and/or other reporting tools
? Working with end users to determine data requirements for reporting and data mining requests, the development and delivery of both ad hoc/recurring reports, and investigating data issues.
? Collaborate with Information Architecture and Business Analysis teams in formulation of requirements for data across all product lines
? Develop appropriate data requirements documentation in line with SDLC framework including Data Requirements, Functional Requirements, mappings, and test plans
? Define data quality plans to address data quality issues; work with business partners to build business understanding of data issues.
? Support day to day production inquiries and questions from other technology groups.
? Assist with the end to end project management of reporting and data development projects within the team.
? Establish strong working relationships with team members and across the business as appropriate.
? Handle individual workload and deliver upon project milestones on time and on budget.
? Coordinate project tasks and timelines for data development within the team
? BS in Mathematics, Finance, Computer Science, Information Management or Statistics
? The ideal candidate is a professional with 5-7 years of background as a data analyst and 5+ years of relevant experience with concentration in Data Analysis and Design.
? Must have some experience in property and casualty insurance or in the financial services industry and possess excellent communication skills.
? Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
? Must have experience working with large SQL databases.
? Adept at writing complex SQL queries, analyzing the results and presenting findings
? Background in analysis and documentation of financial data.
? Experience in data warehousing including reading and understanding ERDs
? Strong understanding of Excel
? Demonstrated ability to work in a team environment for resolution of issues.
? Strong knowledge of relevant technology toolsets relative to data analysis and documentation including SQL, data modeling, metadata organization, data cleansing, and reporting tools such as Cognos, or other data reporting/data mining tools

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

VP and Sr. Credit Analyst, Commercial Real Es...
New York City, NY TalentHub Worldwide
Sr. Analyst - Programmatic Data & Analytics
New York City, NY Town Square Media
Sr. SSP Revenue & Reconciliation Analyst
New York City, NY Emblem Health
New York City, NY Jefferson Frank
Sr Bus Information Writer Clie
Buffalo, NY Aetna
Data Visualization Editor
New York City, NY Dow Jones