Lead Data Analyst

The Lead App Development & Support job programs and configures software to meet the organization's business needs. Under limited supervision, this job identifies and analyzes business software needs, writes complex code to optimize the performance and efficiency of the organization's IT platform/infrastructure and conducts testing to ensure programs are functioning properly. This job is considered a subject matter expert in the Applications Development & Support area.

Key Responsibilities and Duties

• Analyze complex datasets to identify trends, patterns, and insights that support business objectives
• Translate business requirements into technical specifications for data solutions
• Perform data profiling, Source to Target mapping, and validation to ensure accuracy and consistency
• Support the implementation and maintenance of data governance frameworks and standards
• Ensure data quality through regular audits, validation processes, and adherence to data management policies
• Document data flows, data lineage, and system integrations across upstream and downstream systems
• Collaborate with stakeholders to define and maintain data definitions, business rules, and metadata
• Help design and develop ETL (Extract, Transform, Load) processes to support data integration initiatives
• Work with cloud based data platform and relational databases, SQL queries, and data modeling techniques to support analytical needs
• Troubleshoot data-related issues and provide technical support for production systems
• Participate in testing activities by supporting QA resources with test case development, execution, and defect tracking
• Partner with business stakeholders, IT teams (ETL, QA & Production support)
• Communicate findings, insights, and recommendations clearly to both technical and non-technical audiences
• Participate in cross-functional project teams to support enterprise and vertical initiatives
• Contribute to continuous improvement efforts by identifying opportunities for automation and process optimization

Educational Requirements

• University (Degree) Preferred

Work Experience

• 5+ Years Required; 7+ Years Preferred

Physical Requirements

• Physical Requirements:
  
  Sedentary Work

Career Level 8IC

Required Skills
-

• 5 or more years' of experience in SQL and relational database management systems.
• 3 or more years' of experience with data warehouse concepts and data modeling concepts and practices
• 2 or more years' of experience with cloud-based data platforms (e.g., AWS, Azure, Google Cloud)
• 2 or more years' of experience in ETL processes and data integration tools
• Experience in Microsoft Excel (Advanced formulas, pivot tables, and data manipulation)
• Experience in data governance activities (Business Glossary, Data catalogs, source to target mappings) and exposure to Collibra is preferred.
• Experience of Reference data management (tools like EDM / DRM preferred).

Desired Skills :

• An understanding of data architecture and modeling practices and concepts including entity-relationship diagrams, normalization, abstraction, denormalization, dimensional modeling, and meta data modeling practices.
• Financial Asset Management domain knowledge is preferred.
• Experience with data visualization and reporting tools (e.g., Tableau, Power BI, or similar platforms)
• Usage of MYGAIT and prompting.

Related Skills

Agile Methodology, Continuous Integration and Deployment, Data Analysis, Debugging, Dev Ops, Enterprise Application Integration, Operating Systems Management, Problem Solving, Programming, Software Development, Software Development Life Cycle, Web Application Development

Anticipated Posting End Date:

Base Pay Range: $107,000/yr - $141,000/yr

Actual base salary may vary based upon, but not limited to, relevant experience, time in role, base salary of internal peers, prior performance, business sector, and geographic location. In addition to base salary, the competitive compensation package may include, depending on the role, participation in an incentive program linked to performance (for example, annual discretionary incentive programs, non-annual sales incentive plans, or other non-annual incentive plans).

______________________________________________________________________________…