8 days old
2018-07-112018-08-08

Data Analyst with SQL

New York, NY 10022
  • Job Code
    632168
  • Payrate
    $40 To $45
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.

Categories

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Analyst with SQL

Randstad Technologies
New York, NY 10022

Share this job

Data Analyst with SQL

Randstad Technologies
New York, NY
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast