Solution Developer

Acorn AI Boston, Massachusetts

Position at Medidata Solutions

Medidata: Conquering Diseases Together

Medidata is leading the digital transformation of life sciences, creating hope for millions of patients. Medidata helps generate the evidence and insights to help pharmaceutical, biotech, medical device and diagnostics companies, and academic researchers accelerate value, minimize risk, and optimize outcomes. More than one million registered users across 1,400 customers and partners access the world's most-used platform for clinical development, commercial, and real-world data. Medidata, a Dassault Systèmes company, is headquartered in New York City and has offices around the world to meet the needs of its customers. Discover more at

Acorn AI is one of the largest AI companies exclusively dedicated to life sciences. It’s built on Medidata’s platform that includes the industry’s largest structured, standardized and growing clinical trial data repository consisting of 17,000+ trials and 4.5M patients. Our team is composed of over 40 PhD/Masters statisticians, data scientists, analytical product leads, former FDA biostatisticians and computational genomicists. 

Your Mission: 

  • Configure customer solutions leveraging the Acorn commercial data platform in accordance with customer specifications

  • Contribute to evolving team standards and best practices for configuring data pipeline solutions 

  • Author and maintain complex SQL stored procedures that govern data pipeline business rules

  • Debug and optimize SQL queries and stored procedures 

  • Ongoing data warehouse maintenance, change management, and performance tuning 

  • Automate repeated operational tasks through writing scripts and creating database jobs

  • Build and configure dashboards in Tableau and/or Power BI according to customer specifications.

  • Research issues and devise corrective actions 

  • Assist in project planning and scheduling  

  • Enhance and drive existing database development practices and processes towards best practices

Your Competencies: 

  • 0-2 years database development experience

  • Experience with the management and transformation of data to serve analytical purposes 

  • Ability to thrive in a team oriented environment

  • Strong technical, estimating, design and analytical aptitude 

  • Excellent troubleshooting skills and problem-solving skills 

  • Excellent interpersonal and communication skills, both written and oral

Your Education & Experience:

  • B.S./M.S. in Computer Science, MIS or other quantitative fields and demonstrable, relevant work experience

  • Knowledge of Tableau, PowerBI or similar BI tool is a plus

  • Life sciences and data analysis exposure is a plus

  • Experience with Advanced and Predictive Analytics is a plus

  • Knowledge of any of the following is a plus: Python, C# and Powershell 

Note: The requirements should reflect your minimum requirements for the role in general


Medidata is making a real difference in the lives of patients everywhere by accelerating critical drug and medical device development, enabling life-saving drugs and medical devices to get to market faster. Our products sit at the convergence of the Technology and Life Sciences industries, one of most exciting areas for global innovation. Nine of the top 10 best-selling drugs in 2017 were developed on the Medidata platform. 

Medidata Solutions have powered over 20,000+ clinical trials giving us the largest collection of clinical trial data in the world. With this asset, we pioneer innovative, advanced applications and intelligent data analytics, bringing an unmatched level of quality and efficiency to clinical trials enabling treatments to reach waiting patients sooner.

Medidata Solutions, Inc. is an Equal Opportunity Employer. Medidata Solutions provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability status, protected veteran status, or any other characteristic protected by the law. Medidata Solutions complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.