Language change icon for desktop
English  |  Dutch  |  French

Data Warehouse Architect

New York, N.Y. and various unanticipated locations across the U.S.,
Job Description

Duties: Architect and support enterprise data warehouses capable of catering to enterprise-wide customer requirements with downstream users for banking, insurance and finance domains; develop and unit test ETL processes, mappings, workflows, sessions and dashboards; design and analyze data models in accordance with financial regulatory requirements; install, upgrade, patch and configure Hadoop distributions (Cloudera, Horton Works); install, configure and use Hadoop ecosystem components (HDFS, Hive, Pig, Flume, HBase, Oozie, Python, R); use ETL tools to extract data from source systems and load it into target systems after applying requisite modifications, including designing scalable and high-performance standards and techniques for optimal loading of data of various types and from heterogeneous systems; implement business processes through a combination of middle-ware, database procedures, etc.; implement data quality/data cleaning logic driven by business requirements; analyze and validate big data report files; create and schedule ETL jobs to lead data into data warehouse and data marts; implement enterprise-wide data abstraction and security on the data warehouse; and evaluate data warehouse architecture for continual performance improvements and optimizations, including identifying and monitoring key performance indicators (KPIs).

Minimum Requirements:

Education and Experience: Master of Science degree in Computer Science/Engineering, Information Technology or Computer Applications. Alternatively, Bachelor of Science degree in Computer Science/Engineering, Information Technology or Computer Applications plus five (5) years of experience as Software Developer, Database Administrator, Computer Programmer, or related position. Foreign educational equivalent accepted.

Skills required:
  • R, Python, SQL, PL/SQL, UNIX Shell Scripting, PowerShell  
  • MongoDB, MS SQL Server, Oracle  
  • Informatica, SSIS, Ab Initio  
  • HDFS, HBase, Hadoop Distributions (Cloudera and Hortonworks), Hive, Pig, Impala, Sqoop, Oozie, Flume, NoSQL, SSRS, SAP Business Objects, SAP Crystal Reports,, CA Erwin Data Modeler, Microsoft Project, Microsoft Visio  
  • R Studio, Jupyter Notebook, Microsoft Visual Studio, Microsoft SSDT, Apache Subversion, SVN, GitHub  
  • Banking, Insurance and Finance domains  


Worksite: 11 Times Square, New York, NY - 10036. Exact worksite location not known at this time but will report to and will be paid out of headquarters office in New York.

This position qualifies under our incentive-based employee referral program.

Please refer to job code SYN2021/615 when applying for this position.

/ / To apply for this position please
submit your details and responses to the below questions
1) Are you legally authorized to work in the U.S. on a full-time, regular basis?
2) Will you now or in the future require sponsorship for employment visa status?
3) Are you willing to relocate ?
First Name
Last Name
Contact Number
One file only.
100 MB limit.
Allowed types: pdf doc docx.
Enter the characters shown in the image.


Synechron, Inc. and/or its affiliates and group companies takes your privacy seriously. By providing your information, you are signing up to receive information about Synechron services and related marketing. Your personal data will be protected in accordance with Synechron's Privacy Policy. By filling out this form, you are giving Synechron your consent so that we may communicate relevant information to you via email, telephone, invitations, and other digital notifications. If at any time you would like to withdraw your consent or update your profile and preferences, you can do so by clicking here or by contacting us directly.