• US Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 17th May 2022

• They want a ETL Developer with SQL skills who has experience ideally in a BCBS plan and with claims data/HL 7 data.  
• Must have good FHIR (fast healthcare interoperability resources) experience.  

 

EXPERIENCE REQUIREMENTS

Required:

·         Minimum of 7 years of experience computer programming language(s) coding, building deployment software required.

·         Experience with Microsoft’s ASP.NET, SSIS, SSRS, C#, and the .NET Framework required.

·         Experience designing, building, and supporting ETL processes.

·         Experience with managed file transfer) and Opcon Scheduler required.

·         Advanced understanding of complex database methodologies, data analysis, SQL queries, ETL, and business information management applications required.

·         Experience with data lakes, data warehouses, and other data management components utilized to establish data assets for reporting required. 

 

 

JOB SUMMARY

·         The Senior ETL Developer is responsible for the design, implementation, and maintenance of the data warehouse and all related extraction, transformation, and load data functions.

·         This role designs, defines, and implements standards and procedures for platform validation and maintains data integrity through the data lifecycle.

·         The Senior ETL Developer collaborates with stakeholders to define new data assets and design and build data models to integrate the data assets to support data use in reporting and analytics.

·         This role serves as the interface to IT and Security for technology upgrades, file transfer procedures, code management, and job scheduling. 

 

ESSENTIAL FUNCTIONS

·         Analyzes the business requirements for data file requests to design, develop, and deploy fully automated ETL jobs to produce data files.

·         Designs, develops, and deploys ETL programs to facilitate the receipt of data from various data sources and the loading of data into destination tables within the overall data architecture framework.

·         Collaborates to design end-to-end solutions for file creation and distribution, as well as supporting ETL production processes and operations.

·         Performs technical peer reviews and code reviews.

·         Trains, coaches, and mentors departmental staff on new technologies, methods, or processes to enhance data assets and capabilities. Collaborates with leadership to support strategic goals within the team.

·         Leads discussions with customers and stakeholders to understand and translate business use cases and requirements into data models, data integration routines, and analytics reports.

·         Utilizes advanced understanding of healthcare data models to identify data sources and maps data to required file specifications.

·         Designs and automates data quality and data validation functions as part of the overall solution.

·         Leverages expertise in ETL and the MS SQL platform to perform performance tuning of technologies to manage data.

·         Participates in review of potential technical architectures and solutions to improve and enhance existing systems, processes, and data services.

·         Facilitates collaborative data modeling activities or sessions among multiple stakeholders

 

 KNOWLEDGE, SKILLS AND ABILITIES

·         Analytical Thinking Advanced Attention to Detail and Accuracy Advanced Continuous Learning/Development (Self) Advanced Team/Work Guidance Advanced Problem Solving and Resolution Advanced Technical/Professional Knowledge and Skills Advanced 

 

EDUCATION REQUIREMENTS

Required: Bachelor's

Preferred: Bachelor's Field(s) of Study: Computer Science, Computer Information Systems, Management Information Systems, or related field 

 

EXPERIENCE REQUIREMENTS

Required:

·         Minimum of 7 years of experience computer programming language(s) coding, building deployment software required.

·         Experience with Microsoft’s ASP.NET, SSIS, SSRS, C#, and the .NET Framework required.

·         Experience designing, building, and supporting ETL processes.

·         Experience with managed file transfer) and Opcon Scheduler required.

·         Advanced understanding of complex database methodologies, data analysis, SQL queries, ETL, and business information management applications required.

·         Experience with data lakes, data warehouses, and other data management components utilized to establish data assets for reporting required. 

 

CERTIFICATION, LICENSURES & REGISTRATION REQUIREMENTS

Title: DAMA Certified Data Management Professional (CDMP), MS SQL Certifications State or Agency: DAMA International, Microsoft