Data Architect

Sonsoft Inc; Pennington (NJ); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading technology firm in Pennington is seeking an experienced Data Architect to join their team. The ideal candidate will have over 7 years of experience in data architecture and strategy, along with strong leadership and communication skills. Proficiency with ETL tools such as IBM Data Stage and Informatica, and BI tools like Tableau is essential. This is a Full-Time / Permanent role offering an opportunity to work on large-scale data solutions in a complex financial environment.

Qualifications

• 7+ years of hands-on experience in Data Architecture and Strategy.
• 5+ years of experience as a data strategist in the financial industry.
• Experience with large-scale data solutions.

Responsibilities

• Architect solutions independently and lead code reviews.
• Write SQLs with complex joins and aggregations.
• Manage relationships with team members.

Skills

Data Architecture

Data Strategy

Leadership

Communication

Analytical skills

Organizational skills

SQL writing

Query tuning

Education

Bachelor’s degree or foreign equivalent

Tools

IBM Data Stage

Informatica

Tableau

Microstrategy

Hadoop

Cloudera

Job description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

• Minimum of 7+ years of hands on experience Data Architecture and Strategy.
• Possess 5+ years’ experience as a data strategist in a complex financial industry data
• Demonstrate strong leadership, communication, analytical and organizational skills. Should
• possess excellent communication and articulation skills.
• Experience with architecture and design of large-scale shared data solutions with multiple stakeholders.
• Familiarity with data management, metadata management, data lineage and data governance. Strong data quality and controls experience.
• Strong domain knowledge of the data domains supported by control functions (Finance,
• Enterprise Stress Testing, Regulatory Reporting, Compliance, AML, Operational Risk, HR,
• Legal, Marketing, Audit etc. ) and experience in financial services industry.
• Hands-on design and implementation experience with one/more of the following data tools:
• ETL – IBM Data Stage, Informatica, SSIS, Alteryx
• BI – Tableau, Microstrategy, Cognos
• Other Tools – Composite, BeCubic, Hadoop, Cloudera, metadata/lineage tools, Distributed
• Caching tools
• Experience with next generation tools and technologies is a plus (BlockChain, Cognitive
• Strong knowledge of database modeling principles, techniques and enterprise data
• Able to independently architect solutions, lead code reviews and ensure quality throughout
• the life of each project.
• Experience in full software development lifecycle of the Data Warehousing Project.
• Strong knowledge of database modeling principles, techniques and enterprise data
• Efficient in Writing SQL’s with complex joins ,aggregations, UNIX Scripts
• Good understanding of Data Warehouse modeling concepts.
• Must be able to provide Solutions or Enhancements to fix the issues quickly when reported
• by the clients or users.
• Flexibility to Self-learn and understand the system, further assist with query tuning and
• Ability to effectively manage day-to-day interactions and relationships with a diverse group
• of team members

Qualifications

Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

At least 4 years of experience within the Information Technologies.

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.

This isFull-Time / Permanent job opportunity.

**All your information will be kept confidential according to EEO guidelines.