Data Warehousing Director directs the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. Has overall responsibility for the development of data warehouse strategy, architecture and standards that meet business needs. Being a Data Warehousing Director ensures that new data platforms can be successfully integrated with existing warehouses, and that data warehouse systems fully support organization-wide data initiatives. Requires a bachelor's degree. Additionally, Data Warehousing Director typically reports to senior management. The Data Warehousing Director manages a departmental sub-function within a broader departmental function. Creates functional strategies and specific objectives for the sub-function and develops budgets/policies/procedures to support the functional infrastructure. To be a Data Warehousing Director typically requires 5+ years of managerial experience. Deep knowledge of the managed sub-function and solid knowledge of the overall departmental function. (Copyright 2024 Salary.com)
Health Alliance Plan - Henry Ford Health - Careers Careers
Troy, MIFULL_TIME
GENERAL SUMMARY:
Under the general supervision of the Specialist or Senior Data Warehousing Programmer, the Project Manager, Manager or the Portfolio Director: responsible for development, enhancement, production support and maintenance of the data warehouse. Responsible for job design for simple and medium complexity requirements and development of any high complexity jobs under Leads supervision. Responsible for creating and updating of all Project related artifacts which includes high level design and low level design documents, coding the job as per the standards, developing unit test script as well as integration test script documents and Run book creation for scheduling.
The responsibilities also include troubleshooting application issues and/or data issues when they arise. The Data Warehousing Programmer may be accountable for production support (including on-call duties in a 24x7 environment) as well as new projects.
PRINCIPAL DUTIES AND RESPONSIBILITIES:
Participates in requirements definition sessions to gain a general perspective on the business objective(s) or business problem that is to be addressed by the system.
Works with Business Analysts to gain an understanding of functional requirements.
Works with Business Analysts to develop design documents.
Design and develop prototype and work with the senior personnel to fine tune the data warehouse and make recommendations, including DB and ETL job tuning.
Participates in code/design reviews to verify that quality standards and functional/technical requirements are met.
Design, code, test and implement moderately complex programs; Develops appropriate programs and systems documentation according to established IT standards.
Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated in the system design.
Assists in analyzing testing results throughout the project.
Under the supervision of senior staff, supports production systems by helping resolve problems, providing timely follow-up on problem report, and optimizing performance and streamlining processes.
Participates in technical reviews and inspections to verify 'intent of change' is carried out through the entire project.
Provides support, escalation response to production issues/errors. Performs root cause analysis and application resolution.
Provides on call second-level escalation response for client issues and application problem tickets
Ensures proper documentation and on-time delivery of all technical artifacts and deliverables.
Initiates a personal training plan, continue acquiring skills and knowledge, and pursue an understanding of the organization’s business plans and strategies.
Three (3) to five (5) years of relevant domain experience in Data Warehousing, Data Mart builds, and other Information Management related initiatives.
Required to understand general data warehousing concepts such as Star Schema and Snow flake.
Must be familiar with Data Warehouse methodologies like Bill Inmon and/or Ralph Kimball.
Minimum two (2) years of experience with IBM® InfoSphere toolset version 8 or above using DataStage, Shell Scripting, Scheduling tool and SharePoint technologies.
Minimum three (3) years of experience with Oracle database.
Minimum three (3) years of experience working in both Windows and Unix environments.
Experience with FACETS, IKA, and/or PEGA is preferred.
Exposure to cloud technologies such as Azure Data Factory, Azure Databricks, Azure Synapse, Azure Function Apps and programming with Python, Scala in data engineering space preferred.
Experience/exposure to various System Development Life Cycle (SDLC) methodologies (Waterfall, Agile, etc.)
Knowledge on database concepts like indexing, partitioning, views, materialized views, performance tuning and optimization is preferred.
Good understanding of HIPAA data Privacy and Security requirements preferred.
Experience working in a Health Insurance environment is preferred.
Parts Plus-Howell-Inside Sales-Part Time Parts Plus has been Family owned, since 1931, a stable and growing company with growth opportunity. 35 locations across the States of Michigan and Ohio. Inside...
Auto Warehousing (AWC) has been family-owned and operated for more than 50 years and is North America's leader in finished vehicle logistics. Our mission is to service customer vehicles safely, effici...
Auto Warehousing (AWC) has been family-owned and operated for more than 50 years and is North America's leader in finished vehicle logistics. Our mission is to service customer vehicles safely, effici...
Parts Plus-East Jordan-Inside Sales-Part TimeParts Plus has been Family owned, since 1931, a stable and growing company with growth opportunity. 35 locations across the States of Michigan and Ohio.Ins...
Michigan consists of two peninsulas that lie between 82°30' to about 90°30' west longitude, and are separated by the Straits of Mackinac. The 45th parallel north runs through the state—marked by highway signs and the Polar-Equator Trail—along a line including Mission Point Light near Traverse City, the towns of Gaylord and Alpena in the Lower Peninsula and Menominee in the Upper Peninsula. With the exception of two small areas that are drained by the Mississippi River by way of the Wisconsin River in the Upper Peninsula and by way of the Kankakee-Illinois River in the Lower Peninsula, Michigan...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Data Warehousing Director jobs
$184,294 to $242,256
Most Popular Cities in Michigan for Data Warehousing Director Jobs