Apply for this job now

Azure Data Engineer Support - Government and Public Sector

Topeka, Kansas
Job Type
7 Sep 2022
At EY, youll 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 were 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

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 property 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 its produced, in any format, and at any quality
To qualify for the role, you must have
  • 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, youll also have
  • Experience working in a diverse fast paced environment in collaboration with other technical teams.
  • Willingness to work flexible hours, non-business hours, or other scenarios required by the flow of operations.
  • Detail-oriented, well-organized with ability to translate & communicate complex and abstract issues.
  • Experience in Installation, Administration and Troubleshooting of Data Technologies in Azure.
  • Experience working Agile/Scrum environment preferred.
  • Experience utilizing automated solutions with Azure Devops as the orchestrator of choice would be a plus.
  • ITIL Foundation Certification and other technology certifications are very beneficial
  • Certified Database Administrator
  • Basic experience with the following tools and technologies:
  • Amazon Web Services
  • Azure ADLS Gen 2
  • Azure Synapse
  • Alteryx
  • AWS DynamoDB
  • Splunk experience
  • SharePoint
What we look for
  • A self-starter, independent-thinker, curious and creative person with ambition and passion
  • History of continuous learning and continuous progression
What we offer

We offer a competitive compensation package where youll be rewarded based on your performance and recognized for the value you bring to our business. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options. Under our flexible vacation policy, youll decide how much vacation time you need based on your own personal circumstances. Youll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
  • ..... click apply for full job details
Apply for this job now


  • Job Reference: 706379122-2
  • Date Posted: 7 September 2022
  • Recruiter: EY
  • Location: Topeka, Kansas
  • Salary: On Application
  • Sector: Government & Defence
  • Job Type: Permanent