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
- ...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...SuggestedLocal area
- ...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...Suggested3 days per week
- ...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...SuggestedLocal areaWork from homeRelocationFlexible hours3 days per week
- ...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
- ...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
- ...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 placementWork at officeRemote workFlexible hours2 days per week3 days per week
- 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 areaRemote workRelocation3 days per week
- ...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
- ...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
- ...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 workFor contractors
- ...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
- ...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...
- ...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 workFor contractorsWork at officeLocal area
- ...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
$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$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 workFor contractorsWork at officeLocal areaRemote work- ...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
- ...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...
- ...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...
- ...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
- ...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
- ...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 workPart timeFor contractorsLocal area
$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$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...$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 areaRemote work$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 workWork experience placementFlexible hours- ...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 employmentFull time
- ...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...
- ...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 placementWork at office
- ...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...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Warehouse Architect. Be the first to apply!
- data warehouse engineer Richmond, VA
- data warehouse architect Richmond, VA
- data warehouse developer Richmond, VA
- data coordinator Richmond, VA
- master data coordinator Richmond, VA
- minimum data set coordinator Richmond, VA
- data officer Richmond, VA
- data technician Richmond, VA
- test data management Richmond, VA
- data governance Richmond, VA

