SENIOR DATA ARCHITECT & MODELER (Hands on)
Aroha Technologies
Dice Job Match Score™
🧠 Analyzing your skills...
Job Details
Skills
- Python
- Stored Procedures
- Governance
- Microsoft Powerpoint
- Data Analysis
- Marketing Analysis
- SQL
- Database Modeling
- Business Intelligence
- Best Practices
- Strong Communication Skills
- Oracle
- Microservice
- MongoDB
- Power Bi
- Scripting
- Data Modeling
- Excel
- Erwin
- Real-Time
- Splunk
- Financial Services
- Metadata
- Data Warehouses
- Data Warehousing
- Hadoop
- Fiserv
- Data Architecture
- Operational Data Store
- ODS
- Financial Markets
- Engineering Analysis
Summary
Responsibilities:
- An expert to deliver a world class data architecture to an enterprise that establishes robust data governance and enforces best practices, policies, and procedures across the entire data landscape on cloud or premises.
- 15+ years of experience in designing data assets for extremely performant Operational Data Stores and near real time Data Warehouses. Well versed with industry standard Kimball and Inmon practices
- Expertise in creating ER (Entity Relationship), Logical, Physical, and Conceptual data models for an enterprise. At least 15 years hands on experience with Data Modeling tool such as Erwin. Data Modeling experience in financial industry is highly preferred.
- Drive reuse of data and data models at all levels and establish standards to enforce and preserve single version of truth across the data landscape.
- Solid communication skills and be able to facilitate / lead Data Modeling sessions with partners including Business, IT (engineers and developers), BI (Business Intelligence), System of Record (SOR) SMEs etc. to assess business requirements and deliver design prototypes and models.
- Experience in event streaming and event-based data warehousing methodologies.
- Experience in modern data design methodologies such as DDD (Domain Driven Design), Microservices Based Architecture, Bounded Contexts, and Data Mesh building data warehouses for agility, scalability, and autonomy.
- 10+ years of data analysis and profiling experience in financial services development, including account, card, payment, or digital processing.
- Expert SQL development, analysis, design, and performance skills in technologies such as MongoDB, Oracle EXADATA, Hadoop, Spark to support highly performant physical data models.
- Expert hands-on development, and performance tuning experience in Snowflake including writing pipelines, coding stored procedures, and establishing data share.
- Well versed in Power Point and be able to design complex dashboards in Power BI.
- Expert in Excel and Splunk with experience in writing complex macros to expedite data analysis.
- Experience in reverse/forward engineering analysis for complex data flows and be able to develop source-to-target and process mappings.
- Strong scripting experience in Python to create alerts and monitoring, build ingestion and interfaces to move data between systems and automate data governance.
- Experience in building and maintaining an evergreen Data Catalogue for an enterprise with robust metadata and end to end lineage. Experience with Alation, Collibra etc. is nice to have.
- Experience in tools such as Matillion, SnapLogic, or DBT is nice to have to be able to build data pipelines for on cloud / on premises databases such as Snowflake.
- Experience with industry reference frameworks such as BIAN (Banking Industry Architecture Network), IBM Banking & Financial Markets Model, ISO20022 is a plus.
Qualifications:
- Excellent interpersonal, written, and verbal communication skills able to break down complex information and articulate in a manner that is easy to understand.
- Comfortable working in a fast paced, highly complex, matrixed environment and capable of handling multiple tasks concurrently.
- Be able to understand current data landscape, interpret results of analysis, identify trends and issues, and develop data standards to support business objectives.
- Ability to exercise independent judgment and creative problem-solving techniques for data solutions in a large and complex environment.
- Strong organizational skills with demonstrated ability to work with partners to meet business SLAs and plan and deliver work to expectations.
- Functional knowledge of the Financial Services industry with experience promoting a robust risk & control environment is preferred.
- Be able to coach, train, and mentor junior staff.
- Dice Id: 10515154
- Position Id: 2026-6626/39842
- Posted 4 hours ago
Company Info
About Aroha Technologies
Michael Arrington, founder and co-editor of Tech Crunch once famously said that ‘The best startups generally come from somebody needing to scratch an itch’.
Quite true to the thought, Aroha Technologies Inc was launched in 2008 in Florida. While we began our journey with a powerful Staffing Specialist & Software Development, Today our procedure has amplified into a more robust and simplified solution for Marketers looking for consistent and long term.
In our quest to do better, we resolve to simplify user acquisition, retention, engagement and large Business without blinking an eyelid! A semi-remote team spread across the globe, we are here to help you one step at a time.
Unmatchable growing excellence When AROHA was formed, we interviewed many potential clients and business colleagues and asked what a single important question seemed: “If you could design a firm to meet your needs, what would it look like?” The answers to that question have guided our thinking and planning on an ongoing basis, and form the core of our thinking about how we treat our clients and our employees, whom we call associates.
At a most basic level, we have stated our mission in a promise to our clients and our associates: “Unmatchable growing excellence.” This alignment governs superior service to our customers and supports our associates who perform that work, which cannot be matched by our competitors.
In short, we believe that care of our associates, disciplined financial management, and constant attention to the fundamentals of good delivery adds up to a successful, scalable business.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs