Datawarehouse Data Architect - Data & Analytics team (remote / Costa Rica- or LATAM-based)

Hitachi Solutions is a global Microsoft solutions integrator passionate about developing and delivering industry-focused solutions that support our clients to deliver on their business transformation goals. Our industry focus, expertise, and intellectual property is what truly sets us apart. We have earned, and continue to maintain, a strategic relationship with Microsoft. Recognized for our achievements - teaming with our clients to deliver innovative digital solutions and services - is how we have achieved year after year recognition.

As their trusted advisor, we support our clients to deliver on their strategic business initiatives as they unify, automate, and modernize their data and operations to increase efficiency, reduce costs, and enhance their customer’s experience. Our over 3,000 team members across 14 countries, and our 18 years of 100% focus on Microsoft technologies and business applications, is how we deliver excellence through expert services and industry-focused cloud solutions.

A part of Hitachi, Ltd., our company has a long and rich history of innovation, financial strength, and international presence of one of the world’s largest companies. Since 1910, Hitachi, Ltd. has been a leader in manufacturing innovative products and solutions that support industry and social infrastructure around the globe supported by over 300,000 employees in more than 100 countries and across 800+ companies.

Please note: Although this is a Remote / Virtual opportunity candidates MUST reside, and be authorized to work without sponsorship, in Costa Rica. Candidates in other Latin America (LATAM) countries can be considered as an employee if willing to relocate to Costa Rica or can work via our 3rd party payroll company.

This is a full-time role in our Data & Analytics organization for professionals with a proven history of execution, and a desire to rapidly expand a product organization. Our team is seeking DW/Data Architects, with a strong background in data definition, modeling, and implementation.

This is a hands-on architect role where the individual will be responsible for the overall design of solutions within the data ecosystem serving our customers. This role will require someone who is experienced in designing data schemas using Kimball/Dimensional modeling and pipelines in Databricks for data warehouses/lakehouses and reporting systems, is able to evaluate multiple technologies and technical solutions, and be a hands-on contributor for engineering goals for multiple engineering teams. Additionally, as a technical leader within the team, you will mentor and coach your team members; therefore, top candidates have experience as either a team lead or manager.

Responsibilities:

• Scope and execute with independence. Work with the product team to understand platform capabilities and leverage those capabilities to bring customer’s data estate.
• Identify and articulate technical and operational requirements for data pipelines and the models they populate; be able to optimize these pipelines for high performance/resiliency workloads.
• Instill excellence into the processes, methodologies, standards and technology choices embraced by the team with customer teams, and junior staff.
• Lead requirements discovery and delivery workshops – helping customers understand their options and guiding them to the best options.
• Be an advocate for the customer, and support delivery leadership (Director, VPs) in managing client expectations.
• Dedicate time to continuous learning to keep the team and customers appraised of the latest developments in the space.
• A committed teacher and someone who enjoys developing technical maturity across the company.
• Experience supporting analytics, data science and/or engineering teams and understand their unique needs and challenges.

• 8+ overall years of professional experience including 2+ years’ experience in designing high-scale Kimball/Dimensional models is REQUIRED
• 2+ years of experience with data modeling, schema design patterns and modern data access patterns (including API, streams, data lake) is REQUIRED
• 2+ years as a proven leader interacting with customers (client facing) to collect requirements and manage a technical data backlog is REQUIRED; therefore you must have excellent interpersonal skills, both written and spoken, as well as a consultative/collaborative style.
• 2+ years with Databricks and Spark framework are highly desired
• 2+ years of experience building data applications, microservices and/or APIs using Python, Scala or an equivalent language is REQUIRED
• 2+ years of experience with SQL, knowledgeable in complex queries and joins is REQUIRED; experience with UDF and/or Stored Procedure development is highly desired
• 2 + years Azure Data Services including Azure Data Factory, ADLS, and Synapse is highly desired; strong experience with AWS, GCP or other cloud experience will be considered in lieu of.

#LI-CA1

#azure

#datawarehouse

#datalakehouse

#databricks

#datamodeling

We are an equal opportunity employer. All applicants will be considered for employment without attention to age, race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

All your information will be kept confidential according to EEO guidelines.

Beware of scams

Our recruiting team may communicate with candidates via our @hitachisolutions.com domain email address and/or via our SmartRecruiters (Applicant Tracking System) notification@smartrecruiters.com domain email address regarding your application and interview requests.

All offers will originate from our @hitachisolutions.com domain email address. If you receive an offer or information from someone purporting to be an employee of Hitachi Solutions from any other domain, it may not be legitimate.