What are the responsibilities and job description for the Analytics - SQL, ETL & System Developer position at Phillips & Cohen Associates, Ltd.?
Gahanna, OH, USA Req #72
Monday, March 24, 2025
Estate Information Services (EIS)(www.eismgmt.com), which is now part of the Phillips & Cohen Associates (www.phillips-cohen.com) family, is a specialized account receivables management firm located in Gahanna, Ohio. EIS is a long-standing member of the American Collection Association (ACA) and has a reputation as a trusted partner and, thanks to the talented group of colleagues that make up our team, a leading service provider in the ARM industry. We have been named as a diversity supplier of the year by a top five creditor and have received numerous awards for quality and audit excellence, and now with support of Phillips & Cohen’s global resources, we anticipate signification growth in the coming months.
We’re Looking For
SQL ETL and System Developer: A data-driven decision-maker to join our organization to help ensure accurate and timely data is available for analysis and reporting.
Required Qualifications / Experience
About Phillips & Cohen Associates, Ltd.
PCA provides Equal Employment Opportunity for all individuals regardless of race, color, religion, gender, age, national origin, disability, marital status, sexual orientation, veteran status, genetic information and any other basis protected by federal, state or local laws and reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of our jobs.
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Other details
Monday, March 24, 2025
Estate Information Services (EIS)(www.eismgmt.com), which is now part of the Phillips & Cohen Associates (www.phillips-cohen.com) family, is a specialized account receivables management firm located in Gahanna, Ohio. EIS is a long-standing member of the American Collection Association (ACA) and has a reputation as a trusted partner and, thanks to the talented group of colleagues that make up our team, a leading service provider in the ARM industry. We have been named as a diversity supplier of the year by a top five creditor and have received numerous awards for quality and audit excellence, and now with support of Phillips & Cohen’s global resources, we anticipate signification growth in the coming months.
We’re Looking For
SQL ETL and System Developer: A data-driven decision-maker to join our organization to help ensure accurate and timely data is available for analysis and reporting.
Required Qualifications / Experience
- Strong MS SQL database knowledge - 5 years
- Visual Studio 2019 knowledge essential
- SSIS and API service knowledge highly desirable but not essential.
- T-SQL
- JSON and XML knowledge desirable
- Experience and desire to work in a Global delivery environment, engaging with teams in an onsite/offshore model
- Data migration/integration experience desirable
- Self-starter that can work under general direction in a highly collaborative, team-based environment
- Confident in communicating with people at all levels
- Possess strong analytical skills with the ability to analyse raw data, draw conclusions, and develop actionable recommendations
- Strong problem solving, design and development experience
- Willingness to pick up new skills and technology
- Ability to work with our clients, business and internal developers to gather requirements.
- Data profiling and source-to-target mapping.
- Systems analysis and technical assistance during Change Management and Projects.
- Design, development, implementation, and support of ETL process using SSMS and Procedures
- Querying, aggregation and transformation of data using SQL and JSON.
- Deployment and management of controls and exceptions.
- An understanding of relational database principles.
- Good communication and interpersonal skills as the successful candidate will need to communicate within the team and with clients on a regular basis
- Ability to learn new technologies and platforms as needed
- Key attributes; Commitment; Compliance; Compassion; Innovation; Accuracy; Focus; Trouble-shooting; Organization; Teamwork; Critical-thought; Communication; Microsoft Office; Excel; SQL; JSON; ETL; Programming; Database Management
About Phillips & Cohen Associates, Ltd.
PCA provides Equal Employment Opportunity for all individuals regardless of race, color, religion, gender, age, national origin, disability, marital status, sexual orientation, veteran status, genetic information and any other basis protected by federal, state or local laws and reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of our jobs.
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Other details
- Job Family Phillips & Cohen Associates, Ltd.
- Pay Type Salary
- Required Education High School
- Job Start Date Monday, March 24, 2025
- Gahanna, OH, USA
