Business Information Developer Consultant

Elevance Health•Norfolk, VA

5d•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, performs modeling of information sources and flows, and coordinates the activities of a project team, monitoring project schedules and costs for own projects. The consultant 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. 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. The role involves creating, maintaining, and optimizing SQL queries, stored procedures, and data extraction processes, designing and supporting ETL workflows using SSIS or comparable ETL/data integration tools, and developing strategic and operational reports using SSRS. Additionally, the consultant 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, and develops and supports data warehouse-related applications, including database table design and implementation. They maintain strong knowledge of data warehouse design, data definitions, system capabilities, and data integrity standards, participate in project planning activities, and help monitor schedules and deliverables for assigned projects. Finally, the consultant provides end-user training and ongoing support for developed applications and reports, and collaborates with business and technical teams to deliver scalable reporting and analytics solutions, spending the majority of time 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.
Designs and supports ETL workflows using SSIS or comparable ETL/data integration tools.
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.