SQL Data Analyst

3 weeks ago


Carnegie, United States 1872 Consulting Full time
SQL Data Analyst Job Description

RareMed Solutions is a leading provider of comprehensive support services for specialty, orphan, and ultra-orphan products. We offer unique solutions tailored to each partner's needs, ensuring compliance and data-driven decision-making.

Key Responsibilities:
  • Develop and maintain stored procedures, functions, views, and scripts to generate data.
  • Utilize SSIS to create packages for data cleaning, import, and export.
  • Perform root-cause analysis to identify and resolve issues quickly.
  • Identify key trends and reports for RareMed management and external partners.
  • Work with management to define and collect data for specific departments and contractual obligations.
  • Format internal data into dashboards for external sharing.
  • Tune and modify existing databases to upgrade functionality.
Requirements:
  • 1-3 years of hands-on experience in a SQL-based environment.
  • Highly proficient in writing efficient queries, views, indexes, stored procedures, and functions within SQL Server.
  • Understanding of advanced relational database management concepts.
  • Capacity to quickly familiarize themselves with new software and technologies.
  • Strong analytical skills with attention to detail.
  • Ability to exercise independent judgment in managing data in a high-paced environment.
Nice to Have:
  • Advanced Excel knowledge, including Pivot Tables, Advanced Charts/Graphs, VBA.
  • Experience writing PowerShell scripts and batch files to move/manipulate files as needed.
  • Prior experience with report generating technologies (SQL Reporting Services, Crystal Reports, etc.).
  • Experience with documenting technical processes.
  • Previous pharmaceutical and/or healthcare experience.

  • Data Analyst

    3 weeks ago


    Carnegie, United States 1872 Consulting Full time

    Job Title: Data Analyst - RareMed SolutionsJob Summary:RareMed Solutions is a leading provider of comprehensive support services for specialty, orphan, and ultra-orphan products. We are seeking a highly skilled Data Analyst to join our Analytics team. The successful candidate will provide strategic and tactical support to the team, working closely with the...

  • Vibration Analyst

    3 weeks ago


    Carnegie, Pennsylvania, United States Eastern Industrial Automation Full time

    Job SummaryWe are seeking an experienced Vibration Analyst to join our team at Eastern Industrial Automation. The successful candidate will be responsible for performing vibration data collection, analysis, and reporting of machine condition findings. The ideal candidate will have a strong mechanical aptitude and experience working with rotating equipment....


  • Carnegie, United States Prequel Solutions Full time

    Prequel Solutions is seeking a detail-oriented and analytical accountant to play a key role in our financial management department. In this position, you will be responsible for ensuring the accuracy of our financial operations and compliance with accounting regulations. Key Responsibilities: * Manage and maintain accurate financial records and reports *...


  • Carnegie, United States Prequel Solutions Full time

    Accountant Position at Prequel SolutionsWe are seeking a highly skilled and motivated accountant to join our financial management department. As an accountant at Prequel Solutions, you will play a crucial role in ensuring the accuracy and compliance of our financial operations.Key Responsibilities:Manage and analyze financial data to identify trends and...

  • Production Engineer

    3 months ago


    Carnegie, United States Vantage Specialty Chemicals Full time

    Vantage is a leading supplier of naturally derived specialty ingredients and formulations that cater to the evolving needs of industrial and consumer markets. Through our chemistries, our customer focus and our global footprint, we are ENABLING TOMORROW’S SOLUTIONS TODAY.As a company on the move, you’ll be working as part of a collaborative team and...

  • Production Engineer

    3 months ago


    Carnegie, United States Vantage Specialty Chemicals Full time

    Vantage is a leading supplier of naturally derived specialty ingredients and formulations that cater to the evolving needs of industrial and consumer markets. Through our chemistries, our customer focus and our global footprint, we are ENABLING TOMORROW’S SOLUTIONS TODAY.As a company on the move, you’ll be working as part of a collaborative team and...


  • Carnegie, United States Prequel Solutions Full time

    Prequel Solutions is seeking a highly motivated and detail-oriented Accountant to contribute to our dynamic financial management department. In this role, you will play a vital part in ensuring the accuracy of our financial operations and maintaining compliance with all applicable regulations. We offer a flexible work environment with excellent...

  • Production Engineer

    2 weeks ago


    Carnegie, United States Vantage Specialty Chemicals Full time

    Vantage Specialty Chemicals is a global leader in the manufacturing of select raw materials for use in value-added formulations. Our company creates, produces, and sources high-end and tailored specialty chemicals and ingredients incorporated into everyday products that nourish, care for, sustain and enhance performance.We use science to transform naturally...


  • Carnegie, United States Prequel Solutions Full time

    Job DescriptionPrequel Solutions is seeking a highly motivated and experienced accountant to join our financial management department. In this role, you will play a crucial part in our company's financial operations, ensuring accuracy in accounting and compliance with financial regulations.Key Responsibilities:Manage and maintain accurate financial records...

  • Senior Accountant

    6 months ago


    Carnegie, United States Prequel Solutions Full time $65,000 - $80,000

    Prequel Solutions is seeking a self-motivated accountant to join our financial management department. In this role, you’ll play an important role in our company’s financial operations, ensuring accuracy in accounting and compliance with the law. There is lots of growth opportunity with a flexible environment. Description: A successful candidate should...

  • Wind Technician II

    3 weeks ago


    Carnegie, Oklahoma, United States EDP Energias de Portugal S.A. Full time

    Job Title: Wind Technician IIEDP Renewables is a global leader in the renewable energy sector, operating in over 25 markets. As a Wind Technician II, you will be an integral member of our wind farm team, responsible for on-site operations, maintenance, repairs, and replacement of equipment at one of our operating wind energy generation sites.Main...


  • Carnegie, Oklahoma, United States EDPR Full time

    Job Title: Site Lead TechnicianAt EDPR, we are seeking a highly skilled and experienced Site Lead Technician to join our team. As a Site Lead Technician, you will be responsible for the on-site operations, maintenance, repairs, and replacement of equipment at one of our operating wind-energy generation sites.Main Responsibilities:Lead a team of up to 10...