data analyst with sql in new york

posted
job type
contract
salary
US$ 40 per hour
apply now

job details

posted
location
new york
job category
Information Technology
job type
contract
salary
US$ 40 per hour
reference number
632168
phone
.
apply now

job description

job summary:

Responsibilities :

  • Perform ad-hoc analyses and communicate insights through compelling storytelling.
  • Develop packages to automate ETL, ensure data integrity, and identify information gaps.
  • Work with disparate data sources and formulate data structures for analysis.
  • Translate business requirements into technical implementations based on system capabilities.
  • Define optimal solutions addressing functional and nonfunctional requirements, taking into account capabilities across technologies.
  • Ensure deliverables comply with market standards.
  • Develop reusable solutions that adhere to predefined patterns.
  • Encourage zero tolerance on data and technology defects when in UAT and production.
  • Complex data mapping and workflow implementations.
  • Take initiative, own your work, and persistent in following your efforts to completion

Requirements:

  • Minimum of 3 to 5 years' SQL development experience.
  • Solid understanding of the ETL process and application of best practices.
  • Solid understanding of statistical concepts and applied knowledge of basic statistical methods.
  • Intermediate level knowledge of SQL-indexes, normalization, schemas, stored procedures, and triggers.
  • 1 to 2 years' experience in visualization/storyboarding tools (D3, Tableau, Power BI, etc.) is a plus.
  • Familiarity with Python/C# is a plus.
  • Able and motivated to learn new technologies.
  • Proven ability to multitask, manage a heavy workload, and perform with a sense of urgency.
  • Able to adapt quickly to new functional areas and/or concepts and to changing and/or competing priorities.
  • Demonstrated ability to manage multiple competing projects while maintaining a high level of quality.
  • Proven strong analytical, critical thinking, and communication skills.
  • Microsoft Excel skills (pivot tables, macros, look-up functions, VBA, etc.).
  • Strong proficiency with other Microsoft applications (Power Point, Access, Visio, Word).
  • Ability to organize and analyze complex financial data in a fast-paced environment.
  • Articulate, confident, and capable of communicating with and influencing others on strategic deliverables.
  • Problem-solving skills coupled with good critical-thinking and decision-making skills.
  • Experience with and understanding of business process/modeling concepts.
  • Self-motivated and driven to achieve targets and deliverables, with strong attention to detail and accuracy.
 
location: New York, New York
job type: Contract
salary: $40 - 45 per hour
work hours: 9 to 5
education: Bachelors
 
responsibilities:

Responsibilities :

  • Perform ad-hoc analyses and communicate insights through compelling storytelling.
  • Develop packages to automate ETL, ensure data integrity, and identify information gaps.
  • Work with disparate data sources and formulate data structures for analysis.
  • Translate business requirements into technical implementations based on system capabilities.
  • Define optimal solutions addressing functional and nonfunctional requirements, taking into account capabilities across technologies.
  • Ensure deliverables comply with market standards.
  • Develop reusable solutions that adhere to predefined patterns.
  • Encourage zero tolerance on data and technology defects when in UAT and production.
  • Complex data mapping and workflow implementations.
  • Take initiative, own your work, and persistent in following your efforts to completion

Requirements:

  • Minimum of 3 to 5 years' SQL development experience.
  • Solid understanding of the ETL process and application of best practices.
  • Solid understanding of statistical concepts and applied knowledge of basic statistical methods.
  • Intermediate level knowledge of SQL-indexes, normalization, schemas, stored procedures, and triggers.
  • 1 to 2 years' experience in visualization/storyboarding tools (D3, Tableau, Power BI, etc.) is a plus.
  • Familiarity with Python/C# is a plus.
  • Able and motivated to learn new technologies.
  • Proven ability to multitask, manage a heavy workload, and perform with a sense of urgency.
  • Able to adapt quickly to new functional areas and/or concepts and to changing and/or competing priorities.
  • Demonstrated ability to manage multiple competing projects while maintaining a high level of quality.
  • Proven strong analytical, critical thinking, and communication skills.
  • Microsoft Excel skills (pivot tables, macros, look-up functions, VBA, etc.).
  • Strong proficiency with other Microsoft applications (Power Point, Access, Visio, Word).
  • Ability to organize and analyze complex financial data in a fast-paced environment.
  • Articulate, confident, and capable of communicating with and influencing others on strategic deliverables.
  • Problem-solving skills coupled with good critical-thinking and decision-making skills.
  • Experience with and understanding of business process/modeling concepts.
  • Self-motivated and driven to achieve targets and deliverables, with strong attention to detail and accuracy.
 
qualifications:

Notes/Requirements from Intake Call:

SQL IS VERY IMPORTANT - SSIS - SSRS -

SOLID UNDERSTANDING OF THE ETL PROCESS - DEVELOPING, AUTOMATION

EXPERIENCE WITH COGNOS AND OR OPEN PAGES

PYTHON NOT AS IMPORTANT

MUST BE ABLE TO SPEAK TO ANALYZING DATA - DATA STREAMS - FUNCTIONS

FINANCE AND HEALTHCARE BACKGROUNDS ARE NOT IMPORTANT BUT WHERE THESE CANDIDATES HAVE COME FROM

 
skills: Responsibilities :

  • Perform ad-hoc analyses and communicate insights through compelling storytelling.
  • Develop packages to automate ETL, ensure data integrity, and identify information gaps.
  • Work with disparate data sources and formulate data structures for analysis.
  • Translate business requirements into technical implementations based on system capabilities.
  • Define optimal solutions addressing functional and nonfunctional requirements, taking into account capabilities across technologies.
  • Ensure deliverables comply with market standards.
  • Develop reusable solutions that adhere to predefined patterns.
  • Encourage zero tolerance on data and technology defects when in UAT and production.
  • Complex data mapping and workflow implementations.
  • Take initiative, own your work, and persistent in following your efforts to completion

Requirements:

  • Minimum of 3 to 5 years' SQL development experience.
  • Solid understanding of the ETL process and application of best practices.
  • Solid understanding of statistical concepts and applied knowledge of basic statistical methods.
  • Intermediate level knowledge of SQL-indexes, normalization, schemas, stored procedures, and triggers.
  • 1 to 2 years' experience in visualization/storyboarding tools (D3, Tableau, Power BI, etc.) is a plus.
  • Familiarity with Python/C# is a plus.
  • Able and motivated to learn new technologies.
  • Proven ability to multitask, manage a heavy workload, and perform with a sense of urgency.
  • Able to adapt quickly to new functional areas and/or concepts and to changing and/or competing priorities.
  • Demonstrated ability to manage multiple competing projects while maintaining a high level of quality.
  • Proven strong analytical, critical thinking, and communication skills.
  • Microsoft Excel skills (pivot tables, macros, look-up functions, VBA, etc.).
  • Strong proficiency with other Microsoft applications (Power Point, Access, Visio, Word).
  • Ability to organize and analyze complex financial data in a fast-paced environment.
  • Articulate, confident, and capable of communicating with and influencing others on strategic deliverables.
  • Problem-solving skills coupled with good critical-thinking and decision-making skills.
  • Experience with and understanding of business process/modeling concepts.
  • Self-motivated and driven to achieve targets and deliverables, with strong attention to detail and accuracy.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

skills

Responsibilities :

  • Perform ad-hoc analyses and communicate insights through compelling storytelling.
  • Develop packages to automate ETL, ensure data integrity, and identify information gaps.
  • Work with disparate data sources and formulate data structures for analysis.
  • Translate business requirements into technical implementations based on system capabilities.
  • Define optimal solutions addressing functional and nonfunctional requirements, taking into account capabilities across technologies.
  • Ensure deliverables comply with market standards.
  • Develop reusable solutions that adhere to predefined patterns.
  • Encourage zero tolerance on data and technology defects when in UAT and production.
  • Complex data mapping and workflow implementations.
  • Take initiative, own your work, and persistent in following your efforts to completion

Requirements:

  • Minimum of 3 to 5 years' SQL development experience.
  • Solid understanding of the ETL process and application of best practices.
  • Solid understanding of statistical concepts and applied knowledge of basic statistical methods.
  • Intermediate level knowledge of SQL-indexes, normalization, schemas, stored procedures, and triggers.
  • 1 to 2 years' experience in visualization/storyboarding tools (D3, Tableau, Power BI, etc.) is a plus.
  • Familiarity with Python/C# is a plus.
  • Able and motivated to learn new technologies.
  • Proven ability to multitask, manage a heavy workload, and perform with a sense of urgency.
  • Able to adapt quickly to new functional areas and/or concepts and to changing and/or competing priorities.
  • Demonstrated ability to manage multiple competing projects while maintaining a high level of quality.
  • Proven strong analytical, critical thinking, and communication skills.
  • Microsoft Excel skills (pivot tables, macros, look-up functions, VBA, etc.).
  • Strong proficiency with other Microsoft applications (Power Point, Access, Visio, Word).
  • Ability to organize and analyze complex financial data in a fast-paced environment.
  • Articulate, confident, and capable of communicating with and influencing others on strategic deliverables.
  • Problem-solving skills coupled with good critical-

qualification

Notes/Requirements from Intake Call: 

SQL IS VERY IMPORTANT - SSIS - SSRS - 

SOLID UNDERSTANDING OF THE ETL PROCESS - DEVELOPING, AUTOMATION 

EXPERIENCE WITH COGNOS AND OR OPEN PAGES 

PYTHON NOT AS IMPORTANT 

MUST BE ABLE TO SPEAK TO ANALYZING DATA - DATA STREAMS - FUNCTIONS 

FINANCE AND HEALTHCARE BACKGROUNDS ARE NOT IMPORTANT BUT WHERE THESE CANDIDATES HAVE COME FROM 

responsibilities

Responsibilities :

  • Perform ad-hoc analyses and communicate insights through compelling storytelling.
  • Develop packages to automate ETL, ensure data integrity, and identify information gaps.
  • Work with disparate data sources and formulate data structures for analysis.
  • Translate business requirements into technical implementations based on system capabilities.
  • Define optimal solutions addressing functional and nonfunctional requirements, taking into account capabilities across technologies.
  • Ensure deliverables comply with market standards.
  • Develop reusable solutions that adhere to predefined patterns.
  • Encourage zero tolerance on data and technology defects when in UAT and production.
  • Complex data mapping and workflow implementations.
  • Take initiative, own your work, and persistent in following your efforts to completion

Requirements:

  • Minimum of 3 to 5 years’ SQL development experience.
  • Solid understanding of the ETL process and application of best practices.
  • Solid understanding of statistical concepts and applied knowledge of basic statistical methods.
  • Intermediate level knowledge of SQL—indexes, normalization, schemas, stored procedures, and triggers.
  • 1 to 2 years’ experience in visualization/storyboarding tools (D3, Tableau, Power BI, etc.) is a plus.
  • Familiarity with Python/C# is a plus.
  • Able and motivated to learn new technologies.
  • Proven ability to multitask, manage a heavy workload, and perform with a sense of urgency.
  • Able to adapt quickly to new functional areas and/or concepts and to changing and/or competing priorities.
  • Demonstrated ability to manage multiple competing projects while maintaining a high level of quality.
  • Proven strong analytical, critical thinking, and communication skills.
  • Microsoft Excel skills (pivot tables, macros, look-up functions, VBA, etc.).
  • Strong proficiency with other Microsoft applications (Power Point, Access, Visio, Word).
  • Ability to organize and analyze complex financial data in a fast-paced environment.
  • Articulate, confident, and capable of communicating with and influencing others on strategic deliverables.
  • Problem-solving skills coupled with good critical-thinking and decision-making skills.
  • Experience with and understanding of business process/modeling concepts.
  • Self-motivated and driven to achieve targets and deliverables, with strong attention to detail and accuracy.

educational requirements

Bachelors