Intelliswift
Intelliswift is hiring: Data Analyst 3 in New York
Intelliswift, New York, NY, United States
Pay rate range - $65/hr. to $68/hr. on W2
Hybrid - 3 days onsite
Top Skills:
SQL, Data Analysis, Communication-strong Media or Advertising industry experience.
Summary:
The main function of the Data Analyst is to provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions.
Job Responsibilities:
Analyzes performance of process activities, identifies problem areas, and presents findings in clear, concise charts, graphs, tables, or summaries.
Establishes standardized methods of recording, tracking and reporting on activity.
Design, implement, automate and maintain large scale enterprise data ETL processes.
Modify existing databases and database management systems and/or direct programmers and analysts to make changes.
Skills:
Ability to work as part of a team, as well as work independently or with minimal direction.
Excellent written, presentation, and verbal communication skills.
Demonstrated knowledge of one or more key information service standards such as SDLC, ITIL, QA/testing, Project Management, Six Sigma, etc.
Strong PC skills including knowledge of Microsoft SharePoint.
Education/Experience:
Bachelor's degree in a technical field such as computer science, computer engineering or related field required.
5-7 years of experience required.
Process certification, such as, Six Sigma, CBPP, BPM, ISO 20000, ITIL, and CMMI.
Key notes and Attributes:
Responsibilities
•Translate business requirements into SQL queries and Python scripts for Ad Hoc analysis and custom reporting solutions
•Explore data to identify client ad performance opportunities, trends and anomalies, contribute to new Client Data Solutions through custom analytics and coordinate reporting automation with other internal Product and Engineering teams.
•Architect data pipelines to connect different data sources
•Develop and maintain Extract, Transform & Load (ETL) processes
•Transform and cleanse outputs into meaningful analysis for business/sales teams
•Tune and optimize current code base and reporting solutions.
•Oversee documentation
Qualifications
•5+ years in a related engineering/analytics work.
•Degree in computer science/engineering or quantitative discipline (Economics, Statistics, Engineering, Physics, Mathematics.)
•Strong SQL skills 5+ years using SQL
•Snowflake or similar platform experience
•Python experience
•Big Data and Data/Technology methodology experience
•Stakeholder engagement experience
•BI Experience (Domo preferred)
•Exposure to Automation
•Experience with AWS tools such as IAM, Lambda, EC2 and S3.
•Jira, Confluence, GitHub and other agile development tool experience.
•Data privacy
Bonus:
•Familiarity with media, TV measurement
•Athena Experience
•Qubole Experience
•Salesforce Experience
•Vendor management
Hybrid - 3 days onsite
Top Skills:
SQL, Data Analysis, Communication-strong Media or Advertising industry experience.
Summary:
The main function of the Data Analyst is to provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions.
Job Responsibilities:
Analyzes performance of process activities, identifies problem areas, and presents findings in clear, concise charts, graphs, tables, or summaries.
Establishes standardized methods of recording, tracking and reporting on activity.
Design, implement, automate and maintain large scale enterprise data ETL processes.
Modify existing databases and database management systems and/or direct programmers and analysts to make changes.
Skills:
Ability to work as part of a team, as well as work independently or with minimal direction.
Excellent written, presentation, and verbal communication skills.
Demonstrated knowledge of one or more key information service standards such as SDLC, ITIL, QA/testing, Project Management, Six Sigma, etc.
Strong PC skills including knowledge of Microsoft SharePoint.
Education/Experience:
Bachelor's degree in a technical field such as computer science, computer engineering or related field required.
5-7 years of experience required.
Process certification, such as, Six Sigma, CBPP, BPM, ISO 20000, ITIL, and CMMI.
Key notes and Attributes:
Responsibilities
•Translate business requirements into SQL queries and Python scripts for Ad Hoc analysis and custom reporting solutions
•Explore data to identify client ad performance opportunities, trends and anomalies, contribute to new Client Data Solutions through custom analytics and coordinate reporting automation with other internal Product and Engineering teams.
•Architect data pipelines to connect different data sources
•Develop and maintain Extract, Transform & Load (ETL) processes
•Transform and cleanse outputs into meaningful analysis for business/sales teams
•Tune and optimize current code base and reporting solutions.
•Oversee documentation
Qualifications
•5+ years in a related engineering/analytics work.
•Degree in computer science/engineering or quantitative discipline (Economics, Statistics, Engineering, Physics, Mathematics.)
•Strong SQL skills 5+ years using SQL
•Snowflake or similar platform experience
•Python experience
•Big Data and Data/Technology methodology experience
•Stakeholder engagement experience
•BI Experience (Domo preferred)
•Exposure to Automation
•Experience with AWS tools such as IAM, Lambda, EC2 and S3.
•Jira, Confluence, GitHub and other agile development tool experience.
•Data privacy
Bonus:
•Familiarity with media, TV measurement
•Athena Experience
•Qubole Experience
•Salesforce Experience
•Vendor management