Data Engineer
Apply NowCompany: Vanda Pharmaceuticals
Location: Washington, DC 20011
Description:
Key Responsibilities
Data Engineering & Automation
Data Analysis & Insights
Qualifications
Required Skills & Experience:
Preferred Skills:
Soft Skills:
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.
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)
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.
Data Analysis & Insights
- Query, analyze, and generate reports from large datasets.
- Develop data models, dashboards, and reports using SQL, Python, or BI tools.
- Work closely with business teams to understand data needs and provide solutions.
Qualifications
Required Skills & Experience:
- Strong SQL skills (complex queries, performance tuning, handling large datasets).
- Knowledge of indexing strategies (e.g., B-tree, composite indexes) and when to use them.
- Familiarity with partitioning, materialized views, and caching mechanisms.
- Ability to assess schema design and diagnose bottlenecks (e.g., full table scans, inefficient joins).
- Proficiency in scripting with Python, Ruby, or similar
- Experience with ETL/ELT processes and data pipeline automation.
- Hands-on experience with Excel automation (Python, VBA, or Power Query).
- Experience working with large datasets efficiently.
- Strong understanding of data warehousing principles and schema design.
Preferred Skills:
- Exposure to BI tools like Tableau, Power BI, or Looker.
- Experience with data governance, security, and compliance best practices.
Soft Skills:
- Ability to translate business needs into technical data solutions.
- Strong problem-solving skills and the ability to work independently.
- Excellent written and verbal communication skills.
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.
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)