Below are the details for the direct hire role I mentioned earlier. The max salary is 130k. This is remote but candidates are required to fly out to Troy, MI for meetings a couple times a month at their expense if not able to relocate to Troy, MI. Data Engineer End Client: Motor Information Systems Sponsorship offered MOTOR Information Systems, an owned subsidiary of Hearst, is actively seeking a Data Engineer who possesses a strong passion for designing, optimizing, refactoring, and upgrading complex data solutions. MOTOR's Insights team is a new team with an exponential growth opportunity - both in terms of technology and personnel, and we are looking for someone to share our mission that will transform our company's future. With this position, you will have a rare opportunity to use your talents, passions, and expertise to help drive this massive change in how we build, organize, and optimize our backend systems and processes across all MOTOR Insights product line. This position offers excellent career growth and promotional opportunities, stellar compensation, and an opportunity to work with the world's premier provider of aftermarket automotive data. Hearst and MOTOR Information Systems could very well be your best and last position in a rewarding and fulfilling career! Required Experience (must have) <ul> <li>Minimum 5+ years' data engineering experience working with designing data models in both column store and relational databases, incorporating disparate data to solve complex business needs.</li> <li>Minimum Bachelor's degree or Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field. </li> <li>Experience building and optimizing data pipelines, architectures, database modeling and data sets that meet business requirements. </li> <li>Experience in building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources in 'big data' technologies or similar. Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores.</li> <li>Experience in building processes supporting data transformation, analytics tools, data structures, metadata, dependency, and workload management. Assist Data Science team that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and optimizing our product into an innovative industry leader.</li> <li>Experience in using Azure DevOps, or Jira project management/requirements management.</li> <li>Experience with big data tools: Hadoop, Spark, Kafka, or a related technology.</li> <li>Proficient in programming languages such as SQL, Python, R, Shell Scripting</li> <li>Experience with NoSQL databases, including Postgres and Cassandra is a plus - (Nice to have)</li> <li>Strong working experience with technologies like AWS/Databricks and (minimum 3+ years' experience) working with big data, including expertise designing data models in both column store and relational databases, incorporating disparate data to solve complex business needs - (Nice to have) <ul> <li>AWS lambda functions (Python preferred)</li> <li>AWS databases (Aurora, DynamoDB, or Redshift preferred)</li> <li>AWS storage services (EC2, S3 preferred)</li> <li>Data Lake experience or similar (AWS preferred)</li> </ul> </li> </ul>Primary Responsibilities<ul> <li>Developing and implementing an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, database development, implementation and management of data warehouses and data analytics systems.</li> <li>Identifying data sources, both internal and external and work out a plan for data management that is aligned with organizational data strategy.</li> <li>Coordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data system. </li> <li>Managing end-to-end data architecture, from selecting the platform, designing the technical architecture, and developing the application to finally testing and implementing the proposed solution.</li> <li>Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.</li> <li>Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition.</li> </ul> Being MOTOR Driven is Being Diversity Driven We are MOTOR driven. At MOTOR, we are driven by diversity and creating an inclusive and welcoming workplace that celebrates our differences. Being MOTOR driven is celebrating your uniqueness. #MOTORDriven

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,000 of the industry’s brightest talent drive our efforts to deliver purposeful work and meaningful impact every day. Learn more about what makes us different and how you can thrive as a Senior Data Engineer at MMA National.
Marsh McLennan Agency (MMA) provides business insurance, employee health & benefits, retirement, and private client insurance solutions to organizations and individuals seeking limitless possibilities. With 180 offices across North America, we combine the personalized service model of a local consultant with the global resources of the world’s leading professional services firm, Marsh McLennan (NYSE: MMC).
A day in the life.
As a Senior Data Engineer on the MMA National IT Data and Analytics Team, we will count on you to develop and maintain scalable data pipelines, enhance data models, and provide subject matter expertise in data acquisition and consumption pipelines on Azure, Databricks and Confluent.  It involves developing best practices, reusable code, libraries, and frameworks for cloud-based data warehousing and ETL, and uses multi-cloud, programming languages like Java, Scala, Python, RDBMS, NoSQL databases, and design enterprise data warehouse platforms.
By fostering collaboration and aligning with business objectives, you will have the opportunity to elevate data models, drive data-driven decision-making, and enhance data accessibility throughout the organization.  Join us in championing data-driven decision-making and becoming an essential contributor to our data-driven success.
Our future colleague.
We’d love to meet you if your professional track record includes these skills:
7+ years of hands-on experience designing and implementing data engineering solutions using Azure cloud offerings including Data Factory, Azure Synapse, ADLS, and Azure Functions and Logic Apps.

In-depth understanding and experience in data engineering and data warehousing best practices, data modelling, data security and governance principles throughout data lifecycle.

Hands-on development experience with Relational DBs (MS SQL Server, PostgreSQL, Oracle), as well as complex stored procedures and functions using SQL and optimization of SSIS packages and Redshift database queries.

Experience designing and building data pipelines using APIs, BigQuery and Streaming ingestion methods. Proficiency in Spark, Python and ability work with telemetry using Azure monitor, App insights.

Solid understanding of DevSecOps, Git integration, Code deployment using CI/CD pipelines, managing work in an agile environment using Azure Boards, Confluence. Ability to troubleshoot and deploy using Redgate tools and Visual Studio is a must.

These additional qualifications are a plus, but not required to apply:
Familiarity with Modern Data Platforms technologies like Snowflake, Matillion, Bryte Flow, and Tableau is a plus.

Knowledge in Azure IoT, Azure HDInsight + Spark, Kafka and Azure Stream Analytics is a bonus.

Experience with Informatica - IICS task flows development and maintenance.

Data bricks, Microsoft Azure Data Engineer, and/or other cloud certifications.

We know there are excellent candidates who might not check all of these boxes. Don’t be shy. If you’re close, we’d be very interested in meeting you.
Valuable benefits.
We value and respect the impact our colleagues make every day both inside and outside our organization. We’ve built a culture that promotes colleague well-being through robust benefit programs and resources, encourages professional and personal development, and celebrates opportunities to pursue the projects and causes that give colleagues fulfilment outside of work.
Some benefits included in this role are:
Generous time off, including personal and volunteering

Tuition reimbursement and professional development opportunities

Remote work

Charitable contribution match programs

Stock purchase opportunities

To learn more about a career at MMA National, check us out online: http://marshmma.com/careers or flip through our recruiting brochure: https://bit.ly/3Qpcjmw
Follow us on social media to meet our colleagues and see what makes us tick:
https://www.instagram.com/lifeatmma/

https://www.facebook.com/LifeatMMA

https://twitter.com/marsh_mma

https://www.linkedin.com/company/marsh-mclennan-agency/

The applicable base salary range for this role is $101,300-$151,900. The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.
We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other wellbeing programs as well as employee assistance programs.
Applications will be accepted until: 1/1/2025
Who  you  are is who  we  are.
We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. We are always seeking those with ethics, talent, and ambition who are interested in joining our client-focused teams.
Marsh McLennan and its affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.
#LI-Remote

The applicable base salary range for this role is $93,600 to $163,800.
The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs.

Applications will be accepted until: December 2, 2025

HTC Global Services wants you. Come build new things with us and advance your career. At HTC Global you'll collaborate with experts.You'll join successful teams contributing to our clients' success.You'll work side by side with our clients and have long-term opportunities to advance your career with the latest emerging technologies. At HTC Global Services our consultants have access to a comprehensive benefits package. Benefits can include Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short & Long Term Disability Insurance, and a variety of other perks. Data Engineer III Job Responsibilities: <ul> <li>Ability to work in a team environment that promotes collaboration.</li> <li>Degree in Computer Science, Engineering, Mathematics, or a related field and 5+ years industry experience.</li> <li>Must have three year of experience in the following skill(s): Developing and operating large-scale data structures for business intelligence using: ETL/ELT processes; OLAP technologies; data modeling; SQL;Python.</li> <li>Experience with at least one relational database technology such as Redshift, Oracle, MySQL or MS SQL.</li> <li>Experience with at least one massively parallel processing data technology such as Redshift, Teradata, Netezza, Spark or Hadoop based big data solution.</li> <li>Coding proficiency in at least one modern programming language (Python, Ruby, Java, etc).</li> <li>Industry experience as a or related specialty (e.g., Software Engineer, Business Intelligence Engineer Data Engineer, Data Scientist) with a track record of manipulating, processing, and extracting value from large datasets.</li> <li>Coding proficiency in at least one modern programming language (Python, Ruby, Java, etc).</li> <li>Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets.</li> <li>Experience building data products incrementally and integrating and managing datasets from multiple sources Query performance tuning skills using Unix profiling tools and SQL.</li> <li>Experience building large-scale data warehouse projects, including using AWS technologies - Redshift, S3, EC2, Data-pipeline and other big data technologies.</li> <li>Proven ability to drive adoption of data engineering best practices in a team of engineers, and ability to mentor junior team members Linux/UNIX including to process large data sets.</li> <li>Experience with AWS Ability to work on a diverse team or with a diverse range of coworkers.</li> <li>Typical Years of Experience: 7+ years.</li> </ul>

HTC Global Services wants you. Come build new things with us and advance your career. At HTC Global you'll collaborate with experts. You'll join successful teams contributing to our clients' success. You'll work side by side with our clients and have long-term opportunities to advance your career with the latest emerging technologies.

At HTC Global Services our consultants have access to a comprehensive benefits package. Benefits can include Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short & Long Term Disability Insurance, and a variety of other perks.

Data Engineer III

Job Responsibilities:

Ability to work in a team environment that promotes collaboration.
Degree in Computer Science, Engineering, Mathematics, or a related field and 5+ years industry experience.
Must have three year of experience in the following skill(s): Developing and operating large-scale data structures for business intelligence using: ETL/ELT processes; OLAP technologies; data modeling; SQL;Python.
Experience with at least one relational database technology such as Redshift, Oracle, MySQL or MS SQL.
Experience with at least one massively parallel processing data technology such as Redshift, Teradata, Netezza, Spark or Hadoop based big data solution.
Coding proficiency in at least one modern programming language (Python, Ruby, Java, etc).
Industry experience as a or related specialty (e.g., Software Engineer, Business Intelligence Engineer Data Engineer, Data Scientist) with a track record of manipulating, processing, and extracting value from large datasets.
Coding proficiency in at least one modern programming language (Python, Ruby, Java, etc).
Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets.
Experience building data products incrementally and integrating and managing datasets from multiple sources Query performance tuning skills using Unix profiling tools and SQL.
Experience building large-scale data warehouse projects, including using AWS technologies - Redshift, S3, EC2, Data-pipeline and other big data technologies.
Proven ability to drive adoption of data engineering best practices in a team of engineers, and ability to mentor junior team members Linux/UNIX including to process large data sets.
Experience with AWS Ability to work on a diverse team or with a diverse range of coworkers.
Typical Years of Experience: 7+ years.

Data Engineer Jobs in Troy, MI

Data Engineer
December 19, 2024

Senior Data Engineer
December 10, 2024

Data Engineer Iii
December 6, 2024

Data Engineer Iii
December 5, 2024

Ai Data Engineer
November 24, 2024

Quick filters

Top companies

Data Engineer Jobs in Troy, MI

Data EngineerDecember 19, 2024

Senior Data EngineerDecember 10, 2024

Data Engineer IiiDecember 6, 2024

Data Engineer IiiDecember 5, 2024

Ai Data EngineerNovember 24, 2024