Job Location:
Ireland -Leinster -County Dublin -City of Dublin -Dublin
Salary:
$/annum
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.
Qualifications:
- 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
- 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 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
Incase you would like to apply to this job directly from the source, please click here