Role:Data Warehouse/Business Intelligence Developer Location:White River Junction, VT Job description As a BI/DW Developer, you will be responsible for developing logical and physical data models (LDMs/PDMs), data flow diagrams (DFDs), entity relationship diagrams (ERDs), high performing extraction/transformation/load (ETL) programs and business intelligence reports using SQL Server, SQL Server Integration Services (SSIS), Report Services (SSRS) and Analysis Services (SSAS). ESSENTIAL JOB FUNCTION Design, develop, test, implement and manage complex ETL processes sourcing data from a variety of internal and external systems supporting Manufacturing, Distribution, Retail, Cafe, E-commerce, Sales, Marketing, Finance and Human Resources Expert knowledge in database and report performance engineering, diagnosing and tuning of ETL programs and reports Expert understanding of data warehouse concepts such as star schemas, snow flake schemas, operational data stores, data warehouses and data marts Design, develop, maintain and publish logical/physical data models, entity relationship diagrams and a common data dictionary Design, document, maintain and publish data flow diagrams depicting source to target mappings supporting a tiered data architecture comprised of source systems, an operational data store (ODS), data warehouse (DW) and data marts (DM). Track record of building and maintaining solid relationships with internal/external customers, vendors and peers Works collaboratively with key business users to understand their information needs in order to provide high quality, high performing and intuitive data solutions Required Skills Self-motivated, able to work independently and collaboratively with IS peers and managed service providers to identify, understand and analyze complex data in various source systems such as: ERP, WMS, CRM, E-Com, HRMS, etc. Strong organization and prioritization skills. Comfortable creating high level plans, setting dates, making commitments and delivering high quality results on time Comfortable assisting in the design and development of reports, charts and graphs Comfortable operating as a subject matter expert, leader and mentor to improve the knowledge, skills and capabilities of DW/BI throughout the company Participates in the evaluation of new business intelligence technologies such as data modeling, ETL, appliances, reporting tools and portal solutions EDUCATION/EXPERIENCE Bachelors Degree in Technology related discipline preferred 4-6 years experience with MS SQL Server, SSIS, SSRS, SSAS required 7-10 years\' overall experience in IT preferred Experience with other relational databases, BI reporting and data discovery tools is required
Key Skills: