Office Location : Boca Raton, FL
Workstyle : A hybrid schedule where employees work on-site four days per week and remotely one day.
What You'll Do :
The Senior Development and Data Analyst will provide support for ongoing solutions development, data strategies, end-to-end data integrations, and system design improvements for all of ADT's Planning, PCM, EDM, Dodeca, Essbase, and financial systems data hub.
- Creates, update and maintains the library (currently in Microsoft SSIS ETL task) of automation routines for data sources to be used by financial systems tools (EPBCS, PCM, Dodeca, Essbase, EDM).
- Creates data validations for data sets to validate that changes done to the library does not affect the accuracy of existing data.
- Works with the Admin side of the financial systems group to build new data sets that meet the end user requirement.
- Works with the Admin side of the financial systems group the transition of new data sets for the daily execution of the same.
- Provides support and guidance to the admin side of the financial systems group whenever there is a data discrepancy or data challenge.
- Understands ADT's business and general reporting to be able to deliver the best possible solutions using our EPM tools.
- Creates and maintains documentation of existing processes.
- Provides timelines and level of effort for any development / data project.
- Ensures systems are running efficiently and leads any fixes required to keep systems running.
- Identifies potential system improvements to ensure systems run as efficient as possible.
What You'll Need :
Bachelors degree in business or Information Technology. MBA or CPA preferred.5+ plus years of prior related experience is required.Experience understanding, communicating, and prioritizing projects.Excellent interpersonal, written, and verbal communication skills.Resourceful and able to work independently.Ability to build rapport, cultivate working relationships, and drive collaboration across business teams.Proactive and solution-oriented approach towards business problems and process improvements.Ability to manage multiple projects simultaneously and to work well under pressure.Strong analytical and problem-solving skills.Strong Understanding of Oracle EPM tools.Experience with writing SQL code (store procedures in MS SQL, Google's Big Query and Oracle's PL SQL).Experience with using Microsoft SSIS (ETL packages).Experience with data validation between target and source systems.ADT is an Equal Employment Opportunity (EEO) Employer. We celebrate diversity and are committed to building an inclusive team that represents a variety of backgrounds, perspectives, and skills. ADT strives to ensure every employee and applicant feels valued. Visit us at jobs.adt.com / diversity to learn more.