Stefanini Group
Join to apply for the
Data Engineer
role at
Stefanini Group
For quick apply, please contact Ayush Dwivedi Ph: 248 728 2636 / Ayush.dwivedi@stefanini.com. W2 Only!
Stefanini Group is hiring!
Data Engineer - Hybrid (Various USA Locations)
Job Profile Summary The Data Engineer designs and develops data pipelines (data ingestion and extract, transform, load processes) that are scalable, repeatable, and secure for stakeholder needs. Plays a key role in the department's data analytics by designing and implementing processes to inspect clean, transform, and model data to discover useful information, inform conclusions, and support decision making. This position is considered intermediate level and performs work of moderate complexity. The incumbent works under general supervision and may take direction from a more senior team member. This job does not have any direct reports.
Principal Duties And Responsibilities
Creates data management strategies to support business intelligence efforts for various stakeholders.
Builds out data architecture to support data strategy.
Performs the design of logical data model and implements the physical database structure.
Ensures the quality, security, and reliability of data and analytics systems and software across the organization is being followed and troubleshoots any issues that may arise.
Constructs and implements operational data stores and data marts.
Provides support for deployed data applications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution.
Creates real-time and batch enable, transform, load (ETL) data processes aligned with business needs.
Supports optimization of data pipelines by reducing complexity, improving readability and increasing performance.
Builds technical requirements relative to their respective domain and applicable applications, solutions, and/or systems.
Augments data pipelines from raw Online Transaction Processing (OLTP) databases to data solution structures.
Performs design reviews regarding code, tables, and databases regarding the overall architecture of the data warehouse.
Documents data flow diagrams, security access, data quality and data availability across all business systems.
Develops and maintains a query library to support recurring data requests.
Knowledge And Skills
Considered an expert in the data analytics discipline and applies that knowledge through work products.
Responsible for more complex activities associated with data analytics and may assist less experienced staff.
Leads the development and refinement of analysis, reports, and dashboards of key department performance and risk indicators.
Leads and may assist less experienced staff in visualizing and reporting data findings creatively in a variety of visual formats (i.e. reports, dashboards, etc) that meet business function needs.
Leads and may assist less experienced staff in telling stories with data for both technical and non-technical audiences that meet business function needs.
Leads the research and analysis needed to respond to surveys and requests for information from key stakeholders.
Leads and may assist less experienced staff in translating departmental scenarios and requirements into technical specifications.
Identifies best practices and standards in data analysis and visualization and leads their implementation in the department.
Influences strategy by either managing or facilitating district or System data analytics-related initiatives.
Establishes and maintains effective relationships with business functions and other stakeholders to understand data analysis and visualization needs to ensure data strategies support business goals.
Leads the development of training resources and delivers them to stakeholders.
Leads the development of new processes, standards, and operational plans at the Department-level.
Intermediate knowledge of cloud-based data platforms.
Intermediate understanding of data security and privacy regulations.
Intermediate understanding of software development lifecycle (SDLC) and Agile methodologies.
Intermediate critical thinking and decision-making abilities.
Strong written and verbal communication skills.
Excellent attention to detail.
Top 5 hard skills
Data Analytics (analyzing data sets for insights, including via PowerBI, Tableau, Excel)
Data Engineering (data pipeline development, data set management)
Dashboard development (using PowerBI and Tableau)
Workflow Automation (including use of Microsoft Power Automate)
Business Analysis
Education & Experience
Bachelor's Degree and 7 years of related work experience.
Master's degree and 5 years of related work experience.
Relevant certification, active participation in an industry organization, or advanced degree required.
Knowledge & Skills
Business Operations / Business Acumen
Project Management
Data analysis tools (SQL, SQL Server, Tableau, ACL, PowerBI)
Data visualization and modeling
Microsoft Office 365 applications (Teams, Excel, PowerPoint, Word, etc.)
Intermediate understanding of data warehouse technical architectures and extract, transform, load (ETL) or extract, load, transform (ELT) processes.
Intermediate knowledge and experience with data warehouse design, data modeling, and data processing pipelines.
Knowledge of scripting languages.
Intermediate knowledge and understanding of big data tools and software.
Familiar with Continuous Integration (CI) and Continuous Delivery (CD) tools and pipelines.
Skill Areas - Expert Level
Action Oriented
Collaborates
Communicates Effectively (with influence)
Customer Focus
Ensures Accountability
Values Differences
Drives Results
Manages Complexity
Critical Thinking and Judgment
Relationship building
Embraces changes and innovation
Seniority level Mid-Senior level
Employment type Full-time
Job function Information Technology
Industries Business Consulting and Services
About Stefanini Group The Stefanini Group is a global provider of offshore, onshore and near shore outsourcing, IT digital consulting, systems integration, application, and strategic staffing services to Fortune 1000 enterprises around the world. Our presence is in countries like the Americas, Europe, Africa, and Asia, and more than four hundred clients across a broad spectrum of markets, including financial services, manufacturing, telecommunications, chemical services, technology, public sector, and utilities. Stefanini is a CMM level 5, IT consulting company with a global presence.
#J-18808-Ljbffr
Data Engineer
role at
Stefanini Group
For quick apply, please contact Ayush Dwivedi Ph: 248 728 2636 / Ayush.dwivedi@stefanini.com. W2 Only!
Stefanini Group is hiring!
Data Engineer - Hybrid (Various USA Locations)
Job Profile Summary The Data Engineer designs and develops data pipelines (data ingestion and extract, transform, load processes) that are scalable, repeatable, and secure for stakeholder needs. Plays a key role in the department's data analytics by designing and implementing processes to inspect clean, transform, and model data to discover useful information, inform conclusions, and support decision making. This position is considered intermediate level and performs work of moderate complexity. The incumbent works under general supervision and may take direction from a more senior team member. This job does not have any direct reports.
Principal Duties And Responsibilities
Creates data management strategies to support business intelligence efforts for various stakeholders.
Builds out data architecture to support data strategy.
Performs the design of logical data model and implements the physical database structure.
Ensures the quality, security, and reliability of data and analytics systems and software across the organization is being followed and troubleshoots any issues that may arise.
Constructs and implements operational data stores and data marts.
Provides support for deployed data applications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution.
Creates real-time and batch enable, transform, load (ETL) data processes aligned with business needs.
Supports optimization of data pipelines by reducing complexity, improving readability and increasing performance.
Builds technical requirements relative to their respective domain and applicable applications, solutions, and/or systems.
Augments data pipelines from raw Online Transaction Processing (OLTP) databases to data solution structures.
Performs design reviews regarding code, tables, and databases regarding the overall architecture of the data warehouse.
Documents data flow diagrams, security access, data quality and data availability across all business systems.
Develops and maintains a query library to support recurring data requests.
Knowledge And Skills
Considered an expert in the data analytics discipline and applies that knowledge through work products.
Responsible for more complex activities associated with data analytics and may assist less experienced staff.
Leads the development and refinement of analysis, reports, and dashboards of key department performance and risk indicators.
Leads and may assist less experienced staff in visualizing and reporting data findings creatively in a variety of visual formats (i.e. reports, dashboards, etc) that meet business function needs.
Leads and may assist less experienced staff in telling stories with data for both technical and non-technical audiences that meet business function needs.
Leads the research and analysis needed to respond to surveys and requests for information from key stakeholders.
Leads and may assist less experienced staff in translating departmental scenarios and requirements into technical specifications.
Identifies best practices and standards in data analysis and visualization and leads their implementation in the department.
Influences strategy by either managing or facilitating district or System data analytics-related initiatives.
Establishes and maintains effective relationships with business functions and other stakeholders to understand data analysis and visualization needs to ensure data strategies support business goals.
Leads the development of training resources and delivers them to stakeholders.
Leads the development of new processes, standards, and operational plans at the Department-level.
Intermediate knowledge of cloud-based data platforms.
Intermediate understanding of data security and privacy regulations.
Intermediate understanding of software development lifecycle (SDLC) and Agile methodologies.
Intermediate critical thinking and decision-making abilities.
Strong written and verbal communication skills.
Excellent attention to detail.
Top 5 hard skills
Data Analytics (analyzing data sets for insights, including via PowerBI, Tableau, Excel)
Data Engineering (data pipeline development, data set management)
Dashboard development (using PowerBI and Tableau)
Workflow Automation (including use of Microsoft Power Automate)
Business Analysis
Education & Experience
Bachelor's Degree and 7 years of related work experience.
Master's degree and 5 years of related work experience.
Relevant certification, active participation in an industry organization, or advanced degree required.
Knowledge & Skills
Business Operations / Business Acumen
Project Management
Data analysis tools (SQL, SQL Server, Tableau, ACL, PowerBI)
Data visualization and modeling
Microsoft Office 365 applications (Teams, Excel, PowerPoint, Word, etc.)
Intermediate understanding of data warehouse technical architectures and extract, transform, load (ETL) or extract, load, transform (ELT) processes.
Intermediate knowledge and experience with data warehouse design, data modeling, and data processing pipelines.
Knowledge of scripting languages.
Intermediate knowledge and understanding of big data tools and software.
Familiar with Continuous Integration (CI) and Continuous Delivery (CD) tools and pipelines.
Skill Areas - Expert Level
Action Oriented
Collaborates
Communicates Effectively (with influence)
Customer Focus
Ensures Accountability
Values Differences
Drives Results
Manages Complexity
Critical Thinking and Judgment
Relationship building
Embraces changes and innovation
Seniority level Mid-Senior level
Employment type Full-time
Job function Information Technology
Industries Business Consulting and Services
About Stefanini Group The Stefanini Group is a global provider of offshore, onshore and near shore outsourcing, IT digital consulting, systems integration, application, and strategic staffing services to Fortune 1000 enterprises around the world. Our presence is in countries like the Americas, Europe, Africa, and Asia, and more than four hundred clients across a broad spectrum of markets, including financial services, manufacturing, telecommunications, chemical services, technology, public sector, and utilities. Stefanini is a CMM level 5, IT consulting company with a global presence.
#J-18808-Ljbffr