Back to all jobs

Application Development

Title: Sr. Data Engineer
Location: Remote
Duration: 6 Month CTH or Direct Hire

Job Description:

The Sr. Data Engineer designs, builds, and supports data initiatives that meet business needs. This is done by ensuring data initiatives and related project tasks are completed on time, within budget following best practices. Offer meaningful perspectives on design patterns, concepts, alternatives, and best practices.

Support Enterprise Data Architect, DBAs, Data Engineers, Business Analysists, and Project Managers with scoping, assisting in estimating and planning tasks, key milestones, and dependencies. Effectively collaborate with business and application stakeholders when gathering requirements. Document solution details, and develop and maintain technical specification documentation for all solutions.

Responsibilities:

  • The responsibility of the Sr Data Engineer is to provide best practice technology solutions for projects, support, and maintenance including SQL Server administration and development, Synapse, ADF, and related data systems and processes. Able to provide viable solution recommendations and act as a subject matter expert regarding EDW initiatives. Authors and maintains solution design documentation. Identifies and communicates risks associated with solutions and processes.
  • Participates in all phases of Enterprise Data Warehousing (EDW) activities including requirement analysis, application design, code development, testing, release, and maintenance, following Agile/Scrum methodology to deliver high-quality software sprint releases. Participates in design and reviews to ensure they meet best practice security policies and design principles. Develops efficient, well-structured, reusable, and scalable data solutions.
  • Support multiple SQL Server implementations at various support levels. Install, configure and provide day-to-day support after implementation, including off-hours as needed. Understanding of database design and query strategy to provide suggestions for optimal performance. Quickly learns the new features of RDBMS and becomes proficient at implementing as they become available. Analysis and implementation of additional 3rd party software solutions and database add-on solutions when required.
  • Ability to work as and partner with DBAs to monitor and troubleshoot database instances; perform root-cause analysis; identify opportunities for improved system performance, assist and participate in implementation. Ability to work as and partner with Data Engineers to monitor and troubleshoot ETL and ELT processes; perform root-cause analysis; identify opportunities for improved system performance, assist and participate in implementation.
  • Provides technology expertise and guidance, remaining current with emerging technologies and industry best practices. Provides guidance to less experienced team members based on best practices. Adapts to new programming languages, methodologies, platforms, and frameworks to support the business needs.
  • Administer all aspects of the SQL Server stack. Performs thorough code reviews and transfer knowledge based on data engineering standards and writes unit and integration tests based on chosen languages. Accepts other duties as assigned. Analyzes and resolves data and processing issues whenever required.

Requirements:

  • Bachelor’s degree in Computer Science, Data Engineering, Information Technology or equivalent, or equivalent educational/work experience. 5+ years of Microsoft SQL Server Administration experience (2012 and above) including HA environments in the cloud and on-premises, Synapse. 5+ years of experience SSMS, SSIS. Experience applying Service Packs and Hotfixes to SQL Server. Strong On-call troubleshooting experience with SQL Server, ADF, and Synapse.
  • Strong knowledge of Synapse, Azure Data Factory, and Azure Data Lake. Expert knowledge of common database administration tasks such as backup & restore, recovery models, integrity checks, high availability replication methods, and backup encryption. Self-starter with ability to work independently as well as in a team environment by using knowledge on process workflow while keeping abreast of all assigned issues.
  • Deep experience with SQL, T-SQL, stored procedures, views, indexes using Microsoft SQL Server including SQL Server Management Studio (SSMS). Experience with creating and maintaining data warehouses, data marts, and operational system databases. Strong knowledge of all phases of SDLC. Experience with CI/CD processes and tools. Well versed with agile methodologies and source code versioning strategies including branching, forking, and merging.
  • Desire to work in growing, fast-paced, and highly flexible team. Manage workload, manage multiple priorities, and manage conflicts with customers/employees/managers, as applicable. Ability to quickly learn new technologies and adapt to a fast-paced development environment. Interact well with other technical team leaders such as architects, testing, analysts, and release managers as a lead member of the development team in order to accomplish the business goals. Excellent communication skills.
  • Knowledge of Atlassian stack and DevOps (CI & CD) and other dependency management and build tools such as Bitbucket, GitHub, Bamboo, and DevOps. Knowledge of troubleshooting wait statistics/performance with Paul Randall and Glenn Berry. Knowledge of Ola Hallengren’s maintenance procedures/scripts. Knowledge of Chrissy Lemaire’s DBA tools. Knowledge of general troubleshooting and performance tuning with Brent Ozar’s sp_blitz* procedures.
  • (Bonus) Experience with Solarwinds SQL Sentry. (Bonus) Experience with Message Queuing (MQ) technologies. (Bonus) Experience with Alation Data Governance and Catalogue. (Bonus) Experience with Data Bricks.

We’re an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

This serves as notice per Iowa drug testing notification laws; applicants that reside in Iowa are subject to drug testing.