Data Warehouse Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

Oxford Global Resources · 1 day ago

Data Warehouse Analyst

Oxford Global Resources is seeking a Data Warehouse Analyst to support and evolve their enterprise data warehouse environment. This role involves daily operational responsibilities to ensure the reliability of the data platform and project initiatives to enhance data models and analytical capabilities.

ConsultingManagement ConsultingTraining
check
H1B Sponsor Likelynote

Responsibilities

Monitor and maintain data warehouse processes to ensure data accuracy, completeness, and availability
Create and optimize T-SQL queries and stored procedures supporting daily data loads and transformations
Identify, troubleshoot, and resolve data issues using structured root cause analysis (RCA)
Proactively detect performance issues and recommend optimizations
Document operational procedures, data flows, and known issues
Design, develop, and enhance data warehouse objects and data models within Azure Synapse
Partner with business and technical stakeholders to translate requirements into scalable data solutions
Contribute to continuous improvement initiatives around data quality, performance, and scalability
Assist with testing, validation, and deployment of data warehouse changes

Qualification

T-SQLAzure Synapse AnalyticsAzure SQL DatabaseAzure Data FactoryPythonPower BIData quality frameworksCommunication skills

Required

Strong experience with T-SQL, including complex queries, performance tuning, and troubleshooting
Experience working with Azure Synapse Analytics or Azure SQL Database with Azure Data Factory
Proven analytical and problem-solving skills, including the ability to perform effective root cause analysis
Ability to manage multiple tasks simultaneously and adapt to shifting priorities
Comfortable working independently while also collaborating in a team environment
Strong communication skills, with the ability to explain technical concepts to non-technical stakeholders

Preferred

Experience with Python for data analysis or automation
Familiarity with Power BI, Power BI Report Builder, or similar reporting tools
Exposure to Microsoft Fabric
Experience supporting BI, analytics, or reporting teams
Background in data quality frameworks or data governance practices

Company

Oxford Global Resources

company-logo
Oxford Global Resources delivers tailored solutions for any technical challenges you are facing using our partnership-first approach.

H1B Sponsorship

Oxford Global Resources has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Kevin McGreevy, CPA
Executive Vice President, Chief Financial Officer
linkedin
leader-logo
George Young
Credentialed Trainer/Consultant/Support for CPOE, ClinDoc, Stork, Beaker, ASAP. Long Term Care, Drag
linkedin
Company data provided by crunchbase