at EY in Little Rock, Arkansas, United States
Job Description
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. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.
From strategy to execution, the Government & Public Sector (GPS) practice of Ernst & Young LLP provides a full range of consulting and audit services to help our Federal, State, Local and Education clients implement new ideas to help achieve their mission outcomes. We deliver real change and measurable results through our diverse, high-performing teams, quality work at the highest professional standards, operational know-how from across our global organization, and creative and bold ideas that drive innovation. We enable our government clients to achieve their mission of protecting the nation and serving the people; increasing public safety; improving healthcare for our military, veterans and citizens; delivering essential public services; and helping those in need. EY is ready to help our government build a better working world.?
Our GPS Technology Organization is a structure within the US GPS practice that implements and maintains a new operate and technology model designed specifically to support U.S. defense and Government engagements.
The opportunity
This is a remote opportunity that can be performed within Continental United States.
You will be a key member of a dedicated operations team with responsibility of assuring overall health of data and database environments, making recommendations on performance improvements, job improvements, development of playbooks and implementation of Azure functions.
You will monitor applications and environments in Azure Gov for exceptions, review their performance, manage demand planning and capacity utilization. Your focus will be on stability and application uptime with an emphasis on quick incident resolution and automated solutions that prevent future outages. You will support promotion cycles of solutions, testing and executing version upgrades and patches.
You will be expected to keep up with industry developments and standards, ensuring innovative approaches to operate and support data environments.
You will support the delivery of processes to extract, transform and load data from disparate sources into a form that is consumable by analytics processes, for projects with moderate complexity, using strong technical capabilities.
You will help design, develop and produce data models of relatively high complexity, leveraging a sound understanding of data modelling standards to ensure high quality.
You will collaborate with other departments across the business to help define and deliver business value, and may interface and communicate with program teams, management and stakeholders as required to deliver small to medium-sized projects
Your key responsibilities
+ Lead delivery of on-going maintenance and management of pre-production, production environments, setting timelines and monitoring activities in alignment with business requirements
+ Contribute to the development of implementation plans for dealing with more complex requests for change
+ Review new product support documentation and design release packages for solutions
+ Monitor effectiveness of installations and ensure that appropriate recommendations for change are made
+ Oversee preliminary reviews for new environments and the adaption of findings to existing environments, including capacity and performance management recommendations,
+ Develop internal control standards and contribute to the development of procedures
+ Lead the production of high-quality data engineering deliverables, helping to ensure project timelines are met, and providing informal mentoring / training to junior members of the team
+ Lead the delivery of data quality reviews including data cleansing where required to ensure integrity and quality
+ Lead the delivery of data models, data storage models and data migration to manage data within the organization, for a small to medium-sized project
+ Resolve escalated design and implementation issues with moderate to high complexity
+ Analyze the latest industry trends such as cloud computing and distributed processing and beginning to infer risks and benefits of their use in business
+ Provide technical expertise to maximize value from current applications, solutions, infrastructure and emerging technologies and seek to continuously improve internal processes
+ Drive adherence to the relevant data engineering and data modelling processes, procedures and standards
+ Develop relationships with other engineering groups to gain a strong understanding of products and services as well as key business processes and apply technical support engineering expertise to ensure solutions are properly managed and maintained?
+ Support data platforms, databases, and infrastructure in Azure Gov following a shift schedule with availability during afterhours.
Skills and attributes for success
+ Comprehensive understanding of Data and Database technologies with ability to troubleshoot underlying issues.
+ Knowledge of business processes, products, and services, within agreed areas of expertise and is able to provide input and advice to key stakeholders, such as Product Owners, business sponsors and Service Delivery Managers?
+ Full stack knowledge of technologies in Azure Gov is a plus
+ Ability to systematically break apart complex problems (written, verbal or numerical). Ability to analyze figures to solve a problem.
+ Ability to be analytical and systematic whilst being open-minded and creative.
+ Able to base decisions on facts rather than emotions, and always using logic.
+ Ability to design an efficient way of processing high volumes of data where a group of transactions is collected over a period of time
+ Ability to design and implement models, capabilities and solutions to manage data within the enterprise (structured and unstructured, data archiving principles, data warehousing, data sourcing, etc.). This includes the data models, storage requirements and migration of data from one system to another
+ Ability to review (profile) a data set to establish its quality against a defined set of parameters and to highlight data where corrective action (cleansing) is required to remediate the data
+ Ability to discover, integrate, and ingest all available data from the machines that produce it, as fast as it’s produced, in any format, and at any quality
To qualify for the role, you must have
+ Bachelor’s Degree in Computer Science or related discipline or equivalent work experience
+ 5+ years Database Experience including administration and troubleshooting
+ DB Administration and troubleshooting experience in a technology area such as Azure SQL MI, SSIS, Azure SQL PaaS, Azure Data Factory
+ Working Knowledge of SQL Server Database configuration, support and administration tasks
+ Microsoft SQL Server, Windows Service Bus, IIS, .NET, Cloud Development Platforms
+ Excellent analytical and communication skills (verbal and written).
+ Ability to effectively prioritize and execute tasks in a dynamic and high-pressure environment
+ Ability to work in a team environment with in a high performing team
+ Ability to obtain and maintain Top Secret security clearance level
+ Flexibility to work weekends or afterhours as needed
+ Beginning to intermediate experience with the following tools and technologies:
+ Azure Data Catalogue / Purview
+ Azure Cloud
+ Databricks
+ Power BI Dataflows
+ Power Query
+ Azure Cosmos
+ Azure Monitor
+ PowerShell
+ Python
+ R
Ideally, you’ll also have
+ Experience working in a