Trusted by customers. Loved by team members. The smarter way to career.
Principal Data Architect
Location
United States
Posted
8 days ago
Salary
$107.3K - $300.6K / year
Seniority
Lead
Job Description
Principal Data Architect
Mercury Insurance
• Define and lead the enterprise data architecture strategy, target state, and multi-year roadmap for Mercury’s data platform • Establish reference architectures, standards, and guardrails for data ingestion, transformation, modeling, orchestration, quality, observability, and consumption • Drive architecture decisions for enterprise data platforms, including EDW, lakehouse, streaming, operational data integration, and domain-oriented data products • Partner with senior Technology and business leaders to align data investments to enterprise priorities, business value, and long-term scalability • Evaluate current-state architecture, identify gaps, and lead rationalization of tools, patterns, and technical debt across the data ecosystem • Provide technical direction and architectural leadership to data engineering, analytics engineering, and platform teams • Set standards for design quality, model integrity, operational excellence, and scalable delivery across the Enterprise Data & Operations function • Mentor engineers and technical leaders in architectural thinking, modern engineering practices, and delivery excellence • Design, develop, and oversee end-to-end enterprise data solutions supporting multiple data domains, data marts, and analytics use cases • Ensure scalable batch and streaming data pipelines are built to support both enterprise reporting and advanced analytics environments • Own the reliability, quality, consistency, and observability of Mercury’s core data assets and pipelines • Define service levels and operational standards for critical data products and pipelines • Partner across Product, Engineering, Data Science, Analytics, and business teams to ensure the data platform enables real business outcomes • Lead proof of concepts, architecture reviews, and technology evaluations for new tools and capabilities
Job Requirements
- Bachelor’s degree in computer science, Engineering, Information Systems, or a related field; Master’s degree preferred
- 12+ years of experience in data engineering, data architecture, or enterprise data platform leadership
- 5-10 years of experience leading, mentoring, and growing high-performing data engineering or analytics engineering teams
- Proven experience defining enterprise data strategy and leading large-scale modernization of data pipelines, platforms, and models
- Deep expertise in enterprise data modeling, including 3NF, dimensional, star, and snowflake patterns, with strong judgment on how to model real-world business processes
- Strong experience redesigning foundational data models and pipelines with a focus on scalability, usability, and reliability
- Expert-level SQL and Python skills, with strong production experience in Informatica and dbt, including models, testing, and package management
- Experience with orchestration frameworks such as Airflow, Dagster, Tivoli, or similar tools
- Familiarity with streaming and event-driven data technologies such as Kafka or comparable platforms
- Hands-on experience with modern warehouse and lakehouse platforms such as Snowflake, Databricks, Redshift, or BigQuery
- Strong understanding of cloud-native engineering practices across AWS, GCP, or Azure
- Demonstrated commitment to engineering best practices, including Git, CI/CD, infrastructure automation, testing, and DRY design principles
- Experience implementing data quality, observability, lineage, and operational controls in production environments
- Strong stakeholder management and communication skills, with the ability to influence technical and non-technical leaders
- Data product mindset with the ability to turn business needs into architecture, roadmaps, and execution plans
- Experience in insurance, SaaS, or marketplace environments is a plus
- Experience leveraging GenAI or LLM platforms such as OpenAI, Claude, or Gemini to solve meaningful business and engineering problems is strongly preferred
Benefits
- Competitive compensation
- Flexibility to work from anywhere in the United States for most positions
- Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours)
- Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus)
- Medical, dental, vision, life, and pet insurance
- 401 (k) retirement savings plan with company match
- Engaging work environment
- Promotional opportunities
- Education assistance
- Professional and personal development opportunities
- Company recognition program
- Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Senior Data Engineer
WurlWurl, Inc., also known as Wurl Network, is a connected TV (CTV) network founded in 2017 to connect the world's largest media brands with the largest TV streamin
• Evolve and streamline Wurl’s data ETL processes, Business Intelligence dashboards (internal and external) enhancement, data workflows (with emphasis on scale, security, maintainability, and validation), data warehousing processes, and internal/external monitoring, alarming, and reporting. • Act as a data team representative and gather requirements from the internal customers such as data science, sales team, etc.
Instructor - Data Cleaning, Excel and SQL
Fullstack AcademyFounded in 2012, Fullstack Academy is a software development school that offers an immersive programming course developed to transform smart individuals into great software enginee
Instructor - Data Cleaning , Excel & SQL Remote United States Description About Us Simplilearn is the world’s #1 online Bootcamp provider, enabling learners around the globe with rigorous and highly specialized training offered in partnership with world-renowned universities and leading corporations. We focus on emerging technologies and skills, such as data science, cloud computing, programming, and more — that are transforming the global economy. Our training is hands-on and immersive, including live virtual classes, integrated labs and projects, 24x7 support, and a collaborative learning environment. Over two million professionals and 2000 corporate training organizations across 150 countries have harnessed our award-winning programs to achieve their career and business goals. Simplilearn has collaborated with Fullstack Academy to leverage its widespread footprint in the US region and partnerships with Top US universities to grow internationally. Position Overview The Part-Time Instructor for Excel & SQL for Data Analysis plays a key role in delivering engaging and impactful learning experiences to adult learners enrolled in our online programs. Instructors facilitate curriculum content, support student learning, and connect technical concepts to real-world business and analytics applications. This role involves teaching live online sessions, mentoring students, providing feedback, and contributing to a collaborative instructional environment. Classes are delivered 100% online in a synchronous format. Key Responsibilities Deliver live online training sessions covering Excel and SQL concepts. Cover core topics including: Excel: - Data handling and formatting - Functions and formulas (lookup, logical, statistical, etc.) - Pivot Tables and Pivot Charts - Data cleaning and validation - Dashboard creation and reporting - Practical business reporting workflows SQL: - Database fundamentals - Writing queries (SELECT, JOIN, GROUP BY, etc.) - Data filtering and aggregation - Subqueries and views - Query optimization basics - Practical business use cases and case studies Conduct hands-on exercises and guide learners through project work. Provide hands-on support for assignments, labs, and activities. Mentor learners and resolve technical or conceptual queries. Evaluate assignments, assessments, or mock sessions when required. Ensure timely completion of curriculum and learning milestones. Maintain session quality metrics and learner engagement. Collaborate with internal teams on curriculum updates, learner feedback, and delivery planning. Required Qualifications - Bachelor’s degree in IT, Computer Science, Data Analytics, or related field - Strong hands-on experience with Advanced Excel and SQL - Industry experience in data analysis, reporting, or business intelligence roles - Prior experience delivering online or classroom training sessions preferred - Excellent communication, facilitation, and presentation skills - Ability to explain analytical concepts clearly to learners with varied backgrounds Preferred Skills - Experience with Power BI, Tableau, or other BI/visualization tools - Knowledge of Python or data analytics workflows - Relevant certifications in Excel, SQL, analytics, or business intelligence - Experience creating dashboards and business reports - Familiarity with real-world data analysis use cases Key Competencies - Strong instructional and facilitation skills - Ability to simplify technical concepts clearly - Professional virtual presence and delivery - Reliability and schedule discipline - Strong learner engagement and mentoring mindset - Problem-solving and analytical thinking skills Student Support & Mentorship - Provide individualized student support during live sessions and scheduled office hours. - Maintain regular communication with students regarding progress, expectations, and milestones. - Respond to student and staff communications in a timely and professional manner. - Provide clear, constructive, and timely feedback on assignments and assessments. Performance Monitoring - Evaluate student progress based on course deliverables and established grading rubrics. - Maintain accurate documentation of student performance and engagement. - Identify and escalate academic or performance concerns to the Lead Instructor or appropriate staff. - Support performance improvement plans when necessary. Collaboration & Professional Conduct - Adhere to institutional policies and instructional team standards. - Foster an inclusive, respectful, and professional learning environment. - Serve as a role model and mentor for students. - Collaborate with instructional staff and program teams to improve the student learning experience. - Represent the organization professionally when interacting with students, staff, and external stakeholders. Work Schedule - Part-Time instructors typically work 10–15 hours per week depending on cohort schedules. - The total weekly part-time commitment is expected to be 8–12 hours. - Weekday - 06:30 PM CST - 09:30 PM CST (Monday, Wednesday and Thursday) - Weekend - 09:00 AM CST - 12:00 PM CST (Saturday and Sunday) - Flexibility for evening availability is required. Compensation The anticipated pay range for this position is $55 – $60 per hour, depending on qualifications and experience. This position is classified as Part-Time, Non-Exempt, and employees will be compensated for all hours worked in accordance with applicable federal and state wage and hour laws.
Lead Engineer, IT - SAP Data Services
Builders FirstSourceBuilders FirstSource is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status or status as an individual with a disability.
Role Description This role is for a Technical Lead with ownership over the SAP Data Migration aspects of the BFS Data Engineering Team. The ideal candidate will have experience leading the technical aspects of the Data Migration team including: - Providing oversight and ownership over the technical architecture and end-to-end development process. - Implementing data migration solutions using SAP Data Services. - Ensuring timely delivery of high-quality, reliable, and cost-effective migration solutions from diverse ERP sources into SAP S/4 Hana and Azure Cloud. - Defining design guidelines using best practices related to SAP Data Services. - Coding/building pipelines, peer reviews, and general oversight. - Developing the cloud data platform as the environment matures. Qualifications - Bachelor's degree from an accredited college/university. - 7+ years relevant work experience or an equivalent combination of education and experience. - Experience leading ETL on multiple SAP data migration projects from end to end. - Demonstrated high involvement with SAP data object migration processes/tools and complex data extractions, transformations, and loading techniques. - Experience in SAP Data Migration Toolset: SAP Data Services (BODS), iDoc, BAPI, LSMW, RFC, DMC. - Experience in Azure data engineering toolset: Databricks, Microsoft SQL Databases (SQLMI), Azure DevOps. - Experience in basic data warehousing and modeling practices and techniques. - Operating System Technologies: Windows, Linux/Unix including VMs. - Database Technologies: Microsoft SQL, S/4 Hana, Sybase, ODBC/JDBC connection management. - Programming Languages: SQL, Python. Requirements - Manages and resolves data conversion issues during loading, upon consulting with functional team/client. - Demonstrated experience in performance tuning pipelines and applications related to the Data Migration process. - Demonstrated experience in IT security practices in data at rest and in motion. - Maintain Technical and Functional Documentation/Standards including Field Mapping, Validations, Process Flows, Relevancy Rules, etc. Benefits - Medical, dental, vision, and disability insurance plans. - 401(k) retirement savings plan. - PTO (including paid sick time). - 8 paid holidays per year (for salaried and hourly team members). Company Description Builders FirstSource is America’s largest supplier of building materials, value-added components, and building services to the professional market. We are committed to creating a diverse and inclusive workplace that welcomes candidates from all backgrounds and experience levels.
• Build and ship the systems behind Tern's AI features • Build the evaluation systems that answer whether an AI feature is good enough to ship and good enough to keep • Own data quality as a first-class concern • Build and maintain the ETL systems • Work alongside product squads to build reporting



