Data Architect (Snowflake) | Las Vegas, NV

Photon
NV, United States
Full-time

What will you do

Design and develop scalable, high-performance data architectures on the Snowflake cloud data platform to meet the evolving business needs and data growth.

Lead the implementation of Snowflake-based data solutions, including data modeling, schema design, and data integration pipelines.

Optimize data storage, data retrieval, and query performance in Snowflake to ensure the efficient processing of large-scale datasets.

Implement and maintain robust data security practices, including data encryption, role-based access controls, and data privacy measures, to safeguard sensitive information.

Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences.

Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling.

Take ownership of technical solutions from design and architecture perspective for projects in presales phase as well as on- going projects

Design end-to-end data integration architectures using Informatica, considering data sources, data transformation, data mapping, and data delivery to meet business objectives.

Possess a deep understanding of the Informatica platform, including PowerCenter, Data Quality, Master Data Management, and Informatica Cloud, and leverage its capabilities to design efficient and scalable data solutions.

Collaborate with data engineers and data analysts to define data mappings, transformation rules, and data workflows to ensure data accuracy and consistency.

Lead and participate in the development of ETL / ELT workflows using Informatica tools, optimizing data extraction, loading, and transformation processes.

What are we looking for?

Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.

Proven experience as a Data Architect or similar role, with a focus on cloud-based data solutions.

In-depth knowledge of Snowflake cloud data platform and its components, such as Virtual Warehouses, Snowflake Data Sharing, etc.

In-depth knowledge of Informatica PowerCenter, Informatica Cloud, Informatica Data Quality, and other Informatica products.

Experience establishing data quality processes, performing data analysis, participating in technology implementation planning, implementing data integration processes

Expertise in Snowflake data modeling in star, snowflake and data vault 2.0, ELT using SnowPipe, implementing stored procedures and standard DWH and ETL concepts

Create and maintain documentation of the data architecture, flow, and models of the data warehouse for various stakeholders.

Hands-on experience in data modeling, data integration, and ETL / ELT processes.

Design and implement scalable and streamlined data pipelines to address key business use cases and to meet data SLA requirements.

Proficiency in SQL and other data querying languages.

Collaborate with data engineers and analysts to establish data mappings, transformation rules, and workflows for ensuring data accuracy and consistency.

Experience in Data Migration to Snowflake cloud data warehouse

Strong understanding of data governance, data security, and data management best practices.

Experience with cloud infrastructure and services, preferably AWS or Azure.

Excellent analytical, problem-solving, and communication skills.

Ability to work collaboratively in a team environment and interact with stakeholders at all levels of the organization.

27 days ago
Related jobs
Promoted
Amada Senior Care - Las Vegas, NV
Las Vegas, Nevada

At Amada Senior Care - Las Vegas, we realize that to enrich the lives of our clients in the most meaningful way, we need to remain aware of the bigger picture. This means going beyond basic duties of care to truly understand each client’s unique needs and to create lasting relationships with o...

Promoted
Maverick FX
Las Vegas, Nevada
Remote

Often the best candidates have a background in math, finance, and business, and any experience in trading or investing is a bonus. All trading activity also requires fees for data feeds, commissions and trading spreads, which each trader will be responsible for. ...

Promoted
Amada Senior Care - Las Vegas, NV
Las Vegas, Nevada

At Amada Senior Care - Las Vegas, we realize that to enrich the lives of our clients in the most meaningful way, we need to remain aware of the bigger picture. This means going beyond basic duties of care to truly understand each client’s unique needs and to create lasting relationships with o...

Promoted
K&B Transportation
Spring Valley, Nevada

Late Model Equipment! Trucks are 2020 and Newer Freightliner Cascadias and are Equipped with APUS, Refrigerators, Inverters and More!. ...

Promoted
Poly-Trucking
Paradise, Nevada

At Poly Trucking, drivers are not just another number.We treat our drivers like family and only hire the highest quality drivers.The freight is no-touch and no hazardous materials are hauled in our equipment.Drop Pay, Layover Pay, Breakdown Pay.Cell phone reimbursement of $50.Medical and Dental insu...

Promoted
Hogan Transports
Las Vegas, Nevada

Hogan utilizes first-class equipment and advanced technology to help our drivers be successful. ...

Promoted
All Medical Personnel
Las Vegas, Nevada

Plans and conducts segments of treatment programs designed to restore and improve physical, social and mental functions, while meeting department objectives.Serves as co-leader in interdisciplinary approach to patient groups.Completes evaluations to ensure quality standards and addresses assessment ...

Orange Tree Staffing
Summerlin South, Nevada

Occupational Therapist to make a difference with students within a school setting with Clark County School District.Must be licensed as an Occupational Therapist in Nevada.Are you looking to make a difference with children in your community? When you join Orange Tree Staffing, LLC, you partner with ...

Maverick Trading
Las Vegas, Nevada
Remote

Experience Level: Minimum 2+ years experience in handling investments and trades. ...

The Friedkin Group
Las Vegas, Nevada

We hire, train, promote and compensate associates based on competence and performance without regard for race, color, religion, sex, national origin, age, marital status, disability or citizenship, as well as other classifications protected by applicable federal, state or local laws. We are committe...