Job Detail
Overview
The company is building out the data management practice over the next few years. You will be involved in all aspects of this initiative e.g. decision making of tools, methods and design principles. In this role you will have the opportunity to gain experience across all disciplines of data management, i.e. ETL, modeling and BI. They have engaged a part-time data architect (outside consultant) to support you on projects and development of data strategy. You will be a member of the Data Management Steering Committee that provides oversight of data initiatives. You will work directly with business leaders and stakeholders to solve data centric business problems.
The VP if IT perspective on the person for the job:
- Leadership skills
- Presentation skills
- Quality Minded/Standards minded so has faith in what the person develops will endure the test of time.
- Great interpersonal skills
- Broad skills – ETL, Modeling, Data Base, Business Intelligence
Description
- Present ideas for projects and enhancements to management and the executive team and promote growth and advancement for Data Management program by building relationships with key stakeholders
- Perform advanced data analysis, systems analysis, and data profiling, and develop technical specifications based on business requirements
- Collaborate with the IT support teams to design and create technical architectures that comply with corporate guidelines and restrictions
- Create and document specifications for BI or IT reports, dashboards, and other outputs
- Design and develop data warehouse objects and structures for data storage, retrieval and reporting according to project requirements and specifications
- Develop technical best practices for database and ETL design
- Maintain metadata library including data models, documents, and other reusable items
- Test data warehouse and ETL design and functionality
- Design and develop, maintain or update, and provide technical support for BI tools, databases, dashboards, systems, or methods
- Performance tuning for ETL and data warehouse performance
- Interface with customers/business users to ensure the final design meets business and data requirements
- Generate standard or custom reports summarizing data for review by executives, management, clients, and other stakeholders
- Work closely with the project manager to develop and update the project plan and keep the project team informed of critical issues and dependencies on other teams
- Lead Unit and Integration testing and assist in User Acceptance Testing as needed
- Disseminate information regarding tools, reports, or metadata enhancements
- Assist with support of OLTP databases as needed
Requirements:
- BA/BS in Computer Science or equivalent training/education/experience.
- 5+ years experience developing queries, stored procedures, and reports on one or more major enterprise database platforms (i.e. Microsoft SQL Server, IBM DB2) Really wished she knew DB2 for design purposes.
- 5+ years experience with one or more major ETL tools (i.e. SSIS, Informatica, other)
- Working knowledge of Microsoft Office applications (i.e., Word, Excel, etc.) and Windows
- 2+ Experience with tools such as Microsoft Reporting Services, Business Objects /Crystal Reports, or MicroStrategy for Relational Reporting a plus
- Demonstrated experience working on strategy projects and evaluating software in the BI, DW and/or Data Management space
- Demonstrated strong mathematical, analytical and problem solving skills
- Excellent verbal, written and interpersonal communication skills
- Ability to lead and coordinate work in a team environment on large projects
- Ability to work independently on small projects with little to no supervision
- Accurate and strong attention to detail
- Ability to handle multiple and changing priorities
- Demonstrated excellent organizational, time management and prioritization skills
- Willingness and ability to accept and navigate political situations to insure program success
- Willingness to work additional hours to meet deadlines, complete projects and provide support for production systems
Terry Bonertz952-841-9510 ext.1terry@involveit.comContact UsSubmit Resume