Oxford Global Resources

Data Warehouse Analyst

Oxford Global Resources$70K — $100K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 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

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

Benefits

  • Opportunity to work with cutting-edge technology in Azure Synapse
  • Engage in continuous improvement initiatives
  • Collaborate with diverse cross-functional teams
  • Dynamic environment that encourages problem-solving and innovation
  • Gain exposure to additional tools like Python, Power BI, and Microsoft Fabric
Full Job Description
Position Summary:

We are seeking a Data Warehouse Analyst to support and evolve our enterprise data warehouse environment. This role is split between daily operational responsibilities that ensure the reliability and performance of our data platform, and project-based initiatives focused on enhancing data models, pipelines, and analytical capabilities.

The ideal candidate is highly analytical, comfortable working independently, and able to adapt quickly to changing priorities while collaborating effectively with cross-functional teams.

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


Qualifications :

  • 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


Nice-to-Have Skills :

  • 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


What Success Looks Like in This Role :

  • Reliable, accurate, and well-performing daily data warehouse operations


  • Faster resolution of data issues through clear RCA and documentation


  • Well-designed, scalable data solutions delivered on project timelines


  • Strong partnerships with analytics, reporting, and business teams


For US job seekers:
Salary Information:

$70,000.00-$100,000.00 Annual

Please contact [email protected] if you are interested in this position.

About Oxford Global Resources

Oxford Global Resources is a staffing and recruiting company that provides temporary and permanent staffing solutions to clients in a variety of industries. The company was founded in 1984 and is headquartered in Cambridge, Massachusetts. Oxford Global Resources offers a range of services, including contract staffing, direct hire, and temp-to-perm staffing. The company's clients include some of the world's leading companies in the biotechnology, pharmaceutical, and medical device industries, as well as government agencies and other organizations. Oxford Global Resources is committed to providing high-quality staffing solutions that meet the unique needs of each client.
Learn more about Oxford Global Resources
Size
500 employees
Industry
Founded
1984

Similar Jobs

More Jobs at Oxford Global Resources

  • Oxford Global Resources
    Software Developer
    $110K — $143K *
    Remote
    Information Technology
    Remote in Wayzata, MN
  • Oxford Global Resources
    Electrical Engineer I
    $106K — $137K *
    Shreveport, LA 71106 (Caddo County)
    Manufacturing & Automotive
    In-Person
  • Oxford Global Resources
    Data Scientist
    $106K — $137K *
    Remote
    Information Technology
    Remote in Oregon, US
  • Oxford Global Resources
    Project Manager
    $106K — $137K *
    Lewiston Woodville, NC 27849 (Bertie County)
    Business Services
    In-Person
  • Oxford Global Resources
    .Net Developer
    $85K — $112K *
    Milwaukee, WI 53215 (Milwaukee County)
    Information Technology
    In-Person

More Information Technology Jobs

Find similar Data Warehouse Analyst jobs: