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, PowerBI, 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. Requirements 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, BigQuery, Redshift, Azure). Familiarity with dbt and modular data modeling. Strong adherence to data ops best practices, including version control (e.g., GitHub), 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. Nice-to-haves 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: PowerBI, Power Query and, DAX/MDX scripting language. Benefits 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

#J-18808-Ljbffr