Senior Data Engineer - Denver, CO

The Senior Data Engineer leads the design, development, and maintenance of our data architecture. This professional manages integrations between our data and other systems, builds out new automated processes, and monitors and manages existing data pipelines. As a key member of our data team, you will collaborate with cross-functional teams to implement robust data solutions that support business objectives and enable data-driven decision-making.Moore is a data-driven constituent experience management (CXM) company achieving accelerated growth for clients through integrated supporter experiences across all platforms, channels and devices. We are an innovation-led company that is the largest marketing, data and fundraising company in North America serving the purpose-driven industry with clients across education, association, political and commercial sectors.Check out www.WeAreMoore.com for more information.This is a full-time, salaried position open to candidates in the US who are eligible to work without current or future sponsorship.This position is a hybrid position for the Westminster, CO office. The salary range for this role is $90,000-100,000, depending on skills and expertise.Your Impact:Handle support requests from across the enterprise, providing expertise and guidance.Design, implement, and maintain scalable data pipelines for extracting, transforming, and loading (ETL) data from various sources into our data warehouse.Optimize and enhance existing data pipelines for improved performance, reliability, and efficiency.Implement and maintain data warehouse architecture to ensure seamless data integration and accessibility.Manage and optimize databases to ensure seamless data flow and interoperability.Work collaboratively with cross-functional teams to identify root causes and implement preventive measures.Mentor and provide guidance to junior members of the data engineering team.Conduct code reviews and enforce engineering best practices.Complete job-related assignments as required. Your Profile: 3+ years’ experience in data engineering, with a focus on building and optimizing data pipelines.Experience with SQL and Snowflake including:Query performance tuning and optimizationUse of clustering, partitioning, and micro-partitionsWorking with semi-structured data (VARIANT, JSON)Experience building and maintaining ELT/ETL integrations using tools such as Fivetran.Advanced experience developing analytics engineering workflows with dbt (data build tool) including:Designing scalable data modelsImplementing incremental models and snapshotsWriting and maintaining testsHandling schema change detectionManaging dbt in CI/CD pipelinesExperience building data models optimized for BI tools (e.g., Power BI or Tableau), including:Star schema designAggregation strategiesQuery performance and optimization for dashboardsStrong focus on data quality and governance, including:Defining and enforcing data validation rulesIdentifying and resolving data anomaliesDocumenting data lineage and business logicExperience with version control (e.g., Git) and CI/CD practices for data pipelines and dbt projectsPreferred Platform/Tools Experience:Experience with cloud platforms such as AWS, Azure, or Google Cloud.Experience working with marketing/ad data sources and ad platforms such as Google Ads, Meta, Search Ads 360 (SA360), and The Trade Desk (TTD).Experience integrating and working with CRM / eCRM systems such as Salesforce and Engaging NetworksA solid understanding of data modeling concepts and data warehousing.Experience collaborating with cross-functional stakeholders (analytics, marketing, product)Adapt to changing directions and handle competing demands effectively.Are inquisitive with a creative approach to problem-solving.Use excellent critical thinking skills to assess complex data engineering challenges.Bring strong prioritization and organizational skills.Utilize excellent problem-solving and communication skills.How We’ll Support You:Join the largest marketing and fundraising company in North America serving the nonprofit industry where we prioritize innovation and professional growth.Collaborate with industry subject matter experts with over 5,000 employees across the enterprise.To help you stay energized, engaged and inspired, we offer a wide range of benefits including comprehensive healthcare, paid holidays and generous paid time off so you can have the time and space to recharge and pursue your other passions and be with the people you care about.Moore is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.