Business Intelligence Analyst

Req number:

Employment type:

Worksite flexibility:

Who we are

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

Job Description

We are seeking an experienced Business Intelligence Analyst to process, mining, and delivery of data to the client's customer community through repositories, tools and services. This position will be full-time and remote.
What You'll Do

• The Business Intelligence Analyst will be the responsible for Maintaining and enhance the Dynamic SQL Queries, Raw Data Reports, etc.
• Programming Expertise in MySQL, Excel Power Query, Dynamic SQL Query, VBA is a must
• Proficiency in excel with VBA macros and pivot tables is a must
• Knowledge of database structure and data extraction is highly desired Background in statistics or other data analysis and visualization Competencies
• Knowledge of Power BI, Tableau, Power Apps, Visio is desirable and is a big plus
• Ability to quickly understand and navigate in TE digital database architecture and TE digital
  toolset to define data extraction strategy based on reporting needs
• Collaborate with Key stake holders in Governing, tracking, Data Crunching and Analysis
• Develop and maintain weekly / monthly global reporting dashboard for Engineering related KPI’s,
  maintain reporting accuracy, participate in data related projects such as system migration, customization projects
• Proficiency in standard reporting/presentation tools and data analysis with Proven successful
  delivery of innovative solutions to large organizations
• Develop Customized Dashboards liking and merging multiple Data Sources to design, maintain reporting accuracy, system migration and workflow automation
• Must be able to effectively work with people of diverse cultural backgrounds
• Works with high integrity, proactive and self-learner
• Work with less or No supervision

What You'll Need

Required:

• Overall Experience of about 8 to 12 years in Engineering Tools, Dynamic SQL Query, MYSQL, New Product Development Data Management and Reports Creation
• Minimum 5 to 6 years’ experience in Programming in MYSQL, VBA Macros, Dynamic SQL Query
  is a must
• Product Development and/or Project Management Experience is a plus
• Excellent communication skills (written and verbal)
• Strong aptitude for problem solving
• Able to work effectively under pressure and on several topics concurrently
• Values that need to be demonstrated: Integrity, Accountability, Teamwork, Innovation mindset, Strategy Execution
  Competencies Values: Integrity, Accountability, Teamwork, Innovation

Physical Demands

• Ability to safely and successfully perform the essential job functions
• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
  

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.