JOB TITLE: Senior Data Warehouse Architect
JOB LOCATION: Remote
JOB DETAILS:
- This key architecture role is responsible for translating sophisticated business requirements into valuable coordinated data models and maintaining a clean and optimized ELT code base.
- The role will be tasked with working within a multi-functional team to support the development of an enterprise data warehouse.
Responsibilities
Who you are:
Advertisements
- Hands-on developer and teammate with a passion for working on a variety of data projects.
- Supports colleagues in building strong functional requirements and provides insight as a technical liaison with respect to delivery options and opportunities.
- Articulates advantages and disadvantages of data design approaches and modeling methodologies.
- Maintains metadata catalog in an effort to support a scalable self-service analytics environment.
- Ensures that technical requirements and standard methodologies are met and deployed within the context of the data team’s standards.
- Conducts code reviews, provide advice, and gives constructive feedback to analytical engineers and developers.
- Builds open dialogues and discourses with data team leads to remove much of the opacity in directional decision making.
- Supports the drive for innovation through identifying emerging trends and their alignment to business outcomes.
- Builds trust in all interactions and always strives to improve the team around you.
- Exudes attention to detail, and a passion for leaving a code base better than it was found.
Requirements
- Bachelor’s Degree in Computer Science, MIS, Mathematics, Business, or an equivalent combination of education and experience.
- Experience working with cloud data platforms, e.g. GCP Big Query, Azure Synapse, or AWS Redshift.
- Mastery across all phases of data modeling, from conceptual designs to physical designs, with a deep understanding of different modeling methodologies, e.g. dimensional modeling.
- Maintains a proven command of ANSI SQL. Python experience is a plus.
- Experience working with dbt, including authoring sophisticated Jinja and advanced dbt functionality.
- Understanding of modern data architecture and engineering concepts such as streaming, schema-on-read, and real-time data access.
- Extensive experience in how to assess the performance of data solutions, how to diagnose performance problems, and tools used to supervise and tune performance.
- Desire to work in a constantly evolving environment and maintain the ability to shift in new directions as business needs are altered.
- Deep understanding of distributed version control systems, e.g. GitHub, and history of retaining ownership of the cleanliness of multiple repositories.
- Basic understanding of a DataOps approach to delivery.
Benefits
- Fully Remote work culture – we hire globally and all of our roles are fully remote!
- Bring your own device stipend – buy your own laptop with funds from Andela
- Quarterly work from home stipends
- Flexible working hours
- Equity (as a part of compensation package)
- Healthcare, 401k / pension (US only)
- Andela Affinity Groups
- Growth & development paths
- Generous Paid Time Off, Parental Leave, Compassionate Leave
- And more to come! We’re on a journey to reimagine global benefits at Andela.
Application Closing Date
Not Specified.
Apply Now
Job Features
Job Category | Building Design / Architecture |