Data Engineer

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

Accountabilities and Measures

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

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.