Want to know if this job is worth applying to?
Beverly, Massachusetts, United States
Onsite
Join our team and experience how we lead with passion, positivity, and accountability to deliver the Right Talent. Right Now. We create an environment where you can think big, have fun and truly make a difference.
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:
Please contact careers@oxfordcorp.com if you are interested in this position.
Oxford is an Equal Employment Opportunity Employer. All qualified applications will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Oxford will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. Oxford provides holiday pay, paid time off, medical, dental, vision, life and disability benefit plans, flexible spending accounts, health savings accounts, employee tuition reimbursement, student debt assistance and a 401(k) Retirement Savings Plan. Oxford is committed to working with and providing reasonable accommodation to individuals with physical and mental disabilities. If you need special assistance or an accommodation while seeking employment, please email staffbenefits@oxfordcorp.com. We will make a determination on your request for reasonable accommodation on a case-by-case basis.
Know Your Rights | Pay Transparency | Employee Rights Under the National Labor Relations Act