Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

SQL Server Developer with AWS Redshift & BI Experience

RIT Solutions, Inc.

SQL Server Developer with AWS Redshift & BI Experience

Client: Jefferies

Polished candidates that can sit with the Investment banking team in midtown fulltime.

This is a front office role.

3-4 days a week on site

Location: NYC
leading full-service investment banking and capital markets firm is looking for a highly skilled SQL Server Developer with expertise in AWS Redshift and Business Intelligence (BI) solutions. The ideal candidate will be responsible for designing and implementing scalable database solutions, migrating data to the cloud, and developing BI solutions to support data-driven decision-making. You will collaborate closely with business stakeholders, data engineers, and analysts to deliver high-quality data solutions.
Key Responsibilities:
  • Design, develop, and maintain SQL Server and AWS Redshift databases to support data warehousing and reporting needs.
  • Build and optimize ETL pipelines for data extraction, transformation, and loading from various data sources to AWS Redshift.
  • Collaborate with business and data teams to gather requirements and develop Business Intelligence solutions using tools like Power BI, Tableau, or QuickSight.
  • Optimize SQL queries and Redshift performance for large datasets.
  • Ensure data integrity, security, and high availability of data infrastructure in the cloud environment.
  • Implement and maintain data models for reporting and analytics.
  • Automate data processing workflows and monitor ETL processes.
  • Stay updated with AWS cloud services, BI tools, and industry best practices.
Qualifications:
  • Degree in Computer Science, Information Systems, or related field (or equivalent work experience).
  • 4+ years of experience with SQL Server development (T-SQL, stored procedures, functions, and performance tuning).
  • Hands-on experience with AWS Redshift and related AWS services (S3, Lambda, Glue, etc.).
  • Experience with ETL tools (SSIS, AWS Glue, or similar).
  • Proficiency in developing and optimizing complex SQL queries for large datasets.
  • Strong experience with Business Intelligence tools such as Power BI, Tableau, or Amazon QuickSight.
  • Understanding of data warehouse design and data modeling (Star/Snowflake schema).
  • Knowledge of cloud security and best practices for data management.
  • Excellent analytical and problem-solving skills.
Preferred Qualifications:
  • Experience with cloud data migration from SQL Server to AWS Redshift covered by a BI component
  • Knowledge of Python or other scripting languages for data manipulation.
  • Familiarity with big data tools like Athena, EMR, or Redshift Spectrum.
  • AWS certification is a plus (AWS Certified Solutions Architect, AWS Data Analytics Specialty).
Vacancy posted 21 hours ago
Similar jobs that could be interesting for youBased on the SQL Server Developer with AWS Redshift & BI Experience in New York, NY vacancy
  •  ...AWS Redshift Data Architect As an AWS Redshift Data...  ...tuning, and integration with ETL, BI, and ML components....  ...to data engineers and developers. Participate in...  ...metadata strategies. Experience: ~10+ years...  ...scaling. Proficient in SQL performance tuning,... 
    Amazon Web Service
    Business intelligence

    Futran Tech Solutions Pvt. Ltd.

    Passaic, NJ
    17 days ago
  •  ...Our product and engineering teams have developed tools used by companies like Airtable...  ...top tech firms navigate sales tax, with experience from Amazon AWS, Deloitte, EY, and Goldman Sachs. We...  ...Company-wide holidays and paid time off Bi-annual company-wide offsites or... 
    Amazon Web Service
    Business intelligence
    Work at office
    Remote work

    Anrok

    New York, NY
    3 days ago
  •  ...through data solutions. Partner with an organization comprised...  ...Platforms, Workforce Experience Technology (WxT) Workforce...  ...Cloud Providers: Databricks, AWS, Azure, Terraform, Kafka,...  .../Scala, Glue/EMR, AI Developer Automation Tools (Unit Test) BI Consumption with tools such... 
    Amazon Web Service
    Business intelligence

    JPMorgan Chase & Co.

    New York, NY
    2 days ago
  •  ...Firmwide HR and Employee Experience data products. As a Senior...  ...teams. Partner with Product and Architecture...  .../EMR Experience with AI Developer Automation Tools and the use of BI Consumption tools such as...  ...and platforms in cloud (AWS S3, Databricks, GCP, Azure... 
    Amazon Web Service
    Business intelligence

    Aumni

    New York, NY
    3 days ago
  •  ...Overview: Role Name - BI Architect EXPERIENCE_RANGE_IN_REQUIRED_SKILLS_...  ...DESCRIPTION - Lead BI Architect with experience in BO, Crystal...  ...responsibilities include developing data models, ensuring data...  ...new using Tableau in Redshift/AWS. • Technical leadership:... 
    Amazon Web Service
    Business intelligence

    Purple Drive

    Jersey City, NJ
    3 days ago
  •  ...Wed, Thu mandatory) Experience: 10+ Years We are...  ...experienced Product Owner with strong expertise in...  ...capabilities in AWS, PySpark, Tableau,...  ...solutions Develop scalable data and AI...  ...AWS (S3, Glue, EMR, Redshift) Collaborate on large...  ...Tableau (or equivalent BI tools) Deep... 
    Amazon Web Service
    Business intelligence
    3 days per week

    Maven Companies Inc.

    New York, NY
    1 day ago
  •  ...+ Matillion ETL Developer / Data Engineer...  ...Duration: 6 Months Experience: 8-10 Years...  ...Matillion ETL, AWS services, and data...  ..., SCD Type 2) with proven experience...  ...from AWS S3, RDS, Redshift, and APIs into...  ...connectors. Optimize SQL queries,...  ...data architects, BI teams, and... 
    Amazon Web Service
    Business intelligence

    Prophecy Technologies

    New York, NY
    2 days ago
  •  ...Qualifications: 5+ years' experience working with database technologies such as Microsoft SQL Server and Oracle Hands-on...  ...Hands-on experience in developing Python scripts Experience...  ...Experience with AWS technologies such as S3, EMR, RedShift, Athena, Glue, Kinesis... 
    Amazon Web Service
    Work experience placement

    TechDigital Group

    New York, NY
    21 hours ago
  •  ...AWS Consultant Location: New York City, NY Duration: 9+...  ...mandatory. They should have 1 year experience in above technologies...  ...required. Data Architect with BI background. Should have worked...  ...warehousing technologies such as Redshift, Metallion ETL, S3, Glacier.... 
    Amazon Web Service
    Business intelligence

    ClifyX

    New York, NY
    2 days ago
  •  ...you will design, develop, and maintain...  ...remote position, with an opportunity to...  ...sources built on our Redshift analytics...  ...requires strong SQL, deep Tableau expertise...  ...5+ years of experience developing...  ...Experience working with AWS data services...  ...with additional BI tools such as Looker... 
    Amazon Web Service
    Business intelligence
    Remote work

    Keeper Security

    New York, NY
    2 days ago
  •  ...Senior Data Architect (E3) with deep expertise in data...  ...~10+ years of experience in data architecture or...  ...platforms such as: AWS Redshift Snowflake Proven...  ...with ETL and BI tools: Informatica...  ...insurance business needs Develop enterprise data models... 
    Amazon Web Service
    Business intelligence

    Purple Drive

    Jersey City, NJ
    2 days ago
  • # AWS Data Engineer**Remote**Full time785d...  ...will be to design, develop, and maintain scalable...  ...will work closely with technical analysts,...  ...**· 10+ years' experience with a core data engineering...  ..., Snowflake, S3, Redshift).· Experience in...  ...data architecture· BI integrations: Power... 
    Amazon Web Service
    Business intelligence
    Remote work

    Qode

    New York, NY
    3 days ago
  •  ...an experienced AWS Data Engineer to...  ...join the team that develop a data-centric...  ...sources using Python, SQL, scripting, and...  ...and other BI solutions. Work closely with product owners,...  ...years of hands-on experience in developing data...  ...PostgreSQL, S3, Redshift, Athena, and... 
    Amazon Web Service
    Business intelligence
    Remote work
    Home office
    Flexible hours

    Grinteq

    New York, NY
    3 days ago
  • $160k - $180k

     ...investors and working with a large and...  ...reliability. Develop data visualizations...  ...: 5+ years of experience as a data/analytics...  ...role. Expert in SQL, Python, or R...  ....g., Snowflake, Redshift, BigQuery). Deep...  ...data platforms (AWS, GCP, or Azure)....  ...Experience with modern BI tools (e.g.,... 
    Amazon Web Service
    Business intelligence
    Temporary work
    Work at office
    Remote work

    Cyera

    New York, NY
    3 days ago
  •  ...Looker Bi Developer Company description A division of...  ...Groupe, Publicis Digital Experience is a network of top-...  ...that will provide them with a future-proof model...  ...workflows. Strong SQL skills, with experience...  ...Snowflake, Google BigQuery, AWS Redshift). Familiarity with... 
    Amazon Web Service
    Business intelligence
    Worldwide
    Flexible hours

    Digitas

    New York, NY
    3 days ago
  • $88.54k - $127.16k

     .... You will work with internal and external...  ...Partner with BI, Product, and Media...  ...Strong hands-on experience with PySpark (preferred...  ...Proficiency in Python and SQL for data processing...  ...Cloud platforms: AWS, Azure, Databricks...  ...: Snowflake, Redshift, Databricks Lakehouse... 
    Amazon Web Service
    Business intelligence
    Temporary work
    Freelance
    Flexible hours

    Starcom Mediavest Group Germany Gmbh

    New York, NY
    2 days ago
  •  ...+ Matillion ETL Developer / Data Engineer to...  ..., Matillion ETL, AWS data services, and...  ...as AWS S3, RDS, Redshift, and APIs using Matillion...  .... Optimize SQL queries,...  ...efficiency. Collaborate with data architects, BI developers, and DevOps...  ...Skills & Experience 8-10 years of overall... 
    Amazon Web Service
    Business intelligence
    Permanent employment
    Contract work
    Local area

    Robotics Prcocess Automation, LLC

    New York, NY
    2 days ago
  •  ...Working closely with product, analytics...  .... Develop core, reusable data...  ...Requirements 8+ years of experience building, maintaining...  ...(e.g., AWS) and modern data warehouses (Redshift, Snowflake, BigQuery...  ...data products for BI, reporting, and...  ...Proficiency in SQL and at least one... 
    Amazon Web Service
    Business intelligence
    Remote work
    Flexible hours

    Jobgether

    New York, NY
    3 days ago
  • $160k - $250k

     ...in San Francisco with hubs in EMEA and APAC...  ...a team with deep experience in the field, and...  ...spreadsheets inside of BI An MCP server for Blobby, our AI...  ...tools (e.g., SQL, Looker, Tableau,...  ...Snowflake, BigQuery, Redshift Experience with AI...  ...Kotlin / Java AWS Why Join Us We're... 
    Amazon Web Service
    Business intelligence
    Full time
    Remote work

    Theory Ventures

    New York, NY
    3 days ago
  •  ...operational use cases Develop and optimize data...  ...insights Partner with cross-functional...  ..., Product, BI) to translate business...  ...of professional experience in data...  ...datastores such as Redshift, Snowflake, SQL Server, etc. Experience...  ...solutions such as AWS Glue, Azure Data... 
    Amazon Web Service
    Business intelligence
    Remote work
    Flexible hours

    Safe Ride Services

    New York, NY
    3 days ago
  •  ...Perplexity, Gemini, and beyond, with strong guarantees on accuracy...  ...an internal dashboard, not a BI report Strong in Python and SQL, with hands‑on experience in ClickHouse, Redshift, or similar OLAP systems at...  ...or similar Familiarity with AWS‑native stack: Glue, S3, Redshift... 
    Amazon Web Service
    Business intelligence
    Flexible hours

    AirOps

    New York, NY
    3 days ago
  • $160k - $195k

     ...Collaborating directly with executive...  ...years of dedicated experience as a Data Engineer,...  ...Python. Exceptional SQL capabilities and a...  ...Snowflake, BigQuery, Redshift, or Databricks). Proven...  ...supporting leading BI tools such as Looker...  .... Familiarity with AWS cloud environments... 
    Amazon Web Service
    Business intelligence
    Permanent employment
    Temporary work
    Work experience placement
    Work at office

    Randstad Digital Americas

    New York, NY
    3 days ago
  •  ...power PayPay products, with secondary responsibility...  ..., optimization, and BI analytics. Responsibilities...  ...five years of work experience as a data scientist, machine...  ...in Python and SQL (any variant). Preferred...  ...BigQuery, Spark, Hadoop, AWS Redshift, Kafka, or Kinesis streaming... 
    Amazon Web Service
    Business intelligence
    Work experience placement

    Carnot

    New York, NY
    3 days ago
  •  ...have total 8+ years of experience in IT and working as...  ...warehouse, ETL, BI Projects. Must have...  ...data warehouse (Redshift, Postgres, or Snowflake). Design and Develop ETL Processes in AWS Glue to migrate data...  ...Hands-on experience with Postgres SQL, RedShift, Redshift... 
    Amazon Web Service
    Business intelligence

    Futran Tech Solutions Pvt. Ltd.

    Jersey City, NJ
    3 days ago
  • $85k - $160k

     ...Title A career with Goldman Sachs Asset...  .... Design, develop, and maintain automated...  ...related field. Experience: 3+ years of hands...  ...cloud provider — AWS (Redshift, Glue, S3, Lambda)...  ...Strong proficiency in SQL and Python;...  ...is preferred. BI & Visualization: Proficiency... 
    Amazon Web Service
    Business intelligence
    Full time
    Temporary work
    Part time

    The Goldman Sachs Group, Inc.

    New York, NY
    3 days ago
  •  ...Gemini, and beyond - with strong guarantees on...  ...-on engineering experience with clear evidence...  ...internal dashboard, not a BI report ~ Strong Python and SQL with hands-on experience in ClickHouse, Redshift, or similar OLAP...  ...Familiarity with the AWS-native stack: Glue,... 
    Amazon Web Service
    Business intelligence
    Flexible hours
    Shift work

    AirOps

    New York, NY
    4 days ago
  •  ...ll work directly with business leaders...  ...solutions using Redshift, Oracle, and...  ...platforms and systems Develop sophisticated...  ...optimized SQL queries and data...  ...Oracle, NoSQL etc. experience 3+ years of developing...  ...'s degree in BI, finance,...  ...Experience with AWS solutions such as... 
    Amazon Web Service
    Business intelligence

    A9.com LLC

    New York, NY
    4 days ago
  •  ...coordination with the Technology...  ...and developing interactive dashboards...  ...of relevant experience, capable of transforming...  ...Tableau Server, including...  ...DataBricks, AWS Glue, Azure...  ...proficiency in SQL and...  ..., Snowflake, Redshift, PostgreSQL,...  ...Experience with other BI tools (e.g.,... 
    Amazon Web Service
    Business intelligence

    Citi

    New York, NY
    3 days ago
  •  ...Data to design, develop, and scale our data...  ...and writing SQL as they are presenting...  ...needs Partner with engineering to...  ...’ll Bring Core Experience 5+ years in...  ...experience with BI and reporting tools...  ...infrastructure (e.g., AWS Aurora PostgreSQL, AWS Redshift, Snowflake)... 
    Amazon Web Service
    Business intelligence
    Flexible hours

    ExaCare AI

    New York, NY
    21 hours ago
  •  ...System Architect (AWS Analytics) |...  ...Extension Possibility) Experience Required: 6+...  ..., Spark, Glue, Redshift, and other AWS analytics...  ...collaborate with cross‑functional...  ...PySpark/Scala), SQL optimization,...  ..., and S3 Develop star and snowflake...  ...CloudFormation Background in BI, analytics... 
    Amazon Web Service
    Business intelligence
    Contract work
    H1b
    Immediate start
    Remote work

    Tech Junction Ltd

    New York, NY
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to SQL Server Developer with AWS Redshift & BI Experience. Be the first to apply!