*This is a temporary assignment, from September-December*
The Database Analyst I role is responsible for programming, creating logics and use code as a standard part of building, updating a database. This role is also responsible for adjusting existing code to customize database features. This role maintains the daily activities of the team responsible for design, implementation, maintenance and support of enterprise Data Warehouse systems. Provides the evaluation, implementation, maintenance and documentation of existing and emerging database technologies primarily relational, structured databases and also NoSQL, unstructured cloud database technologies. Configures and troubleshoots database and database related applications, consults with development and engineering resources to ensure best practices are followed. This position is also accountable for providing development and operational support to other IT development resources.
DIMENSIONS:
Components Supported: Multiple Redundant Datacenters
Multiple Cloud-Based Infrastructure (IaaS)
Multiple Database-as-a-service (DaaS)
600+ Desktop Systems
50+ Mobile Devices
200+ Servers
Multiple Redundant Unified Communications Systems
26 Branch Locations & Spectrum Center
Hardware/Software Assets Managed: $4MM +
Annual Capital Expenditures: $400M-$600M
Annual Service Contracts Administered: $250M-$350M
Supervisory responsibilities:
- This position reports directly to the Manager, Data Warehouse for coaching, performance appraisal work, guidance, direction and feedback.
- This position will be a part of three Database Engineers and five Software Developers.
NATURE & SCOPE:
As a Data Analyst:
- This position will provide overall development, programming, coding and troubleshooting effort for all the databases and database related application technologies. Collaborates with Data Architecture and Core Development teams to assure adherence to best practices and process standardization.
- Actively participates in design, development and implementation of Data Analytics and Data Warehouse projects, Data Governance, Data Quality systems for standardization of member data and actively participates in the database related activities for the digital platform conversion project.
- Performs the implementation, maintenance, and documentation of existing and emerging database technologies on premise as well as cloud infrastructure. Provides advanced support for SQL database, NoSQL database and cloud database enabled applications.
- Configures and maintains the organization’s Operation Data Store (ODS) that will contain Single Source of Truth (SSOT) information and accesses data directly from an online transaction processing (OLTP) system which are located in Azure cloud and on premise infrastructure.
- Maintain, configure and automate changes required for the organizations core Data Warehouse system which is a Relational Database, to perform effectively on the daily load and the nightly data extract transform and load (ETL) process.
- Develops datasets for analytics in Data Analytics platform and creates advanced reporting within Business Intelligence tools.
- Develops and maintains data fields utilized by the Fraud department to actively monitor fraud alerts on live systems.
- Assist in deployment of various business applications from lower environments to production using automated build tools and scripting.
- Provides advanced support for database systems, including High Availability using Always on Availability Groups (AG’s) and Basic Availability Groups (BAG’s), Disaster Recovery, performance tuning, troubleshooting long running queries, index maintenance, and analyzing query plans.
- SME for various business applications used by departments such as accounting, consumer lending, collections, card services, support services and ensures IT systems are kept up to date according to the organization’s policies.
- Follows agile software development methodologies - Scrum process for software development and Kanban for bugs and tickets.
- Participates in help desk functions periodically to ensure quality service is provided according to company standards in a timely and effective manner.
- Creates or updates and make improvements to related procedure/manuals identifying Standard Operation Procedures (SOP) for assigned tasks.
- Provides technical support to credit union staff to ensure effective utilization of SQL databases, including capacity and performance planning.
- Establishes and maintains regular written and in-person communications with the organization’s end users regarding pertinent IT activities.
- Exhibit excellent customer service skills towards internal and external customers.
Education, skills, & abilities:
The Eight Superpowers
- Provides leadership through modeling of behaviors and bringing forward new ideas and new ways of doing things.
- Demonstrates empathy, self-reflection, and adjustment of own behaviors, showing effective emotional intelligence.
- Practices active listening in communications with others, giving someone full attention and listening to understand, not just respond.
- Demonstrates grit, persisting in application of knowledge, skills, and behaviors to achieve goals and address obstacles.
- Models’ intrinsic motivation; is self-driven to meet or exceed objectives, timelines, and quality measures while building and sustaining effective relationships.
- Applies creative problem-solving to provide clarity, handle resources under one’s control, and address stressful situations; finds ways to meet individual, team, and member goals, by navigating through barriers.
- Shares a diverse set of perspectives, work and life experiences, as well as religious and cultural differences. Actively seeks out differences in values, ideas, and priorities. Respects and value the differences of others, including but not limited to: national origin, language, race, color, disability, ethnicity, gender, age, religion, sexual orientation, gender identity, socioeconomic status, veteran status, and family structures. Believes a diverse workplace is essential to the company’s success.
- Values and shows appreciating for the unique qualities and experiences of each person-inclusion; appreciates and effectively utilizes the talents and skills of others to achieve objectives; is open to the perspective of others; and encourages collaboration, flexibility and fairness. Makes each employee feel valued and supported for their unique qualities.
Other Education, Skills, and Abilities
- Requires an undergraduate degree in computer science, science or related discipline. Also requires a minimum of 3years of related work experience utilizing comprehensive knowledge of database development and database engineering.
- Excellent knowledge and skills in Microsoft SQL Server, T-SQL coding, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MySQL in Amazon RDS, Azure SQL Database and Managed Instance.
- Requires experience in Extract, Transform and Load (ETL) process using SQL Server Integration Services and also experience in hybrid data integration using Azure Data Factory (ADF).
- Knowledge and experience in configuring and maintaining organizations Operational Data Store (ODS) using unstructured database like Cosmos DB and MongoDB Atlas cluster in Azure cloud environment.
- Requires hands on experience in Informatica Data Quality (IDQ) for data standardization; Data Integration using Informatica Intelligent Cloud Services (IICS) and Data Governance experience.
- Highly skilled in data transformation services Business Intelligence Development Studio (BIDS) and experience in developing, administering and present reports through BI Tools like Power BI or Tableau.
- Hands on experience in Data Analytics platforms like Azure Synapse Analytics and Snowflake is a plus.
- Expertise in scripting and automation using PowerShell.
- Code promotion using source control tools like Visual Studio, GitHub, Team Foundation Server and Azure DevOps Server is a plus.
- Experience in data encryption technologies like TDE (Transparent Data Encryption), data masking, data obfuscation, Always Encrypted and column encryption is a plus.
- Knowledge in programming languages such as .NET, HTML, XML, JavaScript and Python is preferred.
- Knowledge in configuring and maintaining web applications using Microsoft IIS and Java is preferred.
- Experience in enterprise applications like outlook, exchange, active directory, SharePoint Online, FootPrints, ServiceNow ticketing system is a plus.
MAJOR ACCOUNTABILITIES:
- Strives to achieve the organization strategic initiatives that include 360-member view for the organization and support development work needed for the implementation of Single Source of Truth (SSOT), golden records in the ODS system.
- Provides development work required for projects related to the organization’s database technologies and other projects that may directly impact the member and development environments.
- Support Enterprise Data Warehouse systems, Big Data Analytics platforms and Business Intelligence.
- Helps in the organization’s development operations functions to ensure productivity, quality and customer service demands are met according to the organization’s standards.
- Ensure member service and satisfaction are a priority in database related projects and implementations.
- Provides technical support to Business Users, troubleshoots and resolves database related issues.
- Certifications around Microsoft SQL Server, Microsoft Azure Fundamentals is a plus.
- Banking industry experience is a plus.
Salary Range
45.00 - 49.00/hr.