The Data Engineer turns data into information, insight and business decisions by designing, building and maintaining data integrations, visualizations and dashboards that support Stelter's marketing and business activities. Primary responsibilities include creating and maintaining data pipelines into our centralized data repository, Domo; managing workflows to clean and organize data, building and automating report delivery, and developing and maintaining dashboards. In addition, this position creates and maintains software applications and automations that improve efficiency and reduce errors.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIES
The following are fundamental duties that an individual who holds the position must perform. This is not an exhaustive list. Other duties, in addition to these essential job functions, will be assigned at the discretion of the Vice President of Strategy, Innovation and Marketing.
1. Create, monitor and maintain data pipelines
- Understand the data available from all Stelter systems
- Establish, maintain and improve data source connections and update schedules
- Create alerts and reports to monitor data pipeline executions
- Develop and maintain quality control measures for data input and output
- Manage and use governance policies related to data retention, naming conventions, and sharing with others inside and outside of Stelter
2. Manage and improve reporting systems
Manage card and dashboard creation using visualization and UX best practicesMaintain, monitor and enhance report-related scripts and automation workflowsBe an administrator of the Domo platform, managing user access, removing outdated / unused content, and working with tech support to resolve issues3. Create and maintain applications and automations
Gather detailed requirementsDefine project outlines and deliverablesConsult with internal staff and external resources as neededMaintain code, workflow and data according to standard work instructionsContinuously identify opportunities to automate workflows, reduce manual effort and scale insights delivery across the organization4. Collaborates with the data analytics team to support company and department goals and strategies
Uses the department's formal processes to share findings and recommendations with supervisor and other stakeholdersDocument and share standard work instructionsManages special projects as assignedStays current with the latest analytics, data, visualization and Stelter's tech stack5. Provide support and technical assistance for analytics and data systems
Provide timely support for data-related and product support requestsWork with others on the data analytics team to resolve more complicated requests6. Data Security and Privacy
Implement best practices for securing customer data, ensuring adherence to data privacy policies and regulations.Regularly monitor and report on the security of PII, addressing any potential risks or vulnerabilities.Ensure that data management processes adhere to company security protocols and industry standards.COMPETENCIES
1. Spirit of Service
Establishes personal credibility by adhering to Stelter's core values and beliefs; acts in line with those values; holds self accountable.Provides exceptional customer service to existing and prospective clients as well as Stelter Company employees2. Management
Demonstrates an exceptional results orientation, with a high degree of personal initiative and leadership, in a lower-resource environment.Thrives in a fluid business environment and is able to manage multiple tasks and priorities with ease. Demonstrates a track record of good decisions when facing new and unfamiliar changes.Demonstrates strong interpersonal skills and the ability to inspire action in others.3. Organization and planning
Demonstrates the ability to organize and plan work, meetings and projects.Effectively prioritizes work and makes good use of time.Demonstrates a high degree of personal responsibility.4. Communication
Excellent oral and written communication skills and demonstrated ability to communicate with peers and leadership effectively.Excellent collaborative skills and the ability to build productive cross-functional relationships.Comfort with client-facing communication; ability to convey information effectively.5. Leadership and Innovation
Takes initiative in identifying new opportunities for improving data management and email deliverability.Offers solutions and recommendations to enhance list management processes and email performance.Keeps up-to-date with industry trends and emerging technologies in email marketing and data management.QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily, with or without reasonable accommodation. The requirements listed below are representative of the knowledge, skill, and / or ability required.
KNOWLEDGE AND SKILL REQUIREMENTS
Proficiency in :
Data integration and visualization tools like Domo, Power BI, Tableau or equivalentWorking with data and performing data analytics tasksData structures and data literacyWindows / Mac : Microsoft Office (with Excel emphasis), Google DocsPractical knowledge of :
Data analytics tools such as SQL, R, Python, or equivalentWeb analytics platforms such as Google or Adobe AnalyticsVisualization and UX / UI best practicesExperience integrating third-party platforms such as Salesforce, email marketing systems (e.g. Salesforce Marketing Cloud), etc.General business competencies :
Office Suite products (Office 365 or Google Suite)Effective oral and written communication skillsMust work effectively with all internal staff and outside suppliers, be professional, be a team player, yet be innovative; able to take constructive criticism and directionMust set a good example to all staff members, as a mature professional, willing to help others when needed and show the willingness to do whatever is necessary to get the job doneNonprofit industry awareness helpfulEDUCATION AND EXPERIENCE
Bachelor's degree in Business Analytics, Computer Science, Information Management, Data Science, Statistics or equivalent degree or experience2+ years of professional data / analytics work experiencePHYSICAL DEMANDS AND WORK ENVIRONMENT
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.
May be required to remain stationary for an extended length of time.Constantly operates a computer and other office machinery, such as a calculator, copier, and computer printer.Occasionally move about inside the office to access file cabinets, office machinery, etc.Occasional requirement to lift 10 pounds or more.The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of duties, responsibilities or physical requirements. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.
