SQL Data Architect (BC)

Bedminster, NJ - Information Technology - Onsite - Full time

Apply Now

Date Posted: 6/5/2025

SQL Data Architect
Bedminster, NJ (Onsite)
Holding Bank

Oversee operation of Enterprise Data Warehouse built on Microsoft SQL and Microsoft Fabric. Includes optimizing performance, monitoring data imports, and integrating new data. Manage and support ETL (Extract, Transform, Load) processes that feed data into the warehouse from various banking systems. Ensure that data pipelines are running on schedule and that data from source systems (e.g. transaction processing systems, CRM, core banking software) is properly transformed and loaded into the warehouse without errors. Plan and execute long term architectural roadmap for Data Warehouse, including cloud migration. Implement and enforce data management standards and procedures to ensure data is consistent, accurate, and secure. Apply the principles of data confidentiality, integrity, and availability by controlling access to sensitive financial data, protecting against unauthorized access, and ensuring reliable data backups and restoration processes. Lead data cleanup initiatives to purge or correct inaccurate and outdated information and to merge duplicate records, thereby improving overall data quality and warehouse efficiency. Perform data audits and use scripts or tools to clean and transform data as needed. Work closely with data analysts, BI developers, and business stakeholders to understand reporting requirements and ensure the data warehouse can fulfill those needs. This may involve creating or optimizing database views, supporting the development of data marts or cubes, and ensuring data is structured for easy retrieval. Act as a liaison between database developers, data architects, and business analysts to translate business data requirements into effective warehouse solutions. Develop, document, and maintain formal policies, procedures, and standards for the Enterprise Data Warehouse. Keep up-to-date on information technology industry trends. Maintain the confidentiality of the bank and its customers.

Please contact Brian Clark at bclark@clarkdavis.com

$130K+Bonus

Recruiter LinkedIn Page

Share This Job Listing:

Be one of the first applicants for this job!

This information technology job opening has been viewed 25 times since it was posted.

For Hiring Managers:
Are you currently hiring for a similar job position? Please visit Information Technology staffing page for more information.

Job Search Tip:

Have you tried posting your resume on career websites? What were your results with that? Submitting your resume to such websites is a useful part of any job search strategy, but they do have some drawbacks. Their reach may be too broad and may attract job offers from companies that are not ideally suited to your career. Also you risk chances of having your resume become more public than you may find to be acceptable to you. This is where a staffing agency or recruiter like those who work at our firm can provide a different alternative in your job hunt. When you submit your resume to us, we keep the document strictly private and only submit it to our clients when we know that the client would genuinely benefit from your career skills in a particular position, and because we work with you to customize your career search to your needs we will know when to forward your resume to the hiring manager and when to wait for a better opportunity. This level of personalized service is not possible with the large nationwide job search websites, and this is why we are in a unique position to help you boost your career. Why not give our staffing team a try today and see for yourself what a difference our resume-matching capabilities can make for your job search!

Was this helpful? Check out our other job search tips for more!