Datawarehouse/C# Solution Architect in Woodbridge Township, NJ at ConsultNet

Date Posted: 6/21/2020

Job Snapshot

Job Description

TITLE: Datawarehouse/C# Solutions Architect
DURATION: 6+ months with a probable extension


The Data Warehouse Solution Architect has a deep understanding of data and processes for ingestion of data for end user consumption.  This individual will manage and lead multiple simultaneous projects, define solution frameworks, programming standards and best practices for the team. Primary responsibilities are the design, development, testing and maintenance of in-house software solutions. This position requires the Senior Solution Architect to be responsible for other functions normally within the realms of Functional Analyst, Development Lead and Data SME.
Responsibilities 50% -       Work with business partners to analyze and define requirements a function typically performed by a Functional Analyst.
-       Design, document and implement technical solutions.
-       Actual hands on coding of the solutions will be required a function typically performed by the Development Lead and or Developers. 30% -       Build data pipelines and perform code review to ensure design is reusable and meet high quality standards.
-       Assist management in defining software development guidelines. 20% -       Create documentation utilized for Training and assist in the initial end-user training.
-       Create documentation utilized for Quality Assurance and supervise the initial validation prior to UAT.
-       Responsible for the creation of documentation utilized for Production Support and perform second level Production Support. Qualifications
•         Bachelor’s Degree in Computer Science, Engineering or an equivalent hard science and/or Banking Certification in a related field.
•         10 years in an Information Technology role dealing with software design and development.
•         Must have strong knowledge of Data Modeling, Data Pipelines, SQL and ETL.
•         Extensive experience in T-SQL development, MS SQL Server preferred, with strong knowledge in query optimization
•         Background in C#, ASP.NET, XML, VBScript, CSS, HTML and JavaScript, JQuery
•         Relational Database design and data warehouse design.
•         Dimensional Modeling.
•         Experience working with ETL tools such as SSIS
•         Exposure to AWS Data Lakes is desirable
•         A collaborative, consultative approach and the ability to gain confidence of business Associates.  Must be equally comfortable with technical or business Associates.
•         Willingness to learn new web development technology.
•         High energy level, strong work ethic and attention to detail. Energy and drive to execute on-time, and on-spec.  Must be detail-oriented and conscientious.
•         Very strong verbal and written communication skills.

Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.
In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at