Data Engineer

Allata is an IT company dedicated to strategy, architecture, and enterprise-level application development with offices in the US, India, and Argentina. We aim to be strategic advisors for our clients, focusing on helping them enhance or scale business opportunities, create efficiencies, automate processes through custom technologies, and find elegant solutions to inefficient problems.

We provide Data Analytics, Advanced Integrations, Product Launch, Experience Design, Support, Cloud, DevOps, Software Development, among other services. Our agile centralized development teams powered by our on-site senior leadership allow us to work with you as a stand-alone group be it integrating into your in-house dev teams or providing external architectural guidance.

We are seeking a skilled Data Engineer to contribute to transformative enterprise data platform projects focused on developing data pipelines and logic engines to manage ingest, staging, and multi-tier data product modeling and enrichment using various OEM-specific data warehouse and data lake house platform implementations for consumption via analytics clients. This role requires full life cycle design, build, deployment and optimization data products for multiple large enterprise industry vertical-specific implementations by processing datasets through a defined series of logically conformed layers, models, and views.

Role & Responsibilities:

• Collaborate in defining the overall architecture of the solution. This includes knowledge of modern Enterprise Data Warehouse and Data Lakehouse architectures that implement Medallion or Lamda architectures
• Design, develop, test, and deploy processing modules to implement data-driven rules using SQL, Stored Procedures, and Python.
• Understands and owns data product engineering deliverables relative to a CI-CD pipeline and standard devops practices and principles
• Build and optimize data pipelines on platforms like Snowflake, Databricks, SQL Server, or Azure Data Fabric.

Hard Skills - Must have:

• Current knowledge of an using modern data tools like (Snowflake, Databricks, FiveTran, Tableau, Power BI and others); Core experience with data architecture, data integrations, data warehousing, and ETL processes
• Applied experience in SQL, Stored Procedures, and Python based on area of data platform specialization.
• Strong knowledge of relational database systems, such as MS SQL Server, Postgres SQL, Oracle, Snowflake, Azure SQL, AWS RDS, Aurora or a comparable engine.

Hard Skills - Nice to have/It's a plus:

• Automation experience with CICD pipelines to support deployment and integration workflows including trunk-based development using GitHub Enterprise
• Proficiency in Python for advanced data processing tasks.
• Experience with DBT and Airflow for rapid model prototyping and collaboration

Soft Skills / Business Specific Skills:

• Ability to identify, troubleshoot, and resolve complex data issues effectively.
• Strong teamwork, communication skills and intellectual curiosity to work collaboratively and effectively with cross-functional teams.
• Commitment to delivering high-quality, accurate, and reliable data products solutions.
• Willingness to embrace new tools, technologies, and methodologies.
• Innovative thinker with a proactive approach to overcoming challenges.