Job Description
Senior Database Engineer, you will be responsible for expanding and optimizing our data architecture and data
pipelines. The ideal candidate is an experienced data engineer and data wrangler who enjoys optimizing data
systems and building them from the ground up. The Database Engineer must be self-directed and comfortable
supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the
prospect of data process automation and optimizing or even re-designing our company’s data architecture to
support our next generation of products and data initiatives.
Key Responsibilities:
— Build the data pipeline for optimal extraction, transformation, and loading of data from a wide variety of data
sources using SQL and cloud database technologies.
— Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related
technical issues and support their data needs.
- Work with data and analytics experts to strive for greater functionality in our data systems.
— Assemble large, complex data sets that meet functional / non-functional business requirements.
-— Ability to quickly analyze existing SQL code and make improvements to enhance performance, take advantage
of new SQL features, close security gaps, and increase robustness and maintainability of the code.
-— Identify, design, and implement internal process improvements: automating manual processes, optimizing data
delivery for greater scalability, etc.
— Unit Test databases and perform bug fixes.
— Develop best practices for database design and development activities.
— Take on technical leadership responsibilities of database projects across various scrum teams.
— Manage exploratory data analysis to support dashboard development (desirable).
Key Requirements:
Experience: 8-12 years would be preferable.
Required Skills:
— Strong experience in SQL with expertise in relational database (PostgreSQL preferrable cloud hosted in
AWS/Azure/GCP).
— Strong experience in cloud based Data Warehouse like Snowflake (preferrable) or any similar ones like Azure
Synapse.
— Competence in data preparation and/or ETL/ELT tools like IBM StreamSets, SnapLogic, DBT, etc. (preferably
strong working experience in one or more) to build and maintain complex data pipelines and flows to handle
large volume of data.
— Understanding of data modelling techniques and working knowledge with OLAP systems
- Deep knowledge of databases, data marts, data warehouse enterprise systems and handling of large data sets.
- In-depth knowledge of ingestion techniques, data cleaning, de-dupe, etc.
— Ability to fine tune report generating queries.
— Understanding of index design and performance-tuning techniques
- Familiarity with SQL security techniques such as data encryption at the column level, Transparent Data
Encryption (TDE), signed stored procedures, and assignment of user permissions
— Experience in understanding the source data from various platforms and mapping them into Entity
Relationship Models (ER) for data integration and reporting (desirable).
- Adhere to standards for all database e.g., Data Models, Data Architecture and Naming Conventions
— Exposure to Source control like GIT, Azure DevOps
— Understanding of Agile methodologies (Scrum, Kanban)
— experience with NoSQL database to migrate data into other type of databases with real time replication
(desirable).
— Experience with CI/CD automation tools (desirable)
— Programming language experience in Golang, Python, any programming language, Visualization tools (Power
BI/Tableau) (desirable).
Personal Attributes:
— Very good communication skills.
- Ability to easily fit into a distributed development team.
-— Ability to manage timelines of multiple initiatives.
-— Ability to articulate insights from the data and help business teams make decisions
- Able to work with ambiguous requirements, to seek clarity around uncertainty and to manage risks
- Ability to communicate complex concepts to non-data audiences
-— Actively participate in User story refinement, design of the solution and develop the same to meet or exceed the
acceptance criteria.
- Excellent verbal and written communication skills and ability to work in a collaborative manner with peers
across different time zones.
Personal Attributes:
— Very good communication skills.
- Ability to easily fit into a distributed development team.
-— Ability to manage timelines of multiple initiatives.
Additional Information
At Tietoevry, we believe in the power of diversity, equity, and inclusion. We encourage applicants of all backgrounds, genders (m/f/d), and walks of life to join our team, as we believe that this fosters an inspiring workplace and fuels innovation. Our commitment to openness, trust, and diversity is at the heart of our mission to create digital futures that benefit businesses, societies, and humanity.
Diversity, equity and inclusion (tietoevry.com)