Associate Analytics Engineer

About the position Responsibilities

• Collaborate with analysts, data scientists, and ER stakeholders to specify and clarify project requirements; plan and develop well-defined, integrated, and reusable solutions using Snowflake, dbt, Power
  
  BI, and other tools.
• Create new and enhance existing data models by writing production-quality data transformations in SQL using dbt.
• Apply software engineering practices (e.g., code review, testing, version control, comprehensive documentation) to ensure data quality & standardization across our pipelines and BI tools.
• Contribute to the design and successful implementation of BI assets and operational workflows, including dashboards, data model documentation, and data operationalization.
• Serve as area expert on ER's web analytics data and maintain self-service resources for insight into IRC's digital fundraising data.
• Identify and execute internal improvements to the ER Analytics data platform, including code improvements, testing and documentation coverage, and performance enhancements.
• Support other analytics tasks as needed.

• 2+ years working in the field of data and analytics.
• 2+ years of professional experience modeling and reporting on large scale data, using BI tools, Excel, or SQL.
• 1+ years of experience with SQL and cloud-based data warehouses (Snowflake, Big Query, Redshift, Azure).
• Familiarity with dbt and modular data modeling.
• Strong adherence to data ops best practices, including version control (e.g., Git Hub), and data testing.
• Independent worker with strong attention to detail & commitment to a high standard of work product.
• Desire to work in a multi-cultural environment and collaborate with people from different backgrounds and experiences.

• Familiarity with Salesforce or similar CRM technology.
• Experience developing dbt in a high-growth organization, including deploying capabilities such as utils, packages, tests, snapshots, and incremental tables.
• Experience in Snowflake.
• Exposure to Microsoft BI tooling:
  Power
  
  BI, Power Query and, DAX/MDX scripting language.

• Sick time
• 403b retirement savings plan with up to 4.5% immediately vested matching contribution and an additional 3-7% IRC contribution
• Employee Assistance Program for staff and families
• 10 US paid holidays
• 20-25 paid time off days
• Disability & life insurance
• Medical, dental, and vision insurance
• FSA for healthcare, childcare, and commuter costs