Business Intelligence Engineer

Foundation Medicine Cambridge , MA 02138

Posted 2 weeks ago


Foundation Medicine is a molecular information company focused on fundamentally changing the way in which patients with cancer are treated. Our products provide more than information. They offer hope to patients, their families and friends, their physicians and caregivers.

We've seen the difference that our technology can make in the lives of patients, but there is still enormous potential to help even more people. In our drive to help transform the way in which patients with cancer are treated, we strive to improve every life we touch through our dedication to innovation, our commitment to people, and our passion for performance.

Team Dynamic:

The Business Intelligence team has transformed how we at Foundation Medicine consume data. From operational reporting to business analytics, we've worked to eliminate manual data crunching and provided our users with advanced reporting capabilities that make the complex business processes more transparent. This data is increasingly used for external reporting including external sample tracking via our physician portal. The BI team is known throughout FMI as a high performing team that works closely with stakeholders to solve complex data-related problems. It is a tight knit group of technology professionals driven by applying data and analytics to business opportunities.


  • Help drive the design, development, implementation and expansion of databases utilizing the full MS SQL Server stack and other database technologies if appropriate.

  • Work as a team player with the product, application development, and infrastructure teams to gather data and reporting requirements and formulate solutions to service them efficiently.

  • Troubleshoot and solve problems - identify root source of problem/incorrect data and implement measures to correct and prevent future occurrences of it.

  • Test performance of databases to insure they are efficient, scalable and tune query execution if necessary to achieve desired system performance.

  • ETL/ELT - Plan and execute data migration procedures to move, transform and load data between platforms without service disruption.

  • Perform other duties and projects as assigned.


  • Bachelor's degree in computer science or other relevant degree/experience.

  • 7+ years' experience in developing and administering Microsoft SQL server databases.

  • Expert knowledge in RSBMS concepts, data normalization, SQL Server, and T-SQL.

  • Strong skills in OLAP and reporting technologies, preferred.

  • Experience developing ETL robust processes.

  • Strong interpersonal and communication skills with an ability to communicate well in English.

  • Extensive experience writing T-SQL. stored procedures, and query tuning on high-transaction systems.

  • Experience with cloud database technologies a plus.

  • Deep understanding of data quality, reporting, and data analysis techniques.

  • Understanding of APIs and modern web architecture.

  • Experience with software lifecycle processes, code reviews, and source control platforms (SSDT, Visual Studio, GIT,VSTS/Azure DevOps).

  • Strong desire to collaborate and work as part of a team.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Intelligence Engineer Internal SLU Analytics Product

Amazon.Com, Inc.

Posted 1 week ago

VIEW JOBS 3/12/2019 12:00:00 AM 2019-06-10T00:00 We are looking for passionate Business Intelligence Engineer (BIE) to scale our spoken language understanding (SLU) analytics product suite. The product itself is internally built and own analytics software, specifically for analyzing automatic speech recognition (ASR) and natural language understanding (NLU) component and system performance. We are developing software to make analyzing baseline performance and identifying improvement areas easier for our Alexa teams. The BIE will own optimizing the underlying SQL queries and ETLs so our software services can consume disparate and large data sources into our analytics suite. As a BIE leader within Alexa, we look to you for design, implementation, and successful delivery of large-scale, critical, and/or difficult data solutions involving a significant amount of work. You will be a part of a team of top technical professionals developing complex systems at scale and with a focus on sustained operational excellence. Where needed, you integrate your team's data solutions with those owned by other teams. You influence your team's technical and business strategy by making insightful contributions to team priorities and overall data approach. You take the lead in identifying and solving ambiguous problems, architecture deficiencies, or areas where your team's current queries, data models/structure, etc. slow the team down. You make data solutions simpler. We are looking for people who are motivated by thinking big, moving fast, and changing the way our internal users analyze information to drive Alexa customer engagement. If you love to implement solutions to hard problems while working hard, having fun, and making history, this may be the opportunity for you. The Business Intelligence Engineer: * Will build and optimize ETLs and their underlying SQL queries to efficiently, accurately, and with low-latency load data to our product suite for use by customers. * Will influence big data solutions/access to data set(s) in team architecture and will be solely responsible for the efficient, secure, and performant queries underlying our analytics suite. As such, attention to detail, data integrity, and strong analytical skills (i.e., understanding business implications of what the data says) are required. * Has knowledge of engineering and operational excellence best practices. Can make enhancements that improve data processes (e.g., data auditing solutions, management of manually maintained tables, automating, ad-hoc or manual operation steps). * Understands how to make appropriate data trade-offs. Can balance customer requirements with technology requirements. Knows when to re-use code. Is judicious about introducing dependencies. * Delivers pragmatic solutions. You do things with the proper level of complexity the first time (or at least minimize incidental complexity). * Understands how to be efficient with resource usage (e.g., system hardware, data storage, query optimization, AWS infrastructure etc.) * Will write code that a Data Engineer or Software Development Engineer unfamiliar with the system can understand. * Communicates proposals and results in a clear manner backed by data and coupled with actionable conclusions to drive business decisions * Will thrive in an agile, iterative environment where collaboration with Product Managers, Data Engineers, and Software Development Engineers is crucial for delivering the right information to our customers. * Should have demonstrated success in an environment which offers ambiguously defined problems, big challenges, and quick changes. Amazon.Com, Inc. Cambridge MA

Business Intelligence Engineer

Foundation Medicine