Data Engineer – ETL, Informatica, SQL, PL/SQL, RDBMS, Data Warehousing
Location
Illinois
Posted
3 days ago
Salary
$86.3K - $143.8K / year
Seniority
Senior
Job Description
Data Engineer – ETL, Informatica, SQL, PL/SQL, RDBMS, Data Warehousing
PNC
• Develops, supports and implements data services for multiple applications to meet business objectives and user requirements • Uses technical knowledge and industry experience to design, build and maintain technology solutions • Works closely with users, developers, operations and business partners to define data service requirements and the data preparation process development • Designs and builds data service infrastructure on multiple data platforms, according to key business processes and the overall workflow • Develops and implements data solutions for multiple applications to ensure its scalability, availability and maintainability • Implements data migration and transformation activities/processes to ensure the accuracy and security of data solutions
Job Requirements
- Strong experience in data engineering and ETL development
- Strong experience with Informatica (PowerCenter and/or Informatica Cloud/IICS)
- Advanced SQL, PL/SQL skills and experience with large-scale data transformations
- Experience with data warehousing platforms (e.g. SQL Server, Oracle, Teradata)
- Writing and optimizing code for data pipelines to ensure systems are highly efficient, scalable, and capable of handling large-scale financial datasets
- Proficient with code deployment tools such as Udeploy, Artifactory
- Experience with cloud data platforms (Azure, AWS, or GCP)
- Knowledge of financial and cost data, preferably Activity Based Costing
- Experience with data quality, reconciliation, and performance optimization
- Proactive and detail-oriented professional with strong sense of ownership
- Creative problem solver who can tackle complex data challenges
- Mentor who can guide junior engineers and contributes to team growth
- Familiarity with Agile/Scrum development environments
- Excellent problem-solving and collaboration skills
- Excellent communication skills, with the ability to present insights to both technical and non-technical audiences
- Strong ownership mindset and accountability for deliverables end to end
- Demonstrated ability to influence stakeholders and recommend data-driven solutions
- Collaborative team player who can also work independently with minimal oversight
Benefits
- medical/prescription drug coverage (with a Health Savings Account feature)
- dental and vision options
- employee and spouse/child life insurance
- short and long-term disability protection
- 401(k) with PNC match
- pension and stock purchase plans
- dependent care reimbursement account
- back-up child/elder care
- adoption, surrogacy, and doula reimbursement
- educational assistance, including select programs fully paid
- a robust wellness program with financial incentives
- maternity and/or parental leave
- up to 11 paid holidays each year
- 9 occasional absence days each year, unless otherwise required by law
- between 15 to 25 vacation days each year, depending on career level; and years of service
Related Guides
Related Categories
Related Job Pages
More Analytics Engineer Jobs
Senior Power Systems Engineer – Modeling & Analytics
ICFICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy.
• Lead a small team in power systems modeling and analytics for utility clients • Mentor and train less experienced engineers in power engineering theories and principles • Manage project tasks such as forecasting, tracking hours, budgeting, milestones, scheduling meetings, delegating tasks • Interact with clients to demonstrate expertise and attract new business • Create and maintain transmission short circuit and power flow models in programs like CAPE, ASPEN, PSSE, and PSCAD • Perform analyses such as Arc Flash, voltage imbalance, and thermal ampacity ratings • Write thorough technical reports summarizing findings • Develop automation scripts to improve task efficiency and accuracy using languages such as Python, SQL, and VBA
• Develop and maintain analytical models, dashboards, and data products • Partner closely with application development, data engineering, and business teams • Deliver scalable, well-governed analytics solutions • Design and develop Power BI reports, dashboards, and semantic data models • Build and maintain statistical models and forecasting tools • Ensure data accuracy and integrity across reporting outputs • Stay current with emerging trends in data science, analytics engineering, and business intelligence tooling.
Senior SQL Application Developer, SQL, Crystal Reports, ETL
MicroHealthPutting the “Health” in Healthcare IT
• Administer Microsoft SQL Server databases in both Windows and Linux environments supporting NPIRS production and development systems • Monitor SQL Server health, performance, storage utilization, and database availability across multiple platforms • Perform routine server monitoring and daily operational health checks • Develop, schedule, monitor, and troubleshoot SQL Server Agent jobs, automated database processes, alerts, Database Mail notifications, and scheduled operational workflows • Execute scheduled SQL Server maintenance activities, including weekly server patching and maintenance windows • Troubleshoot SQL Server performance issues, database connectivity problems, and production incidents • Maintain database security, permissions, access controls, and ensure compliance with organizational standards • Support disaster recovery readiness, high availability solutions, and coordinate infrastructure upgrades • Manage Linux-based database systems including shell scripting and system administration • Design, develop, test, and maintain complex SQL queries, stored procedures, views, functions, and reusable database components • Develop and optimize advanced SQL solutions utilizing Microsoft SQL Server and IBM DB2 healthcare data sources • Develop cross-platform SQL solutions integrating SQL Server reporting environments with DB2 databases • Translate complex healthcare reporting requirements and legacy report logic into validated SQL business rules, including exception handling, reconciliation, and data-quality controls • Optimize SQL code for performance and scalability across multiple database platforms • Create validation scripts and resolve database-related defects • Implement data models and database structures according to best practices • Design, develop, modify, validate, and maintain SQL Server Reporting Services (SSRS) reports • Lead modernization efforts by converting SAP Crystal Reports to SSRS while maintaining functionality • Translate legacy Crystal Reports business logic into validated SSRS solutions while preserving business rules and report functionality • Interpret healthcare reporting requirements and convert them into validated SQL datasets, report parameters, reconciliation logic, exception processing, and data-quality controls • Develop and maintain standardized reporting templates • Perform report validation, peer reviews, and maintain SDLC documentation • Develop, maintain, troubleshoot, and optimize SSIS packages supporting enterprise reporting and healthcare data integration • Support automated processing, scheduled data loads, ETL workflows, and validation • Support data integration initiatives across multiple systems and platforms • Perform database migrations and conversions between platforms with minimal downtime • Migrate databases and reports between different environments • Support cloud database platform initiatives • Ensure data integrity throughout migration processes • Provide production support for NPIRS operational systems • Monitor production database jobs, reporting services, SQL Server Agent jobs, and automated workflows • Perform proactive morning operational monitoring and respond to infrastructure incidents • Support production deployments, server patching, and operational documentation • Collaborate with cross-functional teams to implement technical solutions
Senior Analytics Engineer
Stellus RxTrusted, pharmacist-led health support in every moment that matters.
• Data Quality & Preparation • Data Modeling & Transformation • BI & Reporting Delivery • Integration & Pipeline Ownership • Documentation & Data Governance • AI Tooling Adoption • Stakeholder Enablement & Training • Analytics Project Leadership
