Burtch Works · 5 days ago
Principal Data Modeler & Architect
New York, NY
Full-time
Hybrid
Lead/Staff
$160K/yr - $195K/yr
8+ years expBurtch Works is a Fortune-recognized global financial services leader providing various financial products. They are seeking a Principal Data Modeler & Architect to join their Data and Analytics organization, focusing on the architecture and design of data solutions across business lines.
RecruitingStaffing Agency
Responsibilities
End-to-End Data Architecture Design: Design and solution end-to-end data architecture for data hubs/data products and Salesforce data all the way from source systems to consumption via Salesforce, web applications, and reporting & analytics solutions. Solve complex problems using data and advanced technologies
Data Modeling & Pipeline Design: Own and approve data models for data domains within the U.S. Group Benefits business. Design data pipelines for analytical and operational needs. Build, optimize, and troubleshoot ETL/ELT pipelines to ingest and store large volumes of structured and unstructured data for batch/real-time processing
Innovation & Framework Development: Ideate, solution, and lead the building of reusable data frameworks for enterprise use. Lead POCs to evaluate new technologies, data products, Salesforce products, and solutions as needed
Governance & Standards: Provide oversight for ongoing initiatives and ensure adherence to defined architecture, quality, security, and compliance guidelines, policies, and standards. Define and develop data standards, guidelines, patterns, and recommendations to be used across the organization
Collaboration & Leadership: Collaborate with multiple partners from Business, Technology, Operations, and D&A capabilities including Data Governance, Data Quality, Data Modeling, Enterprise Architecture, Data Science, DevOps, and BI & Insights. Independently lead design, solutioning, and estimations
Qualification
Required
Bachelor's degree in computer science, information technology, or equivalent educational qualification
8+ years of overall related experience in data architecture, data engineering, or similar roles
Data architecture expertise in both traditional systems (Oracle, SQL Server) and modern platforms (AWS, Azure)
Knowledge of Salesforce data architecture patterns
Data modeling for OLTP & OLAP systems using various data modeling techniques
ETL pipeline design and development; solutioning and estimation
Knowledge of data quality and governance practices
Knowledge of BI Tools (Tableau, Power BI, etc.)
Experience with Big Data and Cloud Frameworks including Apache Spark, Hadoop, and Hive
Exposure to Azure data factory, Synapse and/or Databricks
Expertise in core data management processes
Strong understanding of data warehouses, data marts, and data lakes
Data integration strategies using APIs and ETL tools
Willingness to work hybrid schedule with minimum of 3 days per week in office
Preferred
Exposure to Gen AI technology and tools
Performance tuning, optimization, and data quality validation
Real-time and batch data processing, streaming pipelines with Spark
Banking, Financial Services, and Insurance domain knowledge
Experience with EventHub and Azure functions, Azure data factory, Synapse, and Databricks
DevOps practices: Git, Azure DevOps, CI/CD pipelines
Unix shell scripting, Kafka, MongoDB, Nifi, containerization
Benefits
Comprehensive health plan including medical/prescription drug and vision, dental insurance, no-cost short- and long-term disability, company-paid life insurance and legal services, and digital mental health programs
Flexible hybrid work arrangement, parental leave, volunteer time off, and Employee Assistance Program (EAP)
Tuition assistance and opportunities to work with cutting-edge technologies
Retirement pension funded entirely by employer and 401(k) with employer matching, group discounts on voluntary insurance products including auto and home, pet, critical illness, hospital indemnity, and accident insurance
Company
Burtch Works
Burtch Works is an executive recruiting firm.
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Derek Newman
Chief Product Officer
Recent News
2024-02-18
2023-03-06
Company data provided by crunchbase