PricewaterhouseCoopers Jobs

Job Information

PwC Data Engineer in Detroit, Michigan

Specialty/Competency: IFS - Internal Firm Services - Other

Industry/Sector: Not Applicable

Time Type: Full time

Travel Requirements: Up to 20%

The Innovation Team is at the core of innovation and emerging technology development, discovery, deployment and support activity. Our team is leading the effort to digitally enable our business. Our mission is to develop disruptive & innovative technologies and products that drive the evolution of how we deliver our services now and in the future. The key technology domains we are currently focused on include business process automation, data curation, industrialized analytics, machine learning & AI and scalable delivery platform.

As a Data Engineer, you will work in a team together with Data Scientists, Software Engineers and Product Managers to drive Innovation and Technical solutions into practice. Data Engineers will focus on the design and build out of data models, codification of business rules, mapping of data sources to the data models (structured and unstructured), engineering of scalable ETL pipelines, development of data quality solutions, and continuous evaluation of technologies to continue to enhance the capabilities of the Data Engineer team and broader Innovation group. You'll focus on assisting them as they incorporate increased automation, machine learning, data & analytics, commercial and open source technologies into their processes to deliver better quality output and contribute more strategically to organizational decision making.

To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be a purpose-led and values-driven leader at every level. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.

As a Manager, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:

  • Develop new skills outside of comfort zone.

  • Act to resolve issues which prevent the team working effectively.

  • Coach others, recognise their strengths, and encourage them to take ownership of their personal development.

  • Analyse complex ideas or proposals and build a range of meaningful recommendations.

  • Use multiple sources of information including broader stakeholder views to develop solutions and recommendations.

  • Address sub-standard work or work that does not meet firm's/client's expectations.

  • Use data and insights to inform conclusions and support decision-making.

  • Develop a point of view on key global trends, and how they impact clients.

  • Manage a variety of viewpoints to build consensus and create positive outcomes for all parties.

  • Simplify complex messages, highlighting and summarising key points.

  • Uphold the firm's code of ethics and business conduct.

Job Requirements and Preferences :

Basic Qualifications :

Minimum Degree Required :

Bachelor Degree

Required Fields of Study :

Management Information Systems, Computer and Information Science, Systems Engineering, Electrical Engineering, Chemical Engineering, Industrial Engineering, Mathematics, Statistics, Mathematical Statistics

Additional Educational Requirements :

In lieu of a Bachelor Degree, 12 years of professional experience involving: in the design and build-out of data models, codification of business rules and development of data quality solutions including experience in leading teams.

Minimum Years of Experience :

5 year(s) of experience in the design and build-out of data models, codification of business rules and development of data quality solutions including experience leading teams.

Preferred Qualifications :

Preferred Knowledge/Skills :

Demonstrates extensive knowledge and/or a proven record of success in the following areas:

  • Leading teams to generate a vision, establish direction, motivate members, create an atmosphere of trust, leverage diverse views, coach staff, and encourage improvement and innovation;

  • Utilizing data wrangling, ETL, data modelling, and business rules codification (e.g. analytics/transformations written in Python/R or similar business rules engines/languages);

  • Developing analytics, leveraging tools such as Python, R, open source tooling;

  • Using data mapping, data flows and governance processes around data management;

  • Using data integration tools (e.g. Talend, SnapLogic, Informatica) and data warehousing / data lake tools; and,

  • Building and maintaining database models (NoSQL, relational and other) and associated SQL.

Demonstrates extensive abilities and/or a proven record of success in the following areas:

  • Object-oriented/object function scripting languages Python, R, C/C++, Java, Scala, etc.;

  • Relational SQL, distributed SQL and NoSQL databases; - Big data tools such as Hadoop, Spark, Kafka;

  • Data modeling tools such as ERWin, Enterprise Architect, and Visio;

  • Data integration tools such as Talend, Informatica, and SnapLogic;

  • Data pipeline and workflow management tools Azkaban, Luigi, Airflow;

  • Business Intelligence Tools such as Tableau, PowerBI, Zoomdata, and Pentaho;

  • Cloud technologies such as SaaS, IaaS and PaaS within Azure, AWS or Google;

  • Linux and being comfortable with bash scripting; and,

  • Docker and Puppet.

Demonstrates extensive abilities and/or a proven record of success in the following areas:

  • Creating design documentation, assisting in project planning, and leading staff in the development of data warehouses, data lakes, and business systems;

  • Using written and verbal communication skills to effectively and efficiently translate business requirements into technical specifications and test cases;

  • Working with large data sets;

  • Coding data layer services, working with software development teams and data scientists to assist in the broader development of business applications;

  • Using agile development processes;

  • Using verbal and written communication skills with ability to present technical and non-technical information to various audiences;

  • Leading developers code using object oriented design, implementation and maturation to take advantage of the language feature sets;

  • Assessing and reviewing code to establish it is efficient code which is concise and best utilizes system resources which can become constrained in a big data environment;

  • Utilizing leadership know-how of the open source community, especially working with a large array of open source tools / libraries and languages;

  • Building batch data pipeline with relational and columnar database engines as well as Hadoop or Spark, and understands their respective strengths and weaknesses;

  • Applying computer science fundamentals such as data structures, algorithms, programming languages, distributed systems, and information retrieval;

  • Possessing an analytical mind with attention to detail and accuracy; and,

  • Understanding of the security requirements for handling data both in motion and at rest such as communication protocols, encryption, authentication, and authorization.

At PwC, our work model includes three ways of working: virtual, in-person, and flex (a hybrid of in-person and virtual). Visit the following link to learn more:

PwC does not intend to hire experienced or entry level job seekers who will need, now or in the future, PwC sponsorship through the H-1B lottery, except as set forth within the following policy:

All qualified applicants will receive consideration for employment at PwC without regard to race; creed; color; religion; national origin; sex; age; disability; sexual orientation; gender identity or expression; genetic predisposition or carrier status; veteran, marital, or citizenship status; or any other status protected by law. PwC is proud to be an affirmative action and equal opportunity employer.

For positions based in San Francisco, consideration of qualified candidates with arrest and conviction records will be in a manner consistent with the San Francisco Fair Chance Ordinance.

For positions in Colorado, visit the following link for information related to Colorado's Equal Pay for Equal Work Act: