Job Description :
Data Warehouse- Data Architect

Top Skills:

Data Mapping
Data Mining
Architect DW
ETL

The responsibilities also include troubleshooting application issues and/or data issues when they arise. The Senior Data Warehousing Analyst is a leader in an IT team that is accountable for production support (including on-call duties in a 24x7 environment) as well as new projects.

The ideal candidate will have significant experience using analytical skills to seek out, research and evaluate a variety of options to provide clients with high quality solutions that promote efficiency and enterprise-wide standardization. Must demonstrate the ability to mediate and bridge the relationship between technical and business stakeholders without compromising the needs of the solution users and the strategic goals of the organization.

PRINCIPAL DUTIES AND RESPONSIBILITIES:

* Subject matter expert (SME) in one or more applications' capabilities and features for users, owners, and administrators of solutions.
* Assists with developing the methods and procedures required to identify whether current business goals and objectives meet organizational needs.
* Facilitates meetings with clients to gather and document requirements and explore potential solutions.
* Analyzes and documents client's business requirements and processes and communicates these requirements by constructing conceptual data and process models, including data dictionaries and volume estimates from organization.
* Provides input into developing and modifying systems to meet client needs and develops business specifications to support these modifications.
* 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 to the system design.
* Assists in analyzing testing results throughout the project.
* Participates in technical reviews and inspections to verify 'intent of change' is carried out through the entire project.
* Assists in coordinating business analyst tasks on information technology projects, problem tickets and provide support to other team members.
* Provides support, escalation response to production problem issues/errors. Performs root cause analysis and application resolution.
* Provides on call second-level escalation response for client issues and problem tickets
* Assists in providing time estimates for project related tasks.
* Promotes teamwork and leads by example.
* Keeps abreast of new Tools & Technology and functionalities across the application(s
* Collaborates with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions.
* Lead and conduct conference room pilots and demonstrations.
* Demonstrate solutions to client in a workshop setting.
* Assignment of work and development of less experienced team members.
* Ensure proper documentation and on-time delivery of all functional artifacts and deliverables.

Qualifications:
EDUCATION AND EXPERIENCE REQUIRED:

* Bachelor's degree required; Master's degree preferred.
* 5- 7 years of prior experience in a technical lead or consulting role leading Information Management related initiatives (system integration, data warehouse build, data mart build, or similar) is required.
* 7-10 years of experience in data warehouse architecture, application design, systems engineering, SDLC and integration.
* 3 years of experience in leading a design and architecture of beginning to end implementations of multiple large scale data integration projects
* Excellent strategic thinker with ability to provide thoughtful leadership to develop creative solutions for complex business and technical problems.
* 3-5 years of experience and knowledge within the following:

* ETL tools like Microsoft SSIS/ Data stage / Informatica / AbInitio
* Windows and Unix scripting, SQL, PL/SQL
* Datamarts, analytical cubes, data visualization
* Working with several databases like Oracle, DB2, SQL server, Teradata
* Data Analysis services such as Microsoft SSAS
* Data Governance, Data Security, Data architecture and Master data management processes
* Data Visualization tools such as Tableau, WebFocus, Microsoft BI stack
* High degree of healthcare provider or payer industry knowledge is preferred
* Knowledge of large data distributed processing framework such as Hadoop is preferred
             

Similar Jobs you may be interested in ..