Senior Data Engineer

Posted:
9/9/2024, 8:50:20 AM

Location(s):
New Jersey, United States ⋅ Texas, United States ⋅ Missouri, United States ⋅ Florida, United States ⋅ Georgia, United States ⋅ Massachusetts, United States

Experience Level(s):
Senior

Field(s):
Data & Analytics

Workplace Type:
Hybrid

Location and Workplace Flexibility: 

We have offices in Atlanta GA, Boston MA, Morristown NJ, Plano TX, St. Louis MO, St. Petersburg FL, and Hyderabad, India. We foster a hybrid and remote friendly culture and all of our employee's work locations are based on the needs of the position and determined by the Leadership team. In-office work and activities, if applicable, vary based on the work and team objectives in accordance with Company policies.

Senior Data Engineer

Responsibilities:

  • Build High level technical design both for Streaming and batch processing systems

  • Design and build reusable components, frameworks and libraries at scale to support analytics data products

  • Perform POCs on new technology, architecture patterns

  • Design and implement product features in collaboration with business and Technology stakeholders

  • Anticipate, identify, and solve issues concerning data management to improve data quality

  • Clean, prepare and optimize data at scale for ingestion and consumption

  • Drive the implementation of new data management projects and re-structure of the current data architecture

  • Implement complex automated workflows and routines using workflow scheduling tools

  • Build continuous integration, test-driven development and production deployment frameworks

  • Drive collaborative reviews of design, code, test plans and dataset implementation performed by other data engineers in support of maintaining data engineering standards

  • Analyze and profile data for the purpose of designing scalable solutions

  • Troubleshoot complex data issues and perform root cause analysis to proactively resolve product and operational issues

  • Lead, Mentor and develop offshore Data Engineers in adopting best practices and deliver data products.

  • Partner closely with product management to understand business requirements, breakdown Epics,

  • Partner with Engineering Managers to define technology roadmaps, align on design, architecture, and enterprise strategy

Requirements:

Minimum of 6 years experience with the following:

  • Snowflake (Columnar MPP Cloud data warehouse)

  • ETL tool to include any of the following: DBT; Informatica; Matillion; Talend; or Azure Data Factory

  • Python

  • Experience designing and implementing Data Warehouse

Preferred Skills:

  • SQL objects (procedures, triggers, views, functions) in SQL Server.  SQL query optimizations  

  • Understanding of T-SQL, indexes, stored procedures, triggers, functions, views, etc.

  • Design and development of Azure/AWS Data Factory Pipelines preferred.

  • Design and development of data marts in Snowflake preferred

  • Working knowledge of Azure/AWS Architecture, Data Lake, Data Factory

  • Business analysis experience to analyze data to write code and drive solutions

  • Knowledge of: Git, Azure DevOps, Agile, Jira and Confluence

  • Working knowledge of Erwin for data modelling

Zelis is modernizing the healthcare financial experience by providing a connected platform that bridges the gaps and aligns interests across payers, providers, and healthcare consumers. This platform serves more than 750 payers, including the top 5 national health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, and millions of healthcare providers and consumers. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts – driving real, measurable results for clients.

Commitment to Diversity, Equity, Inclusion, and Belonging 
At Zelis, we champion diversity, equity, inclusion, and belonging in all aspects of our operations. We embrace the power of diversity and create an environment where people can bring their authentic and best selves to work. We know that a sense of belonging is key not only to your success at Zelis, but also to your ability to bring your best each day.

Equal Employment Opportunity  
Zelis is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. 

We encourage members of traditionally underrepresented communities to apply, even if you do not believe you 100% fit the qualifications of the position, including women, LGBTQIA people, people of color, and people with disabilities.  

Accessibility Support 

We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email [email protected].  

SCAM ALERT: There is an active nationwide employment scam which is now using Zelis to garner personal information or financial scams. This site is secure, and any applications made here are with our legitimate partner. If you’re contacted by a Zelis Recruiter, please ensure whomever is contacting you truly represents Zelis Healthcare. We will never asked for the exchange of any money or credit card details during the recruitment process. Please be aware of any suspicious email activity from people who could be pretending to be recruiters or senior professionals at Zelis.