Position Title:
Business Intelligence/Data Analyst

Under
limited supervision, performs complex tasks to support the division by
performing data analysis, data mining, design, development, testing activities,
and execution of AdHoc, Standard, and Customized reports to achieve strategic
objectives and goals. Has working experience in writing and working with SQL
(Standard Query Language), Visual Basic, MS Access, Sales Force Marketing
Cloud, dimensional and relational database design, and other business
intelligence software tools to develop queries and create Journey’s to gather
appropriate data from multiple systems and create reports in multiple
technology applications (Excel, Tableau, Sales Force Marketing Cloud, etc.),
write SSIS packages, complete paperwork/documentation to test and move reports
into Production and send out electronic messages (email and SMS) via Sales
Force Marketing Cloud. Knowledge and use of UI Path for creating BOTS (Robotic
Process Automation - RPA) would be a plus. Serves on projects and/or pilots to
develop and/or provide input for requirements, provide technical guidance for
design or enhancements to systems/reports, and develop Work Plans, schedule,
monitor, etc. to ensure successful and timely completion.

Responsibilities:

Responsibilities
include but are not limited to:

·
Designing reports requiring analysis,
writing of SQL, data mining, and presentation to technical and non-technical
audiences in a variety of technical platforms (Tableau, Excel, Power BI, Sales
Force Marketing Cloud, UI Path, etc.) Create Journey’s in Sales Force Marketing
Cloud for sending out ongoing electronic messages (email and SMS.)

·
Prioritize business and operational needs

·
Extract, import, clean, transform, and
validate data

·
Writing queries using SQL
and MS Access

·
Experience with DB2

·
Identify, analyze, and interpret trends
or patterns in complex data sets

·
Create standard and ad-hoc reports
including detail, summary, history, snapshots, drill down, and other reports

·
Develop report specifications, test
plans, prepare test data, execute tests, supporting documentation, and
coordinate production implementation

·
Establish data connections with various
data sources

·
Setup report schedule, subscription,
access process and procedures, and delivery method

·
Present data in lists, tables, charts,
graphs, snapshots, crosstab, and other formats

·
Tailor the analysis and reporting methods
by the type of data as well as to the intended audience

·
Review key indicators to locate and
correct problems

·
Follow up and track remediation of issues

·
Write and present Desk-Aids and Workflows
for both technical and non-technical audiences.

·
Creating RPA BOTs to automate repetitive,
rule-based tasks such as data entry and system processing.

Knowledge, Skills & Abilities:

·
Knowledge of Service Level Agreement
(SLA); laws, rules, security policies, privacy, data confidentiality
management.

·
Knowledge of Engineering workflow, IT
lifecycle and system design, performance tuning, and Business Intelligence
tools and features.

·
Knowledge of Statistical and business
analysis and research and analysis methodologies.

·
Knowledge of multiple business
intelligence software applications (SQL, SSIS, MS Visual Studio, Tableau,
Visual Basic, MS Access, Sales Force Marketing Cloud, UI Path, etc.) and
multidimensional and relational database design.

·
Knowledge of project management concepts,
principles, and practices.

·
Skilled in the use of Business
Intelligence (SQL, SSIS, Tableau, Visual Basic, MS Access, BI Software, and RPA.)

·
Skilled in dimensional and relational
database design.

·
Skilled in analysis, design review,
troubleshooting, implementation, and integration for applications.

·
Skilled in keyboarding and use of
Microsoft Office programs such as Excel, Word, Access, and PowerPoint and
Google for gmail, calendar, chat, sheets, docs, forms, slides, etc.

·
Problem and negotiation skills to
research and resolve issues.

·
Good time management and organizations
skills with attention to detail.

·
Skilled in effective listening, oral and
written communications skills to communicate technical and non-technical
concepts to a variety of audiences.

·
Ability to write business and functional
requirements and diagram business processes, translate into technical solutions
and reports, query and view objects, and present them in a meaningful format.

·
Ability to work at least 40 hours per
week and maintain satisfactory attendance and punctuality standards.

·
Ability to work independently and
collaboratively and under stress/pressure.

·
Ability to analyze data, develop and
execute queries and reports, and proficiently manipulate data.

·
Ability to adapt to changing needs and
priorities quickly while contributing feedback based on rules and regulations.

·
Ability to multi-task and make good
decisions balancing competing deadlines and priorities.