Title: Data Engineer with Adobe Clickstream & GCP Experience (only W2 Position – No C2C Accepted) 12.3.2024
Description: STG is a SEI CMMi Level 5 company with several Fortune 500 and State Government clients. STG has an opening forData Engineer with Adobe Clickstream & GCP Experience.
Please note that this project assignment is with our own direct clients. We do not go through any vendors. STG only does business with direct end clients. This is expected to be a long-term position. STG will provide immigration and permanent residency sponsorship assistance to those candidates who need it.
Job Description:
We are seeking an Analytics Engineer to join our team, responsible for fueling our Power BI dashboards with high-quality data. As an Analytics Engineer, you will design, develop, and maintain scalable data pipelines, architect data models, and transform complex data sets to drive business insights. You will work with large datasets from Adobe Analytics, integrating them with other data sources to create a unified view of customer behavior and preferences. Your work will enable our business stakeholders to make data-driven decisions by providing them with accurate, timely, and actionable data. If you have a passion for data modeling, data transformation, and enjoy working with Power BI, Adobe Analytics and GCP we encourage you to apply for this exciting opportunity!
Skills Required:
Client is seeking a Data Engineer to integrate from Adobe clickstream Data and Merge the web data & transactional data with the database.
The ideal candidate should be proficient in data landing and manipulation within the GCP environment, and capable of enabling the BI team to make sense of the data.
Currently, the team uses QlikSense but is transitioning to Power BI
Build and maintain data models that transform raw data into clean, tested, and reusable datasets and make it easier for stakeholders to analysis the data using Power BI dashboards.
Contribute to the development and maintenance of our Qlik and Power BI dashboards ensuring they are powered by accurate and timely data.
Design, develop, and maintain data transformation pipelines on GCP, handling complex business rules and high-volume data from various sources, including Adobe Analytics.
Build and maintain batch and real-time data pipelines using GCP services like Big Query, Dataflow, Cloud Functions, and Pub/Sub to support our digital analytics needs.
Data Analysis Expressions (DAX) Creating DAX calculations and measures to support data analysis.
Develop and optimize ETL processes to ingest, transform, and load data from multiple sources into our data warehouse, ensuring data quality and consistency.
Collaborate with the analytics team to translate business requirements into actionable data models and pipelines that power reports, dashboards, and other analytical outputs.
Create and maintain comprehensive documentation for all data pipelines, ETL processes, and data models.
Implement and maintain data quality checks and monitoring systems to ensure data accuracy, integrity, and reliability.
Stay up-to-date with the latest technologies and best practices in data engineering, particularly within the GCP ecosystem.
5+ years of experience in analytics engineering, with a proven track record of building data models, data transformation and maintaining data pipelines
Extensive experience with GCP services, including BigQuery, Dataflow, Cloud Storage, Cloud Functions, Pub/Sub, and Data Fusion.
Strong experience with Adobe Analytics data structures and APIs, including data extraction and processing.
Advanced SQL skills Major share of an analytics engineer’s duties will be creating logic for data transformations, writing lots of queries, and building data models, being an expert in SQL is a must.
Data Visualization tools experience with data visualization tools like Qlik Sense and Power BI, is a must.
Strong understanding of data warehousing concepts and best practices.
Excellent problem-solving, analytical, and communication skills.
Ability to work independently and as part of a team in a fast-paced environment.
Experience with digital analytics data (Adobe clickstream, transaction, and OMS data)
Prior background in ecommerce analytics applications
Familiarity with agile development methodologies.
Data Engineer with Adobe Clickstream & GCP Experience is based in Dearborn, MI. A great opportunity to experience the corporate environment leading personal career growth.
Resume Submittal Instructions: Interested/qualified candidates should email their word formatted resumes to Vasavi Konda – vasavi.konda(.@)stgit.com and/or contact @(Two-Four-Eight) Seven- One-Two – Six-Seven-Two-Five (@248.712.6725). In the subject line of the email please include: First and Last Name: Data Engineer with Adobe Clickstream & GCP Experience.
For more information about STG, please visit us at www.stgit.com.
Sincerely,
Vasavi Konda| Recruiting Specialist
“Opportunities don't happen, you create them.”
Systems Technology Group (STG)
3001 W. Big Beaver Road, Suite 500
Troy, Michigan 48084
Phone: @(Two-Four-Eight) Seven- One-Two – Six-Seven-Two-Five: @248.712.6725(O)
Email: vasavi.konda(.@)stgit.com