Job description
Overview
:The Senior Data Engineer is an experienced data warehouse consultant to support the enterprise data warehouse program. A successful candidate should have multiple years of development and support experience with large scale healthcare data warehouse built on either cloud or on-prem platform.
Job Highlights
:
ESSENTIAL DUTIES AND RESPONSIBILITIES:
(
The ideal candidate must be able to complete all physical requirements of the job with or without a reasonable accommodation)
Work with business analysts and business users to identify, understand, and prioritize user requirements.- Drive client conversations around technical and functional design and specifications.
- Communicate between business users and the EDW development team to translate business requirement into technical requirement.
- Work with data warehouse architects to design technical solutions on model enhancement and/or logic change to satisfy client requests.
- Design, code, test new data warehouse features including adding or updating columns, tables, views, OLAP cubes, etc.
- Analyze query performance and perform query tuning to assist development engineers in designing and optimizing queries.
Qualifications
:
KNOWLEDGE/SKILLS/ABILITIES (KSAs):
Bachelor's Degree in Computer Science, Computer Engineering, Information Technology, or equivalent IT certifications.- Strong analytical skills to solve and model complex business requirements.
- Strong verbal and written communication skills, and team player.
- Self-starter, with great analytical skills.
- 5+ years of experience in healthcare IT industry. Working knowledge with US healthcare IT protocols and coding systems, such as CPT, ICD-9/10, HIPPA, etc.
- 5+ years of combined database development experience with on-prem and cloud data platforms. MS SQL server, Azure Synapse, or AWS Redshift highly preferred.
- 3+ years of experience designing, developing, and supporting the enterprise data warehouse and reporting solutions.
- Advanced knowledge of SQL and Python, including the ability to write stored procedures, analytic/windowing functions, and optimize query performance.
- 3+ years of experience with mainstream BI solutions including PowerBI, SSRS, SSAS, SSIS, Tableau, etc.
- Experience troubleshooting common database issues (duplicate keys, inefficient joins/views, DB performance issues).
The physical demands described here are representative of those that may need to be met by an employee to successfully preform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Occasional Standing
- Occasional Walking
- Frequent Sitting
- Frequent hand, finger movement
- Use office equipment (in office or remote)
- Communicate verbally and in writing
www.colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, www.colinoncars.com is the ideal place to find your next job.