Search for Data Warehouse Architect roles in Uncasville, CT, requiring a Master's degree in Computer Science, with expertise in ETL tools, offering full-time positions, and with at least 4 years of experience.

Okay, I've searched for Data Warehouse Architect roles in Uncasville, CT, that require a Master's degree in Computer Science, expertise in ETL tools, offering full-time positions, and with at least 4 years of experience. I have found 37 positions for you.

Data Warehouse Architect

Uncasville, CT

Master

ETL

4 years + Experience

Can you help me to analyze the job description and company culture?

Sure. Here's the analysis:

Job Analysis:

The Data Warehouse Architect at Mohegan Sun is fundamentally tasked with designing the enterprise-wide data and information architecture to align with the organization's strategic goals while balancing access, security, and performance. This includes a comprehensive understanding of data modeling, database design, and ETL processes, where the architect will define standards and facilitate consistent data analysis and access. A proactive approach in engaging with senior management to prioritize data needs is critical, as this role will also involve solving complex technical challenges related to business intelligence tools and databases. Success in this position will not only require technical acumen but also the ability to mentor junior staff and optimize business intelligence tools to meet evolving user needs. The candidate will need to navigate a highly dynamic environment that involves strategic problem solving, adhering to privacy regulations, and enhancing data quality metrics to deliver tangible business outcomes. Within the first 6-12 months, performance might be gauged by the successful implementation of a robust data architecture that enhances analytics capabilities and by fostering a culture of data-driven decision-making across the organization.

Company Analysis:

Mohegan Sun, a prominent player in the gaming and entertainment industry, positions itself as a leading destination for a diverse range of services, including gaming, dining, and entertainment. This expansive, luxury facility is not just about the gaming experience but about creating a comprehensive customer environment, making data a pivotal part of its strategy. The company's emphasis on a strong architectural design for its data systems reflects its commitment to integrating innovative technologies that improve user experience and operational efficiency. The culture at Mohegan Sun likely values innovation and agility, as evidenced by its continuous growth and broad array of offerings. The Data Warehouse Architect will fit within a collaborative, cross-functional organizational structure, liaising closely with IT and business leadership, thus possessing significant visibility. As Mohegan Sun seeks to deepen its data capabilities, this role serves as a critical component of its strategy to harness data for better decision-making and customer engagement, making it essential for the occupant to align with the company’s mission of providing outstanding entertainment experiences.

Mock up some interview questions based on the job description.

Absolutely. Here are some mock interview questions that could come up:

Tell me about a time when you had to design a data warehouse architecture from scratch. What challenges did you face and how did you overcome them?
Describe your experience with ETL tools. Can you walk us through a project where you utilized a tool like Informatica?
How do you ensure data quality and integrity within a data warehouse? What processes or metrics do you implement?
Can you give an example of a complex technical problem you encountered related to business intelligence tools and how you resolved it?
How would you approach optimizing the performance of business intelligence tools in an enterprise setting?
What are the key considerations you take into account when developing a data storage strategy for an organization?
Imagine you are faced with a situation where senior management has conflicting data needs from various departments. How would you prioritize these requests?
If a key supplier's data integration fails, disrupting the ETL process, how would you manage the situation?
Why are you interested in working for Mohegan Sun specifically? How do you see your role aligning with our mission?
How do your personal values align with the principles and culture of Mohegan Sun?
What strategies would you propose for training business end users to effectively utilize business intelligence tools?
What do you see as the future trends in data architecture and business intelligence that could impact a company like Mohegan Sun?
What questions do you have for us regarding the challenges or opportunities that the data team at Mohegan Sun is currently facing?
How do you stay current with trends in data architecture and technology, and how would you apply that to our organization?

Job Details

Overview Company

Data Warehouse Architect

Mohegan Sun

2 months ago

Highlight

OnsiteFull-time4+ yearsMid

Summary

Mohegan Sun is seeking a Data Warehouse Architect to join their team in Uncasville, CT. The role involves designing the enterprise-wide data/information architecture, focusing on data modeling, database design, and ensuring data quality and security.

About the Role

As a Data Warehouse Architect, you will be responsible for designing and developing the architecture for all data warehouse components, including tool integration, ETL strategy, data staging, and analytics delivery. You will work with senior management to prioritize data requirements, solve complex technical problems, and optimize business intelligence tools. Additionally, you will develop training curricula for end users and research new technologies to support enterprise-wide BI solutions.

About You

Required:

Master’s degree in Computer Science or Engineering, and four years of progressive IT experience, or a Bachelor’s degree in Computer Science or Engineering, and ten years of progressive IT experience.
Two years’ experience as a Data Warehouse Engineer or equivalent role.
Demonstrated knowledge of business intelligence tools (e.g., Teradata, Unica, SAS, Cognos) and ETL tools (e.g., Informatica).
Ability to obtain and maintain applicable gaming licenses in multiple jurisdictions.

Preferred:

Certifications as required by Mohegan Sun.
Knowledge of COBIT and ITIL.
Expert knowledge of an enterprise-class ETL tool such as Informatica.
Expert knowledge of SQL and the Teradata product suite.
Demonstrated analytical and critical thinking skills.

Benefits

Medical insurance

Mohegan Sun

Mohegan Sun, owned by the Mohegan Tribal Gaming Authority, is one of the largest, most spectacular entertainment, gaming, dining and shopping destinations in the United States. Situated on 185 acres along the Thames River in scenic southeastern Connecticut, Mohegan Sun is home to three unique casinos, a 34-story, 1,200 room luxury hotel, a world-class spa and golf course, over 75 shops, restaurants and bars as well as three award-winning entertainment venues including a 10,000-seat Arena. Mohegan Sun is within easy access of New York, Boston, Hartford and Providence and located 15 minutes from the museums, antique shops and waterfront of Mystic Country. More information is available by calling 1.888.226.7711 or visiting mohegansun.com. Connect with us on Facebook, follow us on Twitter and view us on YouTube.

Uncasville, CT