So sorry, this position is no longer available.
Please go ahead and submit your application. We may have other positions that would be the perfect fit for you.
Alternatively, you may want to apply to one of the following related jobs:
Domino Technologies, Inc.
http://cdn.haleymarketing.com/templates/62673/logos/dominotech-socialmedia.png
http://www.dominotech.net
http://www.dominotech.net
true
Jason Prough
SAP BRIM Data Analyst
Job Description
SAP BRIM Data Analyst / Full-Time / Hybrid / Middletown, PA
Become a member of a growing team of Information Technology professionals making an impact and providing solutions for Government and Commercial clients since 1996 – Join the Domino Tech Team!
The Position:
Client: Commonwealth of Pennsylvania – Pennsylvania Turnpike Commission (PTC)
Position Title: SAP BRIM Data Analyst
Location: Hybrid; Remote Off-Site and On-Site in Middletown, PA
Duration: 30+ Month Project
Note: This position is hybrid with a minimum of 1 week every 4-6 weeks on-site; additional on-site as required by the project, during key phases of the project. In addition to the PA ePATCH background check, PTC requires a National Criminal Background Check prior to engagement start.
We are seeking an SAP BRIM Data Analyst to add to our team assisting the Pennsylvania Turnpike Commission (PTC) Information Technology (IT) Department;
- Understand source data and query legacy data to analyze source data using strong SQL and PL-SQL skills
- Merge data from multiple data sources to be loaded into the target systems
- Collaborate with Microsoft Dynamics Specialist to develop overall target system data dictionary
- Transform and load data from legacy systems into SAP BRIM across components in scope, including SAP S/4HANA (Subscription Order Management, Convergent Invoicing, Financial Contract Accounting, Banking, Sales & Distribution, Materials Management), Convergent Mediation, and Convergent Charging
- Analyze legacy system data structures and extract structured and unstructured data from legacy data sources
- Perform source to target mapping to map data fields from legacy systems to SAP BRIM data structures
- Define, develop, and maintain business rules and cross-referencing tables
- Transform data using ETL (Extract, Transform, Load) tools, including SAP BODS, ADMM, MS SQL-S
- Cleanse and validate data to ensure accuracy and consistency
- Implement Data Masking or Data hashing so no PII data is included in lower environments
- Plan and oversee detailed schedule and progress against milestones
- Perform delta loads for extreme high volume transformed data into SAP BRIM using standard migration tools in a timely and extremely efficient timeframe to minimize downtime for migration
- Validate data integrity and resolve any discrepancies
- Perform high-volume data reconciliation for technical verification and business validation
- Work closely with functional consultants, business analysts, and technical teams
- Participate in data migration workshops and provide expertise
- Document data migration processes, mappings, and validation rules
- Create data migration runbooks for future reference
- Develop and maintain a productive working relationship with technology staff, business owners, project sponsors, vendors, and key clients.
- Lead and participate in project team activities for system work efforts related to enterprise systems.
- Work independently to accomplish the tasks and duties assigned.
- Adhere to and follow all PTC standards, policies, and procedures.
- Utilize various software and/or technology tools to perform job duties.
- Perform tasks and other duties as assigned by the PTC.
The Skills and Experience:
- 5+ Years: Experience as an SAP BRIM Data Specialist/Engineer/Analyst in SAP S/4 HANA hosted in Azure cloud
- Experience using BODS for transformation and loading data into SAP
- Expert level PL-SQL, SQL skills
- Proficient in the Microsoft Office 365 suite of business software including Teams, Word, Excel, and PowerPoint
- Proficient in Microsoft ADO Testing Module
- ITIL / ITSM practices and methodologies
- Experience in migrating data in systems leveraging Microsoft Dynamics as the CRM engine integrated with SAP S/4 HANA as the backend is highly desired
- Experience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions is highly desired
- Tolling experience is highly desired
The Company:
The mission of Domino Technologies, Inc. is to provide clients with IT solutions for their individual business processes that lead to strategic market advantages. Since its founding in 1996, the Domino Tech Team has built a solid record of performance working with clients in the Government and Commercial sectors.
The Perks:
- Excellent Market Salary
- Competitive Benefits
- Paid Holidays and Vacation
- Positive Work-Life Balance
The Location:
Domino Technologies is based in the Harrisburg area – the capital city of the Commonwealth of Pennsylvania and the county seat of Dauphin County. Located on the east bank of the Susquehanna River, Harrisburg is the anchor of the Susquehanna Valley metropolitan area.
Contact Us Today!
Become a member of a growing team of Information Technology professionals making an impact and providing solutions for Government and Commercial clients since 1996 – Join the Domino Tech Team!
The Position:
Client: Commonwealth of Pennsylvania – Pennsylvania Turnpike Commission (PTC)
Position Title: SAP BRIM Data Analyst
Location: Hybrid; Remote Off-Site and On-Site in Middletown, PA
Duration: 30+ Month Project
Note: This position is hybrid with a minimum of 1 week every 4-6 weeks on-site; additional on-site as required by the project, during key phases of the project. In addition to the PA ePATCH background check, PTC requires a National Criminal Background Check prior to engagement start.
We are seeking an SAP BRIM Data Analyst to add to our team assisting the Pennsylvania Turnpike Commission (PTC) Information Technology (IT) Department;
- Understand source data and query legacy data to analyze source data using strong SQL and PL-SQL skills
- Merge data from multiple data sources to be loaded into the target systems
- Collaborate with Microsoft Dynamics Specialist to develop overall target system data dictionary
- Transform and load data from legacy systems into SAP BRIM across components in scope, including SAP S/4HANA (Subscription Order Management, Convergent Invoicing, Financial Contract Accounting, Banking, Sales & Distribution, Materials Management), Convergent Mediation, and Convergent Charging
- Analyze legacy system data structures and extract structured and unstructured data from legacy data sources
- Perform source to target mapping to map data fields from legacy systems to SAP BRIM data structures
- Define, develop, and maintain business rules and cross-referencing tables
- Transform data using ETL (Extract, Transform, Load) tools, including SAP BODS, ADMM, MS SQL-S
- Cleanse and validate data to ensure accuracy and consistency
- Implement Data Masking or Data hashing so no PII data is included in lower environments
- Plan and oversee detailed schedule and progress against milestones
- Perform delta loads for extreme high volume transformed data into SAP BRIM using standard migration tools in a timely and extremely efficient timeframe to minimize downtime for migration
- Validate data integrity and resolve any discrepancies
- Perform high-volume data reconciliation for technical verification and business validation
- Work closely with functional consultants, business analysts, and technical teams
- Participate in data migration workshops and provide expertise
- Document data migration processes, mappings, and validation rules
- Create data migration runbooks for future reference
- Develop and maintain a productive working relationship with technology staff, business owners, project sponsors, vendors, and key clients.
- Lead and participate in project team activities for system work efforts related to enterprise systems.
- Work independently to accomplish the tasks and duties assigned.
- Adhere to and follow all PTC standards, policies, and procedures.
- Utilize various software and/or technology tools to perform job duties.
- Perform tasks and other duties as assigned by the PTC.
The Skills and Experience:
- 5+ Years: Experience as an SAP BRIM Data Specialist/Engineer/Analyst in SAP S/4 HANA hosted in Azure cloud
- Experience using BODS for transformation and loading data into SAP
- Expert level PL-SQL, SQL skills
- Proficient in the Microsoft Office 365 suite of business software including Teams, Word, Excel, and PowerPoint
- Proficient in Microsoft ADO Testing Module
- ITIL / ITSM practices and methodologies
- Experience in migrating data in systems leveraging Microsoft Dynamics as the CRM engine integrated with SAP S/4 HANA as the backend is highly desired
- Experience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions is highly desired
- Tolling experience is highly desired
The Company:
The mission of Domino Technologies, Inc. is to provide clients with IT solutions for their individual business processes that lead to strategic market advantages. Since its founding in 1996, the Domino Tech Team has built a solid record of performance working with clients in the Government and Commercial sectors.
The Perks:
- Excellent Market Salary
- Competitive Benefits
- Paid Holidays and Vacation
- Positive Work-Life Balance
The Location:
Domino Technologies is based in the Harrisburg area – the capital city of the Commonwealth of Pennsylvania and the county seat of Dauphin County. Located on the east bank of the Susquehanna River, Harrisburg is the anchor of the Susquehanna Valley metropolitan area.
Contact Us Today!
Meet Your Recruiter
Jason Prough
Senior Account Executive
Jason is a Senior member of our recruiting team and has a strong commitment and a proven record of both client and candidate satisfaction. He strives to build long-lasting relationships with both the candidates and clients by listening, understanding and addressing their needs.
Jason came to Domino Technologies in February of 2018 after retiring from the USAF where he spent the last eleven years of his military career in Recruiting and as a Recruiting and Retention Manager for the Pennsylvania Air National Guard. In his spare time, he enjoys spending time with his family and friends and being outdoors anywhere from the mountains to the beach.
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Middletown, PA
Ready to take the next step in your career? Explore our job opportunities in the vibrant area surrounding Middletown, Pennsylvania. Nestled in the heart of Dauphin County, this region boasts a perfect balance of small-town charm and big city opportunities. With easy access to Hersheypark, the historic Pennsylvania State Capitol, and the renowned Pennsylvania Farm Show Complex, Middletown offers a unique blend of cultural attractions and outdoor adventures. From enjoying scrumptious Pennsylvania Dutch cuisine to catching a show at the Whitaker Center for Science and the Arts, there's no shortage of entertainment options. Consider joining our team and discovering the endless growth potential and enchanting allure of Middletown, PA.