Highlights
As an Azure Database Engineer, this position will participate in the analysis, design, development, implementation, and potentially ongoing support of Azure Databases and Data Lakes, with a primary focus on the Data Lakehouse and its integrated data reserves. The position will collaborate with cross-functional teams to optimize data workflows, support data-driven decision-making, and implement best practices for data security and integrity in Azure environments.
Numbers & Facts
| Location | St Paul, MN |
| Industry | Computer/IT Services |
| Company Size | 100 to 499 employees |
| Year Founded | 1997 |
| Website | https://www.tscti.com/careers-0 |
Description
Description of Project
The Minnesota Department of Information Technology Services ( "MNIT ") partnering with the Department of Children, Youth, and Families ( "DCYF ") (collectively "State ") is seeking one full-time Database Engineer. The State has an initiative to modernize the child welfare information system environment through the implementation of a Comprehensive Child Welfare Information System ( "CCWIS "). For additional background, the State plans to hire a DDI vendor to implement a solution. In preparation for the DDI solution, the State is planning to consolidate the data from the 87 county databases into a centralized data lake that the new solution will utilize.
As an Azure Database Engineer, this position will participate in the analysis, design, development, implementation, and potentially ongoing support of Azure Databases and Data Lakes, with a primary focus on the Data Lakehouse and its integrated data reserves. The responsibilities will include administering, maintaining, and securing data to ensure efficient and reliable data storage solutions. The position will collaborate with cross-functional teams to optimize data workflows, support data-driven decision-making, and implement best practices for data security and integrity in Azure environments. This position also will provide mentorship to other Database Engineers.
Tasks
" Develop and implement relational and non-relational databases in Azure.
" Develop and implement data transformations.
" Ensure data access patterns are optimized.
" Maintain necessary documentation.
" Coordinate with necessary teams to meet security standards.
" Implement disaster recovery solution.
" Provide knowledge transfer.
Desired Qualifications
" Experience with designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
" Experience with Databricks.
" Experience with Oracle databases.
" Strong experience developing and implementing data transformation solutions and cloud infrastructure integration.
" Strong experience coding and testing programs and scripts to load data using Azure data load utilities.
" Strong experience with CI/CD pipelines.
" Experience with cloud computing concepts.
" Experience with tools such as Azure Monitor, Azure Data Factory, SQL Analytics, Query Performance Insight, Azure Resource Manager, and Azure CLI/PowerShell for infrastructure management.
" Experience in mentoring others in the needed technologies.
" Experience developing and implementing backup and recovery strategies using tools such as Azure Backup or Geo-replication.
" Experience with role-based access control, encryption, and network security.
" Strong organizational and time management skills.
" Desired 7 years' experience designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
" Knowledge of data concepts, data modeling, schema design, and indexing strategies.
" Knowledge of Azure SQL instances, managed instances, and elastic pools.
" Knowledge of Data Warehouse Administration and Teradata Data Warehouse.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
The Minnesota Department of Information Technology Services ( "MNIT ") partnering with the Department of Children, Youth, and Families ( "DCYF ") (collectively "State ") is seeking one full-time Database Engineer. The State has an initiative to modernize the child welfare information system environment through the implementation of a Comprehensive Child Welfare Information System ( "CCWIS "). For additional background, the State plans to hire a DDI vendor to implement a solution. In preparation for the DDI solution, the State is planning to consolidate the data from the 87 county databases into a centralized data lake that the new solution will utilize.
As an Azure Database Engineer, this position will participate in the analysis, design, development, implementation, and potentially ongoing support of Azure Databases and Data Lakes, with a primary focus on the Data Lakehouse and its integrated data reserves. The responsibilities will include administering, maintaining, and securing data to ensure efficient and reliable data storage solutions. The position will collaborate with cross-functional teams to optimize data workflows, support data-driven decision-making, and implement best practices for data security and integrity in Azure environments. This position also will provide mentorship to other Database Engineers.
Tasks
" Develop and implement relational and non-relational databases in Azure.
" Develop and implement data transformations.
" Ensure data access patterns are optimized.
" Maintain necessary documentation.
" Coordinate with necessary teams to meet security standards.
" Implement disaster recovery solution.
" Provide knowledge transfer.
Desired Qualifications
" Experience with designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
" Experience with Databricks.
" Experience with Oracle databases.
" Strong experience developing and implementing data transformation solutions and cloud infrastructure integration.
" Strong experience coding and testing programs and scripts to load data using Azure data load utilities.
" Strong experience with CI/CD pipelines.
" Experience with cloud computing concepts.
" Experience with tools such as Azure Monitor, Azure Data Factory, SQL Analytics, Query Performance Insight, Azure Resource Manager, and Azure CLI/PowerShell for infrastructure management.
" Experience in mentoring others in the needed technologies.
" Experience developing and implementing backup and recovery strategies using tools such as Azure Backup or Geo-replication.
" Experience with role-based access control, encryption, and network security.
" Strong organizational and time management skills.
" Desired 7 years' experience designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
" Knowledge of data concepts, data modeling, schema design, and indexing strategies.
" Knowledge of Azure SQL instances, managed instances, and elastic pools.
" Knowledge of Data Warehouse Administration and Teradata Data Warehouse.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
About Company
22nd Century Technologies, Inc., is one of the fastest growing IT Service Integrator and Workforce Solution companies in the United States. Founded in 1997, 22nd Century Technologies is a Certified National Minority Business Enterprise with 6,000+ people including 600+ Cyber SMEs nationwide supporting our customers in all 50 states, Canada, and Mexico. With HQs in Somerset, NJ and Mclean, VA, 22nd Century has 14 offices throughout the United States. As part of our unrelenting focus on quality and compliance, 22nd Century Technologies’ delivery is based on Certified Matured Processes including CMMI L3 Dev & SVC, ISO 20000, ISO 27001, and ISO 9001 quality processes. With a strong focus on the public sector, 22nd Century currently holds government contracts with 14 out of 15 Federal Executive agencies including DoD, 37 other Federal agencies, 50 States, 115+ Local agencies, and 37 School Districts. In the last three years, we have expanded our services to Fortune 500 and other commercial clients and currently support 80+ commercial clients.
Recognized among “Best Company to Work For” by Forbes, 22nd Century Technologies, Inc., consistently exceeds our clients’ expectations by focusing on their absolute satisfaction with jobs while keeping our employees motivated.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.