Pay Range: $60.00hr - $65.00hr
Job Overview:
Seeking a Senior Data Architect and Modeler with 12+ years of experience in financial services to design performant Operational Data Stores and near real-time Data Warehouses using Kimball and Inmon methodologies.
Responsibilities:
- 12+ years of experience designing highly performant Operational Data Stores (ODS) and near real-time Data Warehouses, with strong knowledge of industry-standard Kimball and Inmon data modeling methodologies.
- 12+ years of hands-on experience in data analysis and data modeling within the financial services industry, including domains such as accounts, cards (credit and debit cards), payments, and digital transaction processing.
- Proven expertise in developing Enterprise Data Models, including Conceptual, Logical, Physical, and Entity Relationship (ER) models, with strong hands-on experience using Erwin.
- Advanced SQL development, data analysis, database design, and performance tuning skills across technologies such as Oracle Exadata, MongoDB, Hadoop, and Spark, supporting the implementation of highly optimized physical data models.
- Expert hands-on development and performance tuning experience in Snowflake, including writing pipelines, coding stored procedures, and establishing data sharing.
- Well-versed in PowerPoint with the ability to design complex dashboards in Power BI.
- Expert in Excel and Client with experience writing complex macros to expedite data analysis.
Qualifications:
- Excellent interpersonal, written, and verbal communication skills, with the ability to break down complex information and articulate it clearly.
- Comfortable working in a fast-paced, highly complex, matrixed environment and capable of handling multiple tasks concurrently.
- Ability to understand the current data landscape, interpret analysis results, 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, complex environment.
- Strong organizational skills with demonstrated ability to work with partners to meet business SLAs and deliver work to expectations.
- Functional knowledge of the financial services industry with experience promoting a robust risk and control environment.
- Ability to coach, train, and mentor junior staff.
Benefits:
Our Benefits Include:
- Medical, Dental, and Vision Insurance
- 401(k) Retirement Plan
- Health Savings Account (HSA)
- Disability Insurance (Short-Term and Long-Term)
- Life and AD&D Insurance
- Paid Sick Leave (where required by applicable state or local law)
- Supplemental Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Employee Wellness Programs
- Employee Assistance Program (EAP)
- Career Growth and Professional Development Opportunities
Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws.
About Cynet Systems
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.
As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.