Data Warehouse Engineer
Dell Technologies creates technology solutions for a changing world. Our IT Architecture team translates our customers’ business requirements into total enterprise-wide solutions. It takes deep technical knowledge to create architectural designs that exceed service requirements. We’re skilled in analyzing the customer’s business goals, objectives, needs and general business environment to create technical system solutions. Our expertise includes integrating hardware, processes, methodologies and software into the customer environment.
Join us to do the best work of your career and make a profound social impact as a IT Architect on our Teneo Data Warehouse team (Dell application for Apex Custom Solutions) 100% remote.
What you’ll achieve
As an IT Architect for our date warehouse project, you will be responsible for designing bus matrixes, building and maintaining ETL packages, and consulting with technical users to create star schemas necessary to support the... business reporting needs. You will work with report writers, business SMEs, and other developers to ensure a stable and comprehensive reporting platform.
• Design, create, and maintain star-schemas
• Build and ensure efficient nightly ETL package are completed successfully
• Consult with SMEs to correct data inconsistencies and/or add new data elements as needed
• Work with report writers to help them understand how to make the best use of the data warehouse
Take the first step towards your dream career
Every Dell Technologies team member brings something unique to the table. Here’s what we are looking for with this role:
• 2 years experience creating, working with, and troubleshooting SSIS packages
• 4 years of experience working with relational databases (MSSQL preferred)
• 1 year of experience designing star-schemas
• Proven ability to write SSRS reports using embedded SQL and stored procedures
• Experience working with MS PowerBI server and creating PowerBI reports
• Experience using SSAS to create cubes
• Understanding of how to protect data based on user permissions
Here’s our story; now tell us yours
Dell Technologies helps organizations and individuals build a brighter digital tomorrow. Our company is made up of more than 150,000 people, located in over 180 locations around the world. We’re proud to be a diverse and inclusive team and have an endless passion for our mission to drive human progress.
What’s most important to us is that you are respected, feel like you can be yourself and have the opportunity to do the best work of your life -- while still having a life. We offer excellent benefits, bonus programs, flexible work arrangements, a variety of career development opportunities, employee resource groups, and much more.
We started with computers, but we didn’t stop there. We are helping customers move into the future with multi-cloud, AI and machine learning through the most innovative technology and services portfolio for the data era. Join us and become a part of what’s next in technology, starting today.
You can also learn more about us by reading our latest Diversity and Inclusion Report and our plan to make the world a better place by 2030 here.
Application closing date: 01 June 2021
Dell is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at Dell are based on business needs, job requirements and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. Dell will not tolerate discrimination or harassment based on any of these characteristics. Dell encourages applicants of all ages. Read the full Equal Employment Opportunity Policy hereRead more