BI Data Warehouse Developer with SQL Server Database, SSIS, SSRS, SSAS, ETL
- VT-12, White River Junction, VT 05001, USA
This is a direct-client opening for a BI/DW Developer located in White River Junction, Vermont. This is a full-time position with a salary range that depends on experience. Relocation assistance will be provided to non-local candidates.
As a BI/DW Developer, you will be responsible for developing high quality extraction/transformation/load (ETL) programs, creating logical and physical data models, data flow diagrams, entity relationship diagrams and building business intelligence reports using SQL Server, SQL Server Integration Services (SSIS), Report Services (SSRS) and Analysis Services (SSAS).
ESSENTIAL JOB FUNCTIONS
Design, develop, test, implement and manage complex ETL processes sourcing data from a variety of internal and external systems supporting Manufacturing, Distribution, Retail, Café, 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 and 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 and external customers, vendors and peers
Works collaboratively with key business users to understand their information needs and provide high quality, high performing and intuitive data solutions
Self-motivated, able to work independently and collaboratively with IS peers and managed service providers to identify, understand and analyze complex data in a variety of 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
Participation in rotating off-hours, on-call duties is required
Bachelor’s degree in Computer Science, Information Technology, Engineering or related field is required
At least 5 years of experience using Microsoft SQL Server Database, SSIS, SSRS, SSAS is required
Experience with other relational databases, BI reporting and data discovery tools is highly desirable
Please complete the below skills-matrix and send back with your most recent resume:
Total Experience as a BI or DW Developer:
Total Experience with ETL:
Total Experience with Data Modeling:
Total Experience with Data Warehousing:
Total Experience with Microsoft SQL Server Databases:
Total Experience with SSIS:
Total Experience with SSAS:
Total Experience with SSRS:
Currently Salary/Hourly Rate:
Expected Full-time Salary:
What is the link to your Linkedin Profile?
What is the best phone number to reach you at?
Work Status (US Citizen, Green Card, etc.)
Are you ready to relocate for this position / Commute?
All your information will be kept confidential according to EEO guidelines.