Data Engineer Business Intelligence and Data Warehousing

by Irma Moore | Jan 9, 2025 | Uncategorized

Fully Remote • Pittsburgh, PA

Description

Quick Med Claims, LLC (QMC) is a leading Revenue Cycle Management (RCM) organization specializing in Emergency Medical Services (EMS). We leverage data to drive business intelligence, optimize decision-making, and enhance performance offering innovative ways for healthcare organizations to optimize their financial and operational processes. Our growing team is seeking an experienced and driven Data Engineer. This lead role is critical in ensuring that our data infrastructure and architecture are robust, scalable, and optimized for near real-time analytics, reporting, and machine learning.

This Position is 100% Remote

Job Purpose/Summary

The Data Engineer will be responsible for architecting and optimizing data systems, ensuring seamless integration between various data sources, and enabling near real-time or batch processing capabilities. You will guide the design and implementation of robust data pipelines that support advanced analytics, reporting, and machine learning initiatives. This position will shape the future of the QMC data infrastructure. The Data Engineer will work closely with cross-functional teams and lead the design and development of data pipelines in a fast-paced, collaborative environment. This role will be pivotal in supporting and optimizing our AWS Redshift data warehouse while contributing to the migration to a more modern Databricks Lakehouse architecture. In addition, the role will involve applying machine learning in Databricks to deliver actionable insights for specific business problems. You will also work closely with our Sisense BI platform and Jaspersoft Reporting platform to support business intelligence and reporting needs.

Essential Duties & Responsibilities

• AWS Redshift & AWS Ecosystem Support: Support and optimize the existing AWS Redshift data warehouse and Hanger ETL pipeline. Leverage the AWS ecosystem including S3, Spectrum, Redshift, Glue, SQL, and Hanger ETL to integrate, transform, and load data.
• Performance Tuning: Implement data optimizations to improve the performance of large datasets, including data partitioning, indexing, and query performance tuning
• Databricks Lakehouse Architecture: Lead the migration from AWS Redshift to Databricks Lakehouse, implementing Delta Lake for data storage and processing. Optimize large-scale data processing pipelines and workflows.
• Data Pipeline Development: Design, develop, and maintain scalable ETL pipelines using Python, Spark, SQL, and Databricks, ensuring data quality, consistency, and timeliness.
• Data Integration: Integrate structured, semi-structured, and unstructured data from various internal and external sources from both on premise and cloud platforms such as AWS.
• ETL Frameworks & Automation: Utilize ETL frameworks and scheduling tools (e.g., Airflow, Databricks Jobs) for automated monitoring, testing, and validation for data quality and pipeline health
• Data Analysis & Mapping: Perform data analysis and data mapping from SQL Server-based RCM transactional systems and other source systems to transform data into business intelligence and reporting formats residing in data warehouse
• Data Modeling: Apply dimensional modeling techniques (e.g., star schemas) to ensure effective data organization and modeling for BI, reporting, and machine learning.
• Slowly Changing Dimensions (SCD): Implement SCD techniques (Types 1, 2, and 3) to ensure accurate tracking and storage of historical data changes, particularly in operational and transactional data.
• Business Intelligence & Reporting: Work with Sisense to develop interactive dashboards and with Jaspersoft Reporting to develop and enhance reports that support operational and strategic decision-making.
• Machine Learning in Databricks: Implement and integrate large language models (LLMs) to solve specific business problems in Databricks, such as improving billing processes, predicting trends, and enhancing operational efficiency.
• DevOps & Infrastructure: Work with DevOps tools such as Kubernetes, Jenkins, Github, Slack, and Terraform to automate deployments and infrastructure management. Support cloud infrastructure monitoring tools like CloudWatch and Databricks Monitoring for performance tracking.
• Data Governance & Security: Ensure data security and compliance with industry regulations, including HIPAA, by adhering to best practices in data governance and privacy standards as well as managing access control and encryption for sensitive data.
• Documentation & Best Practices: Maintain documentation for data models, data workflows, ETL pipelines, machine learning models, system architectures, and design and coding standards. Promote best practices in data engineering, DevOps, and cloud infrastructure management.
• Problem-Solving & Communication: Collaborate with data engineers, data analysts, business analysts, and other stakeholders to ensure data availability for reporting, modeling, and decision-making. Effectively communicate complex technical concepts to non-technical stakeholders. Possess strong problem-solving and analytical skills.
• Leadership: Lead projects to successful completion. Lead, mentor, and provide guidance to junior team members, promoting best practices and code quality.  
• Continuous Improvement: Stay current with emerging technologies, methodologies, and industry trends. Implement new tools and technologies as necessary to improve the data engineering workflow.

Other Responsibilities

• Adhere to all QMC HIPAA privacy policies and procedures. This includes always maintaining the confidentiality and security of sensitive patient information.
• Ensures consistent adherence to company attendance policies.

Requirements

Education

• Education: Bachelor’s degree in Computer Science, Engineering, Mathematics, or a related field.

Experience, Skills and Abilities

• 5+ years of experience in data engineering, with a focus on ETL pipeline design and development, data warehouse design and management, structured and unstructured database management systems, and cloud technologies.
• Experience with AWS Redshift, including integration with S3, Spectrum, Redshift, Lambda, and Glue for data processing and transformation.
• 1+ years of hands-on experience with Databricks Lakehouse, Delta Lake, and Unity Catalog including data lake management, and optimization of storage and processing. 
• Solid proficiency in Python and SQL for developing ETL pipelines, querying relational databases, and transforming data.
• Experience with ETL tools, ETL frameworks, and scheduling tools like Apache Airflow, Databricks Jobs, AWS Glue, Talend, and Informatica.
• Strong background in data modeling, including dimensional modeling (star and snowflake schemas) to support business intelligence and reporting tools.
• Experience implementing Slowly Changing Dimensions (SCD) techniques to manage and track historical data changes.
• Expertise in machine learning integration within Databricks to solve business problems and optimize business processes.
• Familiarity with DevOps practices and tools such Jenkins, Github, Slack, and Terraform. Experience with containerization tools like Docker and Kubernetes for packaging and deploying applications.
• Basic understanding of cloud infrastructure management and monitoring using tools like CloudWatch and Databricks Monitoring.
• Experience working in an Agile development environment, using Jira and Confluence to manage tasks and collaboration according to the Software Development Life Cycle (SDLC).

Preferred Qualifications:

• Experience with Delta Lake in Databricks and data lake best practices for large-scale data storage and management.
• Familiarity with data privacy regulations, especially in healthcare (HIPAA).
• Experience with containerization tools like Docker and Kubernetes for packaging and deploying applications.
• Experience with administration and management of Sisense BI platform.
• Experience with JavaScript and CSS.
• Experience with leading teams and projects.
• Experience in Healthcare or RCM.

Data Engineer 2

by Irma Moore | Jan 9, 2025 | Uncategorized

With a career at The Home Depot, you can be yourself and also be part of something bigger.

Position Purpose:

The Data Engineer II – Data Engineer is responsible for supporting our enterprise data warehouse for our Supply Chain Operations. As a Software Engineer II, you will be part of a dynamic team with engineers of all experience levels who help each other build and grow technical and leadership skills while creating, deploying, and supporting production applications. In addition, Software Engineer IIs may be involved in configuration, security, resilience, performance tuning and production moni
Key Responsibilities:

• 60% Delivery and Execution – Collaborates and pairs with other product team members (UX, engineering, and product management) to create secure, reliable, scalable software solutions; Documents, reviews and ensures that all quality and change control standards are met; Works with Product Team to ensure user stories that are developer-ready, easy to understand, and testable; Writes custom code or scripts to automate infrastructure, monitoring services, and test cases; Writes custom code or scripts to do destructive testing to ensure adequate resiliency in production; Program configuration/modification and setup activities on large projects using HD approved methodology; Configures commercial off the shelf solutions to align with evolving business needs Creates meaningful dashboards, logging, alerting, and responses to ensure that issues are captured and addressed proactively
• 20% Learning – Actively seeks ways to grow and be challenged using both formal and informal development channels; Learns through successful and failed experiment when tackling new problems
• 20% Plans and Aligns – Collaborates with other team members in agile processes; Assists in creating new and better ways for the team to be successful; Relates openly and comfortably with diverse groups of people; Builds partnerships and works collaboratively with others to meet shared objectives

Direct Manager/Direct Reports:

• This position typically repots to Software Engineer Manager or Sr. Manager
• This position has 0 Direct Reports

Travel Requirements:

• No travel required.

Physical Requirements:

• Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.

Working Conditions:

• Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.

Minimum Qualifications:

• Must be eighteen years of age or older.
• Must be legally permitted to work in the United States.

Preferred Qualifications:

• 1-3 years of relevant work experience
• Extensive ETL experience, preferably with a focus on Google Cloud Platform
• Experience working in SQL, with the ability to work with most databases
• Previous experience working with BigQuery as a Data Warehouse service
• Hands-on experience in big data environments
• Experience in cloud computing techniques: Google Kubernetes, Google Cloud Composer, Google Big Query, Google Secret Manager, Google Cloud DNS
• Experience in CI/CD tools
• Experience in version control systems
• Familiarity with Data Science principles and practices Knowledge of Dimensional Modeling using relevant tools
• Experience in Angualar,Javascript /Typescript frameworks, Python, Bash
• Experience in an object-oriented programming language, Java
• Experience in source code version control
• Experience in Relational or noSQL database technology
• Experience in microservice-based architecture
• Experience with modern debugging and root cause analysis techniques
• Exposure to security frameworks for user and services authorization and authentication
• Exposure to creating and executing unit, functional, destructive and performance tests

Minimum Education:

• The knowledge, skills and abilities typically acquired through the completion of a bachelor’s degree program or equivalent degree in a field of study related to the job.

Preferred Education:

• No additional education

Minimum Years of Work Experience:

• 2

Preferred Years of Work Experience:

• No additional years of experience

Minimum Leadership Experience:

• None

Preferred Leadership Experience:

• None

Certifications:

• None

Competencies:

• Global Perspective
• Manages Ambiguity
• Nimble Learning
• Self-Development
• Collaborates
• Cultivates Innovation
• Situational Adaptability
• Communicates Effectively
• Drives Results
• Interpersonal Savvy

For California, Colorado, Connecticut, Rhode Island, Nevada, New York City, Ithaca (NY), Westchester County (NY), and Washington residents:
 The pay range for this position is between $60,000 – $105,000

Temporary Manager – Data, Analytics, and Reporting Audit

by Irma Moore | Jan 9, 2025 | Uncategorized

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM.

Temporary Manager – Data, Analytics, and Reporting Audit

RSM is seeking a skilled temporary manager to join our data group audit team, supporting a large global bank. This role focuses on auditing and validating consent order and issue remediation efforts related to data management systems, analytics platforms, and reporting applications. The position requires strong technical expertise combined with audit proficiency to ensure compliance with regulatory requirements and internal standards.

Key Responsibilities

• Lead audits of data management systems, data processing solutions, and data consumption processes to ensure effectiveness and compliance with policies.
• Review and validate data processing code written in languages such as Python.
• Audit SQL statements used for data transformation, processing, and reporting.
• Assess Database Management Systems (DBMS) and data management processes used by the bank.
• Audit reporting and analytics platforms like Alteryx focus on data creation, cubes, reporting outputs, and ad-hoc analytics.
• Evaluate access controls and data protection measures to safeguard sensitive data.
• Examine data lineage and flow through processing, management, reporting, and analytics systems.
• Provide technical testing of bank-developed controls and validate key processes.

Qualifications

• 7+ years of experience auditing data systems, reporting platforms, and analytics tools in complex financial institutions.
• Advanced technical skills in Python, SQL, and reporting/analytics platforms like Alteryx.
• Proven ability to audit data processing code, DBMS, and workflows for reporting and analytics.
• Exceptional communication and documentation skills, focusing on producing high-quality audit reports in line with bank and regulatory standards.
• Strong experience with consent order and issue validation audits is preferred.
• Subject Matter Expertise (SME) in global banks’ data management and reporting technologies.
• Demonstrated ability to test technical solutions while adhering to rigorous audit methodologies.

This temporary manager-level role provides an opportunity to leverage both technical and audit expertise to support critical data and reporting initiatives at a global financial institution.

At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits.

As an Affirmative Action and Equal Opportunity Employer, all applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the US uniformed service; US Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable federal, state or local law.

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please call us at 800-274-3978 or send us an email at [email protected].

RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying, excluding internships, you may be eligible for hire as an experienced associate.

RSM will consider for employment qualified applicants with arrest or conviction records in accordance with the requirements of applicable law, including but not limited to, the California Fair Chance Act, the Los Angeles Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the San Francisco Fair Chance Ordinance. For additional information regarding RSM’s background check process, including information about job duties that necessitate the use of one or more types of background checks, click here.

At RSM, an employee’s pay at any point in their career is intended to reflect their experiences, performance, and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including, but not limited to, education, skills, work experience, certifications, location, etc. As such, pay for the successful candidate(s) could fall anywhere within the stated range. Compensation Range: $60 – $90 per hour

Security Testing Specialist – Secure Coding Engineer

by Irma Moore | Jan 9, 2025 | Uncategorized

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Security Testing Specialist within PNC’s Technology organization, you may be based in a remote location. This is a remote position. Work may be performed from a quiet, confidential space in a home location, approved by PNC. This position may not be available in all geographic locations.

**PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position**

This position will be required to be in one of the office locations listed on a weekly basis.

-In this role you will be testing static scans for applications for upcoming production releases.
-This role aids in manually reviewing code using their expert knowledge to identify vulnerabilities in code which may be missed or is not possible to be detected by automated SAST scanners
-Onboarding – This role aids in onboarding new and existing in-scope mnemonics to the program. This allows us to receive continuous scan results as developers push new builds in order to shift left and identify vulnerabilities earlier in the development process.

Skills:
– JAVA, .NET, Python
– Development and App Security
– Perform tool assisted application security testing (SAST)
– Triage and report vulnerabilities discovered
– Assist developers with vulnerability remediation
– Assist teams with onboarding to our SAST platform and orchestrating scans with our CI/CD platform

Job Description

• Carries out security testing of applications, infrastructure, and/or platforms to discover security vulnerabilities.
• Performs manual & automated security testing.
• Performs manual testing to validate vulnerabilities.
• Reviews the testing results with stakeholders and creates a report to review results with stakeholders.
• Assists in the design and implementation of security solutions and continuously enhances information security approaches and methodologies at manager discretion.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• Customer Focused – Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
• Managing Risk – Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC’s Enterprise Risk Management Framework.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.

Preferred Skills

Access Control (AC), Building Architecture, Customer Solutions, Disaster Recovery Planning, Information Security, Network Security, Physical Security, Risk Assessments, Security Technologies

Competencies

Analytical Thinking, Effective Communications, Information Assurance, Information Security Management, Information Security Technologies, IT Environment, IT Standards, Procedures & Policies, IT Systems Management, Problem Solving, Software Security Assurance

Work Experience

Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.

Education

Bachelors

Certifications

No Required Certification(s)

Licenses

No Required License(s)

Benefits

PNC offers a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include: 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.In addition, PNC generally provides the following paid time off, depending on your eligibility: maternity and/or parental leave; up to 11 paid holidays each year; 8 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.

To learn more about these and other programs, including benefits for full time and part-time employees, visit Your PNC Total Rewards.

Disability Accommodations Statement

If an accommodation is required to participate in the application process, please contact us via email at [email protected]. Please include “accommodation request” in the subject line title and be sure to include your name, the job ID, and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses.  Applicants may also call 877-968-7762 and say “Workday” for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

At PNC we foster an inclusive and accessible workplace.  We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.

Equal Employment Opportunity (EEO)

Auditor II – IT – Remote

by Irma Moore | Jan 9, 2025 | Uncategorized

Mayo Clinic’s tech culture is rooted in passion for technology, embraces innovative thinking and strives for high performance. Our teams drive change in health care through comprehensive connected health and digital transformation strategies.

Some examples of our major initiatives are:

• Utilizing artificial intelligence and machine learning principles to develop next generation patient centric care systems
• Transforming the practice by applying data science techniques to discover new approaches to health care delivery
• Leveraging Enterprise Architecture to construct integration centricity, promote data liquidity, and provide innovation support

This transformation creates, connects and applies integrated knowledge to deliver the best health care, health guidance and health information to patients, customers, partners, providers, employees anywhere and anytime so the needs of the patient come first.

Job Description

CityRochester

StateMN

RemoteYES

DepartmentInformation Technology

Why Mayo Clinic

Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the patient first, we are also dedicated to our employees, investing in competitive compensation and comprehensive benefit plans – to take care of you and your family, now and in the future. And with continuing education and advancement opportunities at every turn, you can build a long, successful career with Mayo Clinic. You’ll thrive in an environment that supports innovation, is committed to ending racism and supporting diversity, equity and inclusion, and provides the resources you need to succeed.

Benefits Highlights

• Medical: Multiple plan options.
• Dental: Delta Dental or reimbursement account for flexible coverage.
• Vision: Affordable plan with national network.
• Pre-Tax Savings: HSA and FSAs for eligible expenses.
• Retirement: Competitive retirement package to secure your future.

Responsibilities

Responsible for participating in the development, implementation, and evaluation of technology/information system internal audits for assigned organizational areas and functional activities throughout Mayo Clinic in accordance with the audit plan approved by the Audit and Compliance Committee. Performs information technology audit fieldwork activities, including interviews/walkthroughs, creating end-to-end process maps, performing risk and control analysis, and developing and documenting testing. Documents testing and related results, ensuring testing objectives are achieved and conclusions reached are adequately supported, summarizing written findings to be considered for reporting. Completes project assignments to ensure within time schedules while also meeting quality requirements and communicating any potential delays. Works collaboratively in a team structure leveraging project management skills/tools. Interprets and applies information technology (including general computer, application and information security controls), industry, accounting, regulatory, and internal audit standards. Displays a solution-oriented approach and sense of commitment to getting results and completing project assignments, effectively handling multiple ambiguous activities at one time. Proactively identifies and communicates problems and opportunities; seeks input and participates in implementing innovative solutions or process improvements. Communicates and presents information effectively to various audiences, including Audit project leadership, while simultaneously building credibility, rapport, and solid relationship. Demonstrates professional oral and written communication skills. Possesses the knowledge and demonstrates use of information technology audit strategies, methodologies, and tools. Pursues relevant information to use in complex problem-solving, root cause analysis and decision-making. Ad-hoc travel may be required, as work activities warrant (e.g. team on-site meetings and/or training).

*This position is 100% remote work. Individual may live anywhere in the US.

**This vacancy is not eligible for sponsorship / we will not sponsor or transfer visas for this position.

During the selection process, you may participate in an OnDemand (pre-recorded) interview that you can complete at your convenience. During the OnDemand interview, a question will appear on your screen, and you will have time to consider each question before responding. You will have the opportunity to re-record your answer to each question – Mayo Clinic will only see the final recording. The complete interview will be reviewed by a Mayo Clinic staff member and you will be notified of next steps.

Qualifications

Bachelor’s degree from an accredited university in a relevant field of study, with at least two years of relevant experience.
Public accounting (with regional or Big 4 accounting firm) and/or healthcare experience preferred.

This position will accept applications until 01/11/2025. This deadline may be extended if the necessary candidate pool is not met by this date.

Exemption Status

Exempt

Compensation Detail

$84,510.40 – $118,393.60 / year. Education, experience and tenure may be considered along with internal equity when job offers are extended.

Benefits Eligible

Yes

Schedule

Full Time

Hours/Pay Period

80

Schedule Details

Monday – Friday, business hours of 8:00 am – 5:00 pm CST

Weekend Schedule

N/A

International Assignment

No

Site Description

Just as our reputation has spread beyond our Minnesota roots, so have our locations. Today, our employees are located at our three major campuses in Phoenix/Scottsdale, Arizona, Jacksonville, Florida, Rochester, Minnesota, and at Mayo Clinic Health System campuses throughout Midwestern communities, and at our international locations. Each Mayo Clinic location is a special place where our employees thrive in both their work and personal lives. Learn more about what each unique Mayo Clinic campus has to offer, and where your best fit is.