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: Design strategies for and architect enterprise data warehouse systems for the capital markets and investment banking domains; develop and unit test ETL processes, mappings, workflows, sessions and dashboards; analyze large data sets and develop custom models (including overall architecture/data model design documents, technical design specifications as well as technology justifications) and algorithms to drive business solutions; use ETL tools to extract data from source systems and load it into target systems after applying requisite transformations; implement data quality/cleansing logic driven by business requirements; create Power BI reports and dashboards; SSAS Tabular model creation including writing DAX formulas for creating custom measures in SSAS Tabular and Power BI; design logging and validation frameworks for better error handling, quick fixing, and validation in ETL; and design macros and test suites to automate tasks in databases/warehouses over several networks and platforms.

Minimum Requirements:

Education and Experience: Master of Science degree in Computer Science/Engineering, Electrical/Electronic Engineering, Information Technology, Computer Applications or Computer Information Systems. Alternatively, Bachelor of Science degree in Computer Science/Engineering, Electrical/Electronic Engineering, Information Technology, Computer Applications or Computer Information Systems plus 5 years of experience as Database Administrator/Architect, Data Warehouse Architect, Software Developer, Computer Programmer, Systems Analyst, Programmer Analyst, or related position. Foreign educational equivalent accepted.

Skills required:
  • SQL Server 2008/2012, Oracle DB, SSIS, SSRS, Business Objects (BOXI), SSAS, Performance Point Server, Power BI, C#, .Net, VBA.Net, Power Shell Scripting

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/640 when applying for this position.

/ / Synechron’s Diversity & Inclusion Statement

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

/ / 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.
2 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.