Business Intelligence Technical Lead (14632)

Sundial Software - Madison, WI

This position will provide advanced complex Business Intelligence (BI) and Data Warehouse (DW) support in the areas of:

1. Metadata management - Design, develop, test, maintain and support metadata and data lineage information associated with source and target data and all processes and reports that use the data.
2. Data masking and test data management - Design, develop, test, maintain and support complex workplans to refresh and mask data in lower environments to be used by the various Data Warehouse and BI projects for testing purposes
3. Technical project leadership - Provide project leadership for unit projects which have a significant department impact, that involve interaction with other systems analysts, application programmers, customers and management. Review business case documentation, prepare plans and estimates that ensure consistency with departmental architectures, methodologies, standards, and policies. Gather requirements from various DOT business areas that involve a large number of complex variables including multi-platform requirements and the integration/revision of major systems. Manage project deliverables, risks, and ensure on schedule completion
4. BI Unit Support Tickets - Monitor all incoming BI Unit support tickets and ensure they are routed to the appropriate resource for resolution in a timely manner to ensure the unit meets its SLA

Projects utilize Informatica (Metadata Manager & Test Data Management), Business Objects, Tableau, Infoburst tools to design, create and deliver solutions, collaborating with business analysts, data modelers, database administrators, BI architects, and development teams to facilitate targeted content aggregation reporting/dashboard delivery.

The ideal candidate will have 8 - 10 years skills and experienced in the following:
1. Data Warehouse and Business Intelligence domain
2. Informatica Metadata Manager
3. Informatica Test Data Manager (TDM)
4. SQL
5. Project Leadership and timely delivering of projects in the Data Warehouse and Business Intelligence domain
6. Good communication skills
7. Ability to work with clients on refining requirements, creating project plans, schedules, monitoring progress and assessing risk
8. Cherwell

Additional skills should include leading projects that utilize the following:

1. Informatica PowerCenter
2. Business Objects
3. Tableau Dashboards
4. Dimensional modeling
5. Oracle or DB2

QualificationRatingMust HaveAdministration - Customer Service

Customer presentations

 

and 9 years

Administration - Project Management

Experienced project manager or leader

 

and 9 years

Information Technology

Experience with data management tools, such as Collibra or Informatica

 

and 9 years

Information Technology – Business Intelligence

Experience with Database Management using RDBMS, ORACLE, IBM DB2, SQL Server

9 years

Experience with Star Schema and Snow Flake Data Modeling

9 years

Good understanding of testing activities and methodologies

9 years

Results oriented with an ability to work in team and individual contributor work environments

9 years

Strong ability to decompose a broad level business requirement into technical implementation

9 years

Strong root cause investigation and problem solving skills

9 years

Strong understanding of patterns and best practices

9 years

Information Technology - Databases

Data Warehouse - Experience in data warehouse design and development

9 years

Data Warehouse - Experience in requirements gathering for data warehouse

9 years

Data warehousing

 

and 9 years

DB2

 

and 9 years

Informatica

9 years

Oracle

 

and 9 years

Oracle PL/SQL unit testing

 

and 9 years

SQL Server

 

and 9 years

Tableau Desktop

5 years

Technology - Languages/Tools

Business Objects

 

and 9 years



Posted On: Monday, February 10, 2020



Apply to this job
or