The role of the Sr IT Analyst - Enterprise Systems is to plan, design, support, and develop integration points and processes between PDI Enterprise, PDI Focal Point, PDI Market Basket, Upshop, and CK built Applications. Analyst lead who will be responsible for creating, maintaining and optimizing data transfers, SmartSheet integrations, ETL jobs, data imports and exports ensuring their stability, reliability, and performance. Coordinate other developers in optimizing SQL statements as necessary and establishing best practices. Help solve database usage issues and provide solutions to avoid problems in the future.
A critical component of the role is to be a liaison between IT and Circle K Shared Services (Merchandising, Food Service, Pricebook, and Business Units). The Sr IT Analyst is responsible for understanding the business, assisting in the prioritization of projects, ensuring that projects align with the technology that best provides maximum return on investment, and supporting the overall business strategy with regards to PDI Enterprise Scalability.
The role resides in the North America Enterprise Systems team.
ESSENTIAL DUTIES:
The position includes, but is not limited to, the following essential job duties, responsibilities, and requirements:
- Provide leadership in the development and improvement of business processes specializing in ETL with PDI products and our third-party financial applications and support our scalability.
- Collaborate in the planning, design, development, and deployment of new systems and enhancements to existing systems.
- Analyze New business initiatives, provide initial project estimates for cost-benefit analysis.
- Develop and train on processes to maintain high levels of data integrity.
- Coordinate capacity planning and availability of data across the company.
- Create and optimize SQL statements.
- Collaborate with other team members and stakeholders.
- Assist with performance tuning.
- Prepare documentation and specifications for ETL jobs and processes.
- Analyze server resource usage and optimize and tweak as necessary.
- Coordinate and perform in-depth tests, including end-user reviews, for any modified/upgraded and new systems, and other post-implementation support.
- Maintains on-going knowledge of latest PDI system tools and platforms.
JOB REQUIREMENTS:
- Proficiency in Microsoft Excel, Access.
- Proficient in Postman / JSON / APIs (collections are available - already written, just need execution).
- Proficient in Smartsheet is a must because of all the data meshes between the different sheets / forms.
- Ability to analyze data and find root causes to issues.
- Ability to communicate ideas with both business and technical audiences. Strong leadership skills in business process improvement.
- Strong communication skills (both written and oral).
- Strong project management skills.
- Ability to facilitate relations between business groups and technology departments.
- Experience working in a team-oriented, collaborative environment.
- Excellent listening and interpersonal skills.
- Highly self-motivated and directed.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Strong customer service orientation.
PHYSICAL REQUIREMENTS:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Complete physical activity inventory of the position includes:
- Sit for long periods of time.
- Operate computer keyboard and mouse for data entry.
- View computer monitor
- Hear and speak via telephone.
- Reach forward and/or overhead
- Occasionally lift up to 20 pounds
WORK ENVIRONMENT:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Working conditions inventory of the position includes:
- The noise level in the work environment is usually moderate at a normal range.
- The lighting will include natural light from the outside as well as fluorescent lighting throughout the work areas.
- Work with minimum direction and periodic supervision.
JOB DESCRIPTION ACKNOWLEDGMENT
This Job Description indicates the general nature and level of work to be performed in this position and it is not intended to contain or be interpreted as a comprehensive inventory of all the duties, responsibilities, functions and qualifications required of the position. The incumbent may be asked to perform other duties and will be evaluated, in part, on performance of the tasks listed in this job description. As with all positions, the responsibilities and duties of this position may change. The Company reserves the right to revise this Job Description at any time with or without notice. This Job Description does not constitute a contract for employment and either the incumbent or the Company may terminate employment at any time, for any reason, with or without notice.
Circle K is an Equal Opportunity Employer. The Company complies with the Americans with Disabilities Act (the ADA) and all state and local disability laws. Applicants with disabilities may be entitled to a reasonable accommodation under the terms of the ADA and certain state or local laws as long as it does not impose an undue hardship on the Company. Please inform the Company's Human Resources Representative if you need assistance completing any forms or to otherwise participate in the application process.
Circle K is an Equal Opportunity Employer.
The Company complies with the Americans with Disabilities Act (the ADA) and all state and local disability laws. Applicants with disabilities may be entitled to a reasonable accommodation under the terms of the ADA and certain state or local laws as long as it does not impose an undue hardship on the Company. Please inform the Company's Human Resources Representative if you need assistance completing any forms or to otherwise participate in the application process.
Click below to review information about our company's use of the federal E-Verify program to check work eligibility:
In English
In Spanish