Hi,
Greetings from DIA SOFTWARE SOLUTIONS LLC!
We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?
Direct client Req:: Need Sr Data Warehouse/BI Developer ,Onsite, VA
PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !
Job Description:
A Data Warehouse Developer who can selfmanage, partner with BSAs and PMs, and translate business needs into actionable, analyticsready data solutions. This role requires strong data engineering skills in SQL Server, data modeling using Kimball methodologies, and handson development of data marts, SSIS ETL pipelines, and data flow design documentation. The developer must be able to deep-dive profile source systems, design and implement database projects in Visual Studio, manage code in GIT, and validate data accuracy through testing. Experience building dashboards is helpful but secondary.
This role is ideal for someone who thrives in a selfdirected environment, communicates clearly with both technical and nontechnical partners, and takes pride in delivering clean, wellmodeled, welltested data.
Key Responsibilities:
- Data profiling Analyze and understand source systems to determine data availability, quality, and extraction logic.
- Data modeling Design dimensional models and star schemas to support analytics and reporting needs.
- Data flow design Produce clear, detailed mapping documents that translate business rules into technical specifications.
- SQL Server data mart development Build and optimize tables, views, stored procedures, and indexes.
- Visual Studio database projects Create and maintain database projects for versioned, repeatable deployments.
- GIT source control Manage code changes, branching, and collaboration workflows.
- SSIS ETL development Build, schedule, and monitor ETL packages to load data marts reliably and efficiently.
- Data validation testing Ensure accuracy, completeness, and alignment with business rules.
- Dashboard/report creation (nicetohave) Build basic dashboards or visualizations using tools such as Power BI or Tableau.
SKILLS MATRIX
Skill | Required | Amount of Experience | Experience |
Data profiling | Required | 5 Years | |
Data modeling | Required | 5 Years | |
SQL Server data mart development | Required | 5 Years | |
SSIS ETL development | Required | 5 Years | |
Source Control | Required | 3 Years | |
Dashboard/report creation | Desired | 3 Years | |
DIA SOFTWARE SOLUTIONS LLC.
VENKATESH| DIA SOFTWARE SOLUTIONS LLC.
Direct: Plus One Eight Zero Four Three Six Five Six Nine Three Four
DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Dia soft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer
Never miss an opportunity! Create an alert based on the job you applied for.