Data Engineer/ BI Remote

Allata, LLC; Dallas (TX); Remote; USD 80,000 - 100,000; Full time

Job summary

An innovative consulting firm is on the lookout for a skilled Data Engineer to drive transformative data platform projects. In this dynamic role, you will design and develop data pipelines, utilizing cutting-edge tools and technologies to manage complex datasets. Collaborating with cross-functional teams, you will ensure the delivery of high-quality data solutions that empower enterprise clients to achieve their strategic goals. This position offers an exciting opportunity to work in a fast-paced environment where your contributions will have a significant impact on the success of large-scale data initiatives. If you are passionate about data engineering and eager to tackle complex challenges, this role is perfect for you.

Qualifications

• Expertise in data architecture, data integrations, and ETL/ELT processes.
• Proficient in SQL and Pyspark for data product engineering.

Responsibilities

• Design and deploy data processing modules using SQL, Stored Procedures, and Pyspark.
• Build and optimize data pipelines on platforms like Databricks and SQL Server.

Skills

Data Architecture

SQL

Pyspark

ETL/ELT Processes

Databricks

Data Warehousing

Cloud Database Systems

Data Integration

CI-CD Pipeline

Automation Services

Tools

Databricks

SQL Server

Azure Data Fabric

FiveTran

Azure DevOps

Jenkins

Job description

Allata is a fast-growing technology strategy and data development consulting firm delivering scalable solutions to our enterprise clients. Our mission is to inspire our clients to achieve their most strategic goals through uncompromised delivery, active listening, and personal accountability. We are a group who thrive in fast-paced environments, working on complex problems, continually learning, and working alongside colleagues to be better together.

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. Additionally, this includes but is not limited to data 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 Pyspark.
• Understand and own data product engineering deliverables relative to a CI-CD pipeline and standard devops practices and principles.
• Build and optimize data pipelines on platforms like Databricks, SQL Server, or Azure Data Fabric.

Hard Skills - Must have:

• Current knowledge of and using modern data tools like Databricks, FiveTran, Data Fabric and others; Core experience with data architecture, data integrations, data warehousing, and ETL/ELT processes.
• Applied experience with developing and deploying custom whl and or in-session notebook scripts for custom execution across parallel executor and worker nodes.
• Applied experience in SQL, Stored Procedures, and Pyspark based on area of data platform specialization.
• Strong knowledge of cloud and hybrid relational database systems, such as MS SQL Server, PostgresSQL, Oracle, Azure SQL, AWS RDS, Aurora or a comparable engine.
• Strong experience with batch and streaming data processing techniques and file compactization strategies.

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 automation services such as Azure DevOps, Jenkins, Octopus.
• Advanced proficiency in Pyspark for advanced data processing tasks.
• Advanced proficiency in spark workflow optimization and orchestration using tools such as Asset Bundles or DAG (Directed Acyclic Graph) orchestration.

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 product solutions.
• Willingness to embrace new tools, technologies, and methodologies.
• Innovative thinker with a proactive approach to overcoming challenges.

At Allata, we value differences.

Allata is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

This policy applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.