Remote Data Engineer | Growth & BI/ETL Expert

Affirma; Ireland; Remote; EUR 55,000 - 75,000; Full time

Job summary

Affirma, a full-service technology consultancy in Ireland, seeks a Data Warehouse Engineer with 2–4 years in dimensional modeling, ETL, and data warehousing. You will design and implement data solutions, integrate multiple data sources, and help production deployments while maintaining documentation and standards.

The role emphasizes SQL and Python development, collaboration with teams, and ongoing knowledge growth in data and analytics tools within a dynamic environment.

Qualifications

• 2-4 years experience in dimensional data modeling, ETL development, and data warehousing in a professional capacity.
• Hands-on experience with leading ETL, database, or data warehousing technologies like Azure, SQL Server, Databricks, SSIS, Data Factory, etc.
• Strong knowledge of relational databases including retrieving, manipulating, creating, updating, and deleting data and database objects.
• Experience bringing together data from many disparate data sources to a unified source of truth.
• Hands-on experience implementing data warehouses of any scale and understanding of data warehousing best practices.
• Advanced knowledge of T-SQL and Python in developing complex queries, stored procedures, functions, and database administration operations, and query optimization and tuning.
• Ability to work in a dynamic environment with some level of ambiguity to implement customer and project requirements with minimal supervision.
• Excellent written and verbal communication with stakeholders, team members, and in documentation.
• Bachelor's degree or equivalent education and/or experience

Responsibilities

• Design, propose, and develop database and data warehousing solutions.
• Collaborate with team members to refine and debug scripts and reports.
• Write and maintain documentation to describe database development, logic, scripting, testing, changes, and corrections.
• Support the release of solutions into production environments.
• Balance shifting priorities, demands, and timelines while effectively communicating expectations to team members and stakeholders in a clear and timely fashion.
• Provide technical assistance to data consumers regarding errors, problems, or questions with databases and reports.
• Provide thought leadership, best practices, and standards required to deliver effective, lasting, and easy-to-maintain solutions to clients.
• Continuously grow depth and breadth of knowledge of leading data and analytics tools and principles

Skills

Dimensional data modeling

ETL development

Data warehousing

Python

T-SQL

Education

Bachelor's degree or equivalent education/experience

Tools

Azure

SQL Server

Databricks

SSIS

Data Factory

Job description

Affirma, a full-service technology consultancy in Ireland, seeks a Data Warehouse Engineer with 2–4 years in dimensional modeling, ETL, and data warehousing. You will design and implement data solutions, integrate multiple data sources, and help production deployments while maintaining documentation and standards.

The role emphasizes SQL and Python development, collaboration with teams, and ongoing knowledge growth in data and analytics tools within a dynamic environment.