The Senior Database Engineer will play a key role in expanding and optimizing the data architecture and data pipelines at Tietoevry Create. This position is ideal for an experienced data engineer who thrives on building robust, scalable data systems and supporting cross-functional teams with reliable data infrastructure.
What You'll Do
- 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).
What We're Looking For
- Strong experience in SQL with expertise in relational database (PostgreSQL preferable cloud hosted in AWS/Azure/GCP).
- Strong experience in cloud based Data Warehouse like Snowflake (preferable) 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
- 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)
Nice to Have
- Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting
- Experience with NoSQL database to migrate data into other type of databases with real time replication
- Experience with CI/CD automation tools
- Programming language experience in Golang, Python, any programming language, Visualization tools (PowerBI/Tableau)
Technical Stack
- SQL
- PostgreSQL
- AWS
- Azure
- GCP
- Snowflake
- Azure Synapse
- IBM StreamSets
- SnapLogic
- DBT
- OLAP
- GIT
- Azure DevOps
- NoSQL
- Golang
- Python
- PowerBI
- Tableau
Team & Environment
- Distributed development team working across scrum teams
Work Mode
- hybrid
- Ability to easily fit into a distributed development team and work across different time zones
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
