Data Engineer / Analyst

  • Illumina
  • US - California - San Diego
  • Mar 26, 2020
Full time Biotech

Job Description

  • The selected candidate will report into the Illumina Life Cycle Management team and support the operations organization in the areas of information systems and data analytics.  The role will directly support instruments manufacturing and engineering teams by designing and supporting robust, intuitive tools that seamlessly provide the information and insight our teams need.  This position will be a part of the larger information systems & analytics team spread across California and Singapore. The systems & analytics team will continue to be responsible for collecting and maintaining instruments manufacturing data, connecting to additional data streams, making data accessible to users, and driving value based on the available data.

     

    Responsibilities:

    • Develop and maintain ETL packages for manufacturing data
    • Administer data system configurations in SQL Server
    • Monitor and maintain synchronization between data system and manufacturing parameters
    • Perform ad-hoc queries in SQL Server to gather instruments data for investigation or analysis
    • Monitor usage and influence manufacturing process to encourage data reliability and system uptake
    • Organize and execute user acceptance testing for new functionality releases
    • Contribute to data visualizations for engineers and production personnel using Tableau, SSRS, or custom web design
    • Contribute to SQL Server database design to improve efficiency and effectiveness of manufacturing data systems
    • Contribute to user interface design
    • Develop applications to collect information from users, perform post-hoc analysis of test data, or integrate additional data streams
    • Develop queries in HANA to access and integrate corporate ERP data into manufacturing/engineering reports
    • Design and deploy Denodo views to better integrate data from disparate systems
    • Develop new API’s for external access to manufacturing data; and, integrate existing API’s to provide external data in manufacturing/engineering reports

     

    Requirements:

    • Experience working with scientific, engineering, or manufacturing data is required
    • Demonstrated ability to navigate large, complex datasets to extract useful data is required
    • Demonstrated ability to design and implement ETL processes is required
    • Strong SQL skills required, SQL Server a plus
    • Experience designing HANA queries is preferred
    • Experience designing Denodo views is preferred
    • Experience designing stored procedures and views is required
    • Experience with Relational Database Design is a plus, SQL Server a plus
    • Experience with SQL Server administration is a plus
    • Experience with report design and/or maintenance in SSRS is a plus
    • Experience designing complex technical data visualizations is required, Tableau is preferred
    • Experience with Tableau Server is a plus
    • Web development skills including CSS and Javascript are a plus
    • Experience performing data analysis and data curation is required, experience with JMP, SAS, R, Python, MATLAB is preferred
    • Experience interfacing with manufacturing or engineering customers and processes is required
    • Experience executing User acceptance testing is preferred
    • Experience operating in a controlled development environment is preferred, experience with Agile development a plus
    • Experience integrating external APIs is a plus
    • Experience designing applications for data collection is preferred
    • Ability to collect, prepare, and present information tailored to both technical and non-technical audiences is required
    • Strong analytical, written and verbal communication skills are required
    • Demonstrated ability to succeed on multiple concurrent projects in a complex, dynamic, sometimes ambiguous environment is required

     

    Education:

    • Bachelors or Masters degree in Computer Science, Statistics, Engineering, or related field is required
    • Two years of experience in analytics, data systems design/administration, or related field is preferred

     

     

    Illumina believes that everyone has the ability to make an impact, and we are proud to be an equal opportunity employer committed to providing employment opportunity regardless of sex, race, creed, color, gender, religion, marital status, domestic partner status, age, national origin or ancestry, physical or mental disability, medical condition, sexual orientation, pregnancy, military or veteran status, citizenship status, and genetic information. If you require accommodation to complete the application or interview process, please contact accommodations@illumina.com. To learn more, visit: https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf
      Posted 23 Days Ago
      Full time
      19667-JOB

About Us

       
  • Do you want to make a difference? Illumina’s mission is to improve human health by unlocking the power of the genome. If that inspires you, let’s talk. We’ve built a culture fueled by innovation, collaboration and openness, and established ourselves as the global leader in DNA sequencing and array-based technologies. Our people and our technology change lives by driving advancements in life sciences, oncology, reproductive health, agriculture and other emerging markets. Life at Illumina is about working with teammates who are deeply passionate about what we do, because we know that our work has the power to improve lives.

     

    We’re an established company with a track record of phenomenal growth. Just check out our investor events and presentations to learn about our financial accomplishments. Our growth isn’t just in financials, we’ve been busy hiring the best and the brightest. Perhaps that’s why MIT has ranked Illumina near the top of its World’s Smartest Companies each of the last three years. If you thrive in a brilliant, fast-paced, and mission-driven environment, Illumina is the place for you. Join the journey of a lifetime. Join Illumina.