Data Integrations Developer

Company: EAB (Education Advisory Board)
Location: Washington
Posted on: February 15, 2025

Job Description:

At EAB, our mission is to make education smarter and our communities stronger. We work with more than 2,800 institutions to drive transformative change through data-driven insights and best-in-class capabilities. From kindergarten to college to career, EAB partners with leaders and practitioners to accelerate progress and drive results across five major areas: enrollment, student success, institutional strategy, data & analytics, and diversity, equity, and inclusion (DE&I). We work with each partner differently, tailoring our portfolio of research, technology, and marketing and enrollment solutions to meet the unique needs of every leadership team, as well as the students and employees they serve.At EAB, we serve not only our partner institutions but each other-that's why we are always working to make sure our employees love their jobs and are invested in their communities.Do you have an analytical mindset, the ability to pick up new skills quickly, and a strong sense of ownership? If so, we want you! As a critical member of the application development team, the Data Integrations Developer troubleshoots and analyzes data issues in critical internal software systems and creates data flow pipelines between systems. In addition, this role includes developing and maintaining data integration architecture and processes that adheres to the organization's best practices of flexibility, scalability, and robustness. Applying strong technical and communication skills, the Data Integrations Developer will collaborate with QA, developers, and business partners while providing data support throughout the entire development life cycle.This role may be based out of EAB's Washington, D.C. office; Richmond, VA office; or open to remote work within the continental U.S.Primary Responsibilities:

• Analyze data to identify issues and improvement opportunities
• Develop data diagnostics and report deliverables for internal clients
• Document and maintain data flow diagrams for critical systems
• Manage operational requests and troubleshoot issues, working with diverse user groups
• Recreate, troubleshoot, and resolve customer data related questions/problems in a professional and timely manner
• Maintain system metrics to track trends in usage and data integrity
• Develop and support upserts between systems
• Provide quality support to a diverse group of internal business analysts, IT leaders, system owners, and business stakeholders across the organization
• Analyze and translate functional specifications and change requests into technical specifications
• Create and maintain thorough documentation that can be understood by technical and non-technical teams
• Troubleshoot data integration errors and optimization problems by performing root cause analysis and implementing solutions
• Deploy and maintain Windows and Linux servers in multiple environments using AWS EC2
• Create automated monitoring for Windows and Linux servers to ensure optimal performance
• Maintain the team's Git repositories
• Perform all SQL Server database administration responsibilities including security, performance, backups, and configuration
• Design, build, test, deploy, and maintain data integrations between a diverse set of enterprise applications and information systems including but not limited to Marketo, Salesforce, Dayforce, Zoom, Box, and Slack
• Design, build, test, deploy, and maintain automated data audits to identify bad data scenarios
• Design, build, test, deploy, and maintain a centralized logging and alerting system for all automated data integrations that run on a diverse set of data integration platforms
• Design, build, test, deploy, and maintain automated SQL Server database backups
• Design, build, test, deploy, and maintain data integration scripts using Batch and PowerShell in the Windows environment and Python and Bash in the Linux environmentBasic Qualifications:
  • 4+ years of relevant professional experience
  • Must possess at least two of the following:
    • 2+ years project or data management experience
    • Familiarity with IT systems, database design, and data structures
    • Coursework in Management Information Systems (MIS), Computer Science, Economics, Mathematics, or Statistics or commensurate work experience
    • Ability to communicate both orally and in writing, with managers and team members
    • Demonstrated analytical reasoning and solution-focused problem-solving skills
    • Experience troubleshooting and finding multiple solutions to a complex problem
    • Ability to synthesize and interpret technical data
    • Experience working with business intelligence and/or reporting tools (e.g., Excel advanced functionality, SQL, Access, Tableau)
    • Demonstrated knowledge of relational databases, data modeling, database concepts, and data management
    • Ability to learn new technologies
    • Exceptional attention to detail
    • Ability to work in a rapidly changing and interrupt-driven environment
    • Ability to drill down to the root cause of issues and be creative in problem-solving
    • Experience working within a team environment and independentlyIdeal Qualifications:
      • Bachelor's Degree in Computer Science or related field
      • Experience in a diverse environment of command line interfaces including Bash, Python, Batch, PowerShell, AWS CLI
      • Experience working with the Salesforce CRM platform
      • Experience with a diverse data structures including RDBMS, XML, XSL, XSLT, JSON
      • Experience managing SQL Server including specific familiarity within SQL Job Agent and Service Broker
      • Development experience with various ETL tools (e.g., Pentaho, DBAmp, SSIS)
      • Ability to handle multiple projects simultaneously
      • Commitment to valuing diversity, practicing inclusive behaviors, and contributing to an equitable working and continual learning environment in support of EAB's DE&I PromiseIf you've reached this section of the job description and are unsure of whether to apply, please do! At EAB, we welcome diversity of background and experience. We would encourage you to submit an application if this is a role you would be passionate about doing every day.Compensation:The anticipated starting salary range for this role is $77,500 - $109,000 per year. Actual salary varies due to factors that may include but not be limited to relevant experience, skills, and location. At EAB, it is not typical for an individual to be hired at or near the top of the starting salary range for their role.This hire will additionally be eligible for discretionary bonus or incentive compensation. Variable compensation may depend on various factors, such as individual and organizational performance.Consistent with our belief that our employees are our most valuable resource, EAB offers a competitive and inclusive benefits package. Our benefits currently include:
        • Medical, dental, and vision insurance plans; dependents and domestic partners eligible
        • 20+ days of PTO annually, in addition to paid firm and floating holidays
        • Daytime leave policy for community service and flextime for fitness activities (up to 10 hours per month each)
        • 401(k) retirement savings plan with annual discretionary company matching contribution
        • Health savings account, healthcare and dependent care flexible spending account, and pre-tax commuter plans
        • Employee assistance program with counseling services and resources available to all employees and immediate family
        • Wellness programs including gym discounts, incentives to promote healthy living, and family access to the leading app for sleep, meditation, and relaxation
        • Fertility treatment coverage and adoption or surrogacy assistance
        • Paid parental leave with phase back to work program for birthing and non-birthing parents
        • Access to milk shipping service to support nursing employees during business travel
        • Discounted pet health insurance coverage for dog and cat family members
        • Company-provided life, AD&D, and disability insurance
        • Financial wellness resources and membership in a robust employee discount program
        • Access to employee resource groups, merit-based advancement, and dynamic professional growth opportunities
        • Benefits kick in day one; learn more at eab.com/careers/benefitsThis opening is not eligible for visa sponsorship at this time; EAB will thus consider candidates who possess U.S. work authorization that does not require employment-based visa sponsorship now or in the future.At EAB, we believe that to fulfill our mission to "make education smarter and our communities stronger" we need team members who bring a diversity of perspectives to the table and are committed to fostering a workplace where each team member is valued, respected and heard.To that end, EAB is an Equal Opportunity Employer, and we make employment decisions on the basis of qualifications, merit, and business need. We don't discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law.
          #J-18808-Ljbffr

Keywords: EAB (Education Advisory Board), Washington DC , Data Integrations Developer, IT / Software / Systems , Washington, DC