Analytics Engineer III

At Mitratech, we are a team of technocrats focused on building world-class products that simplify operations in the Legal, Risk, Compliance, and HR functions of Fortune 100 companies. We are a close-knit, globally dispersed team that thrives in an ecosystem that supports individual excellence and takes pride in its diverse and inclusive work culture centered around great people practices, learning opportunities, and having fun! Our culture is the ideal blend of entrepreneurial spirit and enterprise investment, enabling the chance to move at a rapid pace with some of the most complex, leading-edge technologies available.

Given our continued growth, we always have room for more intellect, energy, and enthusiasm - join our global team and see why it's so special to be a part of Mitratech!

Job Description
We are seeking a highly motivated and skilled Analytics Engineer to join our dynamic data team. The ideal candidate will possess a strong background in data engineering and analytics, with hands-on experience in modern analytics tools such as Airbyte, Fivetran, dbt, Snowflake, Airflow, etc. This role will be pivotal in transforming raw data into valuable insights, ensuring data integrity, and optimizing our data infrastructure to support the organization's data platform.

Essential Duties & Responsibilities

• Data Integration and ETL Processes:
  • Design, implement, and manage ETL pipelines using tools like Airbyte and Fivetran to
    ensure efficient and accurate data flow from various sources into our Snowflake data
    warehouse.
  • Maintain and optimize existing data integration workflows to improve performance and
    scalability.
• Data Modeling and Transformation:
  • Develop and maintain data models using dbt / dbt Cloud to transform raw data into
    structured, high-quality datasets that meet business requirements.
  • Ensure data consistency and integrity across various datasets and implement data
    quality checks.
• Data Warehousing:
  • Manage and optimize our Redshift / Snowflake data warehouses, ensuring it meets
    performance, storage, and security requirements.
  • Implement best practices for data warehouse management, including partitioning,
    clustering, and indexing.
• Collaboration and Communication:
  • Work closely with data analysts, data scientists, and business stakeholders to
    understand data requirements and deliver solutions that meet their needs.
  • Communicate complex technical concepts to non-technical stakeholders in a clear and
    concise manner.
• Continuous Improvement:
  • Stay updated with the latest developments in data engineering and analytics tools, and
    evaluate their potential to enhance our data infrastructure.
  • Identify and implement opportunities for process improvements, automation, and
    optimization within the data pipeline.

Requirements & Skills:

• Education and Experience:
  • Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.
  • 3-5 years of experience in data engineering or analytics engineering roles.
  • Experience in AWS and DevOps is a plus.
• Technical Skills:
  • Proficiency with modern ETL tools such as Airbyte and Fivetran.
  • Must have experience with dbt for data modeling and transformation.
  • Extensive experience working with Snowflake or similar cloud data warehouses.
  • Solid understanding of SQL and experience writing complex queries for data extraction and
    manipulation.
  • Familiarity with Python or other programming languages used for data engineering tasks.
• Analytical Skills:
  • Strong problem-solving skills and the ability to troubleshoot data-related issues.
  • Ability to understand business requirements and translate them into technical specifications.
• Soft Skills:
  • Excellent communication and collaboration skills.
  • Strong organizational skills and the ability to manage multiple projects simultaneously.
  • Detail-oriented with a focus on data quality and accuracy.

We are an equal-opportunity employer that values diversity at all levels. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity, disability, or veteran status.