Business Analyst

Job Details

Job Description:

We are seeking a data-savvy professional with strong technical expertise in SQL, Power BI, Power Automate, and JSON. The ideal candidate will be capable of designing data solutions that support complex business requirements through automation, reporting, and data integration. This role demands both analytical thinking and hands-on experience with data manipulation, process automation, and visualization.

SQL Skills:

Beginner (Must Have):

• Familiarity with MS SQL.
• Basic SELECT statements to extract data from single tables.
• Filtering data using WHERE clauses.
• Understanding of LEFT JOIN vs. INNER JOIN.
• Sorting data using ORDER BY.
• Aggregations using GROUP BY, SUM, and COUNT.
• Basic date/time functions like GETDATE().
• Awareness of NULL value handling.

Moderate (Minimum Required):

• String handling and data type conversions.
• Use of CASE statements for conditional logic.
• Combining datasets using UNION and UNION ALL.
• Numeric calculations using arithmetic operators.
• Subqueries and derived tables.
• Common Table Expressions (CTEs) and temporary tables.
• Use of window functions (ROW_NUMBER, RANK, etc.).

Advanced (Desired):

• Data manipulation (INSERT, UPDATE, DELETE).
• Correlated subqueries and advanced joins.
• Creation and use of Views and Stored Procedures.
• Use of MERGE statements for data consolidation.
• User Defined Functions (UDFs).
• APPLY operator (CROSS APPLY, OUTER APPLY).
• Query optimization and indexing strategies.
• Writing and executing dynamic SQL and loop constructs.

Power BI Skills:

Moderate to Advanced:

• Proficient in both beginner and moderate SQL skills as outlined above.
• Data Modeling:
• Designing complex data models with multiple relationships and hierarchies.
• Implementing calculated columns, virtual tables, and date dimensions.
• DAX (Data Analysis Expressions):
• Writing advanced DAX functions including time intelligence and custom aggregations.
• Performance optimization of DAX expressions.
• Visualizations:
• Creating interactive dashboards using slicers, drill-downs, and tooltips.
• Designing intuitive user interfaces with effective storytelling elements.
• Power Query:
• Performing complex data transformations and conditional logic.
• Merging datasets and ensuring data quality.
• Data Integration:
• Connecting to APIs, databases, cloud services, and flat files.
• Managing scheduled refreshes and monitoring data accuracy.
• Data Analysis:
• Applying filtering, segmentation, and trend analysis.
• Communicating insights and actionable recommendations effectively.

Power Automate Skills:

• Building low-code/no-code automated workflows for data movement, approvals, notifications, and integrations.
• Creating automated triggers from Power BI, SharePoint, or Outlook to streamline processes.
• Experience using standard connectors and custom connectors to integrate external services.
• Monitoring and debugging flows using run history and error handling strategies.
• Implementing logic branches, loops, and conditional expressions in flows.

JSON Skills:

• Understanding and working with JSON data structures, including arrays and nested objects.
• Parsing and manipulating JSON data within Power Automate and Power BI.
• Reading and writing JSON for API integrations and data transformation.
• Using expressions to extract, convert, and structure JSON content within automation workflows.

Preferred Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• Strong analytical and problem-solving skills.
• Excellent communication and documentation abilities.
• Experience working in Agile environments is a plus.