Software Developer, Business Intelligence Analyst

Job Description

Must Have Technical/Functional Skills

• Strong proficiency in SQL (including complex queries, tuning, stored procedures).
• Database administration experience in SQL Server, MySQL, PostgreSQL, or similar.
• Experience with BI tools such as Splunk, Power BI, Tableau, Looker, ServiceNow, or Qlik.
• Proficiency with ETL/ELT tools (e.g., SSIS, Informatica, dbt, Airflow).
• Understanding of data modeling (star schema, snowflake, dimensional modeling).
• Knowledge of cloud data architectures (AWS RDS/Redshift, Azure SQL, GCP BigQuery preferred).
• Proficiency in leveraging Artificial Intelligence (AI) to drive innovation and efficiency within technical domains.

Roles & Responsibilities

Database Management

• Administer, maintain, and optimize relational and non-relational databases (e.g., SQL Server, MySQL,
• PostgreSQL, NoSQL platforms).
• Develop and manage data models, schemas, indexing strategies, and stored procedures.
• Ensure database availability, reliability, and performance through routine health checks and monitoring.
• Implement data governance, quality standards, and integrity validation processes.
• Manage database backups, replication, DR/BCP, and recovery plans.
• Support database integrations across applications, platforms, and ETL/ELT pipelines.
• Troubleshoot database issues and execute remediation actions within agreed SLAs.

Business Intelligence & Analytics

• Design, build, and maintain BI dashboards, scorecards, KPIs, and analytics reports
• (e.g., Power BI, Tableau, Looker, Qlik, Splunk, ServiceNow, etc.).
• Translate business requirements into visual dashboards aligned to operational and executive reporting needs.
• Develop automated metrics pipelines, scheduled refresh cycles, and high-quality visualizations.
• Validate data accuracy, reconcile data discrepancies, and ensure metric alignment with business definitions.
• Work with stakeholders to define KPIs, operational metrics, and measurement frameworks.
• Perform ad-hoc data analysis and deliver insights to support decision-making.
• Standardize reporting templates, BI governance models, and documentation.

Salary Range: $90,000 - $130000 a year