Designation: Senior Database Developer
Experience: 5 to 7 years
Location: Oklahoma City
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.
- 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.
Minimum requirements:
- 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
