Warehouse/BI Developer

𝐓𝐢𝐭𝐥𝐞: 𝐃𝐚𝐭𝐚 𝐖𝐚𝐫𝐞𝐡𝐨𝐮𝐬𝐞/𝐁𝐈 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐞𝐫 𝐋𝐨𝐜𝐚𝐭𝐢𝐨𝐧: 𝐑𝐢𝐜𝐡𝐦𝐨𝐧𝐝, 𝐕𝐀 (𝐎𝐧𝐬𝐢𝐭𝐞) 𝐃𝐮𝐫𝐚𝐭𝐢𝐨𝐧: 𝐋𝐨𝐧𝐠 𝐓𝐞𝐫𝐦 𝐉𝐨𝐛 𝐃𝐞𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐨𝐧: A Data Warehouse Developer who can self‑manage, partner with BSAs and PMs, and translate business needs into actionable, analytics‑ready data solutions. This role requires strong data engineering skills in SQL Server, data modeling using Kimball methodologies, and hands‑on 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 self‑directed environment, communicates clearly with both technical and non‑technical partners, and takes pride in delivering clean, well‑modeled, well‑tested data. 𝐊𝐞𝐲 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬: 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. 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐝 / 𝐃𝐞𝐬𝐢𝐫𝐞𝐝 𝐒𝐤𝐢𝐥𝐥𝐬: Data profiling 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐝 Data modeling 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐝 SQL Server data mart development 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐝 SSIS ETL development 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐝 Source Control 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐝 Dashboard/report creation 𝐃𝐞𝐬𝐢𝐫𝐞𝐝