Offer summary

Qualifications:

Bachelor’s degree or equivalent work experience., Minimum five years of work-related experience, including two years in similar roles., Proficiency in T-SQL database development and experience with SSIS and/or ADF data orchestration., Experience with Power BI development and dimensional model designs across various business lines..

Key responsibilities:

Analyze end-user data warehousing requirements and promote data awareness.

Define and implement data quality assurance processes.

Monitor data warehouse loads and work during critical periods as needed.

Maintain and upgrade skills through ongoing training and support multiple tasks in a fast-paced environment.

Job description

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

Required profile