Data Engineer, Web

This is a fully remote position, open to applicants in Ohio.

📋 Description

• Develop and oversee data pipelines.

• Manage database environments effectively.

• Create sophisticated analytics and interactive dashboards.

• Provide support for web platforms and integrations that enhance digital experiences.

• Write complex SQL queries for data extraction, manipulation, and validation.

• Establish and manage AWS Redshift or equivalent data warehouse environments.

• Design data models, transform data across various systems, and construct scalable ETL/ELT processes.

• Ensure adherence to university data governance, FERPA, privacy regulations, and data stewardship standards.

• Develop advanced calculations in Tableau.

• Organize and cleanse data using Tableau Prep Builder or similar tools.

• Create interactive dashboards utilizing filters, parameters, and actions.

• Publish and manage content on Tableau Server or Tableau Cloud.

• Apply statistical methods and data analysis techniques to uncover trends, insights, and business opportunities.

• Utilize Python or R for analytics, data manipulation, and automation.

• Build, maintain, and enhance web assets using JavaScript for WordPress or headless CMS frameworks.

• Provide support for web hosting environments and troubleshoot any deployment or performance issues.

• Integrate CRM systems with internal data platforms.

• Collaborate with cross-functional teams to gather requirements and document solutions.

• Maintain technical documentation and contribute to established standards and best practices.

• Support integrated marketing initiatives through reporting and analysis.

• Work with internal stakeholders and external vendors to ensure a seamless, data-driven user journey.

• Perform additional duties as assigned.

⛳️ Requirements

• Candidates must submit both a resume and a cover letter.

• The cover letter should describe at least two relevant projects.

• Relevant project experience in system integrations using APIs, webhooks, or similar technologies; database management; dashboard creation; or custom engagement tracking across platforms is required.

• Proficiency in writing complex SQL queries is necessary.

• Experience in creating and managing AWS Redshift or comparable data warehouse environments is required.

• Knowledge of designing data models and constructing scalable ETL/ELT processes using Adverity or similar tools is essential.

• Understanding of university data governance policies, privacy regulations including FERPA, and data stewardship standards is required.

• Experience in developing advanced Tableau calculations, including LOD expressions, table calculations, and date/string functions is necessary.

• Familiarity with using Tableau Prep Builder or equivalent tools is required.

• Experience in publishing and managing content on Tableau Server or Tableau Cloud, including permissions and automated refreshes, is necessary.

• Knowledge of statistical methods and data analysis techniques is required.

• Experience using Python or R for advanced analytics, data manipulation, and automation is essential.

• Proficient in building, maintaining, and extending web assets using JavaScript for WordPress or headless CMS frameworks.

• Experience in supporting web hosting environments and troubleshooting deployment or performance issues is required.

• Experience in integrating CRM systems with internal data platforms is necessary.

• Ability to work collaboratively with cross-functional teams, document solutions, and provide support to stakeholders is essential.

• A criminal background check will be required.

🏝️ Benefits

• Remote work arrangement approved by Miami University.

• Eligible for benefits.

• 40 scheduled hours per week.

• Smoke- and tobacco-free campuses.

• Equal Opportunity/Affirmative Action employer.

• Reasonable accommodations for disabilities.

• Criminal background check process.