Data Warehouse Architect @ Next Gen IT, Inc | Jobright.ai
JOBSarrow
RecommendedLiked
0
Applied
0
External
0
Data Warehouse Architect jobs in United States
32 applicants
expire-info-iconThis job has closed.
company-logo

Next Gen IT, Inc ยท 5 hours ago

Data Warehouse Architect

positionUnited States
timeContract
remoteRemote
senioritySenior Level, Lead/Staff
date12+ years exp
ftfMaximize your interview chances
Information Technology & Services

Insider Connection @Next Gen IT, Inc

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Lead the migration of data warehouse systems from IBM iSeries DB2 and IBM Sailfish to Snowflake.
Design and implement effective data models in Snowflake to optimize for performance, scalability, and cost-efficiency.
Architect, design, and optimize data pipelines using DBT and Prefect to ensure efficient ETL processes.
Collaborate with data analysts, data scientists, and business stakeholders to develop a data strategy that supports robust analytics and reporting.
Implement best practices for data quality, data governance, and security within the data platform.
Work with Google BigQuery on integration projects as required, ensuring compatibility with Snowflake.
Analyze data collected from website clicks & generate business insights using Google Analytics.
Define solution & Implement Change Data Capture.
Drive continuous improvement in data engineering processes and ensure the platform's scalability, reliability, and availability.
Ability to own the tech stack & oversee multiple migration project tracks & talk to client with big picture.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

IBM iSeries DB2IBM SailfishSnowflakeDBTPrefectGoogle Cloud Platform (GCP)Google BigQuerySQLData modelingGoogle AnalyticsChange Data CaptureData governanceData securityData quality management

Required

12+ years of experience in data engineering, with hands-on experience in data warehouse migration projects.
Strong expertise with IBM iSeries DB2, IBM Sailfish, and Snowflake.
Proven experience in data modeling with Snowflake, including star schema and snowflake schema design principles.
Proficiency in using DBT for data transformation and Prefect for workflow orchestration.
Experience with Google Cloud Platform (GCP) and Google BigQuery.
Solid knowledge of data warehouse design, data modeling, and ETL/ELT processes.
Proficient in SQL and experienced with performance tuning for large-scale databases.
Experience in Google Analytics.
Experience in Change Data Capture.
Strong analytical and problem-solving skills, with the ability to understand complex data requirements.

Preferred

Hands-on experience with cloud migration projects.
Experience in data governance, data security, and data quality management.
Ability to work independently, manage multiple tasks, and drive projects to completion.
Excellent communication skills, with the ability to explain technical concepts to non-technical stakeholders.

Company

Next Gen IT, Inc

twitter
company-logo
Experience Excellence with NextGenIT, Inc: Your Trusted Partner in US-based Software Consulting.
location
Frisco, Texas, US
people-size11-50 employees
web-link
http://nextgenit.com/

Funding

Current Stage
Early Stage

Leadership Team

leader-logo
Gwyneth Gallucci
Chief Growth Officer
linkedin
Company data provided by crunchbase
logo

Orion

Your AI Copilot