Senior Database Developer

RichRelevance; Marietta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading company in data solutions seeks a Senior Database Developer/Programmer to join their Center of Excellence Group. This role involves designing and maintaining data applications, collaborating with IT teams, and ensuring effective data service delivery to support enterprise strategies. The ideal candidate will possess a Bachelor's degree and strong experience in SQL Server and data management.

Qualifications

• 6-7 years of experience in developing and maintaining data processing and reporting applications.
• Strong knowledge of data engineering & best practices for software development life cycle.
• Familiarity with self-service BI platforms.

Responsibilities

• Design, develop, maintain, and support data and reporting applications.
• Perform data modeling and database design for applications.
• Create deployment packages and instructions for releases.

Skills

SQL Server

T-SQL

Stored procedures

SSIS

Data engineering

Problem-solving

Technical Documentation

Education

Bachelor's degree in Computer Science or Management Information Systems

Job description

Education: A Bachelor's degree in Computer Science, Management Information Systems

At Algonomy, we believe the future of our economy is Algorithmic, where businesses will develop resilient, adaptive and agile decisioning abilities that will constantly test and refine AI-driven actions to create the best personal experience for every individual customer at scale.

We aim to become the algorithmic bridge between consumers and brands/retailers, and to lead our customers through the Algorithmic transformation imperative. The name Algo-nomy signifies an expertise in algorithms. As technology evolves our lives (and our clients’) at hyper-speed, Algonomy stands as a bold, creative and agile brand; and these are also the very qualities that every digital-first business needs in order to be successful in the new normal. We are ambitious, we create category leading solutions in our markets, and we are constantly learning, inventing and adapting to stay ahead of our industry’s needs

Job Profile:

The Senior Database Developer/Programmer acts as a senior member of the Center of Excellence Group within IT Professional Services and is responsible for the overall design, development, test, release, maintenance, and technical support of data and reporting applications to ensure effective data services delivery and support enterprise strategies. This role is also responsible for working with Information Technology (IT) Infrastructure Services to ensure server platform and security needs of data and reporting systems are met.

Primary 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.
• 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.
• 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
  • Performance tuning and database design for SQL Server
  • Building Operational Data Stores, Data Marts, and/or Data Warehouses
  • Working with non-relational data sources such as flat files, excel files, JSON files, and APIs
• Familiarity with:
  • Self-Service Business Intelligence platform
  • Data quality management and master data management
• Experience in teaching and mentoring developers and/or users.

Knowledge:

• 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.

Skills:

• 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

Nice to Have

• Retail/CPG exposure
• Exposure to a cloud technology like AWS, Azure, Redshift, or GCP-based DBS