Data Engineer

Kling Public Media Center 480 Cedar Street Saint Paul, MN 55101, USA The Data Engineer is a core member of the APMG Technology team, responsible for building and maintaining data pipelines, integrations, and models that power the organization’s reporting and operational systems. Working within a small, high-impact team, this role contributes directly to APMG’s data ecosystem — spanning Azure cloud infrastructure, Salesforce NPSP, and a range of integrated SaaS platforms. The Data Engineer partners closely with the Data Architect to translate business requirements into durable, well-tested data solutions, and brings a pragmatic, curious mindset to solving complex integration and modeling challenges. This role operates with meaningful autonomy and is expected to take ownership of assigned pipelines and domains end-to-end — from design through deployment and monitoring. As a member of a lean team, the Data Engineer also contributes to peer learning, documentation, and the ongoing improvement of team practices, including the use of AI-assisted development tooling to increase velocity and code quality. Expected Compensation Range: $105,000 -$112,000 per year. The exact salary rate is determined by experience and education related to the role, organizational compensation structure, and internal equity. Location: Hybrid, St. Paul, MN Application Process: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time. Application Deadline: Open until filled. Position Responsibilities Design, build, and maintain data pipelines and ETL/ELT workflows using Azure Data Factory and related Azure services Develop and maintain data models in the Azure SQL-based Enterprise Data Warehouse, ensuring performance, integrity, and alignment with organizational standards Write clean, well-tested Python and SQL code to support ingestion, transformation, and integration tasks Build and maintain API integrations between internal systems and third-party SaaS platforms (e.g., Salesforce NPSP, donation gateways, media systems) Implement automated testing for data pipelines and transformations to ensure reliability and catch regressions early Monitor pipeline health, respond to data quality issues, and maintain alerting and logging practices Collaborate with the Data Architect to implement and adhere to organizational data standards, naming conventions, and governance practices Contribute to Power BI reporting by maintaining underlying data models and ensuring accurate, performant dataset availability Document pipeline logic, data models, and integration specifications to support knowledge sharing and maintainability Participate in code reviews and contribute to a culture of technical rigor and continuous improvement Leverage AI-assisted development tools to accelerate implementation, improve code quality, and explore new solutions Provide secondary support for business application systems as needed within a collaborative team environment Other duties, as assigned Required Education and Experience Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent professional experience 3–5 years of hands‑on experience in a data engineering, analytics engineering, or similar role Required Skills, Knowledge and Abilities Proficiency in SQL, including complex query writing, stored procedures, and performance tuning in a relational database environment (SQL Server preferred) Proficiency in Python for data engineering tasks, including scripting, API consumption, transformation logic, and testing Experience designing and maintaining data models for analytical or operational use cases Experience building and consuming REST APIs and integrating data across disparate platforms Hands‑on experience with Azure cloud services, including Azure Data Factory or equivalent pipeline tooling and Azure SQL Demonstrated experience writing and maintaining automated tests for data pipelines and transformation logic Experience delivering within an agile development process, including writing user stories, acceptance criteria, test plans for general data engineering and analytics requirements Ability to understand business requirements and translate them into sound data solutions Strong attention to detail and a commitment to data quality and accuracy Ability to work independently and collaboratively in a small, cross‑functional team environment Clear written and verbal communication skills, with the ability to explain technical concepts to non‑technical stakeholders Self‑directed learner with a genuine interest in evolving tooling, practices, and technologies Comfort operating with some ambiguity and finding effective solutions within resource and time constraints Embraces APMG organizational values, including EIDA (Equity, Inclusion, Diversity, and Accessibility) Preferred Skills and Experience Experience with AWS services (e.g., S3, RDS, DynamoDB, Lambda) and cross‑cloud pipeline patterns Familiarity with the use cases and trade‑offs of different data storage paradigms, including relational databases, document stores, data warehouses, and lakehouse architectures Familiarity with Salesforce data structures, particularly NPSP (Nonprofit Success Pack) Experience with Power BI, including dataset development and DAX Familiarity with other cloud‑based data platforms and tools, including Databricks, DBT, data catalogs, etc. Working experience with AI‑assisted development tools (e.g., GitHub Copilot, Claude, Cursor) to accelerate and improve engineering work Experience with identity resolution patterns or working with systems that use multiple identifiers across platforms Familiarity with nonprofit, public media, or fundraising data domains Exposure to data governance practices, data cataloging, or metadata management Experience with version control (Git) and CI/CD workflows for data pipelines Reporting to this Position None Physical Demands and Working Conditions Must be able to perform the essential duties of the position with or without reasonable accommodation Ability to manage some work outside of standard office hours as needed Physical Demands: Required to move about in an office environment and sit for extended periods of time Frequent use of hands for data entry/keystrokes and simple grasping Working Conditions: Moderate noise level APMG offers a comprehensive benefits package including Medical plans with HSA and FSA options, Dental, Vision, Life and AD&D, Short-Term and Long-Term Disability, Paid Parental Leave and Paid Caregiver Leave after 1 year, Vacation (3 wks./per year, pro-rated, based on hours worked), Sick time (12 days, pro-rated, based on hours worked), Holiday Pay (10 holidays + 2 floating holidays each year), Volunteer Time (8 hours per year), Long-Term Care and Critical Illness insurance options, Employee Assistance Program, 403(b) Retirement Plan, and more. Diversity creates a healthier atmosphere: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. We are committed to hiring a breadth of diverse professionals and encourage members of diverse groups to apply. Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor. #J-18808-Ljbffr American-Public-Medi