Data Architect/lead
Job Title:
Data Architect/LeadLocation:
Dallas TXJob type:
Full Time
Job Description:
Must be extremely proficient in Data Warehouse ETL Design/Architecture Experience working in Dimensional/relational data modelling.
Experience in atleast one ETL development project, writing/analyzing complex stored procedures.
Experience in Python/PySpark Snowflake Hands-on Experience with transient and external tables, commands in snowflake like copy, unload data to/from S3, working knowledge of variant data type, flattening nested structure thru SQL, familiarity with marketplace integrations, role-based masking, pipes, data cloning, logs, user and role management.
AWS Should have hands-on experience with S3, Glue (jobs, triggers, workflow, catalog, connectors, crawlers), CloudWatch, RDS and secrets manager.
Should have hands-on experience with version controlling tools like github, working knowledge on configuring, setting up CI/CD pipelines using yaml, pip files.
Streaming Services Familiarity with Confluent Kafka or spark streaming, or Kinesis (or equivalent) is nice to have.
Familiarity with DBT/ coalesce tool is a Plus.
Airflow Scheduling (MWAA) experience is a Plus.
Data Vault 2.
0 (hubs satellite links) experience will be a PLUS.
Interpersonal Ability to work well in a team environment, meet deadlines, demonstrate good time management, and multi-task in a fast-paced project environment.
Highly proficient in Publisher, PowerPoint, SharePoint, Visio, Confluence and Azure DevOps Working knowledge of best practices in value-driven development (requirements management, prototyping, hypothesis-driven development, usability testing) Strong executive presentation skills with expertise in PowerPoint and presentation best practices.
Consistently demonstrates clear and concise written and verbal communication skills Good interpersonal skills, ability to interact with Senior Management Excellent multitasking skills and task management strategies Responsibilities Partner with business stakeholders to gather requirements and translate them into technical specifications and process documentation for IT counterparts (onshore and offshore) Highly proficient in the architecture and development of an event driven data warehouse; streaming, batch, data modeling, and storage Lead and foster data engineers, Data Analysts on their day-to-day activities Code review, test result review.
Review Pull requests ,Scripts for production deployment.
Advanced database knowledge; creating/optimizing SQL queries, stored procedure Recommended Skills Apache Kafka Architecture Cloudwatch Communication Confluence Continuous Integration Apply to this job.
Think you're the perfect candidate? Apply on company site $('.
external-apply-email-saved').
on('click', function (event) window.
ExternalApply = window.
open('/interstitial?jobdid=j3w7sf6pvcwfmzy5r43', 'ExternalApply-j3w7sf6pvcwfmzy5r43'); ); Estimated Salary: $20 to $28 per hour based on qualifications.
Data Architect/LeadLocation:
Dallas TXJob type:
Full Time
Job Description:
Must be extremely proficient in Data Warehouse ETL Design/Architecture Experience working in Dimensional/relational data modelling.
Experience in atleast one ETL development project, writing/analyzing complex stored procedures.
Experience in Python/PySpark Snowflake Hands-on Experience with transient and external tables, commands in snowflake like copy, unload data to/from S3, working knowledge of variant data type, flattening nested structure thru SQL, familiarity with marketplace integrations, role-based masking, pipes, data cloning, logs, user and role management.
AWS Should have hands-on experience with S3, Glue (jobs, triggers, workflow, catalog, connectors, crawlers), CloudWatch, RDS and secrets manager.
Should have hands-on experience with version controlling tools like github, working knowledge on configuring, setting up CI/CD pipelines using yaml, pip files.
Streaming Services Familiarity with Confluent Kafka or spark streaming, or Kinesis (or equivalent) is nice to have.
Familiarity with DBT/ coalesce tool is a Plus.
Airflow Scheduling (MWAA) experience is a Plus.
Data Vault 2.
0 (hubs satellite links) experience will be a PLUS.
Interpersonal Ability to work well in a team environment, meet deadlines, demonstrate good time management, and multi-task in a fast-paced project environment.
Highly proficient in Publisher, PowerPoint, SharePoint, Visio, Confluence and Azure DevOps Working knowledge of best practices in value-driven development (requirements management, prototyping, hypothesis-driven development, usability testing) Strong executive presentation skills with expertise in PowerPoint and presentation best practices.
Consistently demonstrates clear and concise written and verbal communication skills Good interpersonal skills, ability to interact with Senior Management Excellent multitasking skills and task management strategies Responsibilities Partner with business stakeholders to gather requirements and translate them into technical specifications and process documentation for IT counterparts (onshore and offshore) Highly proficient in the architecture and development of an event driven data warehouse; streaming, batch, data modeling, and storage Lead and foster data engineers, Data Analysts on their day-to-day activities Code review, test result review.
Review Pull requests ,Scripts for production deployment.
Advanced database knowledge; creating/optimizing SQL queries, stored procedure Recommended Skills Apache Kafka Architecture Cloudwatch Communication Confluence Continuous Integration Apply to this job.
Think you're the perfect candidate? Apply on company site $('.
external-apply-email-saved').
on('click', function (event) window.
ExternalApply = window.
open('/interstitial?jobdid=j3w7sf6pvcwfmzy5r43', 'ExternalApply-j3w7sf6pvcwfmzy5r43'); ); Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
