Sr. Data Engineer/Cloud/Data Warehouse
Click the Facebook, Google+ or LinkedIn icons to share this job with your friends or contacts. Click the Twitter icon to tweet this job to your followers. Click the link button to view the URL of the job, which then can be copied and pasted into an e-mail or other document.
Chicago, IL 60684
Sr. Data Engineer/Cloud/Data Warehouse
+ Job Family: Data Warehousing and Business Information
+ Type: Full time
+ Date Posted:Jun 28, 2022
+ Req #: PS67853
+ IL, Chicago
Description – External
Be part of an extraordinary team!
We are looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve. You will thrive in a complex and collaborative environment where you take action and ownership to solve problems and lead change. Do you want to be part of a larger purpose and an evolving, high-performance culture that empowers you to make an impact?
Build the Possibilities. Make an extraordinary impact.
Viewed as an expert in the development and execution of data warehouse related activities. Primary duties may include but are not limited to: Undertakes complex assignments requiring additional specialized technical knowledge. 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. Expert level PC, spreadsheet, and database skills, as well as experience in Datastage tool and programming/query languages is strongly preferred. Ability to communicate effectively with multiple levels within the organization is strongly preferred.
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 and direction 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 for own and other projects.
+ Develops and supports very complex Data Warehouse-related applications for business areas requiring design and implementation of database tables.
+ Conducts 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.
Qualifications – External:
Requires a BS/BA degree;minimum of 6 years experience; or any combination of education and experience, which would provide an equivalent background. Expert level PC, spreadsheet, and database skills, as well as experience in standard Business Information tools and programming/query languages is strongly preferred. Ability to communicate effectively with multiple levels within the organization is strongly preferred. If this job is assigned to any Government Business Division entity, the applicant and incumbent fall under a sensitive position’ work designation and may be subject to additional requirements beyond those associates outside Government Business Divisions. Requirements include but are not limited to more stringent and frequent background checks and/or government clearances, segregation of duties principles, role specific training, monitoring of daily job functions, and sensitive data handling instructions. Associates in these jobs must follow the specific policies, procedures, guidelines, etc. as stated by the Government Business Division in which they are employed
Preferred Skills, Capabilities and Experiences:
+ Minimum of 2 years hands-on experience with Cloud Technologies like AWS, GCP or Azure.
+ Minimum of 5 years hands-on experience with ETL Tool: DataStage , SSIS or similar technologies.
+ Strong SQL and analytical skills. Experience developing APIs will be a plus.
+ Hands-on experience in designing and implementing data pipelines in cloud platforms; 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.
+ Experience working with relational databases including Oracle, SQL Server, T-SQL scripts and stored procedures.
+ Experience working in event driven architecture; hands-on experience working with JSON and tool – RabbitMQ
+ Experience working with Sybase and MongoDB a plus
(CO Colorado Pay)
Applicable to Colorado Applicants Only
Annual Salary Range*: $102,000.00 – $127,000.00
Actual compensation may vary from posting based on geographic location, work experience, education and/or skill level.
- The hourly or salary range is the range Anthem in good faith believes is the range of possible compensation for this role at the time of this posting. The Company may ultimately pay more or less than the posted range. This range is only applicable for jobs to be performed in Colorado. This range may be modified in the future. No amount is considered to be wages or compensation until such amount is earned, vested, and determinable under the terms and conditions of the applicable policies and plans. The amount and availability of any bonus, commission, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company’s sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.
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.
The health of our associates and communities is a top priority for Anthem. We require all new candidates to become vaccinated against COVID-19. If you are not vaccinated, your offer will be rescinded unless you provide – and Anthem approves – a valid religious or medical explanation as to why you are not able to get vaccinated that Anthem is able to reasonably accommodate. Anthem will also follow all relevant federal, state and local laws.
Anthem, Inc. has been named as a Fortune 100 Best Companies to Work For®, is ranked as one of the 2020 World’s Most Admired Companies among health insurers by Fortune magazine, and a 2020 America’s Best Employers for Diversity by Forbes. To learn more about our company and apply, please visit us at careers.antheminc.com. Anthem is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. Applicants who require accommodation to participate in the job application process may contact email@example.com for assistance.
Please be advised that Elevance Health only accepts resumes from agencies that have a signed agreement with Elevance Health. Accordingly, Elevance Health is not obligated to pay referral fees to any agency that is not a party to an agreement with Elevance Health. Thus, any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Elevance Health.
Be part of an Extraordinary Team
Elevance Health is a health company dedicated to improving lives and communities – and making healthcare simpler. Previously known as Anthem, Inc., we have evolved into a company focused on whole health and updated our name to better reflect the direction the company is heading.
We are looking for leaders at all levels of the organization who are passionate a