Data Mart Developer

Data Mart Developer

Roles & Responsibilities

• This position is for a Data Mart developer role (ACH Data Mart TM), who will be working on Money Movement Data Mart for ACH Project and other Data Mart specific initiatives to be delivered as a part of overall Data Mart & Modernization initiative. The candidate is required to have strong financial/payments domain knowledge and technical capabilities required to implement the project. The role will provide the technical mentorship required for the enhancements planned for ACH Data Mart Project.

Must Have

• 10+ years of strong experience in designing and implementing ETL/ELT processes, scalable data pipelines, and robust data integration frameworks.
• 10+ Extensive knowledge of database systems and analytics concepts, including query optimization and data processing techniques.
• 10+ Strong proficiency in scripting and programming languages, with a preference for Python, for data processing and automation.
• 5+ Hands-on experience with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP), including data services and storage solutions.
• 5+ Support analytical data models with pre-aggregations and drill-down capabilities
• 5+ Deep understanding of data modeling (dimensional and relational), data warehousing, and big data architecture principles.
• 5+ Very good understanding and hands on experience in Microsoft Power BI (Data modeling, DAX, Optimization, visualization best practices)
• 5+ Develop data mart structures supporting reporting, analytics, and regulatory needs
• 5+ Experience in AI/ML application in the data lake/warehouse areas, knowledge of medallion architecture.
• 5+ Strong understanding of data warehousing concepts and best practices.
• Knowledge of data security and compliance in cloud environments.
• 5+ Design, Develop and support real-time and near real-time data processing pipelines
• 5+ Implement data quality controls (accuracy, completeness, timeliness)
• 5+ Good understanding of implementation of authentication and authorization on application level.
• 5+ Very good understanding of performance optimization.

Nice To Have

• 5+ Experience working in the financial industry domain. Preferred in Payments Domain.
• 5+ Align models with ISO20022 standards, BIAN domains, and enterprise data taxonomy
• 5+ Integrate data across multiple payment rails e.g. ACH, Wires, RTP, FedNow, Zelle
• 5+ Build unified data models for cross-rail analytics and reporting.

Salary Range- $100,000-$120,000 a year