drjobs Staff Data Architect

Staff Data Architect

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Livonia, MI - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Job Description Summary

This position is responsible for building managing and supporting our fleet of AWS Redshift data warehouse environments. This role designs implements and optimizes data architectures and cluster topologies that enable and support a variety data warehousing analytics and reporting workloads.

Job Description

Roles and Responsibilities:

In this role you will:

  • Leverage expertise in Amazon Redshift to design deploy and maintain our fleet of clusters tuning the environments to optimize query performance effectively manage resources and implement best practices for data storage retrieval and processing.
  • Manage data access policies and practices for our AWS Redshift Fleet ensuring compliance with regulations like CMMC DFARS ITAR NIST 800-171).
  • Monitor and optimize the performance of the data platform including tuning Redshift queries implementing best practices for data partitioning compression and caching and utilizing tools like Amazon Redshift Advisor.
  • Document data architectures data flows standards and best practices to ensure consistency and facilitate knowledge sharing across teams.
  • Configure monitoring and logging systems to track platform performance troubleshoot issues and respond to incidents promptly.
  • Anticipate track and advise management on risks and opportunities pertaining to trade-offs between performance and cost
  • Stay abreast of the latest technologies architecture trends and management best practices pertaining to analytical data storage.
  • Assist with monitoring tracking and forecasting of cloud costs across the Data Warehouse

Minimum Qualifications:

  • Bachelors Degree in Computer Science or STEM Majors (Science Technology Engineering and Math) with a minimum of 6 years of experience in cloud & database storage technologies such as AWS RedShift
  • Minimum 4 years experience with database technology and minimum 3 years of experience on AWS or equivalent cloud technologies

Eligibility Requirement:

  • Legal authorization to work in the U.S. is required. We will not sponsor individuals for employment visas now or in the future for this job.

Desired Characteristics:

Technical Expertise:

  • Direct experience with provisioning managing AWS Redshift or other cloud-native data warehouse-like solutions
  • Experience with MPP data architecture and performance optimizations
  • Experience / Familiarity with other AWS data services such as S3 Glue Athena Lambda and DynamoDB
  • Experience with Infrastructure as Code (IaC) tools like CloudFormation or Terraform
  • Experience with designing and implementing security policies in AWS (IAM resource policies roles)
  • Familiarity with the operation and support of workloads from data visualization platforms
  • AWS certifications (e.g. AWS Certified Data Analytics AWS Certified Solutions Architect).
  • Familiarity with ITIL service management practices including Incident Management Change management Problem management availability management

Business Acumen:

  • Adept at navigating the organizational matrix; understanding peoples roles can foresee obstacles identify workarounds leverage resources and rally teammates.
  • Understand how internal and/or external business model works and facilitate active customer engagement
  • Able to articulate the value of what is most important to the business/customer to achieve outcomes
  • Able to produce functional area information in sufficient detail for cross-functional teams to utilize using presentation and storytelling concepts.
  • Possess extensive knowledge of full solution catalog within a business unit and proficiency in discussing each area at an advanced level.
  • Ability to leverage historical & current data to build forecasts on cluster needs and cost; ability to build & update the logic for assessing out cost to our partners.

Leadership:

  • Demonstrated working knowledge of internal organization.
  • Foresee obstacles identify workarounds leverage resources rally teammates.
  • Delivers tasks on-time with alignment to architectural goals. Can identify and raise issues risks and benefits. High say do ratio.
  • Demonstrated ability to work with and/or lead blended teams including 3rd party partners and customer personnel.
  • Demonstrated Change Management /Acceleration capabilities
  • Strong interpersonal skills including creativity and curiosity with ability to effectively communicate and influence across all organizational levels
  • Proven analytical and problem resolution skills
  • Ability to influence and build consensus with other Information Technology (IT) teams and leadership
  • Passionate about Problem Solving and the continuous improvement journey along the FLIGHT DECK fundamentals.
  • Ability to thrive is a highly matrixed environment

Note:

To comply with US immigration and other legal requirements it is necessary to specify the minimum number of years experience for any role based within the USA. For roles outside of the USA to ensure compliance with applicable legislation the JDs should focus on the substantive level of experience for the role and a minimum number of years should NOT be used.

This Job Description is intended to provide a high level guide to the role. However it is not intended to amend or otherwise restrict/expand the duties from each individual employee as set out in their respective employment contract and/or as otherwise agreed between an employee and their manager.

This role requires access to U.S. export-controlled information. Therefore for applicants who are not asylees refugees lawful permanent residents or U.S. Citizens (i.e. not a protected individual under the Immigration and Naturalization Act 8 U.S.C. 1324b(a)(3) otherwise known as a U.S. Person) final offers will be contingent on the ability to obtain authorization for access to U.S. export-controlled information from the U.S. Government.

Additional Information


Required Experience:

Staff IC

Employment Type

Full-Time

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.