- Develop and maintain SAS programs for automated reporting and advanced statistical analysis.
- Create and optimize SAS stored procedures and views for improved data accessibility.
- Maintain and develop data interfaces.
- Troubleshoot system and batch processing.
- Design and execute complex SQL queries to extract, transform, and analyse large datasets from multiple sources.
- Collaborate with stakeholders to understand business requirements and translate them into analytical solutions.
- Build and maintain dashboards and reports to track key performance indicators and share business insights.
- Identify trends and patterns in data to support strategic decision-making.
- Document technical processes and maintain data dictionaries.
- Validate data quality and implement data cleaning procedures.
- Mentor junior analysts in SQL and SAS best practices.
Responsibilities
- Develop and maintain SAS programs for automated reporting and advanced statistical analysis.
- Create and optimize SAS stored procedures and views for improved data accessibility.
- Maintain and develop data interfaces.
- Troubleshoot system and batch processing.
- Design and execute complex SQL queries to extract, transform, and analyse large datasets from multiple sources.
- Collaborate with stakeholders to understand business requirements and translate them into analytical solutions.
- Build and maintain dashboards and reports to track key performance indicators and share business insights.
- Identify trends and patterns in data to support strategic decision-making.
- Document technical processes and maintain data dictionaries.
- Validate data quality and implement data cleaning procedures.
- Mentor junior analysts in SQL and SAS best practices.
Requirements:
- Bachelor's degree in Statistics, Mathematics, Computer Science, or related field.
- 5+ years of experience in SAS programming to mine, alter, manage, retrieve, and combine data from a variety of sources and perform statistical analysis.
- Proficient in SAS programming, including macro development and PROC SQL.
- Proficient with SAS data integration and query tools.
- 5+ years of advanced SQL skills including complex joins, window functions, and query optimization.
- 3+ years of experience in data visualization and tools.
- strong problem-solving and analytical thinking skills.
- Excellent communication skills with ability to present technical concepts to non-technical audiences.
Technical Skills:
- SAS Base SAS, SAS/STAT, SAS Macro language, PROC SQL.
- SQL Complex querying, stored procedures, performance tuning.
- Linux, shell scripting, process scheduling, application scheduling, basic peripheral devices, and file systems.
- Database platforms, SQL Server, Oracle, or similar.
- API development.
- Data visualization Power BI, Tableau, or similar.
- Microsoft Office Suite, especially Excel for data analysis.
Seniority level
- Seniority levelMid-Senior level
Employment type
Job function
- Job functionInformation Technology
- IndustriesPharmaceutical Manufacturing
Referrals increase your chances of interviewing at Katalyst CRO by 2x
Get notified about new SAS Developer jobs in New York, NY.
New York, NY $105,000 - $115,000 1 day ago
New York, United States $115,000 - $120,000 2 weeks ago
New York, NY $104,000 - $149,000 6 days ago
New York City Metropolitan Area $80,000 - $90,000 1 day ago
New York City Metropolitan Area $90,000 - $115,000 2 days ago
New York, NY $85,600 - $112,000 2 days ago
We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr