Home

Data Warehouse Architect (Lead or Senior Level) --Local candidates only Indiana at Indianapolis, Indiana, USA
Email: [email protected]
From:

priya,

Anveta INC

[email protected]

Reply to:   [email protected]

Hi team ,

Local candidates only

IN - DWD Data Warehouse Architect (719691)

Location: Indianapolis, IN 46204---( Webcam only)---( Hybrid)

Duration : Long term

Client:

State of Indiana

Data Warehouse Architect (Lead/Senior Level)

Essential Job Responsibilities:

The essential functions of this role are as follows:

Participate with a Product Owner (PO) and/or Business Analyst (BA) in gathering business requirements.

Participate with a team of business stakeholders, junior Tableau developer(s), BA and PO in developing wireframes and other dashboard mockups.

Provide guidance and experience to best practice in designing Data Lakes, Data Marts, and other data assets to be presented to the business.

Develop data mappings, data flows and data cleansing procedures.

Provide education and guidance to other data group members in effective data asset development.

In general, act as a lead in effective data designs starting with data selection from core system, data transfer and cleansing, to final data presentation.

Participate with other Data Analyst(s) as needed to define minimal viable data assets in support of the visual needs.

Assist the PO in estimating scope and time as it relates to development of data transfers, cleansing and promotion, and as it relates to staffing level.

Assist the PO and/or BA in doing Inspect & Adapt reviews with the business.

Advice management as needed of any shortcomings with current tools and/or approaches related to the business initiatives.

Requirements:

Extensive knowledge of information systems design principles and new systems design techniques.

Extensive knowledge of policies, standards, procedures, and techniques used for data application development.

Ability to perform problem solving and analytical analysis on complex issues.

A very strong understanding of system development using a lean agile approach.

Extensive knowledge of both system and business applications and competent to work at the highest technical level of all phases of data applications systems analysis and developing activities.

Willingness to train/educate other Data Analysts, Business Analysts and other data team members in effective data designs/approaches.

Willingness to train/educate junior Data Analysts in effective data transfer and development.

Experience in using a wide range of ETL tool Talend and Data Factory.

Some experience in using the Tableau Studio tools is desired.

Extensive knowledge of the most recent advancement in data transfer, cleansing and promotion.

Ability to read and understand complicated technical instructions.

Ability to manage multiple application development assignments and priorities.

Ability to communicate effectively, both orally and in writing.

Supervisory Responsibilities/Direct Reports:

This role does not provide direct supervision to direct reports.  At most, this position is a coach to others in the IT Data Group in understanding the best practices/approaches to data transfer, cleansing and promotion.

The Data Warehouse Architect (Lead/Senior Level) performs a broad range of activities within a state-of-the-art Information Technology area.  Although most of the effort will center around building data assets from scratch, work involves using considerable judgment in selecting the most pertinent guidelines to follow and in-depth analysis of multiple variables to fit various circumstances of a medium to complex enterprise-wide system.  Incumbent applies general Software Development Life Cycle (SDLC) principles and industry standards to accomplish agency automation goals.

Responsibility:

The Data Warehouse Architect (Lead/Senior Level) work has a direct influence and impact on the agencys ability to successfully administer the business operation to achieve agency mission, policy and/or practice.  Technical instruction is generally not needed; however, employee may seek guidance when unique problems arise.  Work is reviewed for adherence to deadlines and compliance with policies, standards, procedures, and achievement of the desired objectives.

Personal Work Relationships:

This individual will be expected to partner with both agency and contracted personnel and related stakeholders working towards completion of assigned functions.  Exceptional customer service is provided to agency partners and/or the general public.

Competencies

Acquiring Information

Communicating Effectively

Critical Thinking

Delivering High Quality Work

Testing and Troubleshooting

Displaying Technical Expertise

Adapting to Change

Accepting Responsibility

Training Others

SQL

Azure Synapse

Data Factory

Talend, Data Factory and other ETL tools

Tableau Studio

Jira

App Dynamics

Confluence

System Development using Lean Agile

Data Modeling

Data Mapping

Data Cleansing Schemes

Skill

Required / Desired

Amount

of Experience

Senior level Data Warehouse Design skills

Required

5

Years

Senior level SQL experience

Required

5

Years

Experience in using a wide range of ETL tool Talend and Data Factory.

Required

5

Years

A very strong understanding of system development using a lean agile approach.

Required

5

Years

Competent to work at the highest technical level of all phases of data applications systems

Required

5

Years

Extensive knowledge of the most recent advancement in data transfer, cleansing and promotion.

Required

5

Years

Extensive knowledge of information systems design principles and new systems design techniques.

Required

3

Years

Extensive knowledge of system and business applications

Required

3

Years

Willingness to train/educate other Data Analysts, Business Analysts and other data team members in effective data designs/approaches

Required

3

Years

Azure Synapse skills

Required

2

Years

Azure Data Factory Skills

Required

2

Years

Tableau Studio Skills

Required

2

Years

Keywords: business analyst information technology purchase order
[email protected]
View all
Fri Sep 08 20:43:00 UTC 2023

To remove this job post send "job_kill 618377" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 8

Location: Indianapolis, Indiana