Business Info Developer Consultant Senior

Elevance Health•Mason, OH

2d•Hybrid

About The Position

Business Information Developer Consultant Senior Location: This role requires associates to be in-office 1-2 days per week, fostering collaboration and connectivity, while providing flexibility to support productivity and work-life balance. This approach combines structured office engagement with the autonomy of virtual work, promoting a dynamic and adaptable workplace. Alternate locations may be considered if candidates reside within a commuting distance from an office. Please note that per our policy on hybrid/virtual work, candidates not within a reasonable commuting distance from the posting location(s) will not be considered for employment, unless an accommodation is granted as required by law. The Business Information Developer Consultant Senior will be viewed as an expert while supporting Carelon Payment Integrity in the development and execution of data mining analyses. The Business Developer Consultant Sr. will lead the onshore/offshore development team of engineers and DevOps to produce scalable product solutions. Carelon Payment Integrity is a proud member of the Elevance Health family of companies, Carelon Insights, formerly Payment Integrity, is determined to recover, eliminate and prevent unnecessary medical-expense spending. How you will make an impact: Undertakes complex assignments requiring additional specialized technical knowledge. Develops very complex and varied strategic report applications from a Data Warehouse. Establishes and communicates common goal as well as a roadmap for team. Establishes and maintains advanced knowledge of data warehouse database design, data definitions, system capabilities, and data integrity issues. Acts as a source of direction, training, and guidance for less experienced staff. Monitors project schedules and costs. Develops and supports very complex Data Warehouse-related applications for business areas requiring design and implementation of database tables. Coordinates with offshore team and cross-functional teams to ensure that applications are properly configured, tested, and deployed. Effectively communicates with multiple levels of the organization including models/data story interpretation and presentations to include training on use of applications developed. This job is focused on spending time thinking about programming and how it would be used to design solutions.

Requirements

Requires a BS/BA degree
minimum of 6 years’ experience
any combination of education and experience, which would provide an equivalent background.

Nice To Haves

10+ years of IT experience as a Data Engineer with expertise in designing data-intensive applications using Snowflake, Cloud Data Engineering, Data Warehouse / Data Mart and Data Quality solutions.
7 years’ experience in Spark with Scala and Python, 10 years in SQL, 3 years in Snowflake and 3 years in AWS/GCP ecosystem.
Experience with Snowflake utilities, Snow SQL, Snow Pipe, big data model techniques using Python, Scala, & Java.
Familiar with data warehouse technologies such as Edward, ODW, and GBD Facets.
Designed, built, and managed ETL data pipelines.
Worked on various data source formats like CSV, Parquet, Avro and other RDBMS and Data warehouses are extracted, transformed, and loaded to generate flat files with Python & Scala programming and SQL Queries.
Worked on Spark 2.3.0 with Scala for Extract Transform Load (ETL) process.
Experience in building and migrating large-scale data platforms using Snowflake.
Domain knowledge of US Healthcare/medical claims.
Hands-on experience with EC2, EMR, S3, Glue, Lambda, Athena, IAM, SQS and other, Data Proc, Cloud Function and Cloud Composer services of the AWS/GCP ecosystems.
Utilized AWS Glue for data transformation, validation and data cleansing.
Experience in importing and exporting data between HDFS and RDBMS and vice versa using SQOOP.
Experience in analyzing data using Hive QL and designing custom UDF in Hive.
Hands-on experience in Linux Shell Scripting.
Demonstrated experience writing complicated SQL Queries and database analysis experience for performance tuning.
Expert in building, deploying and maintaining applications using GIT, Jenkins, and/or XL Deploy.
Involvement in Agile Scrum methodology that leverages the client big data platform and experience using version control like Code Hub and Git Hub.
Excellent analytical, interpersonal, and communication skills.
Fast learner, hardworking and good team player who can translate/present outcomes of large data sets to business users.

Responsibilities

Undertakes complex assignments requiring additional specialized technical knowledge.
Develops very complex and varied strategic report applications from a Data Warehouse.
Establishes and communicates common goal as well as a roadmap for team.
Establishes and maintains advanced knowledge of data warehouse database design, data definitions, system capabilities, and data integrity issues.
Acts as a source of direction, training, and guidance for less experienced staff.
Monitors project schedules and costs.
Develops and supports very complex Data Warehouse-related applications for business areas requiring design and implementation of database tables.
Coordinates with offshore team and cross-functional teams to ensure that applications are properly configured, tested, and deployed.
Effectively communicates with multiple levels of the organization including models/data story interpretation and presentations to include training on use of applications developed.

Benefits

Elevance Health offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements).
medical, dental, vision, short and long term disability benefits, 401(k) +match, stock purchase plan, life insurance, wellness programs and financial education resources

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume