The Cervantes Group
Get AI-powered advice on this job and more exclusive features.
Direct message the job poster from The Cervantes Group
The Business Intelligence Analyst analyzes needs, designs, writes and tests new solutions, to fulfill business needs, from coding to testing to debugging to designing to implementing newly developed tools. This person will participate in the conceptualization, design, and development of complex technical solutions daily, ensuring the delivery of high-quality BI solutions that meet project objectives. The ideal person for this role can build OLAP/online analytical processing working with databases, both relational and multidimensional. This role will be an integral component of the organization's data interpretation and analysis group delivering valuable information through Intelligence and Analytics, providing direct support to the entire company. Work as a strategic partner with CDO team members and others to help facilitate data driven solutions through analysis and collaboration with business partners.
Responsibilities:
Build OLAP/online analytical processing solutions while supporting and aggregating and mining data from both relational and multidimensional databases.
Create database tables and write reports on findings presenting information to technical and non-technical audiences while participating in meetings discussing organizational data and future directions of the company.
Create and run database queries and conduct analyses in various database languages utilizing T-SQL Server, SQL and SnowSQL to interact with Snowflake using SQL commands.
Build visualizations and reports for requested projects using PowerBI and MS Excel.
Translate business needs to technical specifications in addition to supporting Product Strategy Team to guarantee that the accurate data is effectively processed and analyzed to understand business needs, customer behavior, and maintain key essential metrics.
Extract data from databases and other data sources for reporting and to facilitate sharing between multiple data systems.
Build automatic procedures for monthly and daily reports needed by transferring data from any of our core systems, to help with short and long-term company planning.
Serve as information support for other company areas by running ad-hoc and other periodical reports while updating and modifying user documentation.
Requirements:
Bachelors Degree required
Fully bilingual both oral and written (Spanish/English)
4+ years experience with database management and analysis
2-4+ years experience with BI technologies (e.g. Microsoft Power BI)
Demonstrated knowledge in Microsoft Excel, including but not limited to data transformation, functions/expressions, Macros
Skills in requirements gathering, designing, prototyping, troubleshooting, and supporting users.
Preferred Requirements:
Experience with Snowflake is highly desired
Previous experience programming in Python is a plus
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Engineering and Information Technology Industries
IT Services and IT Consulting, Technology, Information and Media, and Software Development Referrals increase your chances of interviewing at The Cervantes Group by 2x Inferred from the description for this job
Medical insurance Get notified when a new job is posted. Sign in to set job alerts for Business Intelligence Analyst roles.
Irving, TX $125,760.00-$188,640.00 6 days ago Transportation Business Analyst (Data Analyst)
Irving, TX $104,860.00-$139,813.33 5 days ago Business Analyst (Data Analyst Billing Operations, Telecom)
Analyst/Sr Analyst, Business Transformation
Richardson, TX $55,000.00-$70,000.00 3 weeks ago Dallas, TX $50,800.00-$92,100.00 1 day ago Irving, TX $142,900.00-$157,775.00 1 week ago Dallas, TX $60,000.00-$110,000.00 1 month ago Senior Business Analyst, Digital Delivery & AI Initiatives
Irving, TX $125,760.00-$188,640.00 12 hours ago Business Analyst with Policy Center- 100% Remote
Dallas, TX $50,800.00-$92,100.00 4 days ago Data Management Analyst 4/Business Analyst
Plano, TX $110,000.00-$150,000.00 2 weeks ago Business Data Analyst Sales & Retention (Voice of the Customer Office)
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Engineering and Information Technology Industries
IT Services and IT Consulting, Technology, Information and Media, and Software Development Referrals increase your chances of interviewing at The Cervantes Group by 2x Inferred from the description for this job
Medical insurance Get notified when a new job is posted. Sign in to set job alerts for Business Intelligence Analyst roles.
Irving, TX $125,760.00-$188,640.00 6 days ago Transportation Business Analyst (Data Analyst)
Irving, TX $104,860.00-$139,813.33 5 days ago Business Analyst (Data Analyst Billing Operations, Telecom)
Analyst/Sr Analyst, Business Transformation
Richardson, TX $55,000.00-$70,000.00 3 weeks ago Dallas, TX $50,800.00-$92,100.00 1 day ago Irving, TX $142,900.00-$157,775.00 1 week ago Dallas, TX $60,000.00-$110,000.00 1 month ago Senior Business Analyst, Digital Delivery & AI Initiatives
Irving, TX $125,760.00-$188,640.00 12 hours ago Business Analyst with Policy Center- 100% Remote
Dallas, TX $50,800.00-$92,100.00 4 days ago Data Management Analyst 4/Business Analyst
Plano, TX $110,000.00-$150,000.00 2 weeks ago Business Data Analyst Sales & Retention (Voice of the Customer Office)
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr