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.
