Versant Health · 2 weeks ago
Senior ETL Developer
Troy, NY
Full-time
Onsite
Senior Level, Lead/Staff
$125K/yr - $130K/yr
8+ years expVersant Health is one of the nation’s leading administrators of managed vision care, serving millions of our clients’ members nationwide. The Senior ETL Developer will primarily support ETL development using Informatica PowerCenter and IICS, focusing on the analysis, design, development, and delivery of data from operational systems into various data storage solutions.
EyewearHealth CareInsurance
Responsibilities
ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions in the company
After development work completes, developers also must test their designs to ensure the system runs smoothly
Developers must be experts at taking a big-picture view of a company's data situation
Design, develop and maintain database objects such as the tables, views and stored procedures needed to support reporting and/or analytics solutions
Analyze data to understand gaps, inconsistencies and other quality issues, and devise data quality improvement solutions
Analyze and remedy database and query performance issues
Developers need to be able to read, analyze and digest what a business wants to accomplish with its data, and design the best possible ETL process around those goals
Work with business users and gathering data and reporting requirements
Work with business users and QA team with user-acceptance testing and issue resolution
Must be proficient with SQL Queries
Needs to have greater understanding and experience of Data warehousing, data transformation, and business intelligence
Must have experience working with dimensional modeling
Must have some experience in Python scripting
Must be a team-player and willing to work under tight timeline
Other duties as assigned
Qualification
Required
Bachelor's Degree in Computer Science, Computer Engineering, Information Systems or related field or equivalent relevant experience
8 years of hands-on experience using Informatica Power center, IICS IDQ tools
Solid Hands on experience in SQL programming and writing stored procedures, functions, views, SQL queries is required
Ability to quickly assess data structures and processes to interpret how business data sets relate to each other
Strong desire to learn how things work and to apply that knowledge to problem resolution
Preferred
3 years of experience in Python with data science libraries is plus
Should have worked on complex reporting scenarios involving Multiple Tables, Loops, Contexts, Prompts, Aggregate Awareness, Derived Tables, Charts, Ranking, and Percentages etc
Needs to have greater understanding and experience of Data warehousing, data transformation, and business intelligence
Must have experience working with dimensional modeling
Must be a team-player and willing to work under tight timeline
Benefits
Health and dental insurance
Tuition reimbursement
401(k) with company match
Pet insurance
No-cost-to-you vision insurance for you and your qualified dependents
Company
Versant Health
Versant Health offers eye health and vision care plan for members, clients, brokers, and eye care professionals.
1001-5000 employees
H1B Sponsorship
Versant Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (3)
2023 (2)
2022 (6)
2021 (2)
2020 (5)
Funding
Current Stage
Late StageTotal Funding
unknown2020-09-17Acquired
Leadership Team
Kia Lindsay
Chief People Officer
Neelam Gor
Chief Clinical Officer
Recent News
2022-04-28
Company data provided by crunchbase