Senior Data Engineer

Analytic Era; Phoenix (AZ); On-site; USD 57,000 - 170,000; Full time

Job summary

Analytic Era is seeking a skilled Data Engineer who excels in designing and maintaining data pipelines, optimizing ETL processes, and working with Azure technologies. The ideal candidate will have a strong background in database design and a Bachelor’s degree in computer science. This position offers competitive compensation and the opportunity to work on innovative data solutions in a collaborative environment.

Qualifications

• Strong experience in data ingestion and transformation processes.
• Hands-on experience in cloud-based data infrastructure.
• Familiarity with API/REST, JSON, and cloud environments (GCP, Azure, AWS).

Responsibilities

• Design, develop, and maintain data pipelines and ETL processes.
• Optimize database performance, including query tuning and index optimization.
• Develop Power BI dashboards to communicate data insights.

Skills

Database design practices

Data warehousing

ETL processes

Azure Data Factory

Data reporting on SQL Servers

Power BI

Agile development

Problem-solving

Education

Bachelor's degree in computer science

Tools

Azure DevOps

GitHub

Jenkins

Job description

1 week ago Be among the first 25 applicants

Direct message the job poster from Analytic Era

• Solid experience with Database design practices and data warehousing concepts.

• Design, develop, and maintain data pipelines and ETL processes to extract, transform, and load

data from various sources into our data warehouse.

• Hands on experience delivering data reporting requirements on On-Prem SQL Servers using SSIS

and/or other integration processes.

• Expertise with coding and implementing data pipelines in cloud-based data infrastructure in

batch and streaming ETL using Azure Data Factory, Spark, Python, Scala on Databricks.

• Experience working with Azure data lake storage and Azure SQL Databases.

• Optimize data ingestion and transformation processes to ensure efficient and scalable data

flows, Monitor and optimize database performance, including query tuning and index

optimization.

• Develop and maintain data models, schemas, and data dictionaries for efficient data storage and

retrieval.

• Perform data analysis, data profiling, and data cleansing to ensure data quality and accuracy,

data validation, quality checks, and troubleshooting to identify and resolve data-related issues.

• Develop Power BI dashboards, reports, and visualizations to effectively communicate data

insights. Implement data transformations, data modeling, and data integration processes in

Power BI.

• Create and maintain technical documentation related to database structures, schemas, and

Reporting solutions.

• Experience with MS office tools like excel, word, power point.

• Experience working with build and deploy tools Azure DevOps, GitHub, Jenkins.

• Experience working on an Agile Development team and delivering features incrementally using

Jira and Confluence.

• Stay up to date with industry trends and best practices in data engineering, Power BI and

proactively recommend and implement improvements to our data infrastructure.

• Ability to multi-task, be adaptable, and nimble within a team environment.

• Strong communication, interpersonal, analytical and problem-solving skills.

Preferred:

• Experience with API/REST, JSON

• Experience in Banking and Financial Domains.

• Experience in Cloud environment like GCP, Azure and AWS.

• Familiarity with containerization and orchestration technologies (Docker, Kubernetes) and

experience with shell scripting in Bash, Unix or windows shell is preferable.

• Experience with Power Automate and Power Apps.

• Experience with Collibra Data Lineage and Data Quality Modules.

Education: Bachelor’s degree in computer science or information system along with work experience in

a related field.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Consulting

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Analytic Era by 2x

Sign in to set job alerts for “Data Engineer” roles.

Scottsdale, AZ $85,000.00-$100,000.00 1 month ago

Phoenix, AZ $112,597.33-$152,810.66 1 month ago

Phoenix, AZ $144,768.00-$209,109.33 1 month ago

Scottsdale, AZ $111,500.00-$191,950.00 2 months ago

Phoenix, AZ $102,000.00-$129,000.00 2 weeks ago

Phoenix, AZ $57,700.00-$107,800.00 6 hours ago

Scottsdale, AZ $105,000.00-$147,000.00 4 days ago

Chandler, AZ $140,000.00-$165,000.00 4 months ago

Scottsdale, AZ $152,500.00-$262,350.00 1 day ago

Phoenix, AZ $150,000.00-$170,000.00 1 week ago

Chandler, AZ $110,000.00-$140,000.00 5 months ago

Phoenix, AZ $160,000.00-$170,000.00 6 hours ago

Phoenix, AZ $85,000.00-$170,000.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.