We use cookies. Find out more about it here. By continuing to browse this site you are agreeing to our use of cookies.
#alert
Back to search results

Data Engineer

Vanda Pharmaceuticals Inc.
parental leave, paid time off, 401(k)
United States, D.C., Washington
2200 Pennsylvania Avenue Northwest (Show on map)
Feb 11, 2025
Description

Key Responsibilities

Data Engineering & Automation



  • Develop, optimize, and maintain ETL/ELT pipelines to process large datasets from various sources.
  • Automate repetitive data processing tasks, including Excel workbook updates, reporting workflows, and data cleaning.
  • Ensure data quality, accuracy, and security across pipelines, implementing best practices for data integrity and governance.


Data Analysis & Insights



  • Query, analyze, and generate reports from large datasets to drive business decision-making.
  • Develop data models, dashboards, and reports using SQL, Python, or BI tools.
  • Collaborate with cross-functional teams to understand business data needs and provide scalable solutions.


Qualifications

Required Education & Experience:



  • Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.
  • Minimum 4 years of experience in data engineering, data analytics, or a related field.


Required Skills:



  • Strong SQL skills, including complex queries, performance tuning, and handling large datasets efficiently.
  • In-depth knowledge of indexing strategies (e.g., B-tree, composite indexes) and when to use them.
  • Experience with partitioning, materialized views, and caching mechanisms for database optimization.
  • Proven ability to assess schema design and diagnose bottlenecks (e.g., full table scans, inefficient joins).
  • Proficiency in scripting with Python, Ruby, or a similar language for automation and data processing.
  • Hands-on experience designing and maintaining ETL/ELT processes and data pipeline automation.
  • Experience with Excel automation using Python, VBA, or Power Query.
  • Strong understanding of data warehousing principles, schema design, and best practices for scalability and performance.


Preferred Skills:



  • Experience with BI tools such as Tableau, Power BI, or Looker.
  • Knowledge of data governance, security, and compliance best practices in a corporate environment.


Soft Skills:



  • Ability to translate complex business needs into efficient technical data solutions.
  • Strong problem-solving skills with the ability to work independently and in a team.


Excellent written and verbal communication skills, with the ability to convey technical concepts to non-technical stakeholders.

The total compensation package for this position will also include incentive compensation and benefits such as health insurance, unlimited paid time off, parental leave, a 401k matching program, and other benefits to its employees.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, gender identity, sexual orientation, protected veteran status, or any other characteristic protected by law.

Qualifications
Education
Bachelors (required)
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
Applied = 0

(web-7d594f9859-2nzb9)