Developer - Integrations and Reporting

Develop backend integration and queries to support the Power BI metrics development supporting Technology Strategy and Governance performance KPIs.

Design, develop and implementation of new and existing solutions supporting within R&D in support of metrics and KPI reporting and data visualization. Perform day to day operations including maintenance, deployment, and troubleshooting of solutions.

What You'll Do

• Develop fast and efficient complex database queries, including joining and cross-referencing cells from several tables.
• Design and develop ETL processes to integrate data from various sources into target databases, data warehouses, and data lakes.
• Optimize and tune SQL queries and data models for performance and scalability.
• Ensure data quality, integrity, and security across all data processes.
• Performing validation on existing SQL queries to check whether it is aligned to business and technical requirements. This includes preparing findings to share with business stakeholders and work with technical teams to resolve any defects.
• Leveraging technical definitions (from production/non-production sources) to refine business definitions (from stakeholders)
• Translating business objectives to technical requirements that are actionable by the delivery team. Collaborating with business analysts, data scientists, and other stakeholders to understand data requirements and deliver effective solutions.
• Working cohesively within a multidisciplinary team of Technical Analysts, Solution Designers, Developers and Stream Leads to complete projects to agreed scope and timeframes.
• Contributing to project planning and identifying scope and estimates
• Documenting technical solutions and hands on technical analysis (as needed). Develop and maintain documentation for data models, ETL processes, and reporting solutions.

What You'll Bring

• 2+ years of experience as an ETL Developer or similar role, with a strong understanding of ETL concepts and techniques.
• Certifications in analytics, data visualization, or relevant technologies a plus
• Min. Undergraduate technical degree B.E. or B.Tech. in Computer Applications or IT with 4+ years of relevant experience in any SQL variant, such as PostgreSQL MySQL, MSSQL,
• Hands-on experience with ETL tools such as Informatica PowerCenter, Microsoft SSIS, Talend, or similar.
• Strong proficiency in SQL and experience with data modeling, ETL processes, and data warehousing.
• Experience with Power BI, including DAX and Power Query.
• Experience with visualization on Power BI is a plus.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

The duties and responsibilities listed in this job description represent the major responsibilities of the position. Other duties and responsibilities may be assigned, as required. Clario reserves the right to amend or change this job description to meet the needs of Clario. This job description and any attachments do not constitute or represent a contract.

The Department Head has the discretion to hire personnel with a combination of experience and education, which may vary from the above listed qualifications.