Algonomy is looking to hire a Senior Database Developer to design, develop, test, release, maintain, and provide technical support for data and reporting applications, ensuring effective data services delivery and support for enterprise strategies.
Requirements
- 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
- Proficient in developing solutions using SQL Server, T-SQL, Stored procedures, and SSIS.
- Proficient in performing system and/or integration testing.
- 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.
Responsibilities
- 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.
Other
- Participates in a team-based, scrum development environment.
- Analyzes and understands business users' requirements, clarifying inconsistencies, conflicts, or ambiguities, to effectively develop solutions that meet business needs.
- Experience in teaching and mentoring developers and/or users.
- Skilled in communicating with functional teams of different technical experiences.
- A Bachelor's degree in Computer Science, Management Information Systems, or a closely related field from an accredited college or university is required.
