- Company Name
- MARVEL Infotech Inc.
- Job Title
- Data Analytics Program Lead
- Job Description
-
**Job Title**
Data Analytics Program Lead
**Role Summary**
Lead program-level data analytics initiatives, ensuring high-quality data solutions, robust governance, and alignment with enterprise BI standards. Serve as the technical authority for SQL, MongoDB, Power BI, and Tableau, while integrating QA, SDLC, and CI/CD practices across agile environments.
**Expectations**
- Drive the end-to-end development and deployment of data models and dashboards.
- Maintain data integrity and governance through contracts, SLAs, lineage, and stewardship.
- Communicate complex findings clearly to stakeholders and influence decision‑making.
- Mentor and collaborate with cross‑functional teams on analytics best practices.
**Key Responsibilities**
1. Design, code, and optimize SQL queries (Oracle) and MongoDB aggregation pipelines.
2. Build and validate Power BI data models, DAX calculations, and refresh pipelines; troubleshoot lineage and performance issues.
3. Develop Tableau visualizations and data extracts with strong Excel integration.
4. Create and execute QA test plans, including test cases, regression suites, and defect tracking.
5. Apply SDLC principles in an Agile setting, utilizing Jira, Confluence, CI/CD pipelines (Jenkins, SonarQube, Ansible Tower).
6. Enforce data observability and governance practices, documenting contracts, SLAs, and data stewardship.
7. Provide concise technical documentation and issue write‑ups for stakeholders.
8. Liaise with stakeholders to capture requirements and translate them into actionable analytics solutions.
**Required Skills**
- Advanced Excel (pivot tables, formulas, VBA).
- SQL (Oracle) – joins, window functions, CTEs, performance tuning.
- MongoDB – aggregation pipelines, indexing, schema design.
- Power BI – data modeling, DAX, refresh, lineage cleanup.
- Tableau – visual analytics creation.
- Data governance – contracts, SLAs, lineage, stewardship.
- SDLC & Agile – Jira, Confluence, CI/CD (Jenkins, SonarQube, Ansible Tower).
- QA fundamentals – test case design, regression testing, defect lifecycle.
- Data observability concepts and tooling.
**Required Education & Certifications**
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field.
- Optional: Microsoft Certified: Power BI Data Analyst or equivalent analytics certification.