200+ applicants

This job has closed.

Company

Original Job Post

Amtex Systems Inc. · 2 days ago

Data Warehouse Engineer

California, United States

Full-time

Onsite

Senior Level

7+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

CRMInformation Technology

Actively Hiring

Insider Connection @Amtex Systems Inc.

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Design and build data pipelines to move data from various sources to the data warehouse.

Develop and maintain data warehouse structures to support business needs and ensure data quality.

Implement data ETL processes using tools like MS SSIS, ADF, and Python.

Manage metadata to ensure data accuracy and consistency throughout the data warehouse.

Collaborate with cross-functional teams to understand data requirements and provide appropriate solutions.

Utilize advanced knowledge of database and data warehousing concepts to optimize data storage and retrieval.

Work with healthcare data structures and concepts, particularly from Electronic Health Record systems like Epic.

Stay updated on industry trends and best practices in data engineering and warehousing.

Follow Agile project management methods like SCRUM, Lean, and/or Kanban for efficient project delivery.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLData warehousesData transformationData pipelinesMetadata managementMS SSISADFPythonETL conceptsData structuresTroubleshootingRequirements analysisDatabase conceptsData lakesData modelingJupyter NotebooksAgile project managementHealthcare data structuresEpic CogitoProblem-solvingAnalyticalTeamworkCommunicationOrganizationAzure CloudFabric Data PlatformDevOps

Required

7+ years of experience as a Data Engineer

In-depth knowledge of SQL, data warehouses, and data transformation techniques

Proven experience with designing and building data pipelines

Expert knowledge of metadata management and related tools

Advanced knowledge of data ETL concepts, processes, and tools such as MS SSIS, ADF

Advanced knowledge of Python

Ability to read and understand various data structures

Ability to work independently and as part of a team

Strong analytical, technical, and troubleshooting skills

Ability to assess requirements from multiple sources and their impact on potential solutions

Ability to work in a complex environment

Ability to be organized and proficient at tracking tasks, defining next steps, and following project plans

Advanced knowledge of database and data warehousing concepts, including data lakes, relational and dimensional database design concepts, and data modeling practices

Intermediate knowledge of Jupyter Notebooks

Familiarity with Agile project management methods such as SCRUM, Lean, and/or Kanban

Advanced knowledge of healthcare data structures, workflows, and concepts, from Electronic Health Record systems like Epic

Bachelor’s degree in a technical, scientific, and/or healthcare discipline; or equivalent work experience

Licensure/Certifications: Epic Cogito, Clarity

Preferred

Knowledge of Azure cloud platform, Fabric data platform, ADF and DevOps

Benefits

Healthcare benefits

Company

Amtex Systems Inc.

Glassdoor

3.9

Amtex Systems was officially started in 1997 by Sunny Pokala with its headquarters in Wall Street, New York, and currently has offices across four continents.

Founded in 1997

New York, New York, USA

1,001-5,000 employees