Manager of Data Engineering

Company: Allies for Community Business

Location: Chicago, IL

Job Function: Administrative/Operations/IT


Background

Allies for Community Business believes that entrepreneurs from any background can start and grow businesses that create generational wealth for their families and communities. A4CB provides the capital, coaching, and connections entrepreneurs need to grow great businesses that create jobs and wealth in their communities.

Summary

Position: Manager of Data Engineering  

The Manager of Data Engineering is a salaried, exempt position that reports to the Director of Data and Compliance. The Manager of Data Engineering is responsible for overseeing the maintenance and growth of A4CB’s existing data lake; ongoing enhancement of A4CB’s Power BI dashboards; and working with vendors to build and maintain APIs to enhance efficiencies in workflows. Ultimately, this role will be critical to our development and maintenance of the databases needed to improve upon how we meet our reporting and compliance requirements.

Essential Duties

  • Design, build, and maintain the data systems we need to efficiently and effectively report on outputs and outcomes
  • Develop extract/transform/load processes to consume and manipulate data from multiple sources
  • Create reports, dashboards, and visualizations to help staff and partners understand A4CB’s performance
  • Generate reports required by third parties and internal partners, ensuring both accuracy and timeliness
  • Manage the data life cycle including quality control of data collection and distribution
  • Analyze data to provide insightful and accurate trends, report concerns, and celebrate successes

Responsibilities

Detailed Responsibilities

  • Compile data from all necessary sources, analyze and monitor the data to ensure compliance, track organizational metrics, and ensure the organization is on track to meet strategic milestones
  • Maintain a careful tracking mechanism for all executed agreements and reporting requirements
  • Advise on necessary quality assurance protocols
  • Identify automation opportunities
  • Analyze process issues and bottlenecks to make improvements
  • Communicate and validate requirements with relevant stakeholders
  • Collaborate with A4CB leadership on roadmap planning and technology stack optimization
  • Work from the A4CB office each Wednesday and on other days as agreed upon with the Director of Data and Compliance
  • Perform other duties flexibly and creatively as needs arise

Requirements

Qualifications

A4CB requires its staff to:

  • Solve problems creatively
  • Manage time efficiently
  • Attend to details meticulously
  • Communicate effectively in writing and verbally
  • Collaborate flexibly with colleagues in a diverse and changing environment
  • Believe strongly in A4CB’s vision and mission

The Manager of Data Engineering should have a:

  • Minimum 3-5 years’ experience of using database management software like SQL Server Management Studio, Oracle Database, or MongoDB Compass to optimize for high volume workload requirements, including identifying and troubleshooting bottlenecks plus enabling replication, load balancing, clustering, and monitoring resource usage
  • Minimum of 3 to 5 years of experience working with tools like Excel, R, and SQL to perform data analysis and inform decision-making based on data interpretation and visualization
  • Experience building or editing data dashboards (Power BI preferred)
  • Strong understanding of — and significant experience using — relational NoSQL and SQL databases; workflow management and pipeline tools; AWS cloud services; and object function/object-oriented scripting languages including Scala, C++, Java and Python
  • Proven track record of attending to detail; tracking, analyzing and reporting data; and meeting deadlines
  • Collaborative workstyle that thrives in a fast-paced environment with a customer service focus
  • Minimum training of bachelor’s degree—or equivalent certifications—in computer science, information systems, informatics, statistics, or another quantitative field (Please note that applicants will be required to successfully complete a programming language competency test prior to interviewing with the Director of Data and Compliance.)

Compensation and Benefits

A4CB values transparency and efficiency in the hiring process. If the salary range specified in this job posting does not meet your financial needs, we encourage you to continue your search until you find a role that is a better fit. The salary range for this position is $83,000 – $90,000, commensurate with experience and skills. A4CB offers generous medical and dental insurance plans; offers a SIMPLE IRA retirement plan (with employer match); and provides excellent paid time off to its employees. A4CB is an equal opportunity employer and is committed to building a diverse and inclusive workplace. Women, members of the LGBTQIA+ community, individuals experiencing disability, BIPOC, and individuals with diverse backgrounds and/or work experiences are encouraged to apply.

How to Apply

https://recruiting.paylocity.com/recruiting/jobs/Details/2315400/Allies-for-Community-Business/Manager-of-Data-Engineering

Don’t meet every requirement?

Studies have shown that women, members of the LGBTQIA+ community, individuals experiencing disability, and BIPOC are less likely to apply for a job unless they meet every qualification. If you’re excited about this role, believe you’d be a good fit for A4CB, and would accept an offer within the salary range included in this job posting, we encourage you to apply.