SQL Data Analyst

3 months ago

Carnegie, United States 1872 Consulting Full time
RareMed Solutions offers comprehensive support services for specialty, orphan and ultra-orphan products (medicines used to treat exceptionally rare diseases that are chronically debilitating or life-threatening). Our team has a breadth of experience developing and maintaining therapy specific solutions to ensure compliance. RareMed Solutions is the ideal partner for biotech firms and pharmaceutical manufacturers due to our custom solutions that are unique to each of our partner's needs.

SQL Data Analyst at RareMed Solutions will provide strategic and tactical support to the Analytics team and will report directly to the Lead of Analytics and Reporting. The SQL Analyst will work to develop and distribute reports on a scheduled basis both internally and externally. In addition, the SQL Analyst will work with external partners to collect and load data into the RareMed data warehouse.

Responsibilities:
• Developing and maintaining stored procedures, functions, views and other scripts as necessary to
generate data
• Utilizing SSIS to generate packages that will clean and import data from external sources as well as
export data
• Independently perform root-cause analysis to identify and resolve issues quickly
• Identifying key trends reports for RareMed management and external partners to drive key decisions
• Work with management team to define and collect data needed for specific departments and for
contractual obligations
• Work with management to format internal data into dashboards before sharing externally
• Utilizing an internal scheduling software as well as Windows Task Scheduler to ensure data is
distributed at appropriate times
• Tune and modify existing databases as needed to upgrade functionality

Requirements:
• 1 - 3 years of hands-on experience in a SQL based environment
• Highly proficient at writing efficient queries, views, indexes, stored procedures and functions within SQL Server
• Understanding of advanced concepts in relational database management
• Capacity to quickly familiarize themselves with new software and technologies
• Strong analytical skills with attention to detail
• Ability to exercise independent judgement to manage data in a high paced environment

Nice to have's::
• 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

  • SQL Data Analyst

    3 weeks ago

    Carnegie, United States 1872 Consulting Full time

    SQL Data Analyst Job DescriptionRareMed 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...

  • 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

    2 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....

  • Senior Financial Analyst

    3 weeks ago

    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 *...

  • Senior Financial Analyst

    1 month ago

    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...

  • Senior Financial Analyst

    2 months ago

    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...

  • Senior Financial Analyst

    2 months ago

    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

    2 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...

  • Site Operations Manager

    3 weeks ago

    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...