**Business Information Developer Consultant / ETL Developer** **Location:** This position will work a hybrid model (remote and office). The Ideal candidate will live within 50 miles of one of our Elevance Health PulsePoint locations. **Preferred Location:** Chicago, IL. The **Business Information Developer Consultant / 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. + May coordinate 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. + Conducts training on use of applications developed. + Collaborate with business in translating high-level requirements to technical solutions. + Solving complex technical data engineering problems by providing code changes and patch releases. + Identify opportunities to automate and improve development processes. + Owns the change request process and coordinate with other teams as necessary + Maintains active relationships with business and cross team to determine business requirements and leads requirements gathering meetings. + Performs technical design reviews and code reviews. + Lead multiple or large projects and facilitates large group JAD sessions for requirements, modeling in several disciplines. + Understanding of CI/CD tools, data governance and Agile project management skills **Minimum Requirements:** + 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:** + PC, spreadsheet, and database skills strongly preferred. + Experience in standard Business Information tools and programming/query languages strongly preferred. + Minimum of 2 years hands-on experience with Cloud Technologies like AWS, GCP or Azure preferred. + Minimum of 4 years hands-on experience with ETL Tool: DataStage, SSIS or similar technologies preferred. + Strong SQL and analytical skills. 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; hands-on experience working with JSON and tool – RabbitMQ preferred. + Experience working with Sybase and MongoDB preferred. + Experience in production support from Level 1 to Level 3 preferred. + Experience in Health Care Domain preferred.