Senior Database Developer

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