Apply on Employer Site

Algonomy · 21 hours ago

Senior Database Developer

Oklahoma City, OK

Full-time

Onsite

Senior Level

$80K/yr - $85K/yr

5+ years exp

Algonomy is a company focused on algorithmic solutions for businesses aiming to enhance customer experiences. The Senior Database Developer will design, develop, and maintain data applications while ensuring effective data services delivery and supporting enterprise strategies.

Computer Software

Responsibilities

Participates in a team-based, scrum development environment

Adheres to established best practices, standards, and agreed-upon design patterns for data and reporting application development and support

Analyzes and understands business users' requirements, clarifying inconsistencies, conflicts, or ambiguities, to effectively develop solutions that meet business needs

Responsible for the design, development, test, release, maintenance, and technical support of custom data applications such as data pipelines/ETLs/data processing/APIs

Performs data modeling and database design for data and reporting applications as well as other applications as needed

Performs analysis, design, and implementation of data migration as needed

Participates in design/code reviews

Documents data and reporting application implementations, configurations, and support requirements as needed

Creates deployment packages and instructions for releasing data and reporting applications across environments

Corrects reported incidents on data and reporting applications and releases fixes through the change control processes

Performs solution assessment as needed

Conducts proof of concept to guide technical implementation as needed

Qualification

SQL ServerT-SQLData modelingData WarehousingData integrationData migrationAgile methodologiesTechnical DocumentationCritical thinkingCommunication skills

Required

A Bachelor's degree in Computer Science, Management Information Systems, or a closely related field from an accredited college or university is required

6-7 Years of experience in the solution development life cycle for developing and maintaining data processing and reporting applications

Extensive experience with relational and multidimensional data modeling

Extensive experience with performance tuning and database design for SQL Server

Extensive experience with building Operational Data Stores, Data Marts, and/or Data Warehouses

Extensive experience with working with non-relational data sources such as flat files, excel files, JSON files, and APIs

Familiarity with Self-Service Business Intelligence platform

Familiarity with data quality management and master data management

Experience in teaching and mentoring developers and/or users

Strong knowledge of data engineering & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations

Working knowledge of agile methodologies

Knowledgeable in data integration and/or data migration design and implementation, data management principles and best practices, and the architecture and design of Business Intelligence solutions

Proficient in developing solutions using SQL Server, T-SQL, Stored procedures, and SSIS

Proficient in performing system and/or integration testing

Proficient in applying critical thinking skills in problem-solving

Skilled in communicating with functional teams of different technical experiences

Technical Documentation