Data Engineer

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

Preferred experience includes:

• Background in computer science or related technical field
• Experience working with Big Data tools like Hadoop

Accountabilities and Measures:

• Keeping our clients happy
• Working and collaborating well with internal and external team members
• Adhering to billable and un-billable policies

Why Affirma?

• One of Irelands Top 12 Tech Companies to Watch (According to The Irish Times)
• Casual environment, surrounded by incredibly intelligent and motivated co-workers, and a performance-driven culture
• Flexible Schedule
• Opportunity for growth
• Great location, great people, exciting projects, and tons of fun
• Opportunity to work Remote in Ireland

Web Design, Business Intelligence, Consulting, Data Modeling, Dimensional Modeling, Database Extract Transform and Load (ETL), SQL Server Integration Services (SSIS), Data Warehousing, Microsoft Windows Azure, Microsoft SQL Server, * 2-4 years experience in dimensional data modeling, ETL development, and data warehousing in a professional capacity

• Hands-on experience with a variety of 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
• Bachelors degree or equivalent education and/or experience

Affirma is a full-service technology consultancy. We provide a breadth and depth of expertise while maintaining the personal touch of a boutique firm. Our teams specialize in helping organizations of all sizes solve their most challenging business pain points by creating custom in-house solutions. We offer services ranging from business intelligence, web design and creative consulting, infrastructure, and so much more.