Dice is the leading career destination for tech experts at every stage of their careers. Our client, Apex Systems, is seeking the following. Apply via Dice today!
Job#: 2045281
Job Description:
Data Analyst
Hybrid (San Diego, CA)
JOB OBJECTIVE:
The Database Analyst I role is responsible for programming, creating logics and use code as a standard part of building, updating a database. 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.
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: 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 in Azure cloud and on-premises 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.
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 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.
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.