Cloud Data Warehouse Engineering, Senior Associate
A career in Data Strategy and Platform Engineering will provide you with the opportunity to help businesses make better decisions and improve their performance through scalable and flexible technology that supports diverse data sources and uses.
Youll focus on aligning client data strategies to their business strategy. You will assist clients in choosing a platform, defining their data needs and migrating them to a modern cloud data environment using cloud providers such as Azure, Google Cloud Platform, Amazon Web Services, Snowflake, Databricks or Teradata.
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 Senior Associate, 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 :
- Use feedback and reflection to develop self awareness, personal strengths and address development areas.
- Delegate to others to provide stretch opportunities, coaching them to deliver results.
- Demonstrate critical thinking and the ability to bring order to unstructured problems.
- Use a broad range of tools and techniques to extract insights from current industry or sector trends.
- Review your work and that of others for quality, accuracy and relevance.
- Know how and when to use tools available for a given situation and can explain the reasons for this choice.
- Seek and embrace opportunities which give exposure to different situations, environments and perspectives.
- Use straightforward communication, in a structured way, when influencing and connecting with others.
- Able to read situations and modify behavior to build quality relationships.
- Uphold the firm's code of ethics and business conduct.
Demonstrates thorough abilities and / or a proven record of success in the following areas :
- Understanding and experience with modern cloud data warehouse and engineering for one or more of the following cloud providers Azure (Synapse, Dynamo, Cosmos, Azure ML, Power BI), AWS (Redshift, Sagemaker), GCP (BigQuery, Vertex, Cognitive Services), Snowflake, Tableau;
- Designing and developing modern data warehouse solutions using data modeling techniques such as file based, normalized or denormalized, star schemas, schema on read, Vault data model, and graphs for mixed workloads, such as OLTP, OLAP, streaming using any formats (structured, semi-structured, unstructured);
- Developing file and object-based storage solutions, such as Azure ADLS 2.0 or AWS S3, creating analytics and insights solutions using Redshift, Azure SQL Pools, Snowflake, PySpark dataframes and / or equivalent technologies;
- Designing and developing advanced analytics solutions, AI / ML models, and operationalizing based on ML Ops process;
- Architecting and designing data implementation patterns and engineered solutions using native cloud capabilities that span data ingestion & integration (ingress and egress), data storage (raw & cleansed), data prep & processing, master & reference data management, data virtualization & semantic layer, data consumption & visualization;
- Understanding of cloud data solutions in the context of business applications, cost optimization, clients strategic needs and future growth goals as it relates to becoming a data driven organization;
- Applying leading practices in supporting high availability, scalable, process and storage intensive solutions architectures to data integration / migration, analytics and insights, AI and ML requirements;
- Creating detailed functional and technical specification documentation related to cloud data warehouse solution;
- Understanding and familiarity of one or more is a big plus -CI / CD, cloud devops, containers (kubernetes / Docker, etc.
- Python / PySpark / JavaScript;
- Understanding of enterprise data concepts such as Master Data Management and Enterprise Data Warehouse, experience with MDM standards;
- Understanding or knowledge in SQL, report generation using visualization tools such as Tableau / Power BI, programming using Python / Spark;
- Possessing certifications in one of the following AWS / Azure / GCP data engineering; and,
- Supporting data warehouse team and leads in creation of cloud data warehouse plans, roadmap, success metrics, and assessment of clients enterprise (on-premise and on-cloud) data systems.
Demonstrates a thorough level of abilities with, and / or a proven record of success as both an individual contributor and team member, identifying and addressing client needs :
- Demonstrating prior Big 4 or proven consulting experience in strategy through execution projects;
- Working with large Cloud Data Platform, Cloud Data migration or Enterprise Information Management programs;
- Working closely with business stakeholders to capture and document business objectives / requirements, ability to translate business and technology objectives to next generation cloud, digital and technology solution architectures;
- Collaborating with technology teams and architects to define and develop technology solutions;
- Willing to learn and apply modern, cloud-based technology skills, ability to research emerging trends, analyst publications, and adoption of modern technologies in solution architectures;
- Applying a proven collaboration and teaming approach;
- Demonstrating critical thinking and problem-solving methods and skills; and,
- Using appropriate facilitation techniques to gain agreement or move others to action.
Location(s) : TX-Dallas, FL-Tampa, NC-Charlotte, CO-Denver, IL-Chicago, TX-Austin, DC-Washington, TN-Nashville, MA-Boston, NY-New York, TX-Houston AddThis Sharing Buttons Job Category : Data and Analytics Technology Line of Service : Advisory Level : Senior Associate Specialty / Competency : Data and Analytics Technologies Industry / Sector : Not Applicable Job Type : Regular Time Type : Full time Travel Requirements : Up to 60% Job ID : 296171WD Tampa, FL Tampa, FL Chicago, IL New York, NY New York, NY