Business Information Developer Consulant

Elevance Health•Norfolk, VA

2d•Hybrid

About The Position

The Business Information Developer Consultant is responsible for developing and executing more complex data mining analyses. This role determines how decision support systems will provide the data required to make effective business decisions. It involves performing modeling of information sources and flows, coordinating project team activities, and monitoring project schedules and costs. The consultant develops strategic report applications from the Data Warehouse and establishes and maintains excellent knowledge of data warehouse database design, data definitions, system capabilities, programming languages, and data integrity issues. They develop and support complex data warehouse-related applications for business areas requiring design and implementation of database tables, and develop and execute complex data mining and analytical solutions to support business needs. Additionally, the role involves creating, maintaining, and optimizing SQL queries, stored procedures, and data extraction processes, developing strategic and operational reports using SSRS, building interactive dashboards and visualizations using Tableau and Power BI, and supporting reporting and analytics initiatives using Google Looker or similar BI tools. The consultant analyzes and models information sources, data flows, and reporting requirements, develops and supports data warehouse-related applications, including database table design and implementation, and maintains strong knowledge of data warehouse design, data definitions, system capabilities, and data integrity standards. They participate in project planning activities, help monitor schedules and deliverables, and provide end-user training and ongoing support for developed applications and reports. Collaboration with business and technical teams to deliver scalable reporting and analytics solutions is key, with the majority of time spent designing, developing, testing, and supporting reporting and data solutions.

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

PC, spreadsheet, and database skills highly preferred.
Experience in standard Business Information tools and programming/query languages highly preferred.
Minimum of 4 years of related experience in data warehouse development, reporting, or business intelligence highly preferred.
Strong experience with: SQL development and complex query writing, SSIS or other ETL/data integration tools, SRS report development, and Tableau dashboard creation highly preferred.
Understanding of relational databases, data warehouse concepts, and data modeling techniques highly preferred.
Experience with standard business intelligence and reporting tools highly preferred.
Strong analytical, problem-solving, and communication skills preferred.
Ability to work independently and collaboratively within a team environment preferred.

Responsibilities

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.
Develops and executes complex data mining and analytical solutions to support business needs.
Creates, maintains, and optimizes SQL queries, stored procedures, and data extraction processes.
Develops strategic and operational reports using SSRS.
Builds interactive dashboards and visualizations using Tableau and Power BI.
Supports reporting and analytics initiatives using Google Looker or similar BI tools.
Analyzes and models information sources, data flows, and reporting requirements.
Develops and supports data warehouse-related applications, including database table design and implementation.
Maintains strong knowledge of data warehouse design, data definitions, system capabilities, and data integrity standards.
Participates in project planning activities and helps monitor schedules and deliverables for assigned projects.
Provides end-user training and ongoing support for developed applications and reports.
Collaborates with business and technical teams to deliver scalable reporting and analytics solutions.
Spends the majority of time designing, developing, testing, and supporting reporting and data solutions.