Data Integration Analyst and Software Engineer

United Way Of Greater Atlanta; Atlanta (GA); On-site; USD 90,000 - 125,000; Full time

Job summary

United Way of Greater Atlanta is hiring a Data Integration Analyst & Software Engineer to drive end-to-end data integration projects, improve ETL/API processes, and support business decisions through robust data management. The role requires a strong background in data integration, programming, and collaboration across departments.

The ideal candidate will have six+ years of experience, a Bachelor’s degree, and expertise in Windows development and automation tools, with a focus on data

Qualifications

• Bachelor’s degree or equivalent with data integration experience.
• Minimum six years’ professional software development and database experience.
• Strong programming, development and implementation skills required.
• Knowledge of integration architectures and data sources.
• Ability to manage data from multiple sources.
• Advanced Windows development skills (VB, C++, .NET).
• Experience with automation tools (Power Automate, Zapier).
• Experience with SQL reporting and SQL 2019+ development.
• Azure SQL/Azure DW experience a plus; SSDT skills helpful.
• End-to-end lifecycle knowledge and strong communication.
• Organized, collaborative, and customer-focused.

Responsibilities

• Lead end-to-end integration projects from analysis to support.
• Develop and maintain ETL, API, and integration processes.
• Enhance data automation and reporting for business decisions.
• Ensure data integrity and resolve system issues with campaigns/finance.
• Coordinate with internal teams and vendors; manage timelines.
• Mentor others and drive best practices in integration.

Skills

Data integration

SQL

ETL

API development

Data management

Windows development

Visual Basic

C++

.NET

Code maintenance

Integration architectures

Stored Procedures

Triggers

Azure SQL

Azure Data Warehouse

SSDT

SQL Server Data Tools

Great Plains knowledge

Full software lifecycle

Data integrity

Team collaboration

Customer service

Communication skills

Education

Bachelor’s degree in computer science, Business, Mathematics, Economics, Statistics, or equivalent experience with data integration

Tools

Microsoft Power Automate

Zapier

Azure Data Factory

SQL Server

Job description

Job Details

Level: Experienced

Job Location: Headquarters - Atlanta, GA 30303

Position Type: Full Time

Education Level: Bachelor's Degree

Travel Percentage: Up to 25%

Job Shift: Any

Job Category: Information Technology

ORGANIZATIONAL OVERVIEW

United Way of Greater Atlanta (UWGA) is in the midst of transformational change and is embarking on new and different ways to raise and earn revenue so that it can accelerate and scale its mission to drive sustainable and equitable improvements in the well-being of children, families, and individuals in greater Atlanta. The mission remains the same: To bring together people and resources to drive sustainable and equitable improvements in the well-being of half a million lives across Greater Atlanta. The value proposition is to Unite Greater Atlanta to create, amplify and accelerate solutions that promote child well-being by addressing our communities’ most complex social challenges.

These solutions and the backbone behind them are all in service of the organization’s bold growth ambition: Triple unrestricted revenue by 2029 to be the best-in-class investor in child well-being in Greater Atlanta, ultimately eliminating the barriers of one’s zip code as a hindrance to future success. This transformation will unleash the next generation of UWGA, putting UWGA on a growth pathway that will significantly amplify its impact by increasing its investment in solutions that can make a lasting difference for Child Well-Being in Greater Atlanta.

DEPARTMENT OVERVIEW

The IT division plays a pivotal role in driving the organization’s transformational change. We work closely with other departments to align our technology initiatives with business objectives, fostering a culture of innovation and continuous improvement. Our priorities are centered around enhancing digital capabilities, improving data management, enabling seamless integration across various departments, and ensuring robust security measures. By leveraging advanced technologies and innovative solutions, we aim to support UWGA's mission to drive sustainable and equitable improvements in the well-being of children, families, and individuals in Greater Atlanta.

JOB SUMMARY

The Data Integration Analyst & Software Engineer conducts beginning-to-end integration projects including analysis, design, development, and support. The role performs a variety of duties related to improving the transfer of data from one system to another by scrubbing data, writing test scripts and performing quality control on data; and works collaboratively within the IT division and with internal customer teams to enhance automation and integration of data to drive business decisions and customer sightlines. The role provides relationship management for internal customers and consults with departments, project teams, and vendors to manage and maintain integration of data and reporting. Develops and maintains internal application solutions. Maintains installation programs for internally developed applications. Analyzes campaign and financial system data from staff members for data interpretation and integrity issues. Automate systems for data management and maintenance (SQL DTS). Has knowledge of a variety of concepts, practices, and procedures within field. Performs a variety of complicated tasks. May lead and direct the work of others. A wide degree of creativity, problem solving skills and latitude is expected as well as comfort in writing and maintaining complex systems.

QUALIFICATIONS

• Bachelor’s degree in computer science, Business, Mathematics, Economics, Statistics, or equivalent experience with data integration
• Minimum six years’ professional work experience, software development, database management, client/server technologies
• Superior programming skills that relate to code development, maintenance, and implementation.
• Meticulous knowledge of integrations, development processes, and integration architectures
• Ability to manage data from multiple sources.
• Advanced development skills for Windows systems (Visual Basic, C++, .NET)
• Experience with Microsoft Power Automate, Zapier, or other automation tools.
• Experience with SQL reporting for analysis, development, maintenance, modification, and enhancement of reporting solutions
• Experience in SQL 2019 or newer Development (Stored Procedures, Triggers, and Data Replication)
• Experience with Azure SQL and Azure Data Warehouse a plus.
• Experience with SQL Server Data Tools (SSDT) for Visual Studio
• Knowledge of Back-end financial systems and processing preferred. Experience with Great Plains preferred.
• Knowledge of full application life cycle experience including scope definition, design, development, and user training
• Well organized and able to provide structure and process to areas of responsibility.
• Strong Customer Service and Relationship Management Skills
• Ability to contribute both independently and as part of a team.
• Excellent listening, communication, interpersonal and presentation skills
• Strong written and verbal communication skills

RESPONSIBILITIES

• Apply integration expertise, business knowledge and technical skills to successfully deliver solutions that ensure time and accurate delivery of data.
• Guide beginning-to-end integration projects including analysis, design, development, and support.
• Develop in-depth knowledge of data sources and models to design, develop, implement, and support ETL, API, and other integration processes.
• Develop, manage, maintain, and enhance integration including but not limited to the Azure integration between Microsoft Dynamics and Andar (SQL based legacy system)
• Demonstrate the passion and desire to build a solution from the ground up.
• Coordinate activities to ensure that integration projects are completed on time.
• Formulate strategies and design architectures for systems integrations.
• Ensure that the best practices in integration processes are followed by the organization.
• Check and correct conflicts in data configurations and overlaps.
• Analyze and improve current system integrations.
• Identify, debug, and advise on system errors or architecture issues.
• Assist with the management of organizational databases and retrieval systems.
• Manage third party vendors.
• Be accountable for system and process improvements.
• Work with internal teams on data integrity and resolve other issues with the campaign and financial management systems as needed.
• Other duties as assigned.

IDEAL CANDIDATE

• Able to master the big picture while demonstrating a working-level knowledge of the supporting details
• Organized, goal oriented
• A good listener, self-starting, and a creative problem-solver
• Strong organizational skills to manage multiple tasks within the constraints, available resources, and schedule timelines
• A strong collaborator and comfortable with working in a highly dynamic environment