113517: Data Warehouse Architect (15 Years EXP)

Key Business Solutions, Inc.
Lansing, MI
26 Jan 2025

Vacancy expired!

113517: Data Warehouse Architect (15 Years EXP)

Lansing, MI (Hybrid)

12 Months

Top Skills & Years of Experience: Writing Oracle packages, procedures, and functions, Required 15+ yearsDesigning, creating, normalizing and maintenance of Oracle database objects, Required 15+ years.Experience in Oracle Database administration, PL/SQL, packages, security, and stored procedures, Required 12+ years.Vast experience in LINUX systems, Required 10+ years.

Description: Design, implement, and support data warehousing. Implement business rules via stored procedures, middleware, or other technologies.Install and upgrade Tableau server and perform server performance tuning for optimization.Schedule data refreshes on Tableau Server for daily/weekly/monthly increments depending on the dashboard cadence.Design, develop, conducts unit testing, and maintains complex Tableau reports for scalability, manageability, extensibility, performance, and re-use.Work with team members to create useful reports and dashboards that provide insight, improve/automate processes, or otherwise add value to the team.Perform routine maintenance of Tableau server by optimizing and decommissioning internal resource usage.Generate Tableau dashboards with forecast and reference lines using parameters, sets, groups, and calculations.Developing and maintaining the dashboards, related workflowsArchitecting, Developing, and creating schedules using Tableau Prep Conductor for workflowsOptimize the workflows for performanceWork experience in Azure Data factory for ETL developmentDefine user interfaces and functional specifications. Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse.Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning.Responsible for proper selection of appropriate hardware, software, tools, and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools.Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality. Setting or enforcing standards and overall architecture for data warehouse systems.

Requirements Database programming experience in data migration and conversion practices, Required 15+ yearsWriting Oracle packages, procedures, and functions, Required 15+ yearsDesigning, creating, normalizing and maintenance of oracle database objects, Required 15+ years.Experience in performance tuning, Required 15+ years.Knowledge and experience in understanding and implementing of the CJIC policies. 10+ yearsExperience in Oracle Database administration, PL/SQL, packages, security, and stored procedures, Required 12+ years.Designing logical and physical database model, Required 12+ yearsKnowledge in design, development, implementation, and documentation of data systems.Vast experience in LINUX systems, Required 10+ years.Data analysis and management, Required 10+ yearsExperience in developing using ETL software. desired 10+ yearsExperience in Data Modeling and designing Datawarehouse databases, Required 8+ years.Experience in Tableau software Administration. Required 1-3 yearsExperience in creating Dashboard and Tableau Prep conductor workflows. Required 1-3 yearsExperience in Azure Data factory for ETL development 1-3 years

Regards, SatyaTechnical Recruiter

Key Business Solutions, Inc Office:

916 646 2080 Ext 216 OR D:

Fax: Email:

G Talk:

satyakeysoft Notice: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list. Thank You
  • ID: #48837174
  • State: Michigan Lansing 48901 Lansing USA
  • City: Lansing
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2023-01-26
  • Deadline: 2023-03-24
  • Category: Et cetera