Data Engineer
Share
Job Location:
Chicago, IL - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Details:
Stefanini Group is hiring!
Stefanini is looking for Data Engineer-Hybrid (Various USA Locations)
For quick apply please contact Ayush Dwivedi Ph: /
W2 Only!
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 departments 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 (SDCLC) and Agile methodologies
- Intermediate critical thinking and decision-making abilities
- Strong written and verbal communication skills
- Excellent attention to detail
#LI-AD2
#LI-HYBRID
Details:
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:
- Bachelors Degree and 7 years of related work experience OR
- Masters degree and 5 years of related work experience
- Related certification active participation in an industry organization or advanced degree required
Knowledge & Skills
- Business Operations / Business Acumen
- Project Management
- Data analysis tools (i.e. SQL SQL Server Tableau ACL PowerBI)
- Data visualization and modeling
- Microsoft Office 365 application (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 Judgement
- Relationship building
- Embraces changes and innovation
Stefanini takes pride in hiring top talent and developing relationships with our future employees. Our talent acquisition teams will never make an offer of employment without having a phone conversation with you. Those face-to-face conversations will involve a description of the job for which you have applied. We also speak with you about the process including interviews and job offers.
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. We are CMM Level 5 company
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
