Job Details

ID #23204287
State New York
City New york city
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source Reliable Software Resources
Showed 2021-11-21
Date 2021-11-19
Deadline 2022-01-18
Category Architect/engineer/CAD
Create resume

Data Warehouse Architect

New York, New york city, 10001 New york city USA

Vacancy expired!

Reliable software has a career opportunity for

Sr.

Data Warehouse Architect

with one of our direct clients. Below are a few details pertaining to the job. Please share with me your updated resume.

Job: Senior Data Warehouse Architect

Location: NYC,NY (onsite 3-days per week)

Duration: Long term

Position Overview:

The Data Warehouse Data Architect / Developer defines and designs both solution and application architecture for the enhancing capabilities of an existing Data Warehouse technologies.

Key Responsibilities:

As a part of the firm’s IT Application Development and Support department, responsibilities will include:
  • Analyze and assess existing platform for maintainability, reliability, scalability, security, and performance.
  • Define standards for the design and analysis of load processes, data flows and data models.
  • Lead the design, build, and deployment of ETL (extract, transform, and load) processes for large data sets.
  • Review the existing platform architecture and come up with recommendations to solve the current performance issues which exists in cube processing, Data imports, Drill throughs.
  • Facilitate code reviews, software design sessions and architectural reviews.
  • Participate in technical advisory roles, as required
  • Interact with business users, as required.
  • Provide ad hoc support in troubleshooting highly complex production issues as they arise.
  • Conduct root cause analysis and performance tuning for data load processes.
  • Ability to problem solve, recommend and develop technical solutions.
  • Participate in firm-wide initiatives, such as master data management and other projects on an as-needed basis

Education and professional experience

Required:
  • Bachelor’s degree in Computer Science, Information Systems, or another four-year degree with significant IS experience OR equivalent experience. Master’s degree preferred
  • 10+ years of experience delivering Data Warehouse solutions
  • 10+ years in Microsoft technology – SQL Server, SSIS, SSAS, C#, .Net technologies
  • 4+ years serving as a Data Warehouse architect with a demonstrated track record of implementing highly scalable and available solutions into a highly transactional production setting
  • Data Warehousing & ETL
    • Significant data warehouse experience from planning, to design, to implementation.
    • Experience of designing strategies for ETL audit, load balance, exception handling and high data volumes.
  • Technically excellent in all areas of SQL Server development including stored procedures, functions and triggers.
  • Proven expertise in Data warehouse methodologies as well as extensive knowledge of OLTP/OLAP technologies.
  • Ability to design, organize, and implement module, perform system testing,
  • Plan and automate tasks to maintain existing system
  • Ability to research and trouble-shoot application problems
  • Highly motivated team player with strong communication and interpersonal skills
  • Business analysis, especially business requirements gathering

Proficient In:
  • Software Architecture
  • Software Development Fundamentals
  • Software Design
  • Software Debugging
  • General Programming Skills
  • Relational Database Concepts
  • Data Warehouse Concepts
  • Dimensional Data Modeling and Notation
  • Microsoft SQL Server
  • Microsoft SSIS
  • ETL Processes
  • OLAP Cube Development using MDX
  • MDM (Master Data Management) experience.
  • Microsoft Tabular Models and SSAS Cubes
  • Microsoft Team Foundation Server / Git
  • Application Performance Tuning and Optimization
  • Data Warehouse Technologies: Azure Synapse Analytics and/or Snowflake and/or Single store
  • Agile development methods and Dev/Ops CI/CD (Preferred)
  • Jira (Preferred)

Educational Qualifications:
  • Required - Bachelor’s degree in Computer Science, Information Technology, Computer Engineering or closely related or equivalent.
  • Preferred - Master’s degree in Management Information Systems (MIS), Computer Science, Big Data or Analytics or equivalent

Travel:
  • Open to travel based up on the nature of the engagement

Thanks & Regards

Srikanth Donkani Sr. Talent Acquisition Specialist(w): 312-448-6138 (E): srikanth.d@rsrit.comwww.rsrit.com2260 Haggerty Road, Suite 285 Northville, MI 48167

Equal Employment OpportunityReliable Software employment does not discriminate on the basis of race, religion, gender, sexual orientation, age or any other basis as covered by federal, state, or local law.Employment decisions are based solely on qualifications, merit and business needs.

Vacancy expired!

Subscribe Report job