WilmingtonRecruiter Since 2001
the smart solution for Wilmington jobs

IT Solution Architect

Company: Nesco Resource
Location: Wilmington
Posted on: January 16, 2022

Job Description:

Manufacturing Reporting & Analytics DWH Solution Architect IT MFG Service Line Overview Non-Exempt DWH Solution Architect will be a key member of the Manufacturing Analytics & Reporting team collaborating with key stakeholders to translate business data requirements into solutions that integrate data from multiple plant floor systems into data warehouses. This role requires extensive knowledge of data warehousing principles with ability to build out solutions encompassing all phases of the data warehouse/Business Intelligence development lifecycle from strategic planning, requirements gathering, ETL design, development of solution to production deployment and support. Role also requires establishing and developing best practices to scale solutions to multiple manufacturing facilities. Responsibilities Be able to serve as lead designer and developer for all ETL activities and BI solutions Collaborate with stakeholders to identify, create, and deliver solutions according to business requirements Design and support development efforts to produce integrated, near-real-time data warehouse solutions. Assist ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities Define metadata governance and best practices to ensure accuracy, validity, reusability and consistency of the data warehouse Create and maintain data models; Identify/Detect data discrepancies and data quality issues and provide solutions Define solution architectures, design standards, and quality assurance policies and procedures. Foster close relationships with business personnel and development team to understand changing business requirements and drive adoption of best practices established Work closely with project team to ensure that the end to end design and delivered solution meets business and data requirements and performance around user experience Create Dashboard and visualization using BI tools Develop and support unit and integration test activities and assist with User Acceptance Testing Document all technical and system specifications for ETL and Data Warehouse processes Collaborating with other teams such as DBAs to continually fine tune solutions and put appropriate monitoring in place to ensure quality, reliability and performance Education & Experience BS/MS degree preferably in Information Management, Computer Science, Engineering or other related fields 10+ years of designing, developing, and implementing ETL and Data Warehouse solutions 5+ years of experience working with manufacturing execution systems, inspection and metrology systems Hands on experience working with large scale data and analytics systems Hands on experience with SQL, reporting and BI systems such as PowerBI, Qlik or Tableau Hand on experience with ETL tools e.g. SSIS Strong experience with development in Microsoft BI tools (SSRS, SSAS, SSIS, SQL Server) Strong experience with Cloud Based Technologies (Microsoft Azure, Databricks) Technical expertise in data warehousing, data models, and database design Willing to be on off hours call on a rotational basis. Other Qualifications 5+ years of programming experience with a high-level language such as Python 3+ years working with scripting and automation system Strong relationship building, technical collaboration and communication skills Proven success working in highly matrix environment Excellent analytical and decision-making abilities Must demonstrate a proven willingness to go the extra mile, to take on the things that need to be done and maintain a positive attitude that can adapt to change. Strong leadership and excellent verbal and written communications skills, with the ability to develop and sell ideas Nesco Resource and affiliates (Lehigh G.I.T Inc, and Callos Resource, LLC) is an equal employment opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or veteran status, or any other legally protected characteristics with respect to employment opportunities.

Keywords: Nesco Resource, Wilmington , IT Solution Architect, Other , Wilmington, North Carolina

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest North Carolina jobs by following @recnetNC on Twitter!

Wilmington RSS job feeds