Lucas Group is looking for a Data Warehouse Developer for our client in Southwest Florida.
Requirements:
Demonstrated expertise using Microsoft SQL Server Stack, particularly MS SQL Server 2008, 2012, 2016 +, SSIS (SSRS and SSAS a plus)
Strong Data warehousing proficiency with star schema and dimensional modeling (but not limited to)
Demonstrated ability to implement dimensional data models, star schemas, across multiple data marts/subject areas.
Demonstrated knowledge of formal data flow analysis methodologies and ability to design data warehouse data models using the Kimball Data Modeling methodology, or similar.
Demonstrated ability to design data structures to maximize efficiency and flexibility, including ability to develop and maintain Extract, Transform, and Load (ETL) code to load a data warehouse repository, including code to handle incremental data loads and slowly change dimensions.
Experience with T-SQL to create, troubleshoot large complex stored procedures/triggers
Experience with OLAP reporting tools and cube technologies
Experience with extracting data out of SAP is a plus.
Self-driven and motivated to succeed
Strong attention to detail and sense of urgency required.
Strong ability to manage time and prioritize workload.
Strong analytical & business acumen preferred, specifically in Sales, Finance and Accounting, Inventory
Focuses on quality of work, over quantity.
Knowledge and experience in Agile development methodology a plus.
Education
Bachelor’s Degree in a technical area of study; preferably in Computer Science, MIS or Analytics required. Advanced Degree preferred.
Minimum of 5 years’ experience in implementing and maintaining Database and Data Warehouse solutions end-to-end using MS SQL platforms required.
Add’l Microsoft Stack, SAP, Cognos, TM1 and/or Power BI experience and/or certifications are a plus.
