Jones Day

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

HOUSTON, TXPosted 25 days ago

Job summary

  • Job post source

    This job is directly from Jones Day

  • Job overview

    The Analyst, Data Warehouse (Architecture) role at Jones Day involves analyzing data warehousing requirements and supporting data architecture to enhance data quality and accessibility within the firm.

  • Responsibilities and impact

    The analyst will analyze end-user data needs, promote data awareness, define data quality processes, create standard data architecture, monitor data warehouse loads especially during critical periods, and support the data environment in a fast-paced setting with potential off-hours and on-call duties.

  • Compensation and benefits

    The job offers competitive compensation and benefits in a stimulating work environment, typical for a global law firm.

  • Experience and skills

    Candidates need a bachelor's degree or equivalent experience, at least five years of related work experience including T-SQL development, experience with SSIS or ADF, Power BI development and administration, dimensional model design, and preferably some experience with Azure Databricks.

  • Career development

    The role provides opportunities to build knowledge and skills in a global leading law firm with exposure to evolving technology and ongoing training.

  • Work environment and culture

    Jones Day promotes professional excellence, teamwork, and a stimulating work environment with a global presence and integrated governance.

  • Company information

    Jones Day is a global law firm with 40 offices across 19 countries, known for its client service excellence and unique governance system.

  • Job location and travel

    The position is available in multiple Jones Day offices worldwide, with details provided upon application.

  • Unique job features

    The role involves working in a hybrid cloud environment with evolving hardware and software technologies, requiring adaptability and strong problem-solving skills.

Company overview

Jones Day is a global law firm known for its expertise in a wide range of legal services, including litigation, mergers and acquisitions, and regulatory matters. The firm generates revenue through client fees for legal representation and advisory services across various industries. Established in 1893 in Cleveland, Ohio, Jones Day has grown to become one of the largest law firms in the world, with a presence in major cities across five continents. Notably, the firm has a strong reputation for its client-focused approach and its involvement in high-profile cases and significant corporate transactions.

How to land this job

  • Tailor your resume to emphasize your expertise in T-SQL database development, SSIS or ADF data orchestration, and Power BI development, showcasing your ability to design semantic models and dashboards that align with Jones Day's data warehouse architecture needs.

  • Highlight your experience with dimensional model design and your familiarity with hybrid cloud environments, especially any exposure to Azure Databricks, to match the evolving technology landscape described in the job.

  • Apply through multiple platforms including Jones Day's official corporate career site and LinkedIn to maximize your application visibility and ensure you do not miss any location-specific openings.

  • Connect with current employees in the Data Services or IT divisions at Jones Day on LinkedIn, using ice breakers such as commenting on recent data initiatives by the firm or asking about their experience working in a global law firm's data environment to build rapport.

  • Optimize your resume for ATS by incorporating keywords like 'data warehousing,' 'T-SQL,' 'SSIS,' 'ADF,' 'Power BI,' 'dimensional modeling,' and 'Azure Databricks' to pass automated screenings effectively.

  • Utilize Jennie Johnson's Power Apply feature to automate tailored applications, identify multiple application channels, and discover LinkedIn contacts for networking, allowing you to focus your time on preparing for interviews and skill development.

Jennie Johnson works for you!

Here’s what we do to make sure you’re successful:

  • Targeted Resume Revamp:

    We expertly craft your resume to navigate Applicant Tracking Systems (ATS) and showcase your qualifications, making you stand out as a top-tier candidate.

  • Job Description Dissection:

    Unpack the job posting with expert analysis, ensuring your application hits every key requirement.

  • Bespoke Cover Letter:

    Capture the attention of hiring managers with a personalized cover letter that highlights how your skills align perfectly with the job's needs.

  • Interview Mastery:

    Prepare for interviews like a pro with likely questions, strategic answers, and insightful questions for you to ask, setting you apart as an informed candidate.

  • Direct Application Insights:

    Receive tailored advice on the best places to apply, ensuring your applications are seen by the right employers.

  • Skills and Gaps Assessment:

    Identify and close critical skills gaps to position yourself as the best-fit candidate for your ideal job.

  • Personalized Email Pitch:

    Make a memorable first impression with an email template crafted to engage potential employers and initiate meaningful conversations.

  • In-depth Research Guide:

    Leverage comprehensive research tools to gather effective insights on companies, industry trends, and role-specific challenges.

  • Detailed Company Analysis:

    Gain in-depth understanding of your prospective employer, giving you the edge in applications and interviews.

  • Strategic Candidate Overview:

    Understand your unique value and why companies would want to interview you, highlighting your background and positioning.