Data Warehouse Architect

2 weeks ago

Salem, 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:

Bachelors 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 Warehouse Architect

    2 days ago

    Salem, Oregon, United States Stellar Professionals Full time

    Job DescriptionJob Title: Data Warehouse ArchitectWork Arrangement: OnsiteJob Summary:We are seeking a highly skilled Data Warehouse Architect to join our team at Stellar Professionals. As a Data Warehouse Architect, you will be responsible for designing, implementing, and maintaining large-scale data warehouses that support business intelligence and...

  • Data warehouse Architect

    3 days ago

    Salem, United States Stellar Professionals Full time

    Job DescriptionJob DescriptionTitle: Data warehouse Architect Work Arrangement: OnsiteJob Description:We are looking to fill a Long-term Contract role as Datewarehouse Architect in Salem, ORMode of Interview: In person Candidates must create and modify pipelines with a cloud-based Enterprise Resource Planning (ERP) system. The candidate will need experience...

  • Warehouse Supervisor

    3 months ago

    Salem, United States Warehouse Management Full time

    Shift: Compensation:53000Salem, VA $53000 / Annually Shift: Wednesday, Thursday, Friday, and Saturday 5:00 PM-Until work completed Capstone is a North American supply chain solutions partner with over 650 operating locations, 19,000 associates, and 60,000 carriers. We specialize in freight management, warehouse and distribution center support, last-mile...

  • Warehouse Supervisor

    2 months ago

    Salem, Oregon, United States Warehouse Management Full time

    Shift: Compensation:53000Salem, VA$53000 / AnnuallyShift: Wednesday, Thursday, Friday, and Saturday 5:00 PM-Until work completedCapstone is a North American supply chain solutions partner with over 650 operating locations, 19,000 associates, and 60,000 carriers. We specialize in freight management, warehouse and distribution center support, last-mile...

  • Assistant Site Manager

    3 weeks ago

    Salem, United States Warehouse Management Full time

    Shift: Monday-Friday: Must be able to work weekendsCompensation:65000Assistant Warehouse Manager Capstone Logistics is a fast growing, exciting company focused on 3rd party services in distribution centers across the nation. We are in 48 states and over 500 Distribution Centers across the US. We are looking for an Assistant Site Manager to join our team and...

  • Assistant Site Manager

    3 weeks ago

    Salem, Oregon, United States Warehouse Management Full time

    Shift: Monday-Friday: Must be able to work weekendsCompensation:65000Assistant Warehouse ManagerCapstone Logistics is a fast growing, exciting company focused on 3rd party services in distribution centers across the nation. We are in 48 states and over 500 Distribution Centers across the US. We are looking for an Assistant Site Manager to join our team and...

  • Salesforce Architect

    4 weeks ago

    Salem, United States Stellar Professionals Full time

    Job DescriptionJob DescriptionTitle: Salesforce Architect We are looking to fill a Long-term Contract role as Lotus Domino Developer in Salem, ORMode of Interview: In person Work Arrangement: OnsiteApplicants must have the following experience:5+ years of experience as a Salesforce Technical Architect with at least 2-3 years exp working in the Vlocity / Omni...

  • Solutions Architect

    3 days ago

    Salem, United States Stellar Professionals Full time

    Job DescriptionJob DescriptionJob Description:We are looking to fill a Long-term Contract role as Solutions Architect in Salem, ORTitle: Solutions ArchitectMode of Interview: In person Work Arrangement: OnsiteResponsibilities: Responsible for the solution architecture and design, as well as delivery estimates, and technology projects to coordinate with...

  • Warehouse Manager

    3 weeks ago

    Salem, United States Path Engineering Full time

    Role As a Warehouse Manager (also known as Distribution Manager, Warehouse Supervisor), you will be responsible for creating a warehouse culture that prioritizes people, safety, service, and cost. You will oversee warehouse operations, manage personnel, ensure safe and accurate product handling, and drive efficiency through the team you lead. Benefits $10k...

  • Technical Solutions Architect

    2 weeks ago

    Salem, Oregon, United States Crescens Full time

    Job Title: Technical Solutions Architect Location: Remote Duration: 3 MonthsJob Overview: Crescens is currently engaged in the transformative phase of enhancing their core application, specifically the juvenile justice information system, utilized by a significant number of end users across various jurisdictions.The existing application operates on an...

  • Warehouse Driver

    3 weeks ago

    Salem, United States Site Acquisitions, LLC Full time

    Job DescriptionJob DescriptionSummary:The Driver / Warehouse Associate will work closely with the warehouse staff to perform and assist with all tasks associated with warehousing and distribution. This position will occasionally require driving a non CDL truck making deliveries and pick-ups (depending on current business needs), as well as warehouse...

  • Warehouse Fulfillment Manager

    2 days ago

    Salem, New Hampshire, United States BJ's Wholesale Club Full time

    Job Summary:BJ's Wholesale Club is seeking a highly skilled Warehouse Fulfillment Supervisor to join our team. As a key member of our operations team, you will be responsible for coordinating daily warehouse activities to ensure timely and accurate order fulfillment.Key Responsibilities:Coordinate daily warehouse operations to ensure efficient and accurate...

  • Database Architect II

    2 months ago

    Salem, United States ACL Digital Full time

    Designs and builds relational databases for data storage or processing. Develops strategies for warehouse implementation, data acquisition, and archive recovery. Cleans and maintains the database by removing and deleting old data. May evaluate new data sources for adherence to the organization's quality standards and ease of integration. May require a...

  • Warehouse Operations Manager

    2 days ago

    Salem, Oregon, United States Capstone Logistics, LLC Full time

    Job SummaryWe are seeking a highly motivated and experienced Warehouse Operations Manager to join our team at Capstone Logistics, LLC. As a key member of our operations team, you will be responsible for overseeing the daily activities of our warehouse and distribution center, ensuring that all operations are running smoothly and efficiently.Key...

  • Mainframe Storage Solutions Architect

    1 week ago

    Salem, Oregon, United States State of Oregon Full time

    Job Overview: Join Our Team as a z/OS Storage Systems Architect / Systems ProgrammerThe Enterprise Information Services (EIS) division is a pivotal state government organization dedicated to information technology (IT) management across Oregon. Led by the State Chief Information Officer (CIO), EIS ensures effective governance of IT resources, strategic...

  • Enterprise Architect

    2 weeks ago

    Salem, United States Stellar Professionals Full time

    Job DescriptionJob DescriptionTitle: Enterprise Architect Work Arrangement: OnsiteJob Description:We are looking to fill a Long-term Contract role as Enterprise Architect in Salem, ORMode of Interview: In person Applicants must have a minimum of the following relevant experience with the following:Mandatory Skills:8+ years of leading software development...

  • Principal Integration Architect, Enterprise

    1 month ago

    Winston-Salem, United States Forsyth Barnes Full time

    Title: Principal Integration Architect, EnterpriseLocation: Winston-Salem, North CarolinaIndustry: RetailSalary: $200,000 + Bonus + BenefitsOverview:We have partnered with a global retail organization seeking a Principal Enterprise Architect, to join their expanding team. We are looking for an industry thought leader to create, publish, and communicate the...

  • Azure Data Engineer

    4 days ago

    Salem, United States InnovitUSA Full time

    Job DescriptionJob DescriptionAzure Data EngineerOnsiteHybridEither Webcam or In Person Interview Tax Terms: C2C,W2 And 1099Skills: Snowflake, DBT, Python, Azure Overall, 10-12 years' experience as Data Engineer on the Microsoft Azure cloud platform Snowflake (Columnar MPP Cloud data warehouse), DBT (ETL tool), Python Deep experience with SQL, database...

  • Warehouse Supervisor

    4 weeks ago

    Salem, United States Capstone Logisitcs Full time $53,000 - $55,000

    Job DescriptionJob DescriptionWarehouse SupervisorSalem, VAShift: Wednesday, Thursday, Friday, and Saturday 5:00 PM-Finish Salary Range: $53K-$55K Capstone is a North American supply chain solutions partner with over 650 operating locations, 19,000 associates, and 60,000 carriers. We specialize in freight management, warehouse, and distribution center...

  • Manager, Night Warehouse

    3 weeks ago

    Salem, United States US Foods Full time

    Job Description Summary:The Manager, Warehouse will ensure a warehouse culture focused on people, safety, service, and cost through meaningful engagements with warehouse associates, best in-class service to customers, and safe and profitable operations. They will use their experience in warehouse operations to manage personnel and drive efficient warehouse...