SSIS/SSRS Developer

Lateral Insights•Great Falls, VA

8d•Hybrid

About The Position

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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.