Jobs
>
Roseville

    Senior Data Engineer - Roseville, United States - Tri Counties Bank

    Tri Counties Bank
    Tri Counties Bank Roseville, United States

    3 weeks ago

    Default job background
    Description
    Check us out, this could be the best career move you ever make.


    The hiring range for this opportunity is $120,000 - $160,000 annually along with incentive opportunities, creating a competitive total compensation package based on our pay scale, and may be modified by location and is commensurate with qualifications and experience.

    Position Summary

    The Senior Data Engineer is responsible for the end-to-end development life cycle for the Bank's data warehouse.

    The implementation of Extract, Transform, Load (ETL) procedures, modeling for database and performance management, and dimensional design of the table structure are all tasks that fall under the purview of the Senior Data Engineer.

    The position collaborates closely with the Product Management, other Data Engineers, and Analyst teams to achieve insights, provide the organization with valuable data solutions, and enable reliably to inform strategic decisions.

    The Senior Data Engineers will work independently on projects while keeping senior leadership informed.

    They also need strong communication skills and effectively convey their ideas to senior leadership, other members of the team and mentor less experienced Data Engineers and Analysts.

    Major Responsibilities

    Create data models used to extract information from various sources and store it in a usable format.
    Automation of pipelines, data quality rules and data governance practices
    Maintain data integrity by designing backup and recovery procedures.
    Identify opportunities to enhance performance by improving database structure or indexing methods.
    Conduct research to identify new technologies that can be applied to current projects.
    Ensure delivery of reports, dashboards, and custom solutions for various business lines.

    Accountable for all aspects of data engineering from delivery planning, estimating and analysis, through to data architecture and pipeline design, delivery, and production implementation.

    Analyze data to find patterns or insights that can be used to develop strategies or make business decisions.
    Oversee development of new dashboards using existing data sets to create new products or improve existing services.
    Maintain existing applications by updating existing code or adding new features to meet new requirements.
    Design and implement security measures to protect data from unauthorized access or misuse.
    Proactively recommend infrastructure changes to improve storage capacity or performance.
    Analyze and organize raw data, build data systems and pipelines.
    Evaluate business needs, objectives, interpret trends and patterns through conducting business interviews.
    Conduct complex data analysis and report on results.
    Prepare data for prescriptive and predictive modeling.
    Build algorithms and prototypes, combine raw information from different sources.
    Establish SLA's and communication mechanisms for report disruption.
    Establish a centralized reporting portal for role-based organization wide pull reporting.
    Explore ways to enhance data quality and reliability.
    Identify opportunities for data acquisition.
    Collaborate with data analysts and architects on several projects.
    Design, contribute and maintain a data dictionary.
    Working knowledge of Master Data management and Data Lineage
    Expertise in translating business requirements into actionable work
    Advanced knowledge working with business stakeholders on Date Governance and Data Quality.

    Secondary Responsibilities


    Maintain a current understanding of stated procedures and policies, including regulatory compliance issues as it relates to all pertinent FDIC, DFPI, and other Federal security regulations related to Data Governance and Data Security.

    Maintain a current understanding of Bank policies and procedures in compliance with all federal and state laws, including but not limited to Bank Secrecy Act (SARs, CIP, OFAC), Information Security (GLBA), Privacy Laws (CCPA), Identity Theft Red Flags, Financial Elder Abuse Reporting, and any other applicable regulations that may be specific to your job duties.

    Understand data privacy and data security concepts and experience with delivering data-related projects.
    Ability to communicate across disciplines (ex. security, privacy, legal, risk).

    Other Responsibilities

    Firm understanding of Data Governance, specifically in the banking and financial sector.
    Review, comprehend and maintain a current knowledge of all applicable laws, rules and regulations governing assigned area of responsibility.
    Extensive experience managing corporate data warehouse programs within medium to large organizations.
    Knowledge of evolving and current threats including Cyber terrorism.
    Maintain confidentiality regarding all customer and employee information.
    Perform other duties as assigned.

    Education, Experience And Other Skills Required

    Bachelor's degree in Information Security, Information Technology or related field, strongly preferred.
    8-10 years of proven data and performance engineering experience.

    Extensive experience providing practical direction within AWS & Azure cloud native services, implementing data migration and data processing using Azure services: ADLS, Azure Data Factory, Synapse/DW /Azure SQL DB, Fabric.

    Proven experience with SQL, namely schema design and dimensional data modelling
    Expert knowledge of data warehouse best practices, development standards and methodologies
    Strong experience with Azure Cloud on data integration with Snowflake (developing ETL pipelines)
    Advanced knowledge on Power BI
    Be an independent self-learner with the "let's get this done."
    Strong understanding on ML Studio, AI/ML, MLOps etc.
    Python & Data Bricks experience preferred.
    Expert track record of developing custom-built data/analytics solutions and experience in supporting large scale programs.
    Advanced experience with system analysis, data analysis or programming, using a variety of computer languages and procedures.
    Experience establishing an Agile system and working environment for a data warehouse.
    Banking experience strongly preferred.
    Expert leading complex regulatory projects.
    Experience across multiple bank departments desired.

    Knowledge of laws and regulations impacting data protection and confidentiality, integrity, and availability of systems and data in the financial industry such as Sarbanes-Oxley, and state regulations.

    Effective interpersonal skills with the ability to work effectively with individuals and groups at all organizational levels.
    Leadership ability to provide guidance, coaching and training to staff and to other Bank employees.
    Ability to take initiative and prioritize tasks, good time-management, problem prevention and problem-solving skills.
    Proven track record of success demonstrating leadership and management skills.
    Expert verbal and written communication skills, including presentation skills.
    Knowledge in DevOps and CI/CD deployments, Cloud migration methodologies and processes.

    Nice to have:
    Event Hub, IOT Hub, Azure Stream Analytics, Azure Analysis Service, Cosmos DB knowledge, PBI Gateway knowledge.

    Company Profile

    Established in 1975, Tri Counties Bank is a wholly-owned subsidiary of TriCo Bancshares (


    NASDAQ:
    TCBK) headquartered in Chico, California, with assets of nearly $10 billion and more than 45 years of financial stability.

    Tri Counties Bank provides a unique brand of Service With Solutions for communities throughout California with a breadth of personal, small business and commercial banking services, plus an extensive branch network, more than 37,000 surcharge-free ATMs nationwide, and advanced online and mobile banking.


    Tri Counties Bank remains strong and profitable through our top-down commitment to our core values, sound business principles and responsible lending practices.

    Our success is also based on our community engagement. We still believe in the vision of the helpful and caring community banker.

    As we grow and serve more communities, we become more involved, providing substantial financial and volunteer support to local economies and community organizations.

    We applaud our employees who roll up their sleeves to work and volunteer for a greater good in our communities.


    Tri Counties Bank hires individuals who are qualified for the role and who represent the communities in which we serve.

    We look to place people in positions where they can best utilize their abilities and strengths, and where they are able to grow with the Bank.

    Tri Counties Bank is an Affirmative Action and Equal Opportunity Employer, Race/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Disability/Veteran.
    #J-18808-Ljbffr
  • Gainwell Technologies

    Cloud Data Engineer

    3 weeks ago

    Gainwell Technologies Roseville, United States

    Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You'll have an incredible opportunity to grow your career in a compa ...

  • Zyxware Technologies

    Data Engineer

    1 week ago

    Zyxware Technologies Elk Grove, United States

    Role: Data Engineer (Only W2) · Location: Elk Grove, CA · Duration: 12 months plus · Type: Hybrid 3 days on site 2 days off site · Must be using Tableau, SQL, and Python on a weekly basis for the past 5+ years. · Use Tableau to create visualizations · Use SQL to manipulate and m ...

  • Beth Page tech

    Data Engineer

    2 weeks ago

    Beth Page tech Elk Grove, United States

    Job Description · Job DescriptionRole: Data Engineer · Location: Elk Grove, CA · Duration: 12 months plus · Type: Hybrid 3 days on site 2 days off site · Must be using Tableau, SQL, and Python on a weekly basis for the past 5+ years. · Use Tableau to create visualizations · Use ...

  • The Shipyard

    Senior Data Engineer

    16 hours ago

    The Shipyard Sacramento, United States

    The Shipyard is a leading, independent agency that builds performance-driven brands audiences can't help but love. · By applying modern mindsets to established models, we fuel brand and marketing decisions that are more courageous and more validated. · Our ability to align bold ...

  • ASR Analytics

    Data Engineer Lead

    2 days ago

    ASR Analytics Rancho Cordova, United States

    Opportunity Details · Full Time Data Engineer Lead · Rancho Cardova, CA · Apply Now · Share This · Copy URL · Outcomes. Delivered. · Voyatek, formerly GCOM Software and OnCore Consulting, delivers outcome-driven technology solutions to public sector agencies and higher ed ...

  • Marsh McLennan Companies

    Senior Data Platform Engineer

    3 weeks ago

    Marsh McLennan Companies Golden Valley, United States Full time

    Description: · Our not-so-secret sauce. · Award-winning, inclusive, Top Workplace culture doesn't happen overnight. It's a result of hard work by extraordinary people. More than 10, of the industry's brightest talent drive our efforts to deliver purposeful work and meaningful i ...

  • Choice Bank

    Senior Data Engineer

    16 hours ago

    Choice Bank Golden Valley, United States

    Data Architecture, Modeling, & IntegrationDesign and implement scalable and efficient data models. · Develop and maintain conceptual, logical, and physical data models. · Integrate data from various sources to support business processes and analytics. · Ensure seamless data fl ...

  • The Shipyard

    Senior Data Engineer

    1 week ago

    The Shipyard Sacramento, United States

    The Shipyard is a leading, independent agency that builds performance-driven brands audiences can't help but love. · Skills, Experience, Qualifications, If you have the right match for this opportunity, then make sure to apply today. · By applying modern mindsets to established ...

  • West Advanced Technologies

    Data Engineer with MITA

    1 week ago

    West Advanced Technologies Sacramento, United States

    Data Engineer with MITA · Sacramento, CA · 12+ months · Roles & Responsibilities: · Define overall technical interface project design. · Design, develop and implement an interface adhering to MITA standards. · Schedule, participate in and conduct project meetings (in-pe ...

  • Enformion Inc

    Data Engineer

    3 weeks ago

    Enformion Inc Sacramento, United States

    Enformion is an innovative data and analytics company founded by pioneers in data technology with over two decades of experience. Using state-of-the-art artificial intelligence (AI) and machine learning (ML), we provide an unparalleled and comprehensive view of people, businesses ...

  • State of California

    Senior Data Warehousing Engineer

    5 days ago

    State of California Sacramento, United States

    THIS IS A RE-ADVERTISEMENT, IF YOU PREVIOUSLY APPLIED, YOU DO NOT HAVE TO RE-APPLY. · TELEWORK IS CURRENTLY AVAILABLE, HOWEVER, STAFF MAY BE REQUIRED TO REPORT TO THEIR ASSIGNED HEADQUARTERS AS BUSINESS NEEDS ARISE. · Are you looking for a fast-paced and challenging position th ...

  • Compu-Vision Consulting

    Network Service Data Management Engineer

    3 weeks ago

    Compu-Vision Consulting Rancho Cordova, United States

    a. Mandatory Qualifications – The Contractor shall provide one (1) qualified resource who meets the following minimum qualifications. Resume and Staff Experience Worksheet must document recent and relevant experience within the last five (5) years for each qualification including ...

  • Essel Environmental

    Party Chief

    1 week ago

    Essel Environmental Roseville, United States

    Job Description - Party Chief · $ Operates survey instruments required to perform surveys as directed by the Field Survey Manager. · $ Knowledgeable of, and abides by safety requirements. · $ Knowledgeable of traffic control and safety procedures for a variety of surveying and co ...

  • Odin

    Project Estimator

    3 weeks ago

    Odin Roseville, United States

    Are you ready to join Team Odin and find the career you have always wanted? · Odin is an award-winning contractor delivering turnkey environmental, geotechnical, and civil construction projects nationwide. We've become our clients' trusted collaborators through our commitment to ...

  • Murray Company

    Quality Control Inspector

    2 weeks ago

    Murray Company Roseville, United States

    ABOUT MURRAY COMPANY · At Murray Company, how we operate is defined by shared values that are 100 years in the making -Safety, Quality, Honesty, Hard Work and Pride of Ownership. These values have led to our company consistently being in the top 15% on ENRs Best Specialty Contrac ...

  • Odin

    Health And Safety Manager

    3 days ago

    Odin Roseville, United States

    Why work for us? · Exceptional Pay · Matching 401k · Great Healthcare Benefits · Unlimited Paid Vacation · ASCE Dues Paid · Sign On Bonuses · Great Company Culture · Career Growth Opportunities · Health and Safety Manager · MAJOR FUNCTION · The primary role of the Health and Safe ...

  • New Relic

    Lead Data Engineer

    3 weeks ago

    New Relic Sacramento, United States

    Lead Data Engineer (Remote) Lead Data Engineer (Remote) Lead Software Engineer Your opportunity We are looking for a highly skilled and motivated Lead Data Engineer to join our Data Platform Team. As a team member, you will play a meaningful role in designing, building, and maint ...

  • Saxon Global

    Data Warehouse Engineer

    2 weeks ago

    Saxon Global Sacramento, United States

    Title: Data Warehouse Engineer (MUST HAVE SAS or COBOL, prefer BOTH) · Openings: 2 open positions · Location: 9300 Tech Center Drive, Sacramento, CA 95826 (Will give candidates a remote grace period to relocate) · Work Scheduled: Hybrid, MUST work 1 day a week on site (Every W ...

  • Ledgent Technology

    Data Quality Engineer

    3 weeks ago

    Ledgent Technology Sacramento, United States

    We are partnered with the leading CoC Agency in Sacramento in the search of a Data Quality Engineer. · The Data Quality Engineer finds and cleanses bad data in databases while working with application developers and business users to help prevent data quality problems. · Type: ...

  • Indium Software

    Senior Data Engineer

    3 weeks ago

    Indium Software Sacramento, United States

    Role: Senior Data Engineer · Experience: 4-8 Years · Work Location: California · Work Mode: Work from Office Required Skills : · Extensive experience providing practical direction within azure native services , implementing data migration and data processing using Azure servi ...