Description:

ETL Developer POSITION SUMMARY: Reporting to the Senior Data Modeler, the ETL Developer is primarily responsible for the creation and maintenance of ETLs in support of the DW architecture. The Developer is also responsible for preparing and maintaining tabular reports, as needed by business users across the organization. DUTIES / RESPONSIBILITIES: 1. Define and own the execution of the ETL transactions necessary to implement the DW architecture. 2. Create and maintain gating/QA processes in support of data governance efforts. 3. Author and maintain tabulated/transactional reports for software systems that lack internal reporting functions. 4. Optimize SQL performance and implement performance enhancements. 5. Assist the Senior Data Modeler in the design of the DW/ETL architecture, as appropriate. 6. Maintain thorough and professional documentation for ETLs and reports (business requirement documents, technical design documents, source-to-target mapping, data flow diagrams, etc.). 7. Adhere to best practices and standards; perform coding review and quality testing. QUALIFICATIONS (knowledge, skills, abilities): 1. 5+ years of experience working as an ETL developer in a data warehouse, data lake, or operational data store environment. 2. 4+ years of recent experience working with healthcare payer or provider data; specifically with healthcare claims, EHR, membership, enrollment, and clinical data. 3. Experience designing complex ETLs across multiple disparate datasets and using ETL software (SSIS, Informatica, etc.). 4. Expert SQL skills and experience writing complex queries. 5. Experience writing transactional reports and using SQL-based reporting software (SSRS, etc.). 6. Bachelor's degree, or equivalent experience, in quantitative field (e.g., engineering, computer science, finance). 7. Excellent written and verbal communication skills. 8. Versatility, flexibility, enthusiasm, and a willingness to work with frequently-changing priorities. 9. Experience in a PACE and/or MAO environment a plus. The above statements are intended to describe the general nature of work performed. They are not considered as an exhaustive list of all job tasks performed. On Lok reserves the right to change job descriptions, work hours or work sites as required by the program.

Skills:

Sql, Etl, Data warehouse, snowflake, matillion

Top Skills Details:

Sql,Etl,Data warehouse

Additional Skills & Qualifications:

Snowflake is a nice to have Matillion is a nice to have

Experience Level:

Intermediate Level

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.