Data Warehouse Architect

2 months ago

Dover, United States Winland Foods Full time

The Data Warehouse Architect has the responsibility to drive and coordinate the technical execution of enterprise data warehouse solutions and services that includes understanding business requirement, solution design, Data Extraction, Transformation and Integration architecture, development, testing, deployment and ongoing operational support. The DW Architect will assist in project execution and engage directly with project technical staff and Business stakeholders. This role is responsible to provide technical & functional leadership on data warehouse solutions.

Employee Type:

Full time

Location:

US Works from Home

Job Type:

Information Technology

Job Posting Title:

Data Warehouse Architect

Job Description:

Requirements & Analysis Responsibilities (30%)

  • Elicit requirements from business users, create work breakdown structure, plan and execute deliverables

  • Responsible to investigate, Analyze and understand data contents of source data systems

  • Understands, uses and adheres to dimensional modeling techniques for data warehouse design

  • Research, evaluate, identify alternative approaches, recommend, design and code efficient and effective solutions for challenging problems ranging from small to large work efforts for low to high complexity problems

  • Define/Improve coding standards, comply with standards and guidelines related to the design, construction, testing and deployment activities as established by departmental and organizational standard

  • Demonstrate collaborative skills working within a project team of diverse skills and will bring communication skills including oral, written and presentation skills, creativity, and problem-solving skills to a challenging environment

  • Understands dependencies and timing issues between source systems and data warehouse operations

  • Works directly with business process experts, Business Managers, BI Analysts, and IT Leadership to understand requirements for data warehouse development projects

  • Identify opportunities in processes, system capabilities and delivery methodologies for continuous improvement as applicable to bring DW operations more matured.

  • Must be able to drive DW initiatives for a certain subject area independently without any guidance.

Design and Solution Blueprint Responsibilities (40%)

  • Data warehouse dimensional modeling/design and documentation.

  • Design Data Architecture for DW components

  • Drive UAT activities with business partners to ensure solutions meet business requirements.

  • Lead DW/BI initiatives from ideation to completion

  • Ensures standard data elements are maintained across all data structures in DW

  • Define, Develop and lead implementation of long-term Strategy and road map for Data Warehousing, Data Science & ML

Development and Support Responsibilities (30%)

  • ETL development and testing using tool like SSIS, Azure Data Factory, Talend or Future technologies based on Roadmap

  • SQL Server / Snowflake Query, DDL/DML scripting

  • SAP Business Object Data Services understanding and configuration

  • Unix/Linux Shell Scripting

  • Some Power BI understanding

  • Upon notification of a problem during “off-hours”, will stay with that problem to resolution unless the problem has been handed off to another support person who agrees to take responsibility for said problem.

  • If an “off-hours” problem cannot be resolved, it will then be escalated to the appropriate staff resource.

Qualifications and Requirements:

  • Bachelor’s Degree Required – Type: Information Technology, Computer Science or related field

  • 9+ years of full Software Development Life Cycle experience

  • 7+ years practical experience with any ETL tool with complex transformation business rules implementation. 3+ years’ experience with SSIS or ADF, Talend.

  • 1+ year of experience in implementing and supporting DW in any cloud platform.

  • 3+ years practical experience with writing SQL queries including complex queries

  • 5+ years practical experience working on data warehouse projects using dimensional modeling

  • Ability to analyze the existing SSIS Code for improvements, enhancements, conversion and problem solving

  • Demonstrated ability in collecting and documenting requirements

  • Strong troubleshooting capability/skills

  • Strong communication and presentation skills both verbal and written

  • Ability to execute data warehouse tasks in a timely manner without any guidance

  • Ability to lead walk through of design documents

  • Must possess the ability and willingness to learn, as well as the ability to participate and contribute in a team environment.

  • Project Management and SDLC understanding is required

  • Travel expectations 10-25%

Preferred Attributes:

  • Experience with Data Warehouse Design/Development in Manufacturing company

  • Experience in using SAP ERP as source system

  • Experience in Cloud DW – snowflake and Azure Cloud Platform using Azure Data Factory, Talend, Fivetran/dbt or Matillion

  • Uses previous experience to identify most appropriate solutions or improve defined procedures

  • Has the ability and willingness to work with users of all levels to identify requirements and deliver timely results

EEO Statement:

Winland Foods believes that diversity and inclusion among our teammates is critical to our success as a global company, and we seek to recruit develop, and retain the most talented people from a diverse candidate pool. Winland Foods is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates without regard to race, color, religion, sex, pregnancy, national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information, military and veteran status, and any other characteristic protected by applicable law.

Winland Foods is a leading private label food manufacturer of pasta, dry dinners, condiments, syrups, and more with nearly 3,000 employees operating out of 14 production facilities in US, Canada, and Italy.

As a ‘newly’ established company, we are creating the building blocks for an innovative and agile organization that is purpose driven - delivering high quality food to our customers and communities. We foster an environment that encourages all employees to be heard, and values their contributions and ideas.

By joining Winland Foods, you become a part of a new team that values passion, collaboration, and strives to prosper with our customers.

To all recruitment agencies: Winland Foods does not accept unsolicited agency resumes/CVs. Please do not forward resumes/CVs to Winland Foods employees, or any company location(s). Winland Foods is not responsible for any fees related to unsolicited resumes/CVs.

  • Data & BI Analyst II

    3 weeks ago

    Dover, Delaware, United States Chesapeake Utilities Corporation Full time

    Position: Data & BI Analyst IILocation: Hybrid with minimum of 3 days a week in Newark, DE The Company is looking for a Data and BI Analyst II to be a key member of our Business Intelligence and Analytics team. The successful candidate will build and maintain strong relationships with business partners, while supporting the company's analytic capabilities...

  • Data & BI Analyst II

    3 weeks ago

    Dover, United States Chesapeake Utilities Corporation Full time

    Description Position: Data & BI Analyst II Location: Hybrid with minimum of 3 days a week in Newark, DE   The Company is looking for a Data and BI Analyst II to be a key member of our Business Intelligence and Analytics team.  The successful candidate will build and maintain strong relationships with business partners, while supporting the...

  • Senior Solution Delivery Architect

    3 days ago

    Dover, United States Ensono Full time

    Senior Solution Delivery Architect – MF HardwareRemote - United StatesJR010392 The Senior Solution Delivery Architect will be responsible for configuration of mainframe hardware equipment such as HCD and IOCP. During new client migrations, the Systems Programmer will be a point person for configuring client environments within Ensono data centers to mimic...

  • Data Engineering Manager, Analytics

    3 months ago

    Dover, United States META Full time

    Summary: Do you want to use data to help drive the direction of products that impact the lives of over 1 billion people every day? If yes, we want to talk to you. We're looking for a leader in our Data Engineering team to work closely with Product Managers, Data Scientists and Software Engineers to support product launches and roadmaps by building the data...

  • DIRECTOR, DATA ENGINEERING

    3 weeks ago

    Dover, United States Capital One Full time

    Center 3 (19075), United States of America, McLean, VirginiaDirector, Data EngineeringCapital One is seeking a Director of Data Engineering for our Data Management Services Program Team. This individual will be accountable to drive a cohesive data strategy in collaboration with multiple enterprise partners. This role will build teams to deliver highly...

  • DIRECTOR, DATA ENGINEERING

    2 weeks ago

    Dover, United States Capital One Full time

    Center 3 (19075), United States of America, McLean, VirginiaDirector, Data EngineeringCapital One is seeking a Director of Data Engineering to work in our Enterprise Data organization. This individual will be accountable to drive a cohesive data strategy across Enterprise Data in collaboration with multiple enterprise partners. This role will build teams to...

  • Database Administrator

    3 weeks ago

    Dover, United States Inteliblue Full time

    Job DescriptionJob DescriptionThis is a very urgent requirement with immediate placement, please apply for immediate consideration.No Corp to Corp candidates - only W2 or 1099 candidates.Job Title: Database AdministratorLocation: Dover, DelawareInterview: Phone/In-PersonDuration: Long TermRequired Skills:: SQL, ETL, Data mapping, Data Warehouse, .NET, C#,...

  • Database Administrator

    3 weeks ago

    Dover, United States Motion Recruitment Full time

    Our Client, a state government, is looking for someone to join their team as a Database Administrator!!***This is a remote 10-month contract position that takes place in Dover, DE***What You Will Be DoingHighly skilled at data/database conversions including data mapping, extract, transformation and load (ETL) of data following technical specifications...

  • Database Administrator

    2 weeks ago

    Dover, United States Motion Recruitment Full time

    Our Client, a state government, is looking for someone to join their team as a Database Administrator!!***This is a remote 10-month contract position that takes place in Dover, DE***What You Will Be DoingHighly skilled at data/database conversions including data mapping, extract, transformation and load (ETL) of data following technical specifications...

  • Driving Pharmacy Clerk

    4 weeks ago

    Dover, United States Optum Full time

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data, and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion,...

  • SQL Database Administrator

    3 weeks ago

    Dover, United States Morph Enterprise Full time

    Essential Functions1. Highly skilled at data/database conversions including data mapping, extract, transformation and load (ETL) of data following technical specifications documents and in accordance with State of Delaware policies2. Experience and knowledge in supporting application system development life cycle3. Proficiency in developing and maintaining...

  • SQL Database Administrator

    3 weeks ago

    Dover, United States Morph Enterprise Full time

    Job DescriptionJob DescriptionTitle: Database Administrator 3/Data Conversion Lead Remote: 1 in-person meeting a month in Dover, Delaware Interview: Online The candidate will provide expert level guidance in data conversion, data mapping and analysis. The candidate will be responsible for extract, transformation and load (ETL) of data from multiple data...

  • Delivery Driver

    2 months ago

    Dover, United States United Electric Supply Full time

    Job DescriptionJob Description Delivery Driver - DOVER, DEWho we are: United Electric Supply Co. Inc. is a nationally recognized, 100% employee-owned company that is a major supplier of electrical products, and advanced services for the construction and industrial markets. They offer a full range of electrical products and services with concentrations in...

  • Senior .NET Software Engineer

    4 days ago

    Dover, New Jersey, United States Link Solutions Full time

    Join Link SolutionsWe are excited to announce an opening for a Senior .NET Software Engineer to become a vital part of our innovative team.Must be a US CitizenActive Public Trust clearance is mandatoryHybrid Work Model: 4 days onsite, 1 day remoteThe selected candidate will play a crucial role in our development initiatives, enhancing the capabilities of the...

  • Supply Planning Manager

    1 month ago

    Dover, United States Envision Full time

    ATTENTION LEADERS!!!If you are a manager of people and Supply Planning, we have your new job waiting for you. We are only considering candidates that are local to the Dover, DE area. This is a hybrid role.US Citizens or Green Card holders only.What we are looking for. Top skillsets: *Demonstrated expertise in Supply Planning & Analysis *SAP and JDA/Blue...

  • Supply Planning Manager

    1 month ago

    Dover, United States Envision Full time

    ATTENTION LEADERS!!!If you are a manager of people and Supply Planning, we have your new job waiting for you. We are only considering candidates that are local to the Dover, DE area. This is a hybrid role.US Citizens or Green Card holders only.What we are looking for. Top skillsets: *Demonstrated expertise in Supply Planning & Analysis *SAP and JDA/Blue...

  • 25-016 Fire/Life Safety Inspector

    3 days ago

    Dover, United States City of Dover Full time $29 - $42

    Job DescriptionJob DescriptionThe Planning Director is seeking an individual to perform a variety of routine and complex technical work associated with the inspection and enforcement of established fire and life safety related ordinances, codes and standards. To assist in securing mitigation of fire and life safety related hazards by contacting and...

  • Counter Sales

    2 months ago

    Dover, United States United Electric Supply Full time

    Job DescriptionJob DescriptionCOUNTER SALES REPRESENTATIVEWho we are:United Electric Supply Co. Inc. is a nationally recognized, 100% employee-owned company that is a major supplier of electrical products, and advanced services for the construction and industrial markets. They offer a full range of electrical products and services with concentrations in...

  • Counter Sales

    3 months ago

    Dover, United States United Electric Supply Full time

    Job DescriptionJob DescriptionCOUNTER SALES REPRESENTATIVEWho we are:United Electric Supply Co. Inc. is a nationally recognized, 100% employee-owned company that is a major supplier of electrical products, and advanced services for the construction and industrial markets. They offer a full range of electrical products and services with concentrations in...

  • SENIOR MANAGER, INFORMATION SECURITY OFFICE

    3 weeks ago

    Dover, United States Capital One Full time

    Center 3 (19075), United States of America, McLean, VirginiaSenior Manager, Information Security Office (ISO) Assurance Team LeadAt Capital One, you will help consult on initiatives, programs, and projects to raise their game in Information Security. You are pragmatic and practical in your understanding of risk and security, but also willing to know when to...