IT - Analyst - IT Resources | Big Data - Data Processing | Spark

Ampcus Inc; Fort Worth (TX); On-site; USD 110,000 - 160,000; Full time

Job summary

Ampcus Inc. is seeking a data-focused engineer to design and deliver analytics solutions for airline data assets, leveraging Azure Data Lake, Databricks, and BI tooling. You will work with data teams to migrate, model, and secure data while implementing scalable pipelines.

The role requires 2–5 years of related experience, cloud data skills, and a willingness to work onsite in Fort Worth, TX. Strong communication and mentoring abilities are valued.

Qualifications

• Bachelor's degree in a technical field or equivalent experience.
• 3 years developing software solutions in agile/DevOps environments.
• 3 years data analytics experience using SQL.
• 3 years cloud development and data lake experience (Azure preferred).

Responsibilities

• Design, implement and support analytics solutions for insights to drive decisions.
• Execute data migration and data engineering using Azure services and traditional warehouses.
• Contribute across the development lifecycle: design, cloud engineering, ingestion, modeling, testing, CICD, deployments.
• Provide technical leadership within a team and mentor others.
• Own and support DevOps for the product and implement batch and streaming data pipelines.

Skills

SQL

Azure

Python

Data governance

DevOps

BI analytics

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Data Factory

Azure Databricks

Power BI

Azure Data Lake

GitHub / Azure DevOps

SQL Server / Oracle

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Work Location:

Fort Worth, Texas

Interview Requirements:

• In-person interview required: Yes
• Skype/WebEx interview: No

Position Details:

• Position Type: Onsite
• Relocation Candidates: No
• Visa Independent Candidates Only: Yes

Job Description:

As a diverse, high-performing team dedicated to technical excellence, you will focus relentlessly on delivering unrivaled digital products that drive a more reliable and profitable airline. The Data Domain refers to the area within Information Technology that focuses on managing and leveraging data as a strategic asset. This includes data management, storage, integration, and governance. The Data domain leans into Machine Learning and AI, as well as Data Science and Business Intelligence.

This list is intended to reflect the current job but there may be additional essential functions (and certainly non-essential job functions) that are not referenced. Management will modify the job or require other tasks to be performed whenever it is deemed appropriate to do so, observing, of course, any legal obligations including any collective bargaining obligations.

• Work closely with source data application teams and product owners to design, implement and support analytics solutions that provide insights to make better decisions.
• Implement data migration and data engineering solutions using Azure products and services: Azure Data Lake Storage, Azure Data Factory, Azure Functions, Event Hub, Azure Stream Analytics, Azure Databricks, etc., and traditional data warehouse tools.
• Perform multiple aspects involved in the development lifecycle - design, cloud engineering (Infrastructure, network, security, and administration), ingestion, preparation, data modeling, testing, CICD pipelines, performance tuning, deployments, consumption, BI, alerting, prod support.
• Provide technical leadership and collaborate within a team environment as well as work independently.
• Be a part of a DevOps team that completely owns and supports their product.
• Implement batch and streaming data pipelines using cloud technologies.
• Leads development of coding standards, best practices, and privacy and security guidelines.
• Mentors others on technical and domain skills to create multi-functional teams.

Minimum Qualifications - Education & Prior Job Experience:

• Bachelor's degree in Computer Science, Computer Engineering, Technology, Information Systems (CIS/MIS), Engineering or related technical discipline, or equivalent experience/training.
• 3 years software solution development using agile, DevOps, operating in a product model that includes designing, developing, and implementing large-scale applications or data engineering solutions.
• 3 years data analytics experience using SQL.
• 3 years of cloud development and data lake experience (prefer Microsoft Azure) including Azure EventHub, Azure Data Factory, Azure Databricks, Azure DevOps, Azure Blob Storage, Azure Data Lake, Azure Power Apps, and Power BI.

Preferred Qualifications - Education & Prior Job Experience:

• 5 years software solution development using agile, DevOps, product model that includes designing, developing, and implementing large-scale applications or data engineering solutions.
• 5 years data analytics experience using SQL.
• 3 years full-stack development experience, preferably in Azure.
• 3 years of cloud development and data lake experience (prefer Microsoft Azure) including Azure EventHub, Azure Data Factory, Azure Functions, ADX, ASA, Azure Databricks, Azure DevOps, Azure Blob Storage, Azure Data Lake, Azure Power Apps, and Power BI.
• Airline Industry Experience.
• 3 years of Teradata Vantage development and administration.

Skills, Licenses, and Certifications:

• Expertise with the Azure Technology stack for data management, data ingestion, capture, processing, curation, and creating consumption layers.
• Expertise in providing practical direction within the Azure Native cloud services.
• Azure Development Track Certification (preferred).
• Spark Certification (preferred).
• Combination of Development, Administration & Support experience in several of the following tools/platforms required:
• Scripting: Python, Spark, Unix, SQL.
• Data Platforms: Teradata, Cassandra, MongoDB, Oracle, SQL Server, ADLS, Snowflake.
• Azure Data Explorer. Administration skills a plus.
• Azure Cloud Technologies: Azure Data Factory, Azure Databricks, Azure Blob Storage, Azure Data Lake, Azure Power Apps, and Azure Functions.
• CI/CD: GitHub, Jenkins, Azure DevOps, Terraform.
• BI Analytics Tool Stack - Cognos, Tableau, Power BI, Alteryx, Denodo, and Grafana.
• Data Governance and Privacy: Alation, Monte Carlo, Informatica, and BigID.

Language / Communication Skills:

• Ability to effectively communicate both verbally and written with all levels within the organization.
• Physical ability necessary to safely and successfully perform the essential functions of the position, with or without any legally required reasonable accommodations that do not pose an undue hardship.

Experience Needed:

2 - 5 years of experience is needed for this role.

Top Skills:

• SQL
• Building data solutions
• Develops practices
• Microsoft Azure (Generic)
• Python
• Sequel

Nice to Have Skills:

• Spark and Databricks

Ideal Candidate:

A great candidate will have knowledge of software design principles, understanding of big data, knowledge of SQL, and good work ethics.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.