Salary
$93,303.46 - $139,955.20 Annually
Job Type
Full-time
Job Number
24RSA20101rla047
Closing Date
7/17/2024 11:59 PM Central
Description
Resident Services IT is seeking an experienced Senior IT Engineer (Data) to lead and support the development and maintenance of data technology infrastructure collaborating with the Resident Services development teams, the Information Technology department, and the Integrated Data Analytics business team. This is necessary to support data and analytics initiatives for the departments within the Resident Services line of business. We are a small a group of collaborative teams dedicated to the technology of the Resident Services line of business and offer excellent work life balance. Candidates must have a right to work in the U.S. that is not based solely on possession of a student visa or a visa sponsored by an employer. Current Hennepin County employees who refer a candidate hired into an open competitive position may be eligible for a $500 referral bonus. For more information visit employee referral program.
Location and hours:
This position is remote. Remote employees may be required to come on-site 0 to 12 days a year for work meetings, trainings, or for any other reasons that their supervisor may deem necessary (may include additional days for onboarding and new employee training). Supervisors will provide as much advance notice as practicable. Based on the business needs for this position, individuals must reside in Minnesota or have approval to work from a state authorized by Hennepin County as approved for out-of-state remote work. For a complete listing of allowable states, click here. Candidates must currently reside in or be willing and able to relocate to Minnesota or one of the approved states. Employees living out of state are responsible for all travel expenses when required to come on-site. Individuals who do not reside in or are not willing to relocate to one of these states will not be considered. Work hours are Monday through Friday, 8 a.m. - 4:30 p.m. with flexibility. New employees who are hired into remote or hybrid positions between January 2, 2022, to December 31, 2024, will receive $500 toward the cost of establishing consistent internet connectivity, payable upon completion of 6 months of employment.
About the position type:
This is a full-time, benefit earning position. This position is internally classified as a Senior IT Engineer - IT Database Engineer. Click here to view the job classification specification. At this time, employees may be eligible to receive an additional cash merit of up to $2799.11 that can be earned annually based on performance.
Note:
You must attach a resume and cover letter to be considered for this position.
In this position, you will:
· Lead and support the development and maintenance of data technology infrastructure that supports the data and analytics initiatives for departments within the Resident Services line of business.
· Apply information technology resources to the data domain of expertise as an Azure Data Engineer.
· Create and curate reusable sample libraries for pipelines, integrations, code, automation, scripts, and configuration.
· Build and optimize frameworks to ensure efficient data integrations, transformations, warehousing, data lake/fabric architectures, access and retrieval activities; contribute and influence ongoing decision processes around data collection, analysis, and appropriate protocols for security regulations.
· Promote best practices around data governance, security and quality, modern data management, ETL and ELT, reporting and visualization technologies; stay current with data technologies to ensure Hennepin County data practices are in-line with the evolvement of consumer needs and technological resources.
· Evaluate new products and existing systems in order to identify and lead new process improvement opportunities and implementation.
· Contribute to the planning of the overall organizational data strategy by providing advice and guidance towards desirable outcomes.
· Develop and enforce technical standards and interface tools including the development of appropriate systems models (such as network diagrams, data models, etc.).
· Drive deployment and adoption of new architecture; train and mentor IT staff in new technologies.
Need to have:
· One of the following:
o Associate/vocational/technical degree in computer science, computer engineering, or a related information technology field and five or more years of information technology experience.
o Bachelor's degree or higher in computer science, management information systems, data engineering, business intelligence, data analytics, or a related information technology field and three or more years of information technology experience.
o Seven or more years of information technology experience.
AND
· Current certification in a leading professional level certification area (e.g., Microsoft, Cisco, CompTIA, Infoblox Core DDI, etc.).
Nice to have:
· One or more Microsoft Azure certifications (e.g., Fundamentals, Data Fundamentals, Database Administrator Associate, Data Engineer Associate, Cosmos DB Developer Specialty).
· Three years or more experience with Coud technologies (Azure, AWS, GCP), Modern Data Architecture and Implementations, Azure Data Factory, Azure Synapse Analytics, Azure DataLake/OneLake, Azure Databricks, Cosmos DB, Microsoft Fabric, and Microsoft Purview.
o Experience using T-SQL or PL/SQL, XML, JSON, Spark coding (Scala and/or Python).
· Knowledge of:
o Data storage, integration and transformation by consuming, cleansing, and consolidating data from diverse sources.
o Architectural patterns such as Modern Data Warehouse and Lakehouse Architecture.
o Operationalization and optimization by ensuring data pipelines and data stores are high performing, efficient, organized and reliable.
o Continuous improvement and Agile methodologies and frameworks.
o Broad IT background required to partner with other domains (cloud, security, application, data, etc.).
o Microservices and SOA.
o Cloud-native and serverless.
o Microsoft Fabric, Purview, Azure (Data Factory, Synapse, Data Lake or OneLake Storage, Databricks).
· Ability to:
o Use creative problem solving when confronted with issues.
o Code complex SQL Queries.
o Provide excellent customer service and interact with end users.
o Effectively work in collaboration with other developers, managers, and customers, working in a team development environment.
o Communicate effectively both verbally and in writing with all levels of the organization.
o Focus on system capabilities and functionalities in lieu of single technological application or system.
· Skill in:
o Database design, implementation, maintenance, and migration for on-prem to cloud based SQL solutions including temporal databases and data warehouses, data lakes, and data lakehouses.
o Consuming REST API services.
o T-SQL or PL/SQL, XML, JSON, Spark coding (Scala and/or Python).
o Cloud platforms (Azure, AWS, GCP) for support and development of solutions.
If you have any questions, please contact:
Roberta Arpinar