Senior Data Engineer – Data Analytics & BI

New Era Technology; Chicago (IL); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive benefits

Team-oriented culture

Continuous training

Job summary

New Era Technology, LLC. seeks a Senior Data Engineer to design, build, and maintain large-scale data infrastructure powering business insights. You will leverage SQL, Python, and Tableau to deliver scalable ETL pipelines and self-service dashboards for cross-functional stakeholders.

You will partner with Data Engineering and Data Science teams to ensure data quality and engineering best practices, while staying current with cloud platforms and analytics tooling.

Qualifications

• 8+ years of experience with SQL, including complex query optimization and working with large-scale relational and columnar databases.
• 5+ years of experience in Python for data engineering, including pipeline development, automation, and data transformation.
• 8+ years of experience creating custom reports and dashboards and building visualizations in Tableau or comparable tools.
• Experience with data management, specifically validating and auditing data and reports from multiple systems.
• Experience with cloud-based data platforms such as AWS, Azure, or Google Cloud Platform, and distributed data technologies such as Spark or Hadoop.

Responsibilities

• Triage requests for people data and ad hoc reports, prioritize requests, and communicate delivery expectations.
• Collaborate with partners to create dashboards displaying meaningful KPIs.
• Create visualizations enabling leaders to draw insights and recommendations.
• Build and automate self-service reports and dashboards for end users.
• Document reporting requirements with partners and Data Analytics team members.

Skills

SQL

Python

Tableau

ETL/ELT

Data Visualization

Big Data

Airflow

DBT

Spark

Hadoop

Education

BA/BS/MS in CS/Math/Stats or related field

Tools

Apache Hive

Presto

Jupyter Notebook

VS Code

AWS

Azure

GCP

Airflow

DBT

Spark

Job description

Join New Era Technology, where People First is at the heart of everything we do. With a global team of over 3,000 professionals, we're committed to creating a workplace where everyone feels valued, empowered, and inspired to grow. Our mission is to securely connect people, places, and information with end-to-end technology solutions at scale.

At New Era, you'll join a team-oriented culture that prioritizes your personal and professional development. Work alongside industry-certified experts, access continuous training, and enjoy competitive benefits. Guided by our core attributes — putting people first, embracing continuous learning, and thriving through collaboration and inclusion — we nurture our people to deliver exceptional customer service.

If you want to make an impact in a supportive, growth-oriented environment, New Era is the place for you.

SUMMARY

The Senior Data Engineer designs, builds, and maintains large-scale data infrastructure and analytics solutions that power business insights across the organization. The ideal candidate brings deep expertise in SQL, Python, and data visualization, with a strong track record of delivering self-service reporting platforms, scalable ETL pipelines, and high-quality dashboards that enable data-driven decision making. In this role, you will partner closely with cross-functional stakeholders to translate complex data needs into clear, actionable solutions while upholding engineering best practices in architecture, performance, and data quality.

PRIMARY DUTIES

• Triage requests for people data and ad hoc reports, prioritize requests, and effectively communicate appropriate delivery expectations.
• Collaborate with partners and stakeholders to create dashboards that display meaningful and actionable key performance indicators (KPIs).
• Create visualizations from which leaders can easily draw insights and recommendations.
• Build and automate easy-to-use, self-service reports and dashboards.
• Provide direction and coaching to end users on how to use and interpret metrics.
• Document reporting requirements with partners by collaborating with relevant Data Analytics team members on iterations and changes to core dashboards and solutions.
• Pull, organize, and analyze relevant data from multiple sources using tools such as Tableau, VS Code, and Jupyter Notebook, and programming languages such as SQL and Python.
• Partner and align with cross-functional teams including Data Engineering and Data Science, executing best practices in data gathering, pipeline design, and analytics.
• Audit data integrity, investigate concerns, and establish processes to streamline and improve data quality.
• Design, develop, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver data from diverse internal and external sources.
• Improve the performance of ETL tasks through good architecture and code optimization.
• Be part of the on-call team and monitor and address operational issues to ensure reliability and uptime of data systems.
• Stay current with emerging trends in data engineering, analytics tooling, and cloud-based data platforms.

COMPETENCY

• Experience with Apache Hive and Presto for large-scale distributed query processing.
• Familiarity with machine learning algorithms and data science workflows.
• Experience with large-scale data migration projects, including requirements gathering, pipeline design, and operational support.
• Mentoring experience with junior engineers and analysts.
• Familiarity with DevOps principles and their application to data management and deployment workflows.

REQUIRED EDUCATION

• BA/BS/MS in a field that emphasizes data analysis and visualization (e.g., computer science, social sciences, physical sciences, math, engineering, or statistics), or equivalent work experience.

EXPERIENCE

• 8+ years of experience with SQL, including complex query optimization and working with large-scale relational and columnar databases.
• 5+ years of experience in Python for data engineering, including pipeline development, automation, and data transformation.
• 8+ years of experience creating custom reports and dashboards and building visualizations in Tableau or comparable tools.
• Experience with data management, specifically validating and auditing data and reports from multiple systems.
• Experience with cloud-based data platforms such as AWS, Azure, or Google Cloud Platform, and distributed data technologies such as Spark or Hadoop.

LANGUAGE SKILLS

• Excellent presentation and communication skills, including the ability to explain technical subject matter to a non-technical audience and influence stakeholders at all levels.
• Ability to produce clear technical documentation including design specs, runbooks, and data dictionaries.

QUALIFICATIONS

• Proficiency in SQL and relational database systems, as well as NoSQL databases such as MongoDB or Cassandra.
• Strong Python programming skills with experience in orchestration tools such as Apache Airflow and data transformation tools such as DBT.
• Demonstrated ability to navigate ambiguity and operate effectively in a fast-paced, rapidly evolving environment, shifting fluidly between strategic initiatives and tactical analysis requests.
• A "do it the right way" mindset with commitment to proper documentation, thorough testing, and engineering excellence.

PHYSICAL DEMANDS

Regular use of hands and fingers to operate a computer keyboard, mouse, and other office equipment. Regular, repetitive movements such as typing, mouse movements, and scrolling. Ability to hear and understand spoken communications, both in person and via remote communication tools (e.g., phone, video conferencing). Ability to see and read computer screens and printed documents, as well as adjust focus. This includes prolonged periods of looking at a computer screen.

New Era Technology, LLC., and its subsidiaries ("New Era" "we", "us", or "our") in its operating regions worldwide are committed to respecting your privacy and recognize the need for appropriate protection and management of any Personal Data that you may provide us. In this, we are also committed to providing you with a positive experience on our websites and while using our products, services and solutions ("Solutions").

View our Privacy Policy here https://www.neweratech.com/us/privacy-policy/

We never ask candidates to pay any fees at any point in our hiring process. If you are ever asked to provide payment for training, certification, equipment, or any other purpose, it is not from our company. Only communications from our official company channels should be trusted. Please note our official email domain is @neweratech.com. If you suspect fraudulent activity, please contact us immediately at [e-mail] .