Data and Analytics Engineer - Richmond, VA OR Dallas, TX - Hybrid - 62887
About the position We have an immediate long-term opportunity with one of our prime clients for a position of Data and Analytics Engineer to work in Richmond, VA or Dallas, TX on Hybrid basis. The Data and Analytics Engineering - Platform team is critical to making our organization's data strategy successful. You will play a key role in building and managing modern, adaptive, data-driven, and secure platforms and processes to enable Data & Analytics Engineering. You should have strong fundamentals of Database Administration, Data/Software Engineering, DevOps, and hands-on experience with Azure Cloud services. You will work on cross-functional initiatives and projects. Responsibilities • Design and build Microsoft SQL Server in datacenters and Azure, including build and configuration automation, security, high availability, disaster recovery, monitoring, and maintenance • Design and implement intelligent, predictable, reliable, scalable, cost-efficient, and easy-to-use platforms and frameworks for Data Science Machine Learning (DSML), Enterprise Data Lake/Warehouse (EDL/EDW), Master Data Management (MDM) functions • Design, implement, maintain cloud platform infrastructure • Evaluate and automate the scaling and capacity requirements within Azure environment • Implement Azure cloud capabilities including but not limited to storage, key vaults, virtual networking, virtual machines, and automated deployments • Implement, setup, configure, monitor, and maintain cloud based Data & Analytics platforms such as Databricks and Snowflake • Troubleshoot and resolve environment performance issues, connectivity issues, security issues • Make recommendations and execute cost saving strategies for Cloud services • Self-directed and able to balance the priorities of multiple teams, systems, and products with a leadership mindset • Work collaboratively in teams and develop meaningful relationships to achieve common goals • Streamline development and operation processes via continuous integration, deployment, automated testing while leveraging SRE principles • Drive efficient resolution for system outages as well as performance and functional shortcomings • Engage in critical support situations and effectively, efficiently, and quickly drive successful resolution • Design and implement solutions that leverage cloud services such as serverless computing, containers, and data lakes Requirements • 7+ years with Microsoft SQL Server (2016-2022) in an enterprise-level environment, including setup, security, monitoring, maintenance, and performance tuning • 5+ years Azure SQL, SQL Managed Instance, and SQL Server on Azure Virtual Machines • 5+ years Cloud Platform Engineering experience in an enterprise-level environment • Advanced proficiency with Python, SQL, GitHub, Azure DevOps, Bicep/Terraform, PowerShell is required • Deep understanding and hands on experience with Infrastructure-as-Code, and configuration management automation tools is required • 5+ years of DevOps experience with a clear understanding of related tools, structure, and processes working in an Agile/Scrum setting • 3+ years leading the end-to-end design and development of scalable services to be consumed by the enterprise, including monitoring and production support • Excellent communication skills, adapting to various audience types • Experience on a fast-paced, highly collaborative agile team within a Product-oriented organization • Effective problem-solving, analytical thinking, cloud-native and security-first mind set, documentation, communication, and presentation skills • Ability to positively influence team norms, culture, and technical vision Nice-to-haves • Bachelor's/Master's in Computer Science or equivalent area • Experience with cloud services such as Snowflake, Databricks, Synapse, SQL, CosmosDB, Data Factory, Event Hub, Functions, Batch, Key Vault, Managed Identity, Service Principal, Networking, Active Directory, Log Analytics, Monitoring • Windows and Linux server/systems administration experience is highly desired • Azure Administrator certification, Solution Architect, or Databricks Platform Administrator certification, Snowflake SnowPro certification is a strong plus • Familiarity with microservices software architecture • Experience with Azure cost management and forecasting is desired Benefits • Pay Rate: $55-$58/hr Apply tot his job