Andela is a network of technology leaders dedicated to advancing human potential. We help companies build high-performing distributed engineering teams by investing in Africa’s most talented software developers. Based in NYC, SF, Lagos, Nairobi, Rwanda and Kampala, Andela is catalyzing the growth of tech ecosystems across the African continent while solving the global technical talent shortage.
We are recruiting to fill the position below:
Job Title: Principal Data Warehouse Architect
Location: Remote
About the Role
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:
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.