Data Architect

Company: The Computer Merchant, LTD.
Location: Dallas
Posted on: May 28, 2023

Job Description:

JOB TITLE: Data Architect IIIJOB LOCATION:- Hybrid position- 2 days a week on-site in Dallas, TXWAGE RANGE*: 100-108/hr.JOB NUMBER: 23-01229Description:This role will be part of a team focused on cloud transformation, modernizing analytics platforms and improving agility. The role requires hands-on experience in building and managing analytics solutions in SnowFlake, Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling.Primary duties and responsibilities:Establish data architecture strategy, best practices, standards, and roadmapExperience with data warehousing and data modeling techniques (Kimball, Lakehouse)Engage with business stakeholders to understand strategic, tactical, and operational needs; translate business requirements to technical requirementsBuild Data Flows mapping Source systems and Process flows.Mentor team members on best practices, efficient implementations and delivering high quality data productsAssemble large, complex data sets that meet non-functional and functional business requirementsBuild Data Warehouse Architecture including Data Ingestion, Transformation, Security, and Aggregate layersInitiate and facilitate continuous process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processesPerform code reviews and assist developers in optimization and troubleshooting.Review the architectural/ technological solutions for ongoing projects and ensure right choice of solutionExpertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these featuresKnowledge in AWS and management technologies such as S3.Strong written communication skillsIs effective and persuasive in both written and oral communicationDuration:- Possibility of extensions and/or FTE conversionLocation:- Hybrid position- 2 days a week on-site at the 1601 Elm Street location in Dallas, TXMust Haves:- 7-10+ years of experience- Data Architect/Data Modeling experience- Experience with relational and dimensional modelingPlusses:- Experience in SnowFlake migrations- Understanding of SnowFlake architectureInterview Process:- 2 interviews to hireEqual Opportunity Employer Veterans/Disabled* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.PDN-993554a3-fd7b-4b36-b9fe-62fc0b57d6c3

Keywords: The Computer Merchant, LTD., Dallas , Data Architect, Other , Dallas, Texas