What are the responsibilities and job description for the Business Information Developer Consultant – ETL Developer position at Elevance Health?
Location: This position will work a hybrid model (remote and in office one day per week). Ideal candidates will live within 50 miles of one of our Pulse Point locations in Atlanta, GA, Wilmington, DE, Tampa, FL, Indianapolis, IN, Durham, NC, Norfolk, VA, Richmond, VA, Mason, OH, Cincinnati, OH, St. Louis, MO, Wallingford, CT, Grand Prairie, TX or Louisville, KY.
The Business Information Consultant Developer-ETL Developer is responsible for developing and executing more complex data mining analyses.
How You Will Make An Impact
Requires a BS/BA degree and a minimum of 4 years related experience; or any combination of education and experience which would provide an equivalent background.
Preferred Skills, Capabilities And Experiences
Who We Are
Elevance Health is a health company dedicated to improving lives and communities – and making healthcare simpler. We are a Fortune 25 company with a longstanding history in the healthcare industry, looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve.
How We Work
At Elevance Health, we are creating a culture that is designed to advance our strategy but will also lead to personal and professional growth for our associates. Our values and behaviors are the root of our culture. They are how we achieve our strategy, power our business outcomes and drive our shared success - for our consumers, our associates, our communities and our business.
We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few.
Elevance Health operates in a Hybrid Workforce Strategy. Unless specified as primarily virtual by the hiring manager, associates are required to work at an Elevance Health location at least once per week, and potentially several times per week. Specific requirements and expectations for time onsite will be discussed as part of the hiring process. Candidates must reside within 50 miles or 1-hour commute each way of a relevant Elevance Health location.
The health of our associates and communities is a top priority for Elevance Health. We require all new candidates in certain patient/member-facing roles to become vaccinated against COVID-19 and Influenza. If you are not vaccinated, your offer will be rescinded unless you provide an acceptable explanation. Elevance Health will also follow all relevant federal, state and local laws.
Elevance Health is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process may contact elevancehealthjobssupport@elevancehealth.com for assistance.
The Business Information Consultant Developer-ETL Developer is responsible for developing and executing more complex data mining analyses.
How You Will Make An Impact
- Determines how decision support systems will provide the data required to make effective business decisions.
- Performs modeling of information sources and flows.
- Coordinates the activities of a project team and monitors project schedules and costs for own projects.
- Develops strategic report applications from the data warehouse.
- Establishes and maintains excellent knowledge of data warehouse database design, data definitions, system capabilities, programming languages, and data integrity issues.
- Develops and supports complex data warehouse-related applications for business areas requiring design and implementation of database tables.
- Programs majority of the time
- Conducts training on use of applications developed.
Requires a BS/BA degree and a minimum of 4 years related experience; or any combination of education and experience which would provide an equivalent background.
Preferred Skills, Capabilities And Experiences
- Experience with relational databases and knowledge of query tools and statistical software strongly preferred.
- Ability to manipulate large sets of data strongly preferred.
- Minimum of 2 years hands-on experience with Cloud Technologies like AWS, GCP or Azure preferred.
- Minimum of 3 years hands-on experience with ETL Tool: DataStage, SSIS or similar technologies preferred.
- Strong SQL and analytical skills preferred.
- Experience developing APIs preferred.
- Hands-on experience in designing and implementing data pipelines in cloud platforms preferred.
- In-depth knowledge of various core AWS services such as IAM, Cloud Formation, EC2, S3, ECS, EMR/Spark, SQS, SNS, Glue suite-ETL job, Data Catalog, Crawler, Data sync, Cloud Health, CloudWatch, Lambda, Athena, Quicksight, DMS and Redshift preferred.
- Experience working with relational databases including Oracle, SQL Server, T-SQL scripts and stored procedures preferred.
- Experience working in event driven architecture preferred.
- Hands-on experience working with JSON and RabbitMQ preferred.
- Experience working with Sybase and MongoDB preferred.
- Strong analytical, organizational and problem-solving skills preferred.
Who We Are
Elevance Health is a health company dedicated to improving lives and communities – and making healthcare simpler. We are a Fortune 25 company with a longstanding history in the healthcare industry, looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve.
How We Work
At Elevance Health, we are creating a culture that is designed to advance our strategy but will also lead to personal and professional growth for our associates. Our values and behaviors are the root of our culture. They are how we achieve our strategy, power our business outcomes and drive our shared success - for our consumers, our associates, our communities and our business.
We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few.
Elevance Health operates in a Hybrid Workforce Strategy. Unless specified as primarily virtual by the hiring manager, associates are required to work at an Elevance Health location at least once per week, and potentially several times per week. Specific requirements and expectations for time onsite will be discussed as part of the hiring process. Candidates must reside within 50 miles or 1-hour commute each way of a relevant Elevance Health location.
The health of our associates and communities is a top priority for Elevance Health. We require all new candidates in certain patient/member-facing roles to become vaccinated against COVID-19 and Influenza. If you are not vaccinated, your offer will be rescinded unless you provide an acceptable explanation. Elevance Health will also follow all relevant federal, state and local laws.
Elevance Health is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process may contact elevancehealthjobssupport@elevancehealth.com for assistance.
