Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Warehouse Architect

Arete Technologies Inc

Data Warehouse Architect

Support for development and maintenance of Oracle Data Warehouse to support OBIEE and BIP reporting tools for ABC

The applicant is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in Data Warehouse and BI development and implementations. The applicant will be involved in gathering of business requirements and creating technical designs.

It involves designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems. The data warehouse developer's role in an organization includes providing support to the organization's business requirements in the application and consumption of information from the Data Warehouse.

The applicant will be part of the team to review, analyze, modify, and create ETLs, testing, debugging, integration and implementation processes. Task will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

This position involves the delivering of huge data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how.

Data Warehouse Developer Role:

Experienced SQL and PL/SQL developer on Oracle database platform.

Deep understanding of data warehouse and star schema

Develop ETL scripts and write PL/SQL code from data model, dataflow diagram and technical design specifications

Ability to work on wide variety of development needs from simple queries to complex queries and multidimensional analysis

Ability to follow best coding standards practices

Expert in performance tuning of ETL/SQL code

Analyze and provide resolutions for production data issues

Familiar with Unix shell scripting and job automation

Build and implement BI dashboards, analysis using OBIEE

Build reports using BI publisher

local considered first

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Data Warehouse Architect in Richmond, VA vacancy
  •  ...Data Warehouse Architect We are from US IT Solutions, an ISO Certified, E-Verify, WMBE Certified organization established in 2005 in CA. Our company is serving various State, Local and County Departments for over 10 years. USITSOL has been helping clients innovate... 
    Suggested
    Local area

    Tech Marketing

    Richmond, VA
    1 day ago
  •  ...Responsibilities: Create and modify Workday inbound and outbound interfaces Required Skills: Experience with Sql Server (SSIS) and Azure Data Factory pipelines Preferred Skills: Extensive experience with Workday Studio and XSLT Additional Responsibilities: Creating... 
    Suggested
    3 days per week

    Argyle Infotech

    Richmond, VA
    1 day ago
  •  ...Data Warehouse Architect Location: Chesterfield, VA, Hybrid Rate: Best competitive rate Local Richmond area candidates or those willing to relocate to the Richmond area during this engagement due to onsite work requirement. ONSITE interviews only. Candidates... 
    Suggested
    Local area
    Work from home
    Relocation
    Flexible hours
    3 days per week

    InterSources

    Richmond, VA
    1 day ago
  •  ...interfaces between Workday and other systems. To manage these interfaces the candidate will need experience with Sql Server (SSIS), Azure Data Factory pipelines, and should be experienced, or familiar, with Workday Studio or Eclipse. Work may be executed in cloud or on... 
    Suggested

    Sparktek

    Richmond, VA
    4 days ago
  •  ...Data Warehouse Architect Client is seeking a skilled professional to provide expertise in many areas of data management including but not limited to data warehouse reporting, data analysis, data integration, and data warehousing. Provide these services in support of... 
    Suggested

    vTech Solution

    Richmond, VA
    1 day ago
  •  ...Data Warehouse Engineer Seeking a Data Warehouse Engineer that can develop dimensional model on Delta Data Lake with code written in Python or PySQL running on Apache Spark Server in Azure Synapse Environment, which can scale to process millions to billions of transactional... 
    Work experience placement
    Work at office
    Remote work
    Flexible hours
    2 days per week
    3 days per week

    Software Technology Inc

    Richmond, VA
    1 day ago
  • Broughton Group is seeking a Data Warehouse Architect located in Chesterfield, VA. The role requires a candidate experienced in Azure Data Factory and SSIS development. The ideal candidate should be self-motivated and possess excellent communication skills. The role mandates... 
    Local area
    Remote work
    Relocation
    3 days per week

    Broughton Group

    Richmond, VA
    22 hours ago
  •  ...Job Title: Data Warehouse/BI Developer Duration: 6 Months Location: Richmond, VA Interview Type: Web Cam Interview Only Work Arrangement: Hybrid Note: ~ This is a Hybrid role . Local candidates are strongly advised . Job... 
    Local area

    Apollo ITS

    Richmond, VA
    3 days ago
  •  ...Overview: Role: Data Warehouse/ BI Developer Location: Richmond, VA (This is a Hybrid role. Local candidates are strongly advised.) Duration: 6+ Months Work Authorization: Green Card & US Citizen Required Skills 5+ years of experience in SQL database... 
    Local area

    Alliance Global Tech

    Richmond, VA
    2 days ago
  •  ...Seeking a Data Warehouse/BI Developer 3 for an onsite contract role with the Commonwealth of Virginia in North Chesterfield, VA. We are seeking a highly skilled Senior BI Specialist to design, develop, and maintain advanced business intelligence solutions... 
    Contract work
    For contractors

    VTal Technology Solutions

    Richmond, VA
    1 day ago
  •  ...career destination for tech experts at every stage of their careers. Our client, Tri-Force Consulting Services Inc, is seeking a Data Warehouse/BI Developer. Apply via Dice today! Title: Data Warehouse/BI Developer Duration: 6 Months Client: The Department of Commerce... 
    Full time

    Jobs via Dice

    Richmond, VA
    2 days ago
  •  ...Job Title: Database Architect 4 Location: Richmond, VA (Hybrid- Onsite Tue, Wed & Thurs) Duration: 12+ months (Possible Extension...  ...** Investment Decision Support (IDS) team are the primary data stewards for the Investments Department. IDS connects data to investment... 

    Integrated Resources

    Richmond, VA
    2 days ago
  •  ...Enterprise Data Modeler Location: Richmond, VA (Hybrid - ONSITE 2-3 days/wk.) Local Richmond, VA candidates required Candidate...  ...existing systems and working with a business and data architect to create conceptual data models, data flows. Develop best practices... 
    Contract work
    For contractors
    Work at office
    Local area

    My3Tech Inc

    Richmond, VA
    4 days ago
  •  ...Role: Business Data Management Architect Location: Richmond, VA Duration: 7+ months (extendable) Interview: In Person Only Hybrid Schedule - Long-Term position requires 3 days a week Job Description: The VDOT Program Manager - Business Data Management... 
    3 days per week

    Apollo ITS

    Richmond, VA
    3 days ago
  • $3,600 per month

     ...Are you an experienced data leader ready to architect the future of enterprise-scale data platforms? Join Kinsale Insurance, a leading excess and...  ...evolution of enterprise data architecture across cloud data warehouses and transactional database platforms, ensuring... 
    Immediate start

    Kinsale Insurance Company

    Richmond, VA
    1 day ago
  • $142k

     ...Company : enGen Job Description : JOB SUMMARY We are seeking a hands-on Principal Data Architect to serve as a leader in our ongoing data and digital transformation, leveraging a modern open data ecosystem build on foundational iceberg lakehouse patterns for... 
    Temporary work
    For contractors
    Work at office
    Local area
    Remote work

    Highmark Health

    Richmond, VA
    5 days ago
  •  ...experience in architecture, design or development of enterprise data solutions, applications, and integrations ~ Experience...  ...modern enterprise data architectures and data toolsets (ex: data warehouse, data marts, data lake, modeling tools, profiling tools) ~ Strong... 
    Work from home

    Apex Informatics

    Richmond, VA
    22 hours ago
  •  ...Data Architect The Virginia Department of Transportation's Information Technology Division is seeking a team member to function as a...  ...position will also assist in extending the scope of enterprise data warehouse and the analytics program. Responsibilities: Create... 

    My3Tech Inc

    Richmond, VA
    1 day ago
  •  ...Overview: Role: Data Architect Location: Onsite - Richmond, Virginia, United States Job Summary : The Enterprise Data Architect is responsible for defining and evolving a modern, Databricks-centric data and AI architecture supporting customer, consumer... 

    Purple Drive

    Richmond, VA
    4 days ago
  •  ...Data Architect This position requires experience in data strategy, data and analytics governance, data modeling, data architecture, data...  ...Meta Data Management (MDM), business intelligence, and data warehouse design and implementation techniques. • Experience with... 
    Contract work

    Orbis Corporation

    Richmond, VA
    9 days ago
  •  ...Data Modeler Location: Quantico, Virginia, Job Code: 3097 Job Description: •...  ...integrity. • Collaboration with Data Architects, database administrators, and developers...  ...(MDM), business intelligence, and data warehouse design and implementation techniques.... 
    Contract work

    Orbis Corporation

    Richmond, VA
    2 days ago
  •  ...Enterprise Data Modeler Position is based in Richmond, VA and requires local candidates. The candidate will be required to interview and work onsite part-time, with the possibility of contract extension beyond June 30, 2025. The contractor will be responsible for their... 
    Contract work
    Part time
    For contractors
    Local area

    Argyle Infotech

    Richmond, VA
    1 day ago
  • $165k

     ...We are seeking a highly experienced Data Architect with deep healthcare and Medicaid domain expertise to design, modernize, and govern our...  ...Responsibilities: Establish and maintain enterprise data warehouse (EDW) architecture environments and data ingestion/integration... 
    Remote work

    MAXIMUS

    Richmond, VA
    3 days ago
  • $60 - $68 per hour

     ...Lead technical architecture strategy across enterprise data platform initiatives Define and enforce ETL/ELT architecture...  ...Job Description: Insight Global is seeking an IT Architect - Data & Snowflake for a leading enterprise analytics initiative... 

    Insight Global

    Richmond, VA
    2 days ago
  • $156.64k

     ...Maximus is currently seeking an IT Principal Data Architect. The IT Principal Data Architect - (Data Migration) is a senior technical leader...  ...architectures including modern applications, data lakes, warehouses, lakehouse patterns, and real-time/streaming integrations.... 
    Local area
    Remote work

    MAXIMUS

    Richmond, VA
    3 days ago
  • $97.5k - $199.5k

     ...insights via dynamic visualizations, and enabling collaborative, data-driven improvement projects across the enterprise....  ...Federal Security Clearance. Responsibilities As a Senior Data Architect on the Oracle Health Advance research and development team, you... 
    Temporary work
    Work experience placement
    Flexible hours

    Oracle Defunct

    Richmond, VA
    22 hours ago
  •  ...Data Architect (Permanent /Full Time) Tech Tammina LLC Job Description Relevant Experience (Yrs): 8+ years Technical/Functional...  ...a Data modeler in modeling for Operational Data Stores, Data Warehouses and Data Marts. Strong understanding of DW concepts... 
    Permanent employment
    Full time

    Tech Tammina

    Richmond, VA
    1 day ago
  •  ...Data Architect Dominion Energy is seeking an experienced Data Architect to help design and evolve an enterprise level data platform that supports current business needs and future solutions. The platform already exists, but this role will focus on architecting enhancements... 

    Saxon Global

    Richmond, VA
    3 days ago
  •  ...specifically, ideally from an organization on Epic Cloud Data Architect Responsible for providing technical leadership in...  ...instrumental in enhancing and supporting our Enterprise Cloud Data Warehouse currently on Snowflake . Major Responsibilities:... 
    Work experience placement
    Work at office

    Intellisoft Technologies

    Glen Allen, VA
    2 days ago
  •  ...Oracle 12c or greater is required. ~5+ years serving in a data architecture position is required. ~5+ years experience building...  .... Azure Data Factory experience is required. ~ Ability to architect and model mission critical RDMS, BI, OLTP, OLAP and solutions... 

    InterSources

    Richmond, VA
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse Architect. Be the first to apply!