Previous Job
Data Architect
Ref No.: 18-05677
Location: New York, New York
Position Type:Contract
Pay Rate : $ 71.43 - 82.61 /Hour
The EUT Operations Reporting & Process Improvement team is a service-oriented team that oversees, retrieves, stores, and provides operational, vulnerability and IT Service Management data for end-user computing including the Firm's Windows Desktop, Windows Server, Messaging, Collaboration and Mobile platforms. The resulting information is used for decisions throughout the Service Management life cycles by many customers within and outside of the Firm's Technology division.We are looking for a new team member to bring a foundation of established proven capabilities along with a desire and curiosity to develop new skills with innovative methods to serve our global customers. The ideal candidate would have a foundation in relational database design and development especially in Data Warehousing situations.Our team is nimble in that we provide short-term responses as well as build long-term projects using traditional release methods as well as Agile styles. We work both formally to Firm standards but also informally with customers depending on the needs and requirements.The core team is based in New York, NY and has operational counterparts in Budapest, Hungary.

Day-to-day Responsibilities:
* Aid in design, implementation and continual improvement of data storage models
* Translate requirements from internal customers and analyst into technical code
* Provide support and fix issues in the packages
* Utilize ad-hoc techniques to perform on-the-fly analysis of data
* Work with our task manager to identify business requirements, apply rules during development
* Work with our report designer to determine best methods to develop enterprise reporting

Preferred skills:
* Full stack Microsoft SQL Server centered on Business Intelligence (SSRS, SSIS, SSAS Tabular) 2005 or later, as a developer
* Advanced T-SQL (including optimization)
* Experience in the identification of data quality
* Knowledgeable in ETL strategies / Kimball methods / Star-Schemas
* Adept with intermediate to advanced methods with analysis and reporting products (QlikView, Tableau, PowerBI, SSRS)?Advanced Excel / PowerPoint skills
* At least one of R, PowerQuery, Python, C#, Visual Basic, PowerShell, VBA, Splunk
* Worked remotely or with global teammates, customers

Desired skills / Other Advantages:
* Familiarity with Microsoft Windows in an enterprise environment
* ITIL v3 or later Foundation certification
* Non-relational DB such as MongoDB, NoSQL, etc.
* Splunk certification or training
* Current Microsoft certifications in SQL Server (on-premise)
* Microsoft SCCM
* Vulnerability (CVE, etc.)
* DevOps / Agile exposure