Data Warehouse/Business Intelligence Architect (Tallahassee, FL)

Cedent

Tallahassee (FL)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

A technology consulting firm based in Tallahassee, Florida, is seeking a Data Warehouse/Business Intelligence Architect for a contract position. The candidate should have at least seven years of experience in data warehouse implementation, database design, and administration. Responsibilities include supporting the Florida PALM Project, providing expertise in data modeling, and ensuring efficient data governance practices. Ideal for individuals skilled in Oracle business intelligence tools and ETL processes, this role offers a chance to significantly impact the project's success.

Qualifications

  • Minimum of seven years’ experience in Data Warehouse implementation and database administration.
  • Expertise in data modeling (logical and semantic) and metadata management.
  • Strong background in data warehouse fundamentals including OLAP and ETL processes.

Responsibilities

  • Support Florida PALM Project implementation and production support.
  • Provide solution recommendations as a Data Warehouse expert.
  • Conduct gap analysis and mapping of legacy data.

Skills

Data modeling
SQL
Informatica
ETL processes
Oracle Business Intelligence tools

Tools

Oracle Analytical Server
Oracle Business Intelligence
Oracle Data Integrator

Job description

Data Warehouse/Business Intelligence Architect (Tallahassee, FL)

Minimum of seven (7) years’ experience performing activities directly related to a Data Warehouse implementation, database design and database administration (DBA). Experience includes implementing or maintaining Oracle data warehouse and business intelligence tools such as the following examples:

  • Oracle Analytical Server (OAS)
  • Oracle Business Intelligence (OBI)
  • Oracle Business Intelligence Application (OBIA)
  • Oracle Business Intelligence Enterprise Edition (OBIEE)
  • Oracle Data Integrator (ODI)
  • Oracle Autonomous Data Warehouse (ADW)

Minimum of seven (7) years’ experience performing activities directly related to data modeling (logical and semantic) and metadata management

Experience with data warehouse fundamentals such as SQL, OLAP (Online Analytical Processing), star and snowflake schemas, ETL (Extract, Transform, Load) processes, Informatica, Tidal, and Business Intelligence Application Configuration Manager (BIACM).

Responsibilities:
  • Work with Project team members to support all activities related to the Florida PALM Project implementation efforts and Production Support activities.
  • Use and share lessons learned and best practices associated with Data Warehouse and Business Intelligence implementations that may promote efficiency and help to identify and mitigate potential risks.
  • Serve as a Data Warehouse and/or Business Intelligence subject matter expert, providing solution recommendations and helping to resolve complex challenges.
Assist the State with its responsibilities as described below:
  • Conducting an analysis of the Data Warehouse and underlying data model and related security configurations, to identify and evaluate gaps in meeting reporting need, and make recommendations to address gaps.
  • Conducting a gap analysis to identify where data in PeopleSoft, is not available in the Data Warehouse for reporting.
  • Conducting and/or creating a mapping of legacy data to Florida PALM data to support end-user reporting.
  • Assisting with the data architecture (D&A Architecture) approach.
  • Assisting with data modeling.
  • Assisting with development standards and implementing the data governance model.
  • Assisting with testing and validating the Data Warehouse and Business Intelligence solutions are working correctly, contain the correct data, and are being properly and timely refreshed.
  • Assisting with cutover planning and execution.
  • Assisting with role and data security setup, recommendations, and overall user access management. Provide overall Project support, which includes:
  • Providing updates to Project status reporting;
  • Coordinating with the Project Directors and Architects to develop and update templates for Project use;
  • Facilitating meetings, promoting teamwork, and providing training as requested;
  • Tracking, mitigating, and escalating risks and issues;
  • Maintaining tools for the Project team’s use;
  • Researching, collecting, evaluating, and refining the data and tools necessary to meet Project goals.
  • Complete transition services, including facilitating lessons‑learned meetings; creating a lessons‑learned document related to Data Warehouse and/or Business Intelligence support services; and providing all the documents, software, software licenses, and other Project artifacts to the Project team as it relates to the work performed under the PO.

Department: Preferred Vendors
This is a contract position

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Warehouse & BI Architect
Senior Data Warehouse & BI Architect

Cedent • Tallahassee (FL)

On-site
USD 90,000 - 120,000
Data Architect
Data Architect

Tech Army, LLC • Tallahassee (FL)

Hybrid
USD 110,000 - 160,000
Senior Data Architect Job ID: 413192
Senior Data Architect Job ID: 413192

Mega Cloud Lab • Tallahassee (FL)

On-site
USD 120,000 - 180,000
Database Analyst - Data Warehousing, SQL & Tableau Expert
Database Analyst - Data Warehousing, SQL & Tableau Expert

AHU Technologies Inc. • United States

Remote
USD 70,000 - 90,000
Senior Data Architect
Senior Data Architect

Mega Cloud Lab • Tallahassee (FL)

On-site
USD 120,000 - 160,000
Database Analyst- Tallahassee, FL
Database Analyst- Tallahassee, FL

AHU Technologies Inc. • United States

On-site
USD 70,000 - 90,000
Database Analyst #3410
Database Analyst #3410

Genius Road, LLC • Orlando (FL)

On-site
USD 80,000 - 105,000
Senior Database Analyst
Senior Database Analyst

Vista Applied Solutions Group Inc • Tallahassee (FL)

On-site
USD 60,000 - 100,000
W2 Only- Need only Local to Florida- Snowflake Informatica ETL Data Architect
W2 Only- Need only Local to Florida- Snowflake Informatica ETL Data Architect

American Unit, Inc • Tallahassee (FL)

On-site
USD 120,000 - 140,000
Oracle BI Apps/OBIA Specialist
Oracle BI Apps/OBIA Specialist

Cogent Infotech Corporation • Clearwater (FL)

On-site
USD 80,000 - 100,000