Duties:
- Engage with cross functional partners on data understanding, data storage consultation
- Design, develop, and maintain team data pipelines
- Build interactive data visualization dashboards or front end applications
- Communicate data findings to stakeholders with clear summaries and recommendations to inform next steps
- Continuously improve the existing pipelines and process infrastructure to meet evolving business needs
Skills:
Must Haves:
- Experience in data warehouse
- Experience in custom ETL design, implementation, and maintenance
- Experience with SQL and Python
- Experience with schema design and dimensional data modeling
- Experience managing and communicating data storage, pipelining plan to internal stakeholders
Nice to Haves:
- Experience with more than one coding language, e.g. Java or C.
- Experience with designing and implementing real-time pipelines
- Experience with Airflow
- Experience querying massive datasets using Spark, Presto, Hive, Impala, etc.
- Prior industry data pipeline experience
Education:
- Bachelor or Master's degree in Statistics or Computer Science or Equivalent Experience required
Story Behind the Need – Business Group & Key Projects: Required:
- Surrounding team & key projects
- This CW position will be in Agios Experience Research (AXR) team within Client Agios.
- Key projects: Maintain Duckota Data Pipeline, consult with XFN to build and implement data pipelines and dashboards
Purpose/Size of this team:
- 20-30 people
Reason for the request:
- This resource is required for data pipelining needs at Client Agios.
- Currently, we fully rely on Data Engineer expertise on volunteers from the Client product team.
- We also see increasing demand on data storage/streamlined data pipeline needs across agios.
- For example, maintain existing Duckota Data Pipeline (Glove Initiative), build out Foundry data storage (Foundry team), and build automated data storage and visualization pipelines for Carbonara (PI Initiative).
- Currently, Agios does not have any dedicated FTE/CW with data engineer, we could not satisfy our internal data engineering needs by merely depending on volunteers.
- This CW is critical to implement reusable and scalable data solutions to help Agios move to a more data driven research organization.
Role interesting:
- Build the data foundation to advance ARVR research in the metaverse
- Collaborate with researchers from various background to enable streamlined data processing/knowledge discovery pipeline
Competitive market comparison:
- This senior Data Engineer roles pays competitively in the market
Unique selling points:
- Data Engineer experience at Client will expose you to lots of cutting-edge data infrastructure tools
Value added or experience gained:
- Experience in using various big data tools
- Building data foundation from 0 to 1
Years of experience required:
- 1 to 2
- We could also consider candidate with less than 1 year of experience if he/she is an avid learner
Key performance measurements:
- Task completion (e.g., ability to learn new tools and build data pipeline, effectiveness of maintaining existing pipelines)
- Collaboration with XFN partners (e.g., effectiveness of cross functional collaboration)
Degrees or certifications required:
- Bachelor or Master's degree in Statistics, Engineering, Computer Science or Equivalent Experience required.
Disqualifiers:
- If candidate does not have any python/sql coding experience
As an equal opportunity employer, ICONMA prides itself on creating an employment environment
that supports and encourages the abilities of all persons regardless of race, color, gender, age, sexual
orientation, citizenship, or disability.