Data Integration Specialist

Be PROUD of what you do:

Core Responsibilities

• Data Integration
• Impact Reporting
• Process Documentation
• Internal & External Collaboration

What will you be doing in your role

• Integrate data from multiple sources to form the basis for simple effective and comprehensive reporting.
• Implement tools and processes that facilitate data discovery and insight.
• Support with maintaining Extract Transform and Load (ETL) routines that securely and reliably obtain clean combine and homogenize data from disparate sources.
• Identify and resolve issues in the ETL process and implement solutions to enhance ETL efficiency and reliability.
• Develop solutions to informationbased technical challenges related to data integration solutions including but not limited to creating and maintaining reusable and secure APIs (application programming interface).
• Support with building maintaining optimizing and documenting Enterprise Data Warehouse (EDW) schemas objects tables relationships stored views and procedures.
• Conduct timely and accurate impact reporting to satisfy agency information needs
• Perform data cleaning functions and identify opportunities to implement systematic data cleaning procedures.
• Create and maintain comprehensive documentation for ETL processes job flows troubleshooting steps and best practices.
• Work closely with Data Architect database administrators Business Analysts and other department stakeholders to understand data requirements and ensure data delivery aligns with business needs.
• Generate reports for internal and external stakeholders.
• Author reusable SQL queries to aggregate data for reporting and analytics purposes.
• Support in the creation and maintenance of reports dashboards and infographics that lead to actionable intelligence and address emerging information needs.
• Document processes workflows and best practices related to the organizations data integrations and impact reporting protocols.
• Support creation of data visuals including automated dashboards to creatively communicate program results and client trends.
• Maintain documentation of reporting protocols including definitions measurement and reporting methods of KPIs (key performance indicators) and program outcomes to ensure reporting integrity.
• Keep abreast of the latest developments in data management and data integration.
• Maintain current knowledge of trends and issues around data analysis data management data visualization poverty and family selfsufficiency.
• Participate in staff training and development opportunities.

Are you the next Data Integration Specialist

• Bachelors degree in a relevant field (Data Science Information Technology Statistics Economics Data Analytics etc. AND 12 years of professional experience OR a combination of education and experience.
• Experience in collecting interpreting and analyzing data required.
• Experience using query functions in a relational database required.
• Experience with data analytic software (e.g. SPSS Stata) preferred.
• Experience with ETL tools and concepts (e.g. SSIS Visual Studio) preferred.

• Experience with data visualization software (e.g. Power BI) preferred.

• Experience with machinelearning principles and concepts preferred.

• Demonstrated analytical skills with the ability to apply creative solutions to complex problems required.

• Prior work experience in areas related to social services education and/or poverty preferred.

• Proficiency in MS Excel and Power Query required.

Heres the Good Stuff...

• Fulltime salary position with a starting rate of $50000 annually based on the minimum requirements of the job description. Pay is determined by relevant experience work history education and internal equities.
• Medical/ Dental/ Vision/ Short Term Disability/ Accident Insurance/ Hospital Indemnity Insurance/ Critical Illness/ ID Shield
• Health Savings Account CCFW contributes $110 per month.
• 100 Company paid Long Term Disability
• 100 Company paid Basic Life and AD&D Insurance
• 16 paid Holidays (including being closed Christmas Eve through New Years Day)
• Tiered PTO Accrual by tenure:
  • Vacation Time 100 hours in your first year.
  • Sick Time 48 hours in your first year.
• 403(b) with employer match from day one up to 6
• 3 weeks paid parental/critical illness leave
• Employee Assistance Program

• CCFW Participates in the Public Service Loan Forgiveness program (PSLF)

• Mentorship Program
• Wellness Program
• Financial Coaching

Im in...next steps.
We want to know more about you! Send us your resume and cover letter through the Join our Team tab on our website: www.catholiccharitiesfortworth. Select the job posting and click the Apply now button at the top right of the posting. Be sure to complete all fields so we know who to contact!

Due to the volume of responses only qualified parties will be contacted. No phone calls please. Catholic Charities Fort Worth is an equalopportunity employer.

Required Experience:

Unclear Seniority