Senior ETL Developer

🤖 Senior ETL Developer/ $85k-$130k Great Place To Work!

  • Cranford, NJ
  • $85,000 - $130,000
Easy Apply Now

A bit about us:

Company is committed to connecting our members to the best care and wellness tools—at the best price. Our dedication to this work began in 1940, when the company was started to help people get health care they couldn’t afford during the Great Depression. Now, as we enter a new era of health care, we continue our mission of delivering affordable solutions to improve the care and health of our members.

Why join us?

Nationwide leader in the provider space! 2022 Most Engaged Workplace!

Great benefit package, strong compensation, PTO, 401k and company culture!

Job Details

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
  • Expands the use of data to support the company’s strategic goals and objectives.

EXPERIENCE REQUIREMENTS
Required: Minimum of 5 Years
Experience Details: Minimum of 5 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
Easy Apply Now
Easy Apply Now
Job Details
Managed by Jobot Pro
Location
Cranford, NJ
Job Type
Permanent
Compensation
$85,000 - $130,000