What are the responsibilities and job description for the Data Warehouse Analyst position at Patriot Talent Solutions?
Overview
We’re looking for a Data Warehouse Analyst (Intermediate) to support the design, development, and optimization of cloud-based data platforms in a highly regulated environment.
This role will focus on building scalable data pipelines, improving data quality, and delivering actionable insights through modern cloud and BI technologies.
---
Key Responsibilities
Design, develop, and maintain cloud-based data warehouse solutions
Build and manage data pipelines and integrations using modern ETL/ELT tools
Develop and optimize SQL queries, stored procedures, and database performance
Create and maintain Power BI dashboards, datasets, and reporting solutions
Implement data modeling strategies to support analytics and reporting
Develop API-based and event-driven data integrations
Monitor and optimize system performance using logging and monitoring tools
Participate in CI/CD pipelines for data and application deployments
Document data workflows, architectures, and integration patterns
Collaborate with cross-functional teams to support data standardization and governance
Perform testing, validation, and quality assurance on data pipelines and systems
Provide regular status updates and communicate risks, timelines, and deliverables
---
Required Qualifications
3–5 years of experience with:
Data modeling and cloud data architectures
Performance tuning and data optimization
Hands-on experience with:
Azure Data Factory, Azure Functions, Logic Apps, or similar tools
SQL development (queries, performance tuning, schema design)
3–5 years working with:
Cloud databases (Azure SQL, Cosmos DB, or similar)
2–4 years experience with:
Power BI or similar BI/visualization tools
CI/CD pipelines (Azure DevOps, GitHub Actions, etc.)
Source control systems (Git, GitHub, Azure Repos)
Experience with:
Entity Framework Core and code-first development
Agile / DevOps environments
---
Preferred Qualifications
Experience working in healthcare or regulated environments (HIPAA, PHI/PII)
Familiarity with data governance and compliance frameworks
Experience building microservices or event-driven architectures
DevOps or cloud certification (preferred)
---
Work Environment
Collaborative, cross-functional team environment
Heavy focus on cloud-first data engineering and analytics
Opportunity to contribute to enterprise-scale data modernization initiatives
Equal Opportunity Employer/Veterans/Disabled
Salary : $100,000 - $120,000