"Alerted.org

Sr. Data Analyst

Manager Location: Pittsburgh PA Two PNC Plaza 620 Liberty Ave, Pittsburgh, PA 15222

Cleveland OH Strongsville Technology Center 8100 Mohawk Dr., Strongsville, OH 44136

Birmingham AL Birmingham - Brock 701 32nd St. South, Birmingham, AL 35233

North Texas Market TX Dallas Innovation Center - Luna Rd 11511 Luna Rd, Farmers Branch, TX 75234

Phoenix AZ Phoenix - Biltmore 2850 E CAMELBACK RD, Phoenix AZ 85016

Days of the week: Monday through Friday

Function of the group:

Enterprise Architecture responsibility for technology standards, part of governance crew

Current initiatives/project(s) that this resource will be impacting:

Automate current processes, process improvement work (process flows, assessments, data collection)

Centralize a scorecard to be used by Execs for overall health of the program and compliance and performance

Industry background:

Lean Six Sigma training

Process improvement background, organizational change management

Team dynamic:

Architects, BSAs, Project Mangers, Process Improvement specialists

Roles and Responsibilities:

Process improvement

Create the Power BI items based on what the team is needing

Technical Skills:

Candidate will be tasked to migrate from governance by PPT to data driven with automated notifications, statuses and reminders. Must also implement metric collection for processes.

Skill Set: Six Sigma Blackbelt with the following skills:

+ MS Office tools – advanced user, particularly Excel

+ Process flow tools – MS Visio or Aris

+ MS Enterprise SharePoint – experienced (at least 2 years) administrator / designer of Lists with Forms, Views

+ MS Power Apps: Power BI, Power Automate – experienced (at least 2 years) administrator / designer of reports and workflows

+ Can extract and analyze large volumes of data using Excel, Tableau and/or PowerBI

+ Can create process flow diagrams (esp. swim-lanes) for existing processes

+ Can analyze process steps in diagrams and identify required Inputs and Outputs, Suppliers and Customers for each step\

+ Can assist with validating procedure documents against existing process flow diagrams

+ Can create / modify SharePoint sites and lists, considering audiences, access rights, views to protect data, etc.

+ Can create / modify Power BI reports for large volumes of data

+ Can create / modify Power Automate workflows for complex scenarios with multiple steps, evaluations (T/F), decision trees, etc.

+ Can leverage Power Automate to create notification emails or Teams Alerts or approvals for specific workflow steps

Flex Skills:

n/a

Soft Skills:

+ Communication at all levels of the organization

+ Presentation skills

+ Change management to technical and business focused audiences

+ Ability to work independently

+ Critical thinking

+ Time management and prioritize proactively

+ Resilient

Degrees/Certifications:

Lean Six Sigma Blackbelt

Screening Questions:

Role Differentiator:

Opportunity to make a large impact on the organization, have contribution a new kind of view help with improvements being made

Build something top to bottom

Summary:

The main function is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems.

Job Responsibilities:

+ Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies

+ Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions

+ Design, implement, automate and maintain large scale enterprise data ETL processes

+ Modify existing databases and database management systems and/or direct programmers and analysts to make changes

+ Test programs or databases, correct errors and make necessary modifications

Skills:

+ Experience with database technologies

+ Knowledge of the ETL process

+ Knowledge of at least one scripting language

+ Strong written and oral communication skills

+ Strong troubleshooting and problem solving skills

+ Demonstrated history of success

+ Desire to be working with data and helping businesses make better data driven decisions

Education/Experience:

+ Bachelor's degree in a technical field such as computer science, computer engineering or related field required or equivalent work experience.

+ 6-8 years applicable experience required

Skills:?????

+ ARIS???

+ Business Intelligence - Power BI?

+ Data Visualization (Tableau)

+ MICROSOFT OFFICE TOOLS?

+ Microsoft Sharepoint?

+ Microsoft Visio

+ Power Automate???

+ Six Sigma Black Belt???

Share your resume with [email protected]. Also connect me at LinkedIn : (16) Ariz J. Khan | LinkedIn (https://www.linkedin.com/in/ariz-j-khan-17401599/)

Ref: #404-IT Pittsburgh

System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.