Data Warehousing Director jobs in Detroit, MI
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)
Recently Added Data Warehousing Director jobs
- Health Alliance Plan - Henry Ford Health - Careers Careers
-
Troy, MI
FULL_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.
EDUCATION/EXPERIENCE REQUIRED:
- Bachelor’s degree required/ Master’s degree preferred.
- 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.
Additional Information - 4 Days Ago
- Hello Innovation
-
Detroit, MI
FULL_TIME
- As our Director of Data Science you will set the foundation that powers impactful data-driven insights; harnessing the power of data to shape our products with the potential to improve the lives of bi...
- 10 Days Ago
- United Community Housing Coalition
-
Detroit, MI
FULL_TIME
- Director of Data ManagementPosition Overview:The Director of Data Management at United Community Housing Coalition will report to the Chief Operating Officer and oversees the data entry clerks and dat...
- 28 Days Ago
- Michigan Association of School Boards
-
Macomb, MI
FULL_TIME
- Deadline: April 19, 2024 District/Organization: Anchor Bay School District Position/Type: Central Office – 1st Line Admin, full time Salary: Per master agreement Position Details Summary Under the sup...
- 29 Days Ago
- Publicis Groupe
-
Birmingham, MI
FULL_TIME
- Company DescriptionDigitas is the Networked Experience Agency, built on the vision that we create magnetic experiences that earn the right for brands to exist in human networks. Today, and tomorrow. W...
- 1 Month Ago
- Digitas
-
Birmingham, MI
FULL_TIME
- Company Description Digitas is the Networked Experience Agency, built on the vision that we create magnetic experiences that earn the right for brands to exist in human networks. Today, and tomorrow. ...
- 1 Month Ago
- Current Active Filter
- Detroit, MI
Clear All
- Filter Jobs By posted time
- Within 1 Day
- Within 2-7
- Within 1 Month
- Within 3 Months
0 Data Warehousing Director jobs found in Detroit, MI area
- Gildform
-
Detroit, MI
- Job Description Job Description WHY IS A DIRECTOR OF OPERATIONS IMPORTANT TO GILDFORM?As Gildform's Director of Operatio...
- 4/24/2024 12:00:00 AM
- ATI Physical Therapy
-
Southfield, MI
- Overview: Stronger Together: ATI is the largest outpatient orthopedic physical therapy company under one brand, growing ...
- 4/23/2024 12:00:00 AM
- Capital Markets Advisors LLC
-
Detroit, MI
- CMA is boutique Consultancy & Recruiting firm specializing in the Financial Services sector. Our client is a global cons...
- 4/21/2024 12:00:00 AM
- Sunrise Senior Living
-
Bloomfield Hills, MI
- Overview The Director of Nursing Services is responsible for providing leadership and management to the skilled nursing ...
- 4/11/2024 12:00:00 AM
- KinderCare Education
-
Woodhaven, MI
- Futures start here. Where first steps, new friendships, and confident learners are born. At KinderCare Learning Companie...
- 4/11/2024 12:00:00 AM
- KinderCare Education
-
Detroit, MI
- Futures start here. Where first steps, new friendships, and confident learners are born. At KinderCare Learning Companie...
- 4/5/2024 12:00:00 AM
- Sunrise Senior Living
-
Bloomfield Hills, MI
- Overview The Director of Nursing Services is responsible for providing leadership and management to the skilled nursing ...
- 3/19/2024 12:00:00 AM
- Sunrise Senior Living
-
Bloomfield Hills, MI
- Overview The Director of Nursing Services is responsible for providing leadership and management to the skilled nursing ...
- 2/12/2024 12:00:00 AM
About Detroit, Michigan
were up 1.2% from a year ago