Data engineer jobs in Bellflower, CA

The Principal Data Scientist works to establish a comprehensive Data Science Program to advance data-driven decision-making, streamline operations, and fully leverage modern platforms including Databricks, or similar, to meet increasing demand for predictive analytics and AI solutions. The Principal Data Scientist will guide program development, provide training and mentorship to junior members of the team, accelerate adoption of advanced analytics, and build internal capacity through structured mentorship. The Principal Data Scientist will possess exceptional communication abilities, both verbal and written, with a strong customer service mindset and the ability to translate complex concepts into clear, actionable insights; strong analytical and business acumen, including foundational experience with regression, association analysis, outlier detection, and core data analysis principles; working knowledge of database design and organization, with the ability to partner effectively with Data Management and Data Engineering teams; outstanding time management and organizational skills, with demonstrated success managing multiple priorities and deliverables in parallel; a highly collaborative work style, coupled with the ability to operate independently, maintain focus, and drive projects forward with minimal oversight; a meticulous approach to quality, ensuring accuracy, reliability, and consistency in all deliverables; and proven mentorship capabilities, including the ability to guide, coach, and upskill junior data scientists and analysts. 5+ years of professional experience leading data science initiatives, including developing machine learning models, statistical analyses, and end-to-end data science workflows in production environments. 3+ years of experience working with Databricks and similar cloud-based analytics platforms, including notebook development, feature engineering, ML model training, and workflow orchestration. 3+ years of experience applying advanced analytics and predictive modeling (e.g., regression, classification, clustering, forecasting, natural language processing). 2+ years of experience implementing MLOps practices, such as model versioning, CI/CD for ML, MLflow, automated pipelines, and model performance monitoring. 2+ years of experience collaborating with data engineering teams to design data pipelines, optimize data transformations, and implement Lakehouse or data warehouse architectures (e.g., Databricks, Snowflake, SQL-based platforms). 2+ years of experience mentoring or supervising junior data scientists or analysts, including code reviews, training, and structured skill development. 2+ years of experience with Python and SQL programming, using data sources such as SQL Server, Oracle, PostgreSQL, or similar relational databases. 1+ year of experience operationalizing analytics within enterprise governance frameworks, partnering with Data Management, Security, and IT to ensure compliance, reproducibility, and best practices. Education: This classification requires possession of a Master's degree or higher in Data Science, Statistics, Computer Science, or a closely related field. Additional qualifying professional experience may be substituted for the required education on a year-for-year basis. At least one of the following industry-recognized certifications in data science or cloud analytics, such as: • Microsoft Azure Data Scientist Associate (DP-100) • Databricks Certified Data Scientist or Machine Learning Professional • AWS Machine Learning Specialty • Google Professional Data Engineer • or equivalent advanced analytics certifications. The certification is required and may not be substituted with additional experience.

Axtria is a leading global provider of cloud software and data analytics tailored for the Life Sciences industry. Since our inception in 2010, we have pioneered technology-driven solutions to revolutionize the commercialization journey, driving sales growth, and enhancing patient healthcare outcomes. Committed to impacting millions of lives positively, our innovative platforms deploy cutting-edge Artificial Intelligence and Machine Learning technologies. With a presence in over 30 countries, Axtria is a key player in delivering commercial solutions to the Life Sciences sector, consistently recognized for our growth and technological advancements. Job Description: We are looking for a Project Lead for our Decision Science practice. Success in this position requires managing consulting projects/engagements delivering Brand Analytics, Real World Data (RWD) Analytics, Commercial Analytics, Marketing Analytics, and Market Access Analytics solutions. Candidates will be expected to have familiarity with: Patient analytics using Real World Data (RWD) sources such as Claims data, EHR/EMR data, lab/diagnostic testing data, etc. Predictive modeling using Real World Data Patient and HCP segmentation Campaign effectiveness, promotion response modeling, marketing mix optimization Marketing analytics incl. digital marketing Required skills and experience: Overall, 4-8 years of relevant work experience and 2+ years of US local experience in pharma analytics Knowledge of the Biopharmaceutical domain. Prior experience in analytics in therapeutic areas of Oncology, Inflammation, Cardio and Bone will be preferred Exposure to syndicated data sets including Claims, EMR/EHR data and exposure to/experience working with large data sets. Strong quantitative and analytical skills, including sound knowledge of statistical concepts and predictive modeling/machine learning. Demonstrated ability to frame and scope business problems, design solutions, and deliver results. Excellent spoken and written communication skills, including superior visualization, storyboarding, and presentation skills. Ability to communicate actionable analytical findings to a technical or non-technical audience in clear and concise language. Relevant expertise in using analytical tools such as R/Python, Alteryx, Dataiku etc. and ability to quickly master new analytics tools/software as needed. Ability to lead project teams and own project delivery. Logistics and Location: U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. The position is based out of Thousand Oaks and the candidate needs to be at the client site 3-5 days per week Axtria is an EEO/AA employer M/F/D/V. We offer attractive performance-based compensation packages including salary and bonus. Comprehensive benefits are available including health insurance, flexible spending accounts, and 401k with company match. Immigration sponsorship will be considered. Pay Transparency Laws Salary range or hourly pay range for the position The salary range for this position is $83,200 to $129,738 annually. The actual salary will vary based on applicant's education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant's geographic location. The salary range reflected is based on a primary work location of Thousand Oaks, CA. The actual salary may vary for applicants in a different geographic location.

Job Title - Principal Data Scientist- 809 Duration - 12+ months **Only on W2 ** & **California Resident Candidates Only** JOB DETAILS: Skills Required: The Principal Data Scientist works to establish a comprehensive Data Science Program to advance data-driven decision-making, streamline operations, and fully leverage modern platforms including Databricks, or similar, to meet increasing demand for predictive analytics and AI solutions. The Principal Data Scientist will guide program development, provide training and mentorship to junior members of the team, accelerate adoption of advanced analytics, and build internal capacity through structured mentorship. The Principal Data Scientist will possess exceptional communication abilities, both verbal and written, with a strong customer service mindset and the ability to translate complex concepts into clear, actionable insights; strong analytical and business acumen, including foundational experience with regression, association analysis, outlier detection, and core data analysis principles; working knowledge of database design and organization, with the ability to partner effectively with Data Management and Data Engineering teams; outstanding time management and organizational skills, with demonstrated success managing multiple priorities and deliverables in parallel; a highly collaborative work style, coupled with the ability to operate independently, maintain focus, and drive projects forward with minimal oversight; a meticulous approach to quality, ensuring accuracy, reliability, and consistency in all deliverables; and proven mentorship capabilities, including the ability to guide, coach, and upskill junior data scientists and analysts. Experience Preferred Five (5)+ years of professional experience leading data science initiatives, including developing machine learning models, statistical analyses, and end-to-end data science workflows in production environments. Three (3)+ years of experience working with Databricks and similar cloud-based analytics platforms, including notebook development, feature engineering, ML model training, and workflow orchestration. Three (3)+ years of experience applying advanced analytics and predictive modeling (e.g., regression, classification, clustering, forecasting, natural language processing). Two (2)+ years of experience implementing MLOps practices, such as model versioning, CI/CD for ML, MLflow, automated pipelines, and model performance monitoring. Two (2)+ years of experience collaborating with data engineering teams to design data pipelines, optimize data transformations, and implement Lakehouse or data warehouse architectures (e.g., Databricks, Snowflake, SQL-based platforms). Two (2)+ years of experience mentoring or supervising junior data scientists or analysts, including code reviews, training, and structured skill development. Two (2)+ years of experience with Python and SQL programming, using data sources such as SQL Server, Oracle, PostgreSQL, or similar relational databases. One (1)+ year of experience operationalizing analytics within enterprise governance frameworks, partnering with Data Management, Security, and IT to ensure compliance, reproducibility, and best practices. Education Preferred This classification requires possession of a Master's degree or higher in Data Science, Statistics, Computer Science, or a closely related field. Additional qualifying professional experience may be substituted for the required education on a year-for-year basis. At least one of the following industry-recognized certifications in data science or cloud analytics, such as: • Microsoft Azure Data Scientist Associate (DP-100) • Databricks Certified Data Scientist or Machine Learning Professional • AWS Machine Learning Specialty • Google Professional Data Engineer • or equivalent advanced analytics certifications. The certification is required and may not be substituted with additional experience. Additional Information California Resident Candidates Only. This position is HYBRID (2 days onsite, 2 days telework). Interviews will be conducted via Microsoft Teams. The work schedule follows a 4/40 (10-hour days, Monday-Thursday), with the specific shift determined by the program manager. Shifts may range between 7:15 a.m. and 6:00 p.m

CGS Business Solutions is committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following opportunity: Summary CGS is hiring for a Senior Data Engineer to serve as a core member of the Platform team. This is a high-impact role responsible for advancing our foundational data infrastructure. Your primary mission will be to build key components of our Policy Journal - the central source of truth for all policy, commission, and client accounting data. You'll work closely with the Lead Data Engineer and business stakeholders to translate complex requirements into scalable data models and reliable pipelines that power analytics and operational decision-making for agents, managers, and leadership. This role blends greenfield engineering, strategic modernization, and a strong focus on delivering trusted, high-quality data products. Overview • Build the Policy Journal - Design and implement the master data architecture unifying policy, commission, and accounting data from sources like IVANS and Applied EPIC to create the platform's “gold record.” • Ensure Data Reliability - Define and implement data quality checks, monitoring, and alerting to guarantee accuracy, consistency, and timeliness across pipelines - while contributing to best practices in governance. • Build the Analytics Foundation - Enhance and scale our analytics stack (Snowflake, dbt, Airflow), transforming raw data into clean, performant dimensional models for BI and operational insights. • Modernize Legacy ETL - Refactor our existing Java + SQL (PostgreSQL) ETL system - diagnose duplication and performance issues, rewrite critical components in Python, and migrate orchestration to Airflow. • Implement Data Quality Frameworks - Develop automated testing and validation frameworks aligned with our QA strategy to ensure accuracy, completeness, and integrity across pipelines. • Collaborate on Architecture & Design - Partner with product and business stakeholders to deeply understand requirements and design scalable, maintainable data solutions. Ideal Experience • 5+ years of experience building and operating production-grade data pipelines. • Expert-level proficiency in Python and SQL. • Hands-on experience with the modern data stack - Snowflake/Redshift, Airflow, dbt, etc. • Strong understanding of AWS data services (S3, Glue, Lambda, RDS). • Experience working with insurance or insurtech data (policies, commissions, claims, etc.). • Proven ability to design robust data models (e.g., dimensional modeling) for analytics. • Pragmatic problem-solver capable of analyzing and refactoring complex legacy systems (ability to read Java/Hibernate is a strong plus - but no new Java coding required). • Excellent communicator comfortable working with both technical and non-technical stakeholders. Huge Plus! • Direct experience with Agency Management Systems (Applied EPIC, Nowcerts, EZLynx, etc.) • Familiarity with carrier data formats (Accord XML, IVANS AL3) • Experience with BI tools (Tableau, Looker, Power BI) About CGS Business Solutions: CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering. CGS is an INC 5000 company and is honored to be selected as one of the Best IT Recruitment Firms in California. After five consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments.

Robert Half is partnering with a well known high tech company seeking an experienced Data Engineer with strong Python and SQL skills. The primary duties involve managing the complete data lifecycle and utilizing extensive datasets across marketing, software, and web platforms. This position is full time with full benefits and 3 days onsite in the Culver CIty area. Responsibilities: 4+ years of professional experience ideally in a combination of data engineering and business intelligence. Working heavily with SQL and programming in Python. Ownership mindset to oversee the entire data lifecycle, including collection, extraction, and cleansing processes. Building reports and data visualization to help advance business. Leverage industry-standard tools for data integration such as Talend. Work extensively within Cloud based ecosystems such as AWS and GCP ecosystems. Requirements: Bachelor's or Master's degree in Computer Science, Engineering, or a related field. 5+ years of experience in data engineering, data warehousing, and big data technologies. Proficiency in SQL and experience with relational databases (e.g., PostgreSQL, MySQL, SQL Server) and NoSQL Technologies. Experience working within GCP environments and AWS. Experience in real-time data pipeline tools. Hands-on expertise with Google Cloud services including BigQuery. Deep knowledge of SQL including Dimension tables and experienced in Python programming.

City: Glendale, CA Onsite/ Hybrid/ Remote: Hybrid (3 days a week onsite, Friday - Remote) Duration: 12 months Rate Range: Up to$85/hr on W2 depending on experience (no C2C or 1099 or sub-contract) Work Authorization: GC, USC, All valid EADs except OPT, CPT, H1B Must Have: • 5+ years Data Engineering • Airflow • Spark DataFrame API • Databricks • SQL • API integration • AWS • Python or Java or Scala Responsibilities: • Maintain, update, and expand Core Data platform pipelines. • Build tools for data discovery, lineage, governance, and privacy. • Partner with engineering and cross-functional teams to deliver scalable solutions. • Use Airflow, Spark, Databricks, Delta Lake, Kubernetes, and AWS to build and optimize workflows. • Support platform standards, best practices, and documentation. • Ensure data quality, reliability, and SLA adherence across datasets. • Participate in Agile ceremonies and continuous process improvement. • Work with internal customers to understand needs and prioritize enhancements. • Maintain detailed documentation that supports governance and quality. Qualifications: • 5+ years in data engineering with large-scale pipelines. • Strong SQL and one major programming language (Python, Java, or Scala). • Production experience with Spark and Databricks. • Experience ingesting and interacting with API data sources. • Hands-on Airflow orchestration experience. • Experience developing APIs with GraphQL. • Strong AWS knowledge and infrastructure-as-code familiarity. • Understanding of OLTP vs OLAP, data modeling, and data warehousing. • Strong problem-solving and algorithmic skills. • Clear written and verbal communication. • Agile/Scrum experience. • Bachelor's degree in a STEM field or equivalent industry experience.

Role: Sr Technical Lead Duration: 12+ Month Contract Daily Tasks Performed: Lead the design, development, and deployment of a scalable, secure, and high-performance CDP SaaS product. Architect solutions that integrate with various data sources, APIs, and third-party platforms. Design, develop, and optimize complex SQL queries for data extraction, transformation, and analysis Build and maintain workflow pipelines using Digdag, integrating with data platforms such as Treasure Data, AWS, or other cloud services Automate ETL processes and schedule tasks using Digdag's YAML-based workflow definitions Implement data quality checks, logging, and alerting mechanisms within workflow Leverage AWS services (e.g., S3, Lambda, Athena) where applicable to enhance data processing and storage capabilities Ensure best practices in software engineering, including code reviews, testing, CI/CD, and documentation. Oversee data privacy, security, and compliance initiatives (e.g., GDPR, CCPA). Ensure adherence to security, compliance, and data governance requirements. Oversee development of real-time and batch data processing systems. Collaborate with cross-functional teams including data analysts, product managers, and software engineers to translate business requirements into technical solutions Collaborate with the stakeholders to define technical requirements to align technical solutions with business goals and deliver product features. Mentor and guide developers, fostering a culture of technical excellence and continuous improvement. Troubleshoot complex technical issues and provide hands-on support as needed. Monitor, troubleshoot, and improve data workflows for performance, reliability, and cost-efficiency as needed Optimize system performance, scalability, and cost efficiency. What this person will be working on: As the Senior Technical Lead for our Customer Data Platform (CDP), the candidate will define the technical strategy, architecture, and execution of the platform. They will lead the design and delivery of scalable, secure, and high-performing solutions that enable unified customer data management, advanced analytics, and personalized experiences. This role demands deep technical expertise, strong leadership, and a solid understanding of data platforms and modern cloud technologies. It is a pivotal position that supports the CDP vision by mentoring team members and delivering solutions that empower our customers to unify, analyze, and activate their data. Position Success Criteria (Desired) - 'WANTS' Bachelor's or Master's degree in Computer Science, Engineering, or related field. 8+ years of software development experience, with at least 3+ years in a technical leadership role. Proven experience building and scaling SaaS products, preferably in customer data, marketing technology, or analytics domains Extensive hands-on experience with Presto, Hive, and Python Strong proficiency in writing complex SQL queries for data extraction, transformation, and analysis Familiarity with AWS data services such as S3, Athena, Glue, and Lambda Deep understanding of data modeling, ETL pipelines, workflow orchestration, and both real-time and batch data processing Experience ensuring data privacy, security, and compliance in SaaS environments Knowledge of Customer Data Platforms (CDPs), CDP concepts, and integration with CRM, marketing, and analytics tools Excellent communication, leadership, and project management skills Experience working with Agile methodologies and DevOps practices Ability to thrive in a fast-paced, agile environment Collaborative mindset with a proactive approach to problem-solving Stay current with industry trends and emerging technologies relevant to SaaS and customer data platforms.

We are seeking a skilled Data Engineer with strong experience in business intelligence (BI) and data warehouse development to join our team. In this role, you will design, build, and optimize data pipelines and warehouse architectures that support analytics, reporting, and data-driven decision-making. You will work closely with analysts, data scientists, and business stakeholders to ensure reliable, scalable, and high-quality data solutions. Responsibilities: Develop and maintain ETL/ELT pipelines for ingesting, transforming, and delivering data. Design and enhance data warehouse models (star/snowflake schemas) and BI datasets. Optimize data workflows for performance, scalability, and reliability. Collaborate with BI teams to support dashboards, reporting, and analytics needs. Ensure data quality, governance, and documentation across all solutions. Qualifications: Proven experience with data engineering tools (SQL, Python, ETL frameworks). Strong understanding of BI concepts, reporting tools, and dimensional modeling. Hands-on experience with cloud data platforms (e.g., AWS, Azure, GCP) is a plus. Excellent problem-solving skills and ability to work in a cross-functional environment.

Role: Principal Data Scientist Duration: 12+ Months contract The Principal Data Scientist works to establish a comprehensive Data Science Program to advance data-driven decision-making, streamline operations, and fully leverage modern platforms including Databricks, or similar, to meet increasing demand for predictive analytics and AI solutions. The Principal Data Scientist will guide program development, provide training and mentorship to junior members of the team, accelerate adoption of advanced analytics, and build internal capacity through structured mentorship. The Principal Data Scientist will possess exceptional communication abilities, both verbal and written, with a strong customer service mindset and the ability to translate complex concepts into clear, actionable insights; strong analytical and business acumen, including foundational experience with regression, association analysis, outlier detection, and core data analysis principles; working knowledge of database design and organization, with the ability to partner effectively with Data Management and Data Engineering teams; outstanding time management and organizational skills, with demonstrated success managing multiple priorities and deliverables in parallel; a highly collaborative work style, coupled with the ability to operate independently, maintain focus, and drive projects forward with minimal oversight; a meticulous approach to quality, ensuring accuracy, reliability, and consistency in all deliverables; and proven mentorship capabilities, including the ability to guide, coach, and upskill junior data scientists and analysts. Required Experience • Five (5)+ years of professional experience leading data science initiatives, including developing machine learning models, statistical analyses, and end-to-end data science workflows in production environments. • Three (3)+ years of experience working with Databricks and similar cloud-based analytics platforms, including notebook development, feature engineering, ML model training, and workflow orchestration. • Three (3)+ years of experience applying advanced analytics and predictive modeling (e.g., regression, classification, clustering, forecasting, natural language processing). • Two (2)+ years of experience implementing MLOps practices, such as model versioning, CI/CD for ML, MLflow, automated pipelines, and model performance monitoring. • Two (2)+ years of experience collaborating with data engineering teams to design data pipelines, optimize data transformations, and implement Lakehouse or data warehouse architectures (e.g., Databricks, Snowflake, SQL-based platforms). • Two (2)+ years of experience mentoring or supervising junior data scientists or analysts, including code reviews, training, and structured skill development. • Two (2)+ years of experience with Python and SQL programming, using data sources such as SQL Server, Oracle, PostgreSQL, or similar relational databases. • One (1)+ year of experience operationalizing analytics within enterprise governance frameworks, partnering with Data Management, Security, and IT to ensure compliance, reproducibility, and best practices. Education This classification requires possession of a Master's degree or higher in Data Science, Statistics, Computer Science, or a closely related field. Additional qualifying professional experience may be substituted for the required education on a year-for-year basis. At least one of the following industry-recognized certifications in data science or cloud analytics, such as: • Microsoft Azure Data Scientist Associate (DP-100) • Databricks Certified Data Scientist or Machine Learning Professional • AWS Machine Learning Specialty • Google Professional Data Engineer • or equivalent advanced analytics certifications. The certification is required and may not be substituted with additional experience. Additional Information • California Resident Candidates Only. This position is HYBRID (2 days onsite, 2 days telework). Interviews will be conducted via Microsoft Teams. The work schedule follows a 4/40 (10-hour days, Monday-Thursday), with the specific shift determined by the program manager. Shifts may range between 7:15 a.m. and 6:00 p.m.

Sr. Data Engineer Full Time Direct Hire Job Hybrid with work location-Irvine, CA. The Senior Data Engineer will help design and build a modern data platform that supports enterprise analytics, integrations, and AI/ML initiatives. This role focuses on developing scalable data pipelines, modernizing the enterprise data warehouse, and enabling self-service analytics across the organization. Key Responsibilities • Build and maintain scalable data pipelines using Snowflake, dbt, and Fivetran. • Design and optimize enterprise data models for performance and scalability. • Support data cataloging, lineage, quality, and compliance efforts. • Translate business and analytics requirements into reliable data solutions. • Use AWS (primarily S3) for storage, integration, and platform reliability. • Perform other data engineering tasks as needed. Required Qualifications • Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field. • 5+ years of data engineering experience. • Hands-on expertise with Snowflake, dbt, and Fivetran. • Strong background in data warehousing, dimensional modeling, and SQL. • Experience with AWS (S3) and data governance tools such as Alation or Atlan. • Proficiency in Python for scripting and automation. • Experience with streaming technologies (Kafka, Kinesis, Flink) a plus. • Knowledge of data security and compliance best practices. • Exposure to AI/ML workflows and modern BI tools like Power BI, Tableau, or Looker. • Ability to mentor junior engineers. Skills • Snowflake • dbt • Fivetran • Data modeling and warehousing • AWS • Data governance • SQL • Python • Strong communication and cross-functional collaboration • Interest in emerging data and AI technologies

Job Title: Data Engineer Duration: Direct-Hire Opportunity We are looking for a Data Engineer who is hands-on, collaborative, and experienced with Microsoft SQL Server, Snowflake, AWS RDS, and MySQL. The ideal candidate has a strong background in data warehousing, data lakes, ETL pipelines, and business intelligence tools. This role plays a key part in executing data strategy - driving optimization, reliability, and scalable BI capabilities across the organization. It's an excellent opportunity for a data professional who wants to influence architectural direction, contribute technical expertise, and grow within a data-driven company focused on innovation. Key Responsibilities Design, develop, and maintain SQL Server and Snowflake data warehouses and data lakes, focusing on performance, governance, and security. Manage and optimize database solutions within Snowflake, SQL Server, MySQL, and AWS RDS. Build and enhance ETL pipelines using tools such as Snowpipe, DBT, Boomi, SSIS, and Azure Data Factory. Utilize data tools such as SSMS, Profiler, Query Store, and Redgate for performance tuning and troubleshooting. Perform database administration tasks, including backup, restore, and monitoring. Collaborate with Business Intelligence Developers and Business Analysts on enterprise data projects. Ensure database integrity, compliance, and adherence to best practices in data security. Configure and manage data integration and BI tools such as Power BI, Tableau, Power Automate, and scripting languages (Python, R). Qualifications Proficiency with Microsoft SQL Server, including advanced T-SQL development and optimization. 7+ years working as a SQL Server Developer/Administrator, with experience in relational and object-oriented databases. 2+ years of experience with Snowflake data warehouse and data lake solutions. Experience developing pipelines and reporting solutions using Power BI, SSRS, SSIS, Azure Data Factory, or DBT. Scripting and automation experience using Python, PowerShell, or R. Familiarity with data integration and analytics tools such as Boomi, Redshift, or Databricks (a plus). Excellent communication, problem-solving, and organizational skills. Education: Bachelor's or Master's degree in Computer Science, Information Systems, Data Science, or a related field. Technical Skills SQL Server / Snowflake / MySQL / AWS RDS ETL Development (Snowpipe, SSIS, Azure Data Factory, DBT) BI Tools (Power BI, Tableau) Python, R, PowerShell Data Governance & Security Best Practices Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual's skill sets, experience and training, licensure and certifications, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company's 401(k) retirement plan. Additional disclaimer: Unless otherwise noted in the job description, the position Vaco/Highspring is filing for is occupied. Please note, however, that Vaco/Highspring is regularly asked to provide talent to other organizations. By submitting to this position, you are agreeing to be included in our talent pool for future hiring for similarly qualified positions. Submissions to this position are subject to the use of AI to perform preliminary candidate screenings, focused on ensuring minimum job requirements noted in the position are satisfied. Further assessment of candidates beyond this initial phase within Vaco/Highspring will be otherwise assessed by recruiters and hiring managers. Vaco/Highspring does not have knowledge of the tools used by its clients in making final hiring decisions and cannot opine on their use of AI products.

We are seeking a Data Analytics Engineer to join our team who serves as a hybrid Database Administrator, Data Engineer, and Data Analyst, responsible for managing core data infrastructure, developing and maintaining ETL pipelines, and delivering high-quality analytics and visual insights to executive stakeholders. This role bridges technical execution with business intelligence, ensuring that data across Salesforce, financial, and operational systems is accurate, accessible, and strategically presented. Essential Functions Database Administration: Oversee and maintain database servers, ensuring performance, reliability, and security. Manage user access, backups, and data recovery processes while optimizing queries and database operations. Data Engineering (ELT): Design, build, and maintain robust ELT pipelines (SQL/DBT or equivalent) to extract, transform, and load data across Salesforce, financial, and operational sources. Ensure data lineage, integrity, and governance throughout all workflows. Data Modeling & Governance: Design scalable data models and maintain a governed semantic layer and KPI catalog aligned with business objectives. Define data quality checks, SLAs, and lineage standards to reconcile analytics with finance source-of-truth systems. Analytics & Reporting: Develop and manage executive-facing Tableau dashboards and visualizations covering key lending and operational metrics - including pipeline conversion, production, credit quality, delinquency/charge-offs, DSCR, and LTV distributions. Presentation & Insights: Translate complex datasets into clear, compelling stories and presentations for leadership and cross-functional teams. Communicate findings through visual reports and executive summaries to drive strategic decisions. Collaboration & Integration: Partner with Finance, Capital Markets, and Operations to refine KPIs and perform ad-hoc analyses. Collaborate with Engineering to align analytical and operational data, manage integrations, and support system scalability. Enablement & Training: Conduct training sessions, create documentation, and host data office hours to promote data literacy and empower business users across the organization. Competencies & Skills Advanced SQL proficiency with strong data modeling, query optimization, and database administration experience (PostgreSQL, MySQL, or equivalent). Hands-on experience managing and maintaining database servers and optimizing performance. Proficiency with ETL/ELT frameworks (DBT, Airflow, or similar) and cloud data stacks (AWS/Azure/GCP). Strong Tableau skills - parameters, LODs, row-level security, executive-level dashboard design, and storytelling through data. Experience with Salesforce data structures and ingestion methods. Proven ability to communicate and present technical data insights to executive and non-technical stakeholders. Solid understanding of lending/financial analytics (pipeline conversion, delinquency, DSCR, LTV). Working knowledge of Python for analytics tasks, cohort analysis, and variance reporting. Familiarity with version control (Git), CI/CD for analytics, and data governance frameworks. Excellent organizational, documentation, and communication skills with a strong sense of ownership and follow-through. Education & Experience Bachelor's degree in Computer Science, Engineering, Information Technology, Data Analytics, or a related field. 3+ years of experience in data analytics, data engineering, or database administration roles. Experience supporting executive-level reporting and maintaining database infrastructure in a fast-paced environment.

Pacific Life is a Fortune 500 company headquartered in Newport Beach, California, with nearly 160 years of experience supporting policyholders. The company provides innovative life insurance, annuity solutions, and mutual funds to help individuals and businesses achieve financial security. Serving both retail and institutional markets, Pacific Life emphasizes offering value and stability to current and future generations. With a strong commitment to excellence, Pacific Life has earned a reputation for financial strength and reliability. Role Description This is a full-time, hybrid Senior Data Engineer position based in Newport Beach, California. The Senior Data Engineer will be responsible for designing, building, and maintaining scalable data pipelines and architecture. Day-to-day responsibilities include implementing Extract Transform Load (ETL) processes, managing data warehouses, and supporting data analytics initiatives to drive business insights. Collaboration with cross-functional teams and ensuring data quality and efficiency are essential aspects of this role. Qualifications Proficiency in Data Engineering, including building and maintaining large-scale data pipelines Experience in Data Modeling, database design, and optimizing data structures Hands-on expertise in Extract Transform Load (ETL) processes and tools Knowledge of Data Warehousing technologies and managing data storage solutions Familiarity with Data Analytics and deriving meaningful insights from datasets Strong problem-solving skills and the ability to work collaboratively in a team environment Bachelor's degree in Computer Science, Data Science, or a related field 7+ year of experience in analysis, design, development and delivery of data 7+ years of experience in SQL, ETL, ELT, leading cloud data warehouse technologies, data transformations and data management tools Experience working in Azure Dev Ops (ADO), Build and Release CI/CD pipelines and orchestration Experience with AWS 2+ years of experience with Snowflake, dbt, Matillion or Profisee Understanding of data catalogs, glossary, data quality and effective data governance Master Data Management (MDM)/Reference Data experience

Thank you for stopping by to take a look at the Data Integration Engineer role I posted here on LinkedIN, I appreciate it. If you have read my s in the past, you will recognize how I write job descriptions. If you are new, allow me to introduce myself. My name is Tom Welke. I am Partner & VP at RSM Solutions, Inc and I have been recruiting technical talent for more than 23 years and been in the tech space since the 1990s. Due to this, I actually write JD's myself...no AI, no 'bots', just a real live human. I realized a while back that looking for work is about as fun as a root canal with no anesthesia...especially now. So, rather than saying 'must work well with others' and 'team mindset', I do away with that kind of nonsense and just tell it like it is. So, as with every role I work on, social fit is almost as important as technical fit. For this one, technical fit is very very important. But, we also have some social fit characteristics that are important. This is the kind of place that requires people to dive in and learn. The hiring manager for this one is actually a very dear friend of mine. He said something interesting to me not all that long ago. He mentioned, if you aren't spending at least an hour a day learning something new, you really are doing yourself a disservice. This is that classic environment where no one says 'this is not my job'. So that ability to jump in and help is needed for success in this role. This role is being done onsite in Irvine, California. I prefer working with candidates that are already local to the area. If you need to relocate, that is fine, but there are no relocation dollars available. I can only work with US Citizens or Green Card Holders for this role. I cannot work with H1, OPT, EAD, F1, H4, or anyone that is not already a US Citizen or Green Card Holder for this role. The Data Engineer role is similar to the Data Integration role I posted. However, this one is mor Ops focused, with the orchestration of deployment and ML flow, and including orchestrating and using data on the clusters and managing how the models are performing. This role focuses on coding & configuring on the ML side of the house. You will be designing, automating, and observing end to end data pipelines that feed this client's Kubeflow driven machine learning platform, ensuring models are trained, deployed, and monitored on trustworthy, well governed data. You will build batch/stream workflows, wire them into Azure DevOps CI/CD, and surface real time health metrics in Prometheus + Grafana dashboards to guarantee data availability. The role bridges Data Engineering and MLOps, allowing data scientists to focus on experimentation and the business sees rapid, reliable predictive insight. Here are some of the main responsibilities: Design and implement batch and streaming pipelines in Apache Spark running on Kubernetes and Kubeflow Pipelines to hydrate feature stores and training datasets. Build high throughput ETL/ELT jobs with SSIS, SSAS, and T SQL against MS SQL Server, applying Data Vault style modeling patterns for auditability. Integrate source control, build, and release automation using GitHub Actions and Azure DevOps for every pipeline component. Instrument pipelines with Prometheus exporters and visualize SLA, latency, and error budget metrics to enable proactive alerting. Create automated data quality and schema drift checks; surface anomalies to support a rapid incident response process. Use MLflow Tracking and Model Registry to version artifacts, parameters, and metrics for reproducible experiments and safe rollbacks. Work with data scientists to automate model retraining and deployment triggers within Kubeflow based on data freshness or concept drift signals. Develop PowerShell and .NET utilities to orchestrate job dependencies, manage secrets, and publish telemetry to Azure Monitor. Optimize Spark and SQL workloads through indexing, partitioning, and cluster sizing strategies, benchmarking performance in CI pipelines. Document lineage, ownership, and retention policies; ensure pipelines conform to PCI/SOX and internal data governance standards. Here is what we are seeking: At least 6 years of experience building data pipelines in Spark or equivalent. At least 2 years deploying workloads on Kubernetes/Kubeflow. At least 2 years of experience with MLflow or similar experiment‑tracking tools. At least 6 years of experience in T‑SQL, Python/Scala for Spark. At least 6 years of PowerShell/.NET scripting. At least 6 years of experience with with GitHub, Azure DevOps, Prometheus, Grafana, and SSIS/SSAS. Kubernetes CKA/CKAD, Azure Data Engineer (DP‑203), or MLOps‑focused certifications (e.g., Kubeflow or MLflow) would be great to see. Mentor engineers on best practices in containerized data engineering and MLOps.

JSG is seeking a Senior Data Solutions Architect for a client in Woodland Hills, CA. This position is remote, and our client is looking for local candidates based in Southern California.The Senior Data Solutions Engineer will design, scale, and optimize the company's enterprise data platform. This role will build and maintain cloud-native data pipelines, lakehouse/warehouse architectures, and multi-system integrations that support Finance, CRM, Operations, Marketing, and guest experience analytics. The engineer will focus on building secure, scalable, and cost-efficient systems while applying modern DevOps, ETL, and cloud engineering practices requiring a strong technologist with hands-on expertise across data pipelines, orchestration, governance, and cloud infrastructure. Key Responsibilities Design, build, and maintain ELT/ETL pipelines across Snowflake, Databricks, Microsoft Fabric Gen 2, Azure Synapse Analytics, and legacy SQL/Oracle platforms. Implement medallion/lakehouse architecture, CDC pipelines, and streaming ingestion frameworks. Leverage Python (90%) and SQL (10%) for data processing, orchestration, and automation. Manage AWS and Azure multi-account environments, enforcing MFA, IAM policies, and governance. Build serverless architectures (AWS Lambda, Azure Functions, EventBridge, SQS, Step Functions) for event-driven data flows. Integrate infrastructure with CI/CD pipelines (GitHub Actions, Azure DevOps, MWAA/Airflow, dbt) for automated testing and deployments. Deploy infrastructure as code using Terraform and Azure DevOps for reproducible, version-controlled environments. Implement observability and monitoring frameworks (Datadog, Prometheus, Grafana, Kibana, Azure Monitor) to ensure system reliability, performance, and cost efficiency. Collaborate with stakeholders to deliver secure, scalable, and cost-efficient data solutions. Background in Finance a or Consumer facing industries is preferred Salary: $160K-$175K JSG offers medical, dental, vision, life insurance options, short-term disability, 401(k), weekly pay, and more. Johnson Service Group (JSG) is an Equal Opportunity Employer. JSG provides equal employment opportunities to all applicants and employees without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, marital status, protected veteran status, or any other characteristic protected by law.

Join the Pacsun Community Co-created in Los Angeles, Pacsun inspires the next generation of youth, building community at the intersection of fashion, music, art and sport. Pacsun is a leading lifestyle brand offering an exclusive collection of the most relevant brands and styles such as adidas, Brandy Melville, Essentials Fear of God, our own brands, and many more. Our Pacsun community believes in and understands the importance of using our voice, platform, and resources to inspire and bring about positive development. Through our PacCares program, we are committed to our responsibility in using our platform to drive change and take action on the issues important to our community. Join the Pacsun Community. Learn more here: LinkedIn- Our Community About the Job: Pacsun's IT eCommerce team uses AI and innovative technologies to enhance customer experience and improve operational efficiency. As a key member of the team, the Senior eCommerce Developer contributes the architecture, development and optimization of the company's digital commerce experiences. This role is responsible for both back‑end and front-end development on Salesforce Commerce Cloud (SFCC), ensuring high‑performance, secure and accessible storefronts, with robust system integration in the eCommerce ecosystem. The Senior eCommerce Developer will lead end‑to‑end delivery of new features, mentor junior developers and off-shore team, and collaborate closely with UX, product, QA and business teams to create compelling online experiences that drive revenue and customer loyalty. This role will work on the full stack of Pacsun's Salesforce Commerce Cloud, mobile app, AI initiatives and system integrations, supporting Commerce, Loyalty, CRM, OMS, and other eCommerce platforms. A day in the life, what you'll be doing: Back‑End Development & Integration Design, build and maintain SFCC server‑side components, including controllers, pipelines, cartridges and custom business logic. Develop and manage robust APIs that connect SFCC with tax engines, payment processors, fraud management services and the order management system. Ensure reliable data synchronization between SFCC and external platforms such as CRM, Loyalty, OMS, ERP and analytics systems. Optimize database models, caching strategies and performance tuning to support high transaction volumes and peak traffic periods. Checkout & Transaction Optimization Own the end‑to‑end checkout experience, ensuring seamless, secure and performant workflows from cart to order confirmation. Integrate payment gateways and fraud protections to deliver accurate pricing and effortless transactions. Collaborate with UX and product teams to identify friction points in the checkout process and implement improvements that boost conversion and customer satisfaction. Tax, Shipping & OMS Integration Implement and maintain integrations with third‑party tax services to handle complex jurisdictional tax rules. Connect SFCC to shipping providers and fulfillment platforms to provide real‑time shipping options and tracking. Build and support integrations with the order management system to ensure accurate order routing, inventory updates and status synchronization. AI & Innovation Support Partner with data science and innovation teams to embed AI‑driven personalization, recommendation and search solutions into the platform. Develop integration points for machine‑learning models and real‑time personalization engines, ensuring data security and compliance. Prototype and implement new technologies that enhance the customer experience and streamline operations. Technical Leadership & Collaboration Lead code reviews, define backend architecture standards and mentor less experienced developers on integration patterns and best practices. Participate in IT management and technical teams to develop and deploy processes to ensure rapid, reliable releases. Work closely with product, UX, QA and DevOps teams to define requirements, plan sprints and deliver high‑quality software on schedule. What it takes to Join: 8+ years of experience in web development and at least 5 years focused on Salesforce Commerce Cloud and SFRA. Deep knowledge of modern front‑end technologies (HTML5, CSS3/SCSS, JavaScript, React or similar frameworks) and back‑end development (Node.js, Java or equivalent). Hands‑on experience with SFCC OCAPI/SCAPI, cartridge development, API integrations and Business Manager configurations. Proven track record integrating third‑party services (payments, tax, shipping, CRM, loyalty, analytics) and implementing secure, scalable solutions. Familiarity with Agile methodologies, version control (Git) and CI/CD pipelines. Strong understanding of web performance optimization, SEO and accessibility standards. Ability to lead discussions, mentor teammates and collaborate with technical teams. Bachelor's degree in Computer Science, Information Systems or related field; Salesforce B2C Commerce Developer certification is preferred. Salesforce Commerce Cloud SFRA certified developer is preferred. Proven ability to excel in fast-growing, dynamic business environments with competing priorities, with a positive, solution-oriented mindset. Excellent analytical and problem-solving skills. Salary Range: $149,000 - $159,000 Pac Perks: Dog friendly office environment On-site Cafe On-site Gym $1,000 referral incentive program Generous associate discount of 30-50% off merchandise online and in-stores Competitive long term and short-term incentive program Immediate 100% vested 401K contributions and employer match Calm Premium access for all employees Employee perks throughout the year Physical Requirements: The physical demands described here are representative of those that are required by an associate to successfully perform the essential functions of this job. While performing the duties of this job, the associate is regularly required to talk or hear. The associate is frequently required to sit; stand; walk; use hands to finger, handle or feel; as well as reach with hands and arms. Specific vision abilities required by this job include close vision, distance vision, depth perception and ability to adjust focus. Ability to work in open environment with fluctuating temperatures and standard lighting. Ability to work on computer and mobile phone for multiple hours; with frequent interruptions. Required to travel in elevator or stairwells to attend meetings and engage with associates on multiple floors throughout building. Hotel, Airplane, and Car Travel may be required. Position Type/Expected Hours of Work: This is a full-time position. As a National Retailer, occasional evening and/or weekend work may be required during periods of high volume. This role operates in a professional office environment and routinely uses standard office equipment. Other Considerations: Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the associate for this job. Duties, responsibilities and activities may change at any time with or without notice. Reasonable accommodations may be made to qualified individuals with disabilities to enable them to perform the essential functions of the role. Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

DevOps Engineer - Satellite Technology Onsite in Irvine, CA or Washington, DC Pioneering Space Technology | Secure Cloud | Mission-Critical Systems We're working with a leading organization in the satellite technology sector, seeking a DevOps Engineer to join their growing team. You'll play a key role in shaping, automating, and securing the software infrastructure that supports next-generation space missions. This is a hands-on role within a collaborative, high-impact environment-ideal for someone who thrives on optimizing cloud performance and supporting mission-critical operations in aerospace. What You'll Be Doing Maintain and optimize AWS cloud environments, implementing security updates and best practices Manage daily operations of Kubernetes clusters and ensure system reliability Collaborate with cybersecurity teams to ensure full compliance across AWS infrastructure Support software deployment pipelines and infrastructure automation using Terraform and CI/CD tools Work cross-functionally with teams including satellite operations, software analytics, and systems engineering Troubleshoot and resolve environment issues to maintain uptime and efficiency Apply an “Infrastructure as Code” approach to all system development and management What You'll Bring Degree in Computer Science or a related field 2-3 years' experience with Kubernetes and containerized environments 3+ years' Linux systems administration experience Hands-on experience with cloud services (AWS, GCP, or Azure) Strong understanding of Terraform and CI/CD pipeline tools (e.g. FluxCD, Argo) Skilled in Python or Go Familiarity with software version control systems Solid grounding in cybersecurity principles (networking, authentication, encryption, firewalls) Eligibility to obtain a U.S. Security Clearance Preferred: Certified Kubernetes Administrator or Developer AWS Certified Security credentials This role offers the chance to make a tangible impact in the satellite and space exploration sector, joining a team that's building secure, scalable systems for mission success. If you're passionate about space, cloud infrastructure, and cutting-edge DevOps practices-this is your opportunity to be part of something extraordinary.

Key Responsibilities Design develop and maintain ELT pipelines using Snowflake and DBT Build and optimize data models in Snowflake to support analytics and reporting Implement modular testable SQL transformations using DBT Integrate DBT workflows into CICD pipelines and manage infrastructure as code using Terraform Collaborate with data scientists analysts and business stakeholders to translate requirements into technical solutions Optimize Snowflake performance through clustering partitioning indexing and materialized views Automate data ingestion and transformation workflows using Airflow or similar orchestration tools Ensure data quality governance and security across pipelines Troubleshoot and resolve performance bottlenecks and data issues Maintain documentation for data architecture pipelines and operational procedures Required Skills Qualifications Bachelors or Masters degree in Computer Science Data Engineering or related field 10 years of experience in data engineering with at least 3 years focused on Snowflake and DBT Strong proficiency in SQL and Python Experience with cloud platforms AWS GCP or Azure Familiarity with Git CICD and Infrastructure as Code tools Terraform CloudFormation Knowledge of data modeling star schema normalization and ELT best practices

In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers. As a leading Modernization Engineering company, we aim to deliver modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16-step Platformation™ playbook. In addition, we bring agility and systems thinking to accelerate time to market for our clients. Headquartered in Bengaluru, India, Sonata has a strong global presence, including key regions in the US, UK, Europe, APAC, and ANZ. We are a trusted partner of world-leading companies in BFSI (Banking, Financial Services, and Insurance), HLS (Healthcare and Lifesciences), TMT (Telecom, Media, and Technology), Retail & CPG, and Manufacturing space. Our bouquet of Modernization Engineering Services cuts across Cloud, Data, Dynamics, Contact Centers, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms. Job Title : Sr. DevOps Engineer Location :Westlake Village CA(Onsite position) Interview :In person interview Responsibilities: The Sr DevOps Engineer - AI platform will: Design, implement, and manage scalable and resilient infrastructure on AWS. Architect and maintain Windows/Linux based environments, ensuring seamless integration with cloud platforms. Develop and maintain infrastructure-as-code(IaC) using both AWS Cloudformation/CDK and Terraform/OpenTofu. Develop and maintain Configuration Management for Windows & Linux servers using Chef. Design, build, and optimize CI/CD pipelines using GitLab CI/CD for .NET applications. Integrate and support AI services, including orchestration with AWS Bedrock, Google Agentspace, and other generative AI frameworks, ensuring they can be securely and efficiently consumed by platform services. Enable AI/ML workflows by building and optimizing infrastructure pipelines that support large-scale model training, inference, and deployment across AWS and GCP environments. Automate model lifecycle management (training, deployment, monitoring) through CI/CD pipelines, ensuring reproducibility and seamless integration with development workflows. Collaborate with AI engineering teams to deliver scalable environments, standardized APIs, and infrastructure that accelerate AI adoption at the platform level. Implement observability, security, data privacy and cost-optimization strategies specifically for AI workloads, including monitoring and resource scaling for inference services. Implement and enforce security best practices across the infrastructure and deployment processes. Collaborate closely with development teams to understand their needs and provide DevOps expertise. Troubleshoot and resolve infrastructure and application deployment issues. Implement and manage monitoring and logging solutions to ensure system visibility and proactive issue detection. Clearly and concisely contribute to the development and documentation of DevOps standards and best practices. Stay up-to-date with the latest industry trends and technologies in cloud computing, DevOps, and security. Provide mentorship and guidance to junior team members. Qualifications: Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience). 5+ years of experience in a DevOps or Site Reliability Engineering (SRE) role. 1+ year(s) of experience with AI services & LLMs. Extensive hands-on experience with Amazon Web Services (AWS) Solid understanding of Windows/Linux Server administration and integration with cloud environments. Proven experience with infrastructure-as-code tools, specifically AWS CDK and Terraform. Strong experience designing and implementing CI/CD pipelines using GitLab CI/CD. Experience deploying and managing .NET applications in cloud environments. Deep understanding of security best practices and their implementation in cloud infrastructure and CI/CD pipelines. Solid understanding of networking principles (TCP/IP, DNS, load balancing, firewalls) in cloud environments. Experience with monitoring and logging tools (e.g., NewRelic, CloudWatch). Strong scripting skills (e.g., PowerShell, Python, Ruby, Bash). Excellent problem-solving and troubleshooting skills. Strong communication and collaboration skills. Experience with containerization technologies (e.g., Docker, Kubernetes) is a plus. Relevant AWS and/or GCP certifications are a plus. Experience with the configuration management tool Chef Preferred Qualifications: Knowledge of and a strong understanding of Powershell and Python Scripting Strong background with AWS EC2 features and Services (Autoscaling and WarmPools) Understanding of Windows server Build process using tools like Chocolaty for packages and Packer for AMI/Image generation. Extensive hands-on experience with Amazon Web Services (AWS) Why join Sonata Software? At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world's toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next. Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.