About the role
Business Intelligence Analyst Permanent Position / Direct Hire!
Tasks and Activities: As a Business Intelligence Analyst, the beneficiary’s job duties will include:
• Design, develop, and optimize complex SQL queries, stored procedures, and data pipelines to process and analyze large-scale structured datasets from SQL Server and Snowflake environments.
• Engineer and deploy data validation and quality assurance frameworks using Python, SQL, and VBA to enforce data integrity, consistency, and referential accuracy.
• Perform advanced data analysis, statistical evaluation, and reconciliation of multi-source datasets using Python (Pandas, NumPy) and SQL.
• Apply data modeling techniques, normalization principles, and schema design to build scalable and efficient data structures.
• Conduct root cause analysis (RCA) of data anomalies by performing data lineage tracing and system-level diagnostics.
• Support data migration, system integration, and data conversion projects through data profiling, validation, and User Acceptance Testing (UAT).
• Integrate and validate external financial datasets (e.g., Bloomberg) with internal enterprise systems using automated validation logic.
• Develop and implement Python-based data processing frameworks and ETL pipelines for data extraction, transformation, cleansing, and integration across heterogeneous systems.
• Collaborate with cross-functional stakeholders to translate business requirements into technical data solutions and system specifications.
• Utilize enterprise tools such as JIRA and ServiceNow for defect tracking, incident management, and workflow coordination in Agile environments.
• Leverage AI-assisted development tools (e.g., Microsoft Copilot) to enhance productivity in coding, debugging, and technical documentation.
• Ensure adherence to data governance frameworks, regulatory compliance standards, and audit requirements in all data processing activities.
Full time direct hire
Tasks and Activities: As a Business Intelligence Analyst, the beneficiary’s job duties will include:
• Design, develop, and optimize complex SQL queries, stored procedures, and data pipelines to process and analyze large-scale structured datasets from SQL Server and Snowflake environments.
• Engineer and deploy data validation and quality assurance frameworks using Python, SQL, and VBA to enforce data integrity, consistency, and referential accuracy.
• Perform advanced data analysis, statistical evaluation, and reconciliation of multi-source datasets using Python (Pandas, NumPy) and SQL.
• Apply data modeling techniques, normalization principles, and schema design to build scalable and efficient data structures.
• Conduct root cause analysis (RCA) of data anomalies by performing data lineage tracing and system-level diagnostics.
• Support data migration, system integration, and data conversion projects through data profiling, validation, and User Acceptance Testing (UAT).
• Integrate and validate external financial datasets (e.g., Bloomberg) with internal enterprise systems using automated validation logic.
• Develop and implement Python-based data processing frameworks and ETL pipelines for data extraction, transformation, cleansing, and integration across heterogeneous systems.
• Collaborate with cross-functional stakeholders to translate business requirements into technical data solutions and system specifications.
• Utilize enterprise tools such as JIRA and ServiceNow for defect tracking, incident management, and workflow coordination in Agile environments.
• Leverage AI-assisted development tools (e.g., Microsoft Copilot) to enhance productivity in coding, debugging, and technical documentation.
• Ensure adherence to data governance frameworks, regulatory compliance standards, and audit requirements in all data processing activities.
Full time direct hire
Requirements
REQUIREMENTS
Business Intelligence Analyst
Ability to work in a project driven environment
Business Intelligence Analyst
Ability to work in a project driven environment
SAR Tech LLC is an equal opportunity employer. Applicants must be legally authorised to work in the United States.