Talent.com
Principal Cyber Security Engineer

Principal Cyber Security Engineer

Ally500 Woodward Avenue, MI, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.job_card.part_time
job_description.job_card.job_description

The Opportunity

At Ally, you get a startup feel, but experience the benefits of a company that has worked out the kinks and is fulfilling its purpose. We are always evolving and see that as a good thing. From owning our work to seeing its impact in the real world, our team is relentless in finding new ways technology can help make experiences better and help people. We are problem solvers, we value diverse thinking, we support one another, and we challenge ourselves to think bigger in the journey to deliver customer-obsessed tech solutions. To read more about what our tech team does, be sure to visit our tech blog at Ally.Tech.

We are looking for a highly skilled and enthusiastic SQL and Power BI lead to support our Cybersecurity Technology & Risk Automation initiatives. This role is ideal for a lead with 5-7 years of experience in data engineering, visualization, and analytics, who is eager to grow their skills while contributing to a critical area of IPRM Risk Management. You will collaborate with senior developers, cybersecurity analysts, and risk managers to design, build, and maintain risk data warehouse and testing analytics solutions.

At this time, Ally will not sponsor a new applicant for employment authorization for this position.

The Work Itself

The Work Itself

  • Assist in designing and developing complex data models and ETL pipelines in Postgres / Snowflake and Power BI to support cybersecurity reporting and Technology Risk Management needs.
  • Write, test, and optimize SQL and DAX queries for data extraction, transformation, and visualization.
  • Support the creation and maintenance of automated testing routines using SQL and reporting using Power BI.
  • Collaborate with cybersecurity and risk teams to gather and clarify data requirements, ensuring alignment with business objectives.
  • Troubleshoot and resolve issues in data workflows and Power BI reports, ensuring data accuracy and performance.
  • Maintain comprehensive documentation for data solutions and processes.
  • Stay updated on emerging technologies and best practices in Postgres, Snowflake, Power BI, and data engineering.

The Skills You Bring

The Skills You Bring

  • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent work experience.
  • At least 5 years of hands-on experience with SQL, Python, relational databases, and data visualization tools like Power BI or Tableau.
  • Good understanding of Databases (Snowflake, Postgres etc), including database design and query optimization, and Power BI features like DAX and Power Query.
  • Demonstrable experience in integrating Power BI with SQL data sources and other data platforms.
  • Strong analytical and problem-solving skills with a keen attention to detail.
  • Excellent communication and teamwork skills, with a demonstrated ability to mentor and guide junior team members.
  • Preferred Skills :
  • Exposure to cybersecurity concepts, risk management, or related metrics is a plus.
  • Knowledge of cloud platforms like Snowflake, AWS, or Azure, particularly in relation to data services.
  • Experience with Python or similar programming languages for data automation.
  • Familiarity with advanced Power BI features such as Row-Level Security and Power BI Embedded.

    • LI-Hybrid

    How We'll Have Your Back

    Ally's compensation program offers market-competitive base pay and pay-for-performance incentives (bonuses) based on achieving personal and company goals. Our Total Rewards program includes industry-leading compensation and benefits plus additional incentives that are designed to meet your needs and those of your family so you can get the most out of your career and your life, including :

  • Time Away :  Program starts at 20 paid time off days in addition to 11 paid holidays and 8 hours of volunteer time off yearly (time off days are prorated based on start date and program varies based on full or part-time status and management level).
  • Planning for the Future :  plan for the near and long term with an industry-leading 401K retirement savings plan with matching and company contributions, student loan pay downs and 529 educational save up assistance programs, tuition reimbursement, employee stock purchase plan, and financial learning center and financial coach access.
  • Supporting your Health & Well-being :  flexible health and insurance options including medical, dental and vision, employee, spouse and child life insurance, short- and long-term disability, pre-tax Health Savings Account with employer contributions, Healthcare FSA, critical illness, accident & hospital indemnity insurance, and a total well-being program that helps you and your family stay on track physically, socially, emotionally, and financially.
  • Building a Family :  adoption, surrogacy and fertility assistance as well as paid parental and caregiver leave, Dependent Day Care FSA back-up child and adult / elder care days and childcare discounts.
  • Work-Life Integration :  other benefits including Mentally Fit Employee Assistance Program, subsidized and discounted Weight Watchers® program and other employee discount programs.
  • Other compensations :  depending on the role for which you are considered, you may be eligible for travel allowances, relocation assistance, a signing bonus and / or equity.
    • serp_jobs.job_alerts.create_a_job

    Cyber Security Engineer • 500 Woodward Avenue, MI, United States