Job Description:

Role: Senior DW/BI Developer 

Location: Houston, TX

Job type: Fulltime



Responsibilities:

•         Oversees the client data warehouse environment (EDW) and tools (Microsoft BI Stack, Tableau, GenReports, Power BI) to support monthly and self-servicing reporting for existing customers as well as internal data analysis. 

•    The Senior DW Developer  of BI is responsible for ensuring data integrity and report consistency across all data warehouse reporting. 

•         Additionally, the position ensures frequency specific reporting is completed and distributed to our internal decision makers as well as external customers on time. 

•         Manage and Provide leadership and direction for  the Business Intelligence team which may include multiple functional areas including but not limited to the DW platform & reporting

•         Responsible for gathering business requirements, analyzing business needs, defining the BI/DW architecture to meet & support and participate in the delivery of technical solutions to complex business and technical requirements

•         Responsible for leading the design, Architect and maintenance of the Data Warehouse and Business Intelligence platform and tools.

•         Design a BI framework based on the SQL BI methodology that allows incremental and full loading of multiple sources and facilitate the rapid onboarding of additional client data & programs.

•         Implement an innovative modeling of a rapidly changing environment that allowed for accurate historical reporting for contracted and pre contract customers.

•         Design, implement, and design an SSAS cube that facilitate near real-time reporting on several key source systems permitting the application to operate in both analytical and operational capacities

 

Education/Experience:

•         Master’s or Bachelor's degree in business, computer science, mathematics, engineering, informatics, business intelligence, information technology, business or related field required

•         Minimum 6 + years of extensive experience in Microsoft BI Stack (SSIS, SSAS, SSRS, T-SQL & MDX Programming).

•         Minimum 3+ years of DW/BI design and development experience is required.

•         Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server.

•         Knowledge of the Kimball data warehouse lifecycle and strong dimensional data modeling experience, star schemas including an understanding of extraction, transformation, and load processes from operational source systems into the data warehouse

•         Experience in large scale Data warehouse systems.

•         Experience in Cube development using Microsoft SQL Server Analysis Services.