- Translate business needs into ETL and report requirements, as well as provide expert advice and education in the usage and interpretation of data.
- Ability to diagram complex technical processes and translate abstract problems into discrete technology actions.
- Design and implement data pipelines with DBT, Python, and GitHub using software and data engineering best practices to ensure that data is accurate, reliable, and timely.
- Enhance development and implementation environments by implementing new and custom DBT libraries, and writing/modifying Python and shell scripts.
- Monitor daily job execution and fix issues as they arise to ensure SLAs are met with internal stakeholders.
- Enhance data warehouse design using data modeling best practices and identify gaps in our data collection capabilities.
- Collaborate with product and engineering, governance, and security on requirements for data capture, retention, and security.
- Develop reports and dashboards using to answer key business questions clearly, accurately, and with minimal latency.
- Work with Cloud Engineering to configure docker images.
- Coordinate with Data Platform Engineering team, Enterprise Data Analyst Team, Data Governance Team, and IT Teams to align with change management processes and to ensure performance, processes and access is optimal for our reporting solutions.
- Bachelors degree in Engineering, Computer Science, Math or a related technical field required.
- A minimum of 7 years experience in data engineering and analytics, with a focus on ETL development, data modeling, and data analysis.
- Expertise in SQL and ETL optimization techniques, especially within cloud-based data warehouses like Snowflake, BigQuery, and Redshift, as well as use of command line and version control software (git).
- Experience with cloud-based data storage solutions such as AWS S3, Azure Blob Storage, or Google Cloud Storage.
- Proficiency in Python including the Pandas and Numpy libraries.
- Ability to leverage tools, business intuition, and attention to detail for data validation and QA.
- Excellent communication skills, particularly when explaining technical or complex matters to less technical co-workers.
- A high degree of motivation to be proactive and go above and beyond the task at hand.
- Understanding of major marketing channels, such as TV, direct mail, social media, search.
- Familiarity with data schemas and logging of common marketing platforms, such as Salesforce, Adobe Campaign, and Google Analytics.
- Experience mentoring and guiding junior data engineers and analysts.
- A collaborative, energetic work environment where you can put your passion for people to work
- Medical, Dental, Vision, Life and Disability coverage available day one
- Pension Plan
- Performance-based incentive plan
- 401k available with a Company match
- Holidays and Paid Time Off
- AAA Basic Membership
-
Analytics Platform Engineer
3 days ago
Apex Systems Dearborn, United StatesJob#: · Job Description: · Position Description: · This position is part of the Descriptive Analytics team. It is an Engineering and Operations position for our strategic visualization platforms in on-premises, Software-as-a-Service (SaaS), and Google Cloud instances. Our analyt ...
-
Associate Data Engineer, Advanced Analytics
3 days ago
Amerisure Mutual Insurance Company Farmington, United StatesAmerisure creates exceptional value for its partners, policyholders and employees. As a property and casualty insurance company, Amerisure's promise to our partner agencies and policyholders begins with a comprehensive line of insurance products designed to protect businesses, as ...
-
Data Analytics Engineer
1 week ago
Hyundai America Technical Center, Inc. (HATCI) Ypsilanti, United StatesJob Description · Job DescriptionHyundai America Technical Center, Inc. (HATCI) is currently looking for a Virtual Development Engineer at our Superior Township, Michigan facility: · The Vehicle Control Software department in Hyundai America Technical Center, Inc. (HATCI) is a re ...
-
Analytics Engineer I
3 days ago
Blue Cross Blue Shield of Michigan Detroit, United StatesTITLE: Analytics Engineer I · * · Duties: Design, develop, document and test advanced data systems that supports building of artificial intelligence/machine learning models. Identify, integrate, and cleanse data source information for processing. Document and communicate opport ...
-
Lead Data Analytics Engineer
3 days ago
ICONMA Southfield, United StatesLead Data Analytics Engineer · Location: Southfield, MI · Duration: 14 months · Description: · Dept: SHS Clinical Analysis · Engagement Description: · Responsible for leading complex projects and independently executing analyses that support the healthcare value portfolio. ...
-
Senior Tester
3 weeks ago
Orion Innovations Garden, MI, United States FreelanceGarden, MI based e\*star is a leading provider of trading solutions for the European energy markets, with over 15 years of experience in the field. As the European energy sector undergoes a significant transformation due to the energy transition and digitalization, e\*star is at ...
-
Data Analytics Software Engineer
1 week ago
Insight Global Detroit, United StatesInsight Global is looking for a Data Analytics Software Engineer for a large automotive client based in Metro Detroit, MI. This role demands a candidate adept in crafting complex analytic solutions, utilizing Python and PySpark within an Agile framework. Essential to this positio ...
-
Data Engineer Data Analytics
2 weeks ago
Stefanini Dearborn, MI, United StatesStefanini is looking for a Data Engineer, Location: We're seeking a Data Engineer who has experience building data products on a cloud analytics platform. You will work on ingesting, transforming, and analyzing large datasets to support the Enterprise in the Data Factory on Googl ...
-
Senior NVH Analytical Engineer
2 weeks ago
American Axle & Manufacturing Rochester, United StatesUse computer-aided engineering (CAE) tools, including finite element analysis (FEA), Boundary Element (BE), Multiple Body Dynamics (MBD) and any other analytical tools to performance up-front design optimization for NVH, evaluate product NVH performa Analytical, Engineer, Senior, ...
-
Data Engineer – Web Analytics
1 day ago
Rock Family of Companies Detroit, United States Paid WorkThe Rock Family of Companies is made up of nearly 100 separate businesses spanning fintech, sports, entertainment, real estate, startups and more. We're united by our culture – a drive to find a better way that fuels our commitment to our clients, our community and our team membe ...
-
HARMAN International Novi, United States Full timeA Career at HARMAN · As a technology leader that is rapidly on the move, HARMAN is filled with people who are focused on making life better. Innovation, inclusivity and teamwork are a part of our DNA. When you add that to the challenges we take on and solve together, you'll disc ...
-
Manager of Patient Services
6 days ago
Shields Health Solutions Farmington, United StatesAt Shields, we pride ourselves on our culture of inclusion and kindness and the difference we make in patients' lives every day. We are tremendously proud to be certified as a 'Great Place to Work' four years in a row. In 2022, we were awarded US Fortune Best Workplaces in Health ...
-
Matech Detroit, United StatesManager, Integrated Data Analytics – Data Engineering · Job Summary · The Manager, Integrated Data Analytics provides leadership, analysis and design related to the development of data solutions in support or independent of other BI solutions. They collaborate with the agile pro ...
-
Department Manager of Purchasing
2 weeks ago
Stellar Enterprises Farmington, United StatesJoin our team as a part of Farmington · About us · Welcome to KMW - a pioneer in modern energy supply. Our mission is to shape the future of energy generation by utilizing innovative technologies and sustainable solutions. At KMW, we not only focus on energy production, but also ...
-
Value Stream Buyer
14 hours ago
Trumpf Farmington, United StatesHow brave are you? We are a high-tech company providing machine tools and laser technology, and are looking for people who can face new challenges with a fresh mind. As an independent family company, we offer you the freedom and trust to put your brave ideas into practice. With y ...
-
Dual Study Electrical Engineering
2 weeks ago
Velocity Enterprises Northville, United StatesResponsibilitiesThe program provides important foundations in electrical engineering, electronics, and programming. You can specialize in the field of automation technology and apply and complement your acquired knowledge with us in the development and production of frequency con ...
-
Tech Tammina LLC Warren, United StatesJob Description · Job DescriptionRole: Data Analyst - Data Engineer for Digital Operations with Advanced Analytics · Location: Warren, MI (Hybrid, 3 days onsite, 2 days remote) · Need Locals · Duration: Long term · Rate: Market · Top must-have hard skills: · SQL expertise is ess ...
-
Chemist
2 days ago
Actalent Wixom, United States Full timeDescription: · This is a first shift opportunity, 8am - 5pm M-F. · This position is broken down into two main responsibilities. 80% of the day is spent working on the day to day experiments (scale ups from production batches), and the other 20% will be working on long-term proje ...
-
Chemist
1 day ago
Actalent Wixom, United States Full timeDescription: · This is a first shift opportunity, 8am - 5pm M-F. · This position is broken down into two main responsibilities. 80% of the day is spent working on the day to day experiments (scale ups from production batches), and the other 20% will be working on long-term proje ...
-
Data Catalog and Business Metadata Advisor
2 weeks ago
Trinity Technology Solutions Bloomfield, United States**About us** · We are professional and agile. · Our work environment includes: · - Modern office setting · - Food provided · **Job Title: Data Catalog and Business Metadata AdvisorLocation: Connecticut Duration: Contract Job Description**: · - 4+ years of experience cataloging da ...
Senior Analytics Engineer - Livonia, United States - AAA Life Insurance Company
Description
Overview:
AAA Life Insurance Company is looking for a Senior Analytics Engineer to build and maintain data infrastructure essential to AAA Lifes business intelligence, data governance and operational reporting efforts. You will support data processes from end-to-end, including data ingestion, transformation, and visualization, and design data architecture to facilitate analysis and ensure best-in-class operational reliability and modularity.
The ideal candidate will have experience with Data Build Tool (DBT) and other data analytics tools, as well as a strong background in data engineering and data modeling. This individual will be responsible for designing, developing, and maintaining data pipelines and analytical data models, as well as supporting and optimizing our data infrastructure. The Senior Analytics Engineer will be expected to provide leadership and/or mentorship for junior staff.
Responsibilities:WHAT WE OFFER:
For the states of California, Colorado, New York and Washington the pay scale is $115,218 to $172,826 and pay scales may vary based upon location.