Business Intelligence Analyst
CAI Open At a glance
Mid-level Data Analysis & BI role at CAI. Remote, Philippines · full-time.
Pay not stated Data Analysis & BI salary
remoteroles summary, based on the employer's posting.
What you'll do
- Maintain and improve dynamic SQL queries and raw-data reports used to deliver information to customer teams
- Build and update global dashboards for engineering KPIs, checking that reported figures remain accurate
- Combine data from multiple sources into tailored dashboards and automate reporting workflows
- Work with stakeholders to govern, track, analyze and prepare data, including for system migrations and customization projects
- Set data extraction approaches around reporting needs while navigating the digital database and toolset
What you bring
- You have about eight to twelve years working with engineering tools, SQL, product-development data management and report creation
- You bring at least five years programming with MySQL, VBA macros and dynamic SQL
- You can use Excel Power Query, pivot tables and VBA macros, and understand database structures and data extraction
- You communicate clearly, solve problems, and can handle concurrent work under pressure
Who this fits
This remote, full-time role suits an experienced analyst who can work independently and collaborate with people from diverse cultural backgrounds. Product-development or project-management experience is a plus.
From the employer
Req number:
R8764Employment type:
Full timeWorksite flexibility:
RemoteWho 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
We are looking for a motivated Business Intelligence Analyst ready to take us to the next level! If you have experience in processing, mining, and delivery of data to the client's customer community through repositories, tools and services, and are looking for your next career move, apply now.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.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BIRemote
Find me workBy the team behind remoteroles.