Sr. Data Warehouse Engineer

Posted 3 months agoViewed

💎 Seniority level: Senior, 8-10 years

🔍 Industry: Health Plan

🗣️ Languages: English

⏳ Experience: 8-10 years

Requirements:

8-10 years of experience as a Data Engineer

Strong ETL experience (SSIS, data warehousing concepts)

Health plan experience strongly preferred

Experience with bringing external data sources into data marts

Strong business knowledge of health plan operations and data

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

Knowledge of Azure cloud platform, Fabric data platform, ADF, and DevOps is highly preferred

Responsibilities:

Develop and maintain data pipelines, API-based or file-based data flows between source systems and the data warehouse

Use innovative tools and techniques to automate common data preparation and integration tasks with the goal of reducing defects and ensuring data quality

Implement best practices to ensure the integrity of data with exception-handling routines

Provides source to target mapping development, support, and maintenance.

Lead troubleshooting efforts and formulate interdisciplinary task force groups for ETL issues

Design, develop, and deploy data structures and data transformations in the enterprise data warehouse using Python, SSIS, ADF

Maintain and extend the Epic Caboodle platform and develop custom Caboodle data modeling components

Form relationships and coordinate with business stakeholders to identify data needs, clarify requirements, and implement solutions

Contribute to the department's short-term and long-term strategic plan

Make appropriate recommendations on the management of data extraction, and analysis

Maintain knowledge of the current regulations and technologies related to data management

Assist with data governance initiatives in the areas of data quality, data security, metadata, and master data management

Actively contribute to all aspects of the data project lifecycle including request intake and acknowledgment, project estimation, time-tracking, and prioritization of tasks.

Be an exemplary team player with excellent collaboration skills

Exhibit outstanding customer service skills with stakeholders

Perform other duties as required or assigned.

Apply

How to Overcome Burnout While Working Remotely: Practical Strategies for Recovery

Posted about 1 month ago

Burnout is a silent epidemic among remote workers. The blurred lines between work and home life, coupled with the pressure to always be “on,” can leave even the most dedicated professionals feeling drained. But burnout doesn’t have to define your remote work experience. With the right strategies, you can recover, recharge, and prevent future episodes. Here’s how.

Top 10 Skills to Become a Successful Remote Worker by 2025

Posted 7 days ago

Remote work is here to stay, and by 2025, the competition for remote jobs will be tougher than ever. To stand out, you need more than just basic skills. Employers want people who can adapt, communicate well, and stay productive without constant supervision. Here’s a simple guide to the top 10 skills that will make you a top candidate for remote jobs in the near future.

Weekly Digest: Remote Jobs News and Trends (August 11 - August 18, 2024)

Posted 9 months ago

Google is gearing up to expand its remote job listings, promising more opportunities across various departments and regions. Find out how this move can benefit job seekers and impact the market.

Weekly Digest: Remote Jobs News and Trends (August 5 - August 11)

Posted 10 months ago

Read about the recent updates in remote work policies by major companies, the latest tools enhancing remote work productivity, and predictive statistics for remote work in 2024.

Tech Layoffs and the New Dynamics of Remote Jobs