Data Engineer - Industrials & Energy Sector - Senior - Consulting - Location Open

$105,800 - $174,800/Yr

Ernst & Young - Miami, FL

Full-time - Senior

Miami, FL

Professional, Scientific, and Technical Services

About the position

At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you. The exceptional EY experience is yours to build. EY focuses on high ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities. The position of Senior Data Engineer in the US Consulting - AI & Data - Data Engineer team is crucial for ingesting, building, and supporting large-scale data architectures that serve multiple downstream systems and business users. This role involves supporting the Data Engineer Leads and collaborating with Visualization teams on data quality and troubleshooting needs. In this role, you will design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals. You will be responsible for developing and maintaining scalable data pipelines, building out new integrations using AWS native technologies to support increasing data sources, volume, and complexity. Additionally, you will define data requirements, gather and mine large-scale structured and unstructured data, and validate data using various tools in a Big Data environment. You will also implement processes to drive data reconciliation and monitor data quality, ensuring production data is accurate and available for key stakeholders and business processes. As a Senior Data Engineer, you will lead the evaluation, implementation, and deployment of emerging tools and processes for analytic data engineering to improve productivity. You will develop and deliver communication and education plans on analytic data engineering capabilities, standards, and processes. Furthermore, you will solve complex data problems to deliver insights that help achieve business objectives and implement statistical data quality procedures on new data sources. This position requires a strong partnership with Business Analytics and Solution Architects to develop technical architectures for strategic enterprise projects and initiatives, as well as collaboration with Data Scientists and AI/ML engineers to create data products for analytics.

Responsibilities

• Design, develop, optimize, and maintain data architecture and pipelines that adheres to ETL principles and business goals.
• Develop and maintain scalable data pipelines, build out new integrations using AWS native technologies to support continuing increases in data source, volume, and complexity.
• Define data requirements, gather and mine large scale of structured and unstructured data, and validate data by running various data tools in the Big Data Environment.
• Support standardization, customization and ad hoc data analysis and develop the mechanisms to ingest, analyze, validate, normalize, and clean data.
• Write unit/integration/performance test scripts and perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
• Implement processes and systems to drive data reconciliation and monitor data quality, ensuring production data is always accurate and available for key stakeholders, downstream systems, and business processes.
• Lead the evaluation, implementation and deployment of emerging tools and processes for analytic data engineering to improve productivity.
• Develop and deliver communication and education plans on analytic data engineering capabilities, standards, and processes.
• Learn about machine learning, data science, computer vision, artificial intelligence, statistics, and/or applied mathematics.
• Solve complex data problems to deliver insights that help achieve business objectives.
• Implement statistical data quality procedures on new data sources by applying rigorous iterative data analytics.

Requirements

• Bachelor's degree in Engineering, Computer Science, Data Science, or related field.
• 5+ years of experience in software development, data science, data engineering, ETL, and analytics reporting development.
• Experience designing, building, implementing, and maintaining data and system integrations using dimensional Datamodelling and development and optimization of ETL pipelines.
• Proven track record of designing and implementing complex data solutions.
• Demonstrated understanding and experience using Data Engineering Programming Languages (ie, Python).
• Experience with Distributed Data Technologies (eg, Pyspark).
• Familiarity with cloud platform deployment and tools (eg, Kubernetes).
• Experience with Relational SQL databases.
• Knowledge of DevOps and continuous integration.
• Experience with AWS cloud services and technologies (ie, Lambda, S3, DMS, Step Functions, Event Bridge, Cloud Watch, RDS).
• Experience with Databricks/ETL IICS/DMS GitHub Event Bridge, Tidal.
• Strong organizational skills with the ability to manage multiple projects simultaneously and operate as a leading member across globally distributed teams to deliver high-quality services and solutions.
• Understanding of database architecture and administration processes.
• High proficiency in code programming languages (eg, SQL, Python, Pyspark, AWS services) to design, maintain, and optimize data architecture/pipelines that fit business goals.
• Ability to extract, transform, and load data from multiple external/internal sources using Databricks Lakehouse/Data Lake concepts into a single, consistent source to serve business users and data visualization needs.
• Utilization of the principles of continuous integration and delivery to automate the deployment of code changes to elevate environments, fostering enhanced code quality, test coverage, and automation of resilient test cases.
• Excellent written and verbal communication skills, including storytelling and interacting effectively with multifunctional teams and other strategic partners.
• Strong problem solving and troubleshooting skills.
• Ability to work in a fast-paced environment and adapt to changing business priorities.

Nice-to-haves

• Experience in leading and influencing teams, with a focus on mentorship and professional development.
• A passion for innovation and the strategic application of emerging technologies to solve real-world challenges.
• The ability to foster an inclusive environment that values diverse perspectives and empowers team members.

Benefits

• Comprehensive compensation and benefits package based on performance.
• Medical and dental coverage.
• Pension and 401(k) plans.
• Wide range of paid time off options including designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence.
• Flexible vacation policy allowing employees to decide how much vacation time they need based on personal circumstances.