> Markdown version of [/jobs/ext/2012439-data-warehouse-analyst-ii](https://www.wearedevelopers.com/jobs/ext/2012439-data-warehouse-analyst-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Warehouse Analyst II

- **Company:** BEACON TECHNOLOGIES INC
- **Location:** United States (Remote available)
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Profiling, Databases, Data Architecture, Data Cleansing, Data Profiling, Data Retrieval, Relational Databases, Database Design, Python (Programming Language), Metadata, Oracle Databases, Oracle SQL Developer, Oracle Warehouse Builder, SQL Databases, Information Technology, Data Management
- **Published:** August 10, 2026
- **Apply:** https://www.beacontechinc.com/careers/data-warehouse-analyst-ii/

## About the Role

* Experience in metadata discovery and documentation
 * Experience in data profiling
 * Experience in data quality assessment and identification
 * Advanced experience in SQL and Python, * Python , 3 years
 * Database design concepts, 5+ years
 * Excellent organization, analytical, and communication skills, 5 years
 * Creating and reviewing SQL scripting, 5 years
 * Knowledge of Oracle PL/SQL, 5 years
 * Metadata tools, 5 years
 * Oracle 11g/DB2/SQL Server, 5 years
 * Oracle data dictionary views, 4 years
 * Metadata documentation experience, 5 years
 * Data quality assessment and profiling, 5 years

## Description

Beacon Technologies is seeking a Data Warehouse Analyst II for our client partner. This role will provide support for data warehousing initiatives and monitor data warehousing system to ensure reliability and accuracy of information loaded into the databases. Analyze the logical and physical database models and ensure models are in accordance with standards. Generate and prepare reports to support business objectives. Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues. Career-Development position within field. Requires moderate skill sets and developing proficiency within discipline. Conducts tasks and assignments as directed., * This position will be responsible for the assessment of data quality and metadata within data architecture; they will be responsible for the data profiling, analysis and documentation of data quality

 * Audit existing databases to assess data characteristics such as completeness, accuracy, outliers, and duplicates
 * Investigate and define automated validation rules to guarantee data accuracy and catch errors at the point of entry
 * Develop data cleansing and remediation recommendations for data irregularities
 * Establish key performance indicators (KPIs) to measure data health, and build reporting dashboards to track quality metrics and trends
 * Investigate the origins of recurring data errors (e.g., system bugs, user errors, integration issues) and recommend targeted, systemic solutions
 * Document and define key metadata around database architecture
 * Make recommendations on data maintenance and data quality
 * Collaborate with Data Modelers and Data Architects on recommendations for key data management and data quality efforts


## Related Videos

- [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata)
- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [Profiling Symfony & PHP apps with Blackfire](https://www.wearedevelopers.com/videos/265-profiling-symfony-php-apps-with-blackfire)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)