BI Analyst

About ISOCRATES
Since 2015, iSOCRATES advises on, builds and manages mission-critical Marketing, Advertising and Data technologies, platforms, and processes as the Global Leader in MADTECH Resource Planning and Execution(TM).

iSOCRATES delivers globally proven, reliable, and affordable Strategy and Operations Consulting and Managed Services for marketers, agencies, publishers, and the data/tech providers that enable them.

iSOCRATES is staffed 24/7/365 with its proven specialists who save partners money, and time and achieve transparent, accountable, performance while delivering extraordinary value. Savings stem from a low-cost, focused global delivery model at scale that benefits from continuous re-investment in technology and specialized training.

About MADTECH.AI
MADTECH.AI
is the Unified Marketing, Advertising, and Data Decision Intelligence Platform purpose-built to deliver speed to value for marketers.

At MADTECH.AI, we make real-time AI-driven insights accessible to everyone. Whether you're a global or emerging brand, agency, publisher, or data/tech provider, we give you a single source of truth - so you can capture sharper insights that drive better marketing decisions faster and more affordable than ever before.

MADTECH.AI
unifies and transforms MADTECH data and centralizes decision intelligence in a single, affordable platform. Leave data wrangling, data model building, proactive problem solving, and data visualization to MADTECH.AI.

Job Description
As a BI Analyst specializing in any of BI tools, your role focuses on leveraging your expertise in BI tools to research, design, create, and implement data models, reports/dashboards, and data-driven applications. You will spearhead the design and implementation of end-to-end BI solutions, actively identifying and resolving data quality issues. As a collaborative team member, you will closely engage with other development teams within the organization to strategize, coordinate, and deliver solutions aligned with client priorities and internal product roadmaps.

Responsibilities

• The Business Intelligence (BI) Analyst works directly with business stakeholders to create data-based solutions that analyze performance and maintain operations Design data models and reports.
• Translate requests from business stakeholders into actionable reports
• Meet with business stakeholders to clarify requirements and communicate progress
• Collaborate with team members
• Write and troubleshoot SQL queries
• Prep data for reports and analysis
• Peer review work of other team members
• Plainly communicate technical issues and concepts to business stakeholders
• Support automated report distributions
• Promote reports from development to test to production
• Flexible to work on any BI platform

Required Skills

• Graduate with 2 - 4 years of experience, 2+ years of relevant experience is mandatory.
• Extensive experience with Power BI & Tableau, and SQL / relational databases.
• Extensive experience in dimensional data modeling; star schemas, snowflakes, denormalized models, and handling - slow-changing- dimensions/attributes.
• Strong understanding of disciplined approaches to Data Visualization and Reporting.
• Experience in understanding complex ETL processes, involving relational and non-relational data.
• Proven record or experience in working with Apache Superset/Power BI/Tableau/Looker.
• Connect and Harmonize (both structured & unstructured) data across third-party data platforms.
• Draw insights from data and action it through alerts & customizable publishing tools.
• Certification in Power BI or any BI tool is preferred.
• Ability to lead cross-functional team communication and develop cross-functional partnerships.
• Excellent problem-solving and data analysis skills.
• Familiarity with our Data Technology Stack (SQL Server, Amazon Redshift, S3, Athena and Snowflake)
• Experience in Media/Marketing industry or domain is a plus
• Ability to quickly grasp existing systems, goals and tech. options for given situations.
• Experienced complete lifecycle of at least one data warehouse/Business Intelligence program at Enterprise scale.
• Experience in Agile Delivery & Agile tools like JIRA/Azure DevOps is a plus

Preferred Skills

• Structured thinker, result-oriented, passionate about data-driven decision-making, particularly leveraging Apache Superset/Tableau/Power BI.
• Passion for problem-solving, developing reports & dashboards
• Should possess good communication skills. Should be a very good team player with a go-getter attitude, results-driven, adaptable, inspirational, organized and quality focused
• Ability to handle complex problems from design to execution and deliver in time bound manner under constraints.

Minimum Education Required

• Bachelor's degree in Computer Science, or related quantitative field required (master's degree in business administration preferred).