6 Month CTP
The Lead BI Developer provides expertise in the design, development and support of our data warehouse and the components of the ETL process, with 50% of time spent on data gathering, design and deployment of data models and ETL, 30% on project management from requirements gathering to implementation, and 20% spent on data warehouse administration and architecture. An understanding of ETL using SISS, business intelligence reporting and software, dimensional data models, and project management are required.
ESSENTIAL DUTIES AND RESPONSIBILITIES
The ability to translate business requirements into solid data models for ease of use in BI reporting solutions
Understanding the different levels of reporting needs such as summary, detail, relative time, ad-hoc analytics and hierarchical relationships
Demonstrating iterative data model prototypes to users and guiding them through effective testing to ensure data and model integrity
Resolving technical and/or business problems
The ability to transform relational and unstructured data into dimensional data
Assist with database administration of MS SQL Server 2016
Supporting the development of productive relationships with non-IT staff performing BI-related activities
Supporting user security to the application, as well as, data security
Leading the initiation, vendor relationships, deliverables and training of projects requiring data input/output from the company
Cross train IT and non-IT areas on BI concepts and solutions
Continuous improvement to data design, reports and/or processes
Other duties as assigned by supervisor/manager
All your information will be kept confidential according to EEO guidelines.