Careers Center - Data Warehouse Solution Architect
Data Warehouse Solution Architect
DeVry Education Group
More information about this job:
Opportunity at a Glance:
As a Data Warehouse Solution Architect you are responsible for designing, developing, testing, tuning and deploying solutions in support of the company’s enterprise data warehouse and operational data stores. You will work closely with business partners, ETL developers, report developers, and other solution architects to deliver enhancements and new functionality consistent with project deadlines and service level agreements. You will utilize your combination of business acumen, technical skills and people skills to help define, guide, and implement data warehousing strategy.
Work with business partners to understand the business requirements and business processes
Design data warehouse schema and define Extract/Translate/Load (ETL) processes for the data warehouse
Provide direction for diverse and complex initiatives and be accountable for a variety of tasks to architect and deliver data warehousing solutions
Provide proactive recommendations for improving the performance and operability of the data warehouse and reporting environment
Participate in the development and championing of advanced data techniques, including data modeling, data access, data integration, data discovery, database design and implementation
Provide assistance to data warehouse team members with issues requiring technical expertise or knowledge of complex systems and/or programming
Provide on the job training for new or less experienced team members
Provide day to day support for the data warehouse environment
Completes other duties as assigned.
Bachelor’s degree in Computer Science, Information Systems or similar fields
5+ years of data warehouse design and development as an ETL architect, data warehouse developer, data warehouse architect or a similar role
Proven knowledge of SQL and an understanding of database structures enabling research and discovery
Proven experience in dimensional data modeling (such as star schemas, snowflakes, normalized and de-normalized models) and handling slowly changing dimensions and attributes
In depth knowledge of relational databases structures and design – experience with Oracle 10g and higher preferred
Experience with data modeling tools (ER/Studio, Erwin, etc…)
Strong analytical and problem solving skills
Outstanding verbal, written and visual presentation skills
Proven consensus building abilities
Ability to work independently, establishing objectives, project plans, and milestone goals
Experience providing practical direction on information and analytics platforms in conjunction with data warehouse tools and technologies
Experience analyzing complex source systems and data structures
Ability to interact with all levels of the organization and work in a fast paced environment
We are proud to be an EEO employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing. Thank you for applying for this outstanding opportunity today.
Who We Are:
Since our founding in 1931, DeVry University has focused on delivering a different kind of education – one based on experiential learning with real-world applications. When you join our team, you’re choosing an institution that serves students who are different, too: a diverse group of go-getters from all walks of life.
We know our colleagues are integral to the success of the institution. At DeVry, we’re guided by our culture of care, and we embrace values that teach us to care for students, self and colleagues. It’s one way we position our colleagues for success.
We are looking for engaged, caring colleagues to join our organization in serving our students. We take extra pride in our dedicated support teams, as well as our outstanding faculty members who have often worked for years in the fields that they teach. We believe all our colleagues deserve opportunities to reach their goals. Whether it’s career advancement, maintaining a healthy lifestyle or saving for retirement, our comprehensive benefits and professional development offerings can help you meet your goals.
If you want to be a part of an institution focused on providing high-quality education, care and attention, we invite you to apply for a position today.
If you are an Alumnus of the DeVry Education Group institutions, please log in to our Alumnus page to apply for opportunities.
If you are a current colleague of any of DeVry Education Group's institutions, please log in to the The DeVry Commons to apply for internal opportunities. Please note that only current employees of DeVry Education Group will be able to log in using this link.