Data Systems Analyst

The Goff Financial Group
Job LocationUS

About:

Location: Houston, TX but open to all TX candidates as well as those willing to relocate.

The Goff Financial Group, which is a Houston-based financial company, is seeking a software developer/administrator with experience using Microsoft Access and SQL database development using Azure. Candidate must have excellent grasp of database concepts and be able to develop and upgrade existing databases and internal processes.

Responsibilities:

  • Maintain and Support existing data systems:
  • In-house developed application for managing client portfolios including implementation of trading strategies and creating files for executing trades with brokers
  • In-house developed application for creating and tracking client-facing needs such as cash withdrawals, tax related distributions, incoming cash, and setting up new accounts
  • Using Microsoft Power Automate tools to establish data interchange between systems, databases, and Microsoft data environment (Share Point, Outlook, Dynamics 365)
  • Lead and support usage of Dynamics 365 and establish necessary customizations to meet marketing and client support needs
  • Learn other desktop applications and web-based services and apps

Qualifications:

  • Critical skills in Microsoft Access (client-side functionality) including:
  • Forms: ADO connections, form events, calls to SQL Server, form-subform relationships, and input controls
  • VBA: understanding complex subroutines, global functions, and maintaining integrity of procedures and client-side functions
  • SQL Server (Azure Cloud)
  • Understand table designs and relationships
  • Maintain and develop complex viewsAnalyze and debug (as needed) complex stored procedures and functions
  • Evaluate data import failures and debug source files
  • Azure Cloud Data Storage (blob and file server)
  • Access data storage area, download and upload files
  • Analyze data storage usage and maintain data exchange environment to meet future needs
  • Microsoft SQL Certification
  • Advanced VBA skills
  • Power BI
  • Microsoft Power Automate

The 8 Must-Have Data Analyst Skills

In the field of data analytics, there are a number of skills and qualities that set great analysts apart from the competition. We have outlined the 8 must-have data analyst skills and habits that can help you become an in-demand and proficient data analyst.

Related Industries: Data Analytics

Understanding Data Science Roles: Who Does What?

Looking to leverage your data boot camp knowledge or jumpstart a career in data science? With data becoming increasingly important to companies’ bottom lines, data scientists are some of the most valuable individuals in the professional world today.

Related Industries: Data Analytics, Data Science