Data Warehouse/BI Developer
Intellibee Inc · Richmond, VA · 2 wk ago
Information TechnologyFull-time
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 (nice-to-have) - Build basic dashboards or visualizations using tools such as Power BI or Tableau.
Skills
- 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
Benefits
Benefits at IntelliBee include Long-Term Stability, Comprehensive Health Coverage, Future Planning, and GC Assistance.