> Markdown version of [/jobs/ext/1989631-data-warehouse-analyst-intermediate](https://www.wearedevelopers.com/jobs/ext/1989631-data-warehouse-analyst-intermediate). 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 (Intermediate) - **Company:** SystemDomain, Inc. - **Location:** Tallahassee, FL, United States - **Experience:** Experienced - **Contract:** Temporary to permanent - **Skills:** Agile Methodology, Data Analysis, Business Process Management, Data Validation, Data Governance, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Profiling, Data Warehousing, Relational Databases, Database Development, Dimensional Modeling, Metadata, Meta-Data Management, Systems Development Life Cycle, Query Optimization, Power BI, Standard Sql, Software Engineering, SQL Server Integration Services, System Integration Testing, Tableau (Software), Freeform SQL, Star Schema, Tools for Reporting - **Published:** August 8, 2026 - **Apply:** https://www.dice.com/job-detail/860efec4-16a7-4aff-b0c8-c9b09c16683a ## About the Role We are seeking an experienced Data Warehouse Analyst (Intermediate) to support enterprise data warehouse and business intelligence initiatives within a large-scale organization. The ideal candidate will possess strong expertise in data analysis, SQL development, ETL processes, data modeling, and reporting solutions. This role involves partnering with business stakeholders and technical teams to translate business requirements into scalable data warehouse solutions while ensuring data quality, accuracy, and performance., * Experience working in enterprise Data Warehouse environments. * Strong SQL development, query optimization, and data analysis skills. * Experience with ETL concepts, data integration, and data transformation. * Knowledge of relational databases and data modeling principles. * Experience supporting reporting and business intelligence solutions. * Strong analytical, troubleshooting, and problem-solving abilities. * Experience gathering and documenting business requirements. * Knowledge of data validation, data quality, and reconciliation processes. * Excellent verbal and written communication skills. * Ability to collaborate effectively with cross-functional technical and business teams., * Experience supporting enterprise data warehouse implementations. * Knowledge of dimensional modeling, including Star and Snowflake schemas. * Experience with ETL tools such as Informatica, SSIS, or similar technologies. * Experience with Power BI, Tableau, or comparable BI/reporting platforms. * Public sector or government project experience is highly preferred. * Familiarity with Agile methodology and Software Development Life Cycle (SDLC). Desired Skills * Data Warehouse * SQL * ETL * Data Modeling * Data Analysis * Business Intelligence * Power BI * Tableau * Informatica * SSIS * Data Quality * Metadata Management * Requirements Gathering * UAT * Agile * SDLC * Reporting * Relational Databases * Documentation * Problem Solving ## Description * Analyze business requirements and translate them into scalable data warehouse solutions. * Gather, document, and validate functional and technical requirements. * Support the design, development, enhancement, and maintenance of enterprise data warehouse solutions. * Perform data profiling, validation, reconciliation, and quality assurance activities. * Develop, optimize, and troubleshoot complex SQL queries for reporting and analytics. * Collaborate with ETL developers, database administrators, data engineers, and business users. * Create and maintain source-to-target mappings, metadata, and technical documentation. * Support data integration, reporting, and business intelligence initiatives. * Identify, troubleshoot, and resolve data quality and performance issues. * Participate in system integration testing, user acceptance testing (UAT), and production support. * Ensure compliance with organizational standards, security policies, and data governance practices. * Document business processes, workflows, and technical specifications. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## 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) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-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)