Data Analyst

FullTime - United States

We are an innovative technology services company, since 2001 we have been providing mission critical systems and their support for some of the leading financial institutions around the world. The solutions provided by us are part of millions of people’s everyday life in making payments or online transactions. Our global team are from diverse backgrounds and experiences in a collaborative and open culture to deliver outstanding services for our customers. Our team enjoys this thought provoking and rewarding environment. Our customers tell us that our team are some of the best they have worked with – not only because of their professional ability, but also their behaviour and attitude. As part of the Pinion team, you will develop those core skills while delivering critical technology solutions for a variety of customers.

  • Work w/stakeholders to clarify business requirements (BR), translate them to tech specifications; Prep Business Requirement & Business Solution Specifications; Create and maintain Requirement Traceability Matrix to ensure current project requirements are being met; Conduct gap analysis to derive requirements for existing systems; Translate BR to workable functional and non-functional requirements at detailed production level using Workflow Diagrams and Use Case Modeling; Perform Source System Analysis to identify required source data; Design Data Models based on BR; Design STAR schema for detailed data marts with conformed dimensions; Work on building prototypes using SQL for each BR; Develop ETL packages for moving data from source to target by using SAP BODS and IICS tools; Develop complex PL/SQL packages, conduct unit testing, coordinate production deployment, resolve post implementation issues; Provide maintenance & support to app; Work w/ETL developers to explain complex Data Transformation Logic; Collaborate with ETL, BI & DBA teams to analyze & provide solutions to data issues, other challenges while implementing OLAP models. Travel (domestic; work/mtgs; 20%) and reloc possible to unanticipated locations throughout the U.S. Work loc: Downers Grove, IL. Mail res, salary reqmt, position applied for to: Pinion Services, Inc., 1901 Butterfield Rd, Ste 160, Downers Grove, IL 60515.

  • Work w/stakeholders to clarify business requirements (BR), translate them to tech specifications; Prep Business Requirement & Business Solution Specifications; Create and maintain Requirement Traceability Matrix to ensure current project requirements are being met; Conduct gap analysis to derive requirements for existing systems; Translate BR to workable functional and non-functional requirements at detailed production level using Workflow Diagrams and Use Case Modeling; Perform Source System Analysis to identify required source data; Design Data Models based on BR; Design STAR schema for detailed data marts with conformed dimensions; Work on building prototypes using SQL for each BR; Develop ETL packages for moving data from source to target by using SAP BODS and IICS tools; Develop complex PL/SQL packages, conduct unit testing, coordinate production deployment, resolve post implementation issues; Provide maintenance & support to app; Work w/ETL developers to explain complex Data Transformation Logic; Collaborate with ETL, BI & DBA teams to analyze & provide solutions to data issues, other challenges while implementing OLAP models. Travel (domestic; work/mtgs; 20%) and reloc possible to unanticipated locations throughout the U.S. Work loc: Downers Grove, IL. Mail res, salary reqmt, position applied for to: Pinion Services, Inc., 1901 Butterfield Rd, Ste 160, Downers Grove, IL 60515.

1 - Apply

Read the job profile to the left- but don’t worry if you think you’re short of the skills we’re looking for. We have plenty of roles available for people with all levels of experience. So, please go ahead and apply even if you are short of few skills. We would like for people to evolve with us. Our talent team does a great job at matching everything up.

2 - Meet

Interested in hearing more about this role? Wondering how Pinion can benefit you professionally? Here’s your chance to ask us! We’ll initially schedule an informal phone chat. If at the end of this chat we both agree that we’re a great match for each other, we’ll invite you round to meet the team face to face.

3 - Join

After we meet, if we still think that we’re a great match for each other, we’ll make you an offer. We promise it won’t be long before you hear from us. Once you accept, your new colleagues will begin planning for your first days at Pinion, while our talent team will continue to be on hand to answer all of your questions.

;