Analyst, Data Warehouse (Architecture) - Information Technology (IT)

Analyst, Data Warehouse (Architecture) - Information Technology (IT) Join to apply for the Analyst, Data Warehouse (Architecture) - Information Technology (IT) role at Jones Day Analyst, Data Warehouse (Architecture) - Information Technology (IT) Join to apply for the Analyst, Data Warehouse (Architecture) - Information Technology (IT) role at Jones Day This position is available in multiple Jones Day offices, click apply to find out more. Jones Day is a global law firm with 40 offices in major centers of business and finance throughout the world. Covering 19 countries on five continents, our unique governance system fosters an unparalleled level of integration and contributes to our ranking as one of the best in the world in client service. Jones Day seeks to employ the most qualified people, capable of delivering superior client service through professional excellence and teamwork, for every position in the Firm. We offer competitive compensation and benefits in a stimulating work environment. Are you interested in the opportunity to work for a global leading law firm that will give you the experience and exposure you need to build your knowledge and skills as well as advance your career? If you are, then Jones Day may be the firm for you. Summary of Essential Duties and Responsibilities: The Data Warehouse (Architecture) Analyst works under the direction of the Data Services Manager and is responsible for analyzing end-user data warehousing requirements, promoting awareness, and understanding of the data available in the data estate, defining and implementing data quality assurance processes and assisting in the creation of standard data architecture including dimensional model design. The Data Warehouse Analyst is responsible for monitoring data warehouse loads during periods when successful loads are a requirement (e.g., Year End), working weekends, second shift and/or third shift, as necessary. The Analyst will have the ability to carry out assigned tasks with limited need for supervision and work well in a fast-paced, agile, and fluid environment. The Analyst will possess strong problem-solving skills and a strong attention to detail. The Data Warehouse Analyst works in a constantly evolving and rapidly changing hardware and software technology hybrid cloud environment. The individual will be responsible for maintaining and upgrading skills through ongoing training, education, and self-study. The Analyst must be able to work and communicate with team members, and work on multiple tasks in parallel with changing priorities and periodic stress-oriented situations. Travel and additional hours may be required as necessary including regular on-call monthly support rotations. Required Qualifications: Bachelor's degree or equivalent work experience. Minimum five (5) years of work-related experience including two (2) years of experience in positions with similar levels of responsibility. Minimum five (5) years of work experience with T-SQL database development. Minimum three (3) years of work experience with SSIS and/or ADF data orchestration development and support. Minimum three (3) years of work experience with Power BI development (DAX, Semantic Model & Dashboard Design) and platform administration support. Minimum two (2) years of work experience with dimensional model designs across different lines of business. Minimum one (1) year of work experience with Azure Databricks preferred. Jones Day is an Equal Opportunity Employer Seniority level Seniority level Mid-Senior level Employment type Employment type Full-time Job function Job function Legal and Information Technology Industries Law Practice and IT Services and IT Consulting Referrals increase your chances of interviewing at Jones Day by 2x Inferred from the description for this job Medical insurance Vision insurance 401(k) Get notified when a new job is posted. Sign in to set job alerts for Data Warehouse Analyst roles. Business Data Analyst / Fully remote / SQL Business Data Analyst / Fully remote / SQL Houston, TX $90,000.00-$115,000.00 2 days ago Greater Houston $110,000.00-$150,000.00 5 days ago Business Tax Analyst- Work From Home - 3+ Yrs Paid Tax Experience Required We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr