Sr. Data Analyst with SQL
Company Name:
Open Systems Technologies
Summary
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
Qualifications:
? 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
Estimated Salary: $20 to $28 per hour based on qualifications.
Open Systems Technologies
Summary
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
Qualifications:
? 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
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
