> Markdown version of [/jobs/ext/1213009-ssis-ssrs-developer](https://www.wearedevelopers.com/jobs/ext/1213009-ssis-ssrs-developer). 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). --- # SSIS/SSRS Developer - **Company:** LATERAL INSIGHTS, LLC - **Location:** Great Falls, VA, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Agile Methodology, Business Systems, Databases, Data Validation, Data Integration, Extract Transform Load (ETL), Data Mart, Data Profiling, Data Systems, Data Warehousing, Database Development, Software Design Documents, Revision Control Systems, Systems Analysis, Microsoft Visual Studio, Microsoft SQL Server, Power BI, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, Data Streaming, Tableau (Software), Transact-SQL, Enterprise Data Management, Git, Git Flow, Software Version Control - **Published:** July 9, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=fc4adfd00acb0465 ## About the Role * Minimum 5 years of experience in data profiling and source system analysis. * Minimum 5 years of experience in dimensional data modeling and data warehouse design. * Minimum 5 years of hands-on experience developing SQL Server data marts. * Minimum 5 years of experience designing, developing, and maintaining SSIS ETL solutions. * Minimum 3 years of experience using Git or other source control systems. * Strong proficiency with SQL Server, T-SQL, Visual Studio Database Projects, and database deployment methodologies. * Experience translating business requirements into scalable data warehouse solutions. * Excellent analytical, problem-solving, communication, and collaboration skills. * Ability to work independently in a fast-paced, self-managed environment. Preferred Qualifications * Experience creating reports or dashboards using Power BI, Tableau, or similar BI tools. * Experience working in Agile project environments. * Strong understanding of data quality, governance, and best practices for enterprise data warehousing. ## Description We are seeking an experienced Data Warehouse Developer to join our team in Richmond, VA. The ideal candidate is a self-driven professional who can work independently while collaborating effectively with Business Systems Analysts (BSAs), Project Managers, and business stakeholders to translate business requirements into scalable, analytics-ready data solutions. This role requires strong expertise in SQL Server, dimensional data modeling using Kimball methodologies, SSIS ETL development, and SQL Server data mart design. The successful candidate will be responsible for profiling source systems, designing and developing data warehouse solutions, maintaining database projects in Visual Studio, managing source code through Git, and ensuring data quality through rigorous testing. Experience with reporting and dashboard development is considered a plus but is not the primary focus of the role., * Analyze and profile source systems to determine data availability, quality, relationships, and extraction requirements. * Design and develop dimensional data models, including star schemas, using Kimball methodologies. * Create comprehensive data flow mapping and technical design documentation that accurately translates business requirements into technical specifications. * Develop, optimize, and maintain SQL Server data marts, including tables, views, stored procedures, functions, and indexes. * Build and maintain SQL Server Database Projects using Visual Studio to support version-controlled and repeatable deployments. * Develop, deploy, schedule, and monitor SSIS ETL packages to ensure efficient and reliable data integration. * Manage source code, branching strategies, and deployments using Git source control. * Perform comprehensive data validation and testing to ensure data accuracy, completeness, and compliance with business rules. * Collaborate with Business Analysts, Project Managers, and business stakeholders throughout the project lifecycle to deliver high-quality data solutions. * Troubleshoot and resolve data quality and ETL issues while continuously improving performance and reliability. * Create basic reports and dashboards using tools such as Power BI or Tableau, when required. ## Related Videos - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Why Git Still Matters](https://www.wearedevelopers.com/videos/100288-why-git-still-matters) - [Applying DevOps in Flutter mobile development](https://www.wearedevelopers.com/videos/60-applying-devops-in-flutter-mobile-development) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Dev Digest 159: AI Pipelines, 10x Faster TypeScript, How to Interview](https://www.wearedevelopers.com/magazine/563-dev-digest-159-ai-pipelines-10x-faster-typescript-how-to-interview) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)