181 applicants

Company

Affinity Solutions · 2 days ago

Sr. Data Analyst (IM-004)

New York, NY

Full-time

Onsite

Mid, Senior Level

$112K/yr - $112K/yr

2+ years exp

Maximize your interview chances

AnalyticsBrand Marketing

H1B Sponsor Likely

Insider Connection @Affinity Solutions

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Develop and improve SQL queries for data retrieval and analysis from relational databases using PostgreSQL

Develop Tableau dashboards and visualizations to provide marketing insights

Conduct statistical analysis and predictive modeling to predict upcoming trends, leveraging methodologies such as linear regression and time series analysis

Collect data from various platforms, such as API, AWS, and Snowflake, and provide analytical and statistical support, including marketing tests, metrics design, projections, and insights

Develop Python scripts to automate the delivery of weekly and monthly reports and integrate these processes into AWS Airflow

Develop Shell scripts to automate the ingestion, extraction, and processing of data.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL queriesPostgreSQLPython scriptsSnowflakeShell scriptsAWS AirflowStatistical analysisPredictive modelingTableau dashboardsData collectionLinear regressionTime series analysis

Required

Master’s degree in Statistics, Financial and Risk Management

2 years of experience

Develop and improve SQL queries for data retrieval and analysis from relational databases using PostgreSQL

Develop Tableau dashboards and visualizations to provide marketing insights

Conduct statistical analysis and predictive modeling to predict upcoming trends, leveraging methodologies such as linear regression and time series analysis

Collect data from various platforms, such as API, AWS, and Snowflake, and provide analytical and statistical support, including marketing tests, metrics design, projections, and insights

Develop Python scripts to automate the delivery of weekly and monthly reports and integrate these processes into AWS Airflow

Develop Shell scripts to automate the ingestion, extraction, and processing of data

Skills- SQL queries, PostgreSQL, Snowflake, Python scripts, Shell scripts & AWS Airflow

Company

Affinity Solutions

Affinity Solutions offers technology, analytics, data processing, and business services for customers.

Founded in 2005

New York, New York, USA

51-200 employees

https://www.affinity.solutions

H1B Sponsorship

Affinity Solutions has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (5)

2022 (7)

2021 (6)

2020 (6)