Business Information Developer Consultant

Elevance Health•New York, NY

3d•Hybrid

About The Position

Business Information Developer Consultant Location: This role requires associates to be in-office 1 day 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. Ideal candidates will be able to report to our Pulse Point location in New York, NY. Please note that per our policy on hybrid/virtual work, candidates not within a reasonable commuting distance from the posting locations will not be considered for employment, unless an accommodation is granted as required by law. The Business Information Developer Consultant is responsible for developing and executing complex data analysis and delivering data-based products. How you will make an impact: Determine how decision support systems will provide the data required to make effective business decisions. Perform modeling of information sources and flows. Coordinate the activities of a project team and monitors project schedules and delivery dates for own projects. Establish connectivity to operations source systems and data repositories. Conduct data discovery work to understand strengths, limitations, and opportunities within the currently available data. Develop strategic report applications from the data warehouse, using structured query language (SQL) to extract relevant sets of data. Establish and maintain excellent knowledge of data warehouse database design, data definitions, system capabilities, programming languages, and data integrity issues. Develop and support complex data warehouse-related applications for business areas requiring design and implementation of database tables (the majority of time will be spent programming). Work with a diverse set of business partners in Pharma, Trade, IT, Operations, etc. to understand their needs and craft data-oriented solutions. Help with performance-tuning of existing SQL queries to ensure completion of business-essential processes in accordance with established partner service-level-agreements. Conduct training on use of applications developed.

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.

Nice To Haves

Expertise in Microsoft SQL Server, Postgres, Amazon RedShift, Snowflake, Oracle, or equivalent database software highly preferred.
Familiarity with ETL coding via Microsoft SSIS, Python routines, Informatica, or Talend preferred highly preferred.
Experience presenting technical subject matters to non-technical audiences highly preferred.
Experience in navigating new data models (both documented and undocumented) highly preferred.
Ability to learn new subject matter and document effectively for broader team knowledge/use highly preferred.
Professionalism, positivity, and being solution-oriented in communications and collaborations inside and outside of the team highly preferred.
Ability to toggle effectively between several concurrent projects preferred.
Proficiency in presenting team’s work in various forums preferred.
Ability to train and mentor junior team members in advanced SQL query-writing and team standard operating procedures preferred.
Background in operations (pharmacy, drug manufacture, contact center, manufacturing, etc.) preferred.

Responsibilities

Determine how decision support systems will provide the data required to make effective business decisions.
Perform modeling of information sources and flows.
Coordinate the activities of a project team and monitors project schedules and delivery dates for own projects.
Establish connectivity to operations source systems and data repositories.
Conduct data discovery work to understand strengths, limitations, and opportunities within the currently available data.
Develop strategic report applications from the data warehouse, using structured query language (SQL) to extract relevant sets of data.
Establish and maintain excellent knowledge of data warehouse database design, data definitions, system capabilities, programming languages, and data integrity issues.
Develop and support complex data warehouse-related applications for business areas requiring design and implementation of database tables (the majority of time will be spent programming).
Work with a diverse set of business partners in Pharma, Trade, IT, Operations, etc. to understand their needs and craft data-oriented solutions.
Help with performance-tuning of existing SQL queries to ensure completion of business-essential processes in accordance with established partner service-level-agreements.
Conduct training on use of applications developed.