The Senior Data Engineer in Analytics will own the design, implementation, and scaling of our analytics infrastructure to form the foundation of a cohesive analytics ecosystem. This role also empowers data analysts and data scientists to follow DataOps best practices to independently create metrics. Additionally, the Data Engineer will interface with the application database team to synergistically improve the overall cloud ecosystem. The ideal candidate will have demonstrable experience implementing data warehouses, a strong foundation in SQL and Python, and a mindset for cloud systems design.
\n ResponsibilitiesData Warehousing: Ingest data from Postgres, Google Cloud Storage, Salesforce, Jira, web analytics platforms, and other sources into BigQuery. Use Data Build Tool (DBT) to transform raw data into user friendly "data-marts" for use in BI tools. Implement reverse-etl to make aggregate data available in the application database for web application and mobile application use.Data Quality & Governance: Use DBT to establish a data testing framework to ensure data remains completely accurateUse DBT to produce a suite of metric definitions and documentation that can be understood by any user within the organization. Champion DataOps best practices across the organization.Evaluate New Tools and Integrations: Help evaluate and choose the best cloud tools to meet ever-evolving business needs.Optimizing and Monitoring Cloud Costs: Monitor and implement controls to ensure data warehousing costs are predictable and within reasonable levels. Unlock synergies between the application database and data warehouse to reduce overall cloud costs.Security & Compliance: Help ensure account permissions remain appropriate and enforced across the data consumption layer. Implement controls to ensure the data warehouse maintains compliance with GDPR, PII laws, SOC 2, and other regulations QualificationsTechnical Qualifications: BS or MS in Computer Science or related fields highly recommended but not required. 3+ years of experience with SQL is required. 3+ years of experience in BigQuery and GCP is requiredExperience with DBT is highly preferred. Experience interfacing with Postgres is highly preferred. Experience ingesting data via API from other software platforms is a plus. Experience transforming non tabular data with Python is a plus. Experience with data streaming is nice to have.Experience & Abilities: Experience implementing and owning responsibility for data warehouses. Experience data modeling specifically for analytical use-cases. Experience empowering peers with DataOps best practices including data security and data governance. A deep understanding of the strengths and weaknesses between transactional and analytical databases.Soft Skills: Excellent communication skills with the ability to convey complex technical concepts and work collaboratively across cross-functional teams. Autonomous and independent, with a sense of ownership and accountability. The ability to evangelize and communicate the importance of best practices across the organization.
\n$120,000 - $135,000 a year
The base salary offered is based on market location, and may vary further depending on individualized factors for job candidates, such as job-related knowledge, skills, experience, and other objective business considerations. Subject to those same considerations, the total compensation package for this position may also include other elements, including equity compensation, in addition to a full range of medical, financial, and/or other benefits. Details of participation in these benefit plans will be provided if an employee receives an offer of employment. \nAt Simbe, you will be at the forefront of retail innovation, working with cutting-edge AI and robotics technologies to transform retail operations. Our culture is dynamic, inclusive, and driven by a passion for improving the way retailers operate and serve their customers. Join us to be a part of a team that is not only reshaping the future of retail but also offering immense value to our clients worldwide. Simbe Values: R. E. T. A. I. L.
Result Driven - We are customer-centric and results-driven. We strive to create immense value for our team, partners, customers, and investors.
Empathetic - We are sensitive and mindful. We support each other in challenging times, both professionally and personally.
Transparent - We highly value open communication internally, and with our partners and customers. We are receptive to feedback.
Agile - We are agile and always eager to learn. We quickly adapt to changes and customer needs.
Innovative - We are bold and innovative, with an intense focus on product design and user experience.
Leaders - We strive for excellence. We are accountable, the best at what we do, and leaders in our field.
Apply for this job