Job description
Affirma is an award-winning consultancy specializing in Mobile, Cloud, Business Intelligence, SharePoint, Technology Infrastructure, Custom Development, Visual Design, and Staffing Services. We focus on delivering true, measurable business value to our clients. We have top industry customer satisfaction and are dedicated to delivering dependable and reliable solutions that exceed client expectations. Affirma's motto is quality solutions on budget, on time, every time.
Affirma Consulting is looking for a mid-level Data Engineer to join our growing Data & Analytics team. This individual will support Affirma's mission to provide exception value to our clients by planning, executing, and deploying data management solutions.
Qualifications and Requirements
- 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
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 Washington's Fastest Growing Private Companies & Top 100 Best Companies to Work For (According to Seattle Business Magazine and Puget Sound Business Journal)
- One of Ireland's 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
- Remote work within Ireland
Affirma is an Equal Opportunity Employer and does not make employment decisions or otherwise discriminates based on race, creed, color, national origin, sex, military status, sexual orientation, or the presence of any sensory, mental, or physical disability, genetic information, or any other category protected by law.
