With Query Example Sql Jobs in Usa

We are currently looking to hire an experienced and analytical Financial Analyst 3 for an onsite role at our Costa Mesa, CA Headquarters. In this role, you will support the organizations Corporate Finance: Analysis and Reporting team by developing, managing, and presenting financial analysis projects, creating and publishing executive reporting/dashboards, and analyzing Profit and Loss (P&L) statements for management.

What You'll Do:

• You will prepare, analyze, coordinate and present reporting for executives and perform financial analysis, variance analysis and profitability analysis.
• You'll be responsible for reviewing, identifying, and working with other departments to gather data and analyze projects.
• You will lead financial analysis projects, present slides to executives, research profitability challenges and create recommendations.
• You will perform Ad Hoc Analysis as needed and be able to explain the data effectively.
• You will manage access databases and create Tableau dashboards to display trends and data.
• You'll be responsible for the update and creation of reports and completing/presenting assigned financial analysis projects.

What You'll Need:

• Minimum requirements include a Bachelor's degree in Finance, Business, Economics or Accounting and 3 5 years of experience in Financial Analysis, Corporate Budgeting and Forecasting, or Accounting.
• You will need to have a strong understanding of accounting concepts and processes.
• Strong verbal and written communication skills, presentation skills, be a motivated self-starter and detail oriented.
• Advanced Excel skills, Tableau skills or other data visualization (i.e. Power BI) skills are required.
• Experience with a large ERP system is required and Oracle Hyperion experience is a plus.
• Ad Hoc querying skills, Access Database experience and SQL experience is preferred.
• Teamwork, leadership, interpersonal, multitask management and presentation skills.
• Candidate must also be willing to work extra hours occasionally, to meet deadlines.

The starting pay range for this position is $90,400.00 - $120,300.00. Additionally, for full time positions, you will be eligible to participate in our incentive program based upon the achievement of organization, team and personal performance.

Remarkable benefits: Health coverage for medical, dental, vision 401(K) saving plan with company match AND Pension Tuition assistance PTO for community volunteer programs Wellness program Employee discounts

We are Generac, a leading energy technology company committed to powering a smarter world.

Over the 60 plus years of Generac’s history, we’ve been dedicated to energy innovation. From creating the home standby generator market category, to our current evolution into an energy technology solutions company, we continue to push new boundaries.

As a Digital Manufacturing Engineer, you will have the opportunity to use your digital toolset to solve some of Generac’s most complex manufacturing problems. You will be challenged to build innovative solutions that will free our manufacturing sites to focus on what they do best, while leading projects and mentoring others. This role is a member of our corporate Advanced Manufacturing team and is a key contributor in our digitalization effort.

Essential Duties and Responsibilities:

• Tulip app building with MES as key area of focus
• Integration of Tulip with enterprise solutions: SAP, CMMS. Etc.
• Design, implement, and maintain analytics and dashboards in Power BI and Tulip Analytics.
• Evaluate new solutions and support lab testing with onsite proof of concept activities.
• Support end of line test cell enhancements.
• On-call rotation for after hours support of applications deployed by Advanced Manufacturing team.
• Responsible for managing assigned project schedules and budgets.
• Ensure manufacturing data accuracy from responsible systems.
• Regularly conduct training and knowledge transfer sessions with operations team.

Minimum Qualifications:

• Bachelor's degree in engineering, Business, or Industrial Technology
• 5+ years of progressive manufacturing experience supporting operations technology.

Preferred Qualifications:

• Experience managing technical projects; including requirements, budgets, timelines, and changes.
• Proven track record of utilizing technology to drive manufacturing improvements.
• Ability to lead workshops with sites and key stakeholders to understand and document complex manufacturing requirements.
• Experience developing, deploying, and supporting manufacturing systems; specifically, MES. Includes others such as QMS, PLCs, SCADA, Data Historians, CMMS, and computer vision.
• Expertise with common OT programming languages such as Python, JavaScript, C# and/or others
• Experience working with SQL databases, writing complex queries, stored procs, functions, and triggers.
• Experience in OT integration technologies and standards including OPC and/or MQTT.
• Experience design and developing cloud-based data analytics and reports.
• Experience working with OPC servers and data tags.
• Experience integrating OT systems with enterprise solutions using REST API and similar.

Great Reasons to work for Generac:

• Competitive Benefits: Health, Dental, Vision, 401k and many more
• State-of-the-art facility with an onsite gym, walking trails, café, free parking and many employee activities
• Scheduled events throughout the year that allow our employees, both current and retirees, to gather together and enjoy their time with their families and co-workers
• Eligible for summer hours! (Memorial Day – Labor Day)
• Pride! When a storm strikes, Generac employees always rise to the occasion. Each time a storm hits many employees volunteer their time with the customer support team or on the production line while others go right into storm-affected areas to repair generators
• We believe in having fun. From minor celebrations to major events, our employees balance their work by building a strong culture of teamwork and collaboration through a variety of occasions, including our Fun Days.
• Every day is Jeans Day! Dress for your day.
• Product loan and discount programs

To formally apply to this position click here: You will not be considered an applicant until you complete online application.

Physical Demands: While performing the duties of this job, the employee is regularly required to talk and hear; and use hands to manipulate objects or controls. The employee is regularly required to stand and walk. On occasion the incumbent may be required to stoop, bend or reach above the shoulders. The employee must occasionally lift up to 25 - 50 pounds. Specific conditions of this job are typical of frequent and continuous computer-based work requiring periods of sitting, close vision and ability to adjust focus. Occasional travel.

“We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability status, protected veteran status, or any other characteristic protected by law.”

Job Title: Interoperability Specialist

Location: Little Rock, AR / Remote

Company Overview

At AngelEye Health, our mission is to empower families to improve the clinical outcomes of their loved ones. We provide a HIPAA-compliant family engagement platform that integrates parents into the child’s care team. From our bedside camera systems to our feeding and discharge management tools, we aim to reduce family stress and improve the patient journey from admission to home.

Position Summary

We are looking for a skilled Interoperability Specialist to join our technical team. In this role, you will be the bridge between AngelEye’s platform and the complex Electronic Health Record (EHR) environments of our hospital partners. You will design, develop, and maintain critical data interfaces using Mirth Connect and APIs, ensuring that vital patient information flows seamlessly to support our family-centered care solutions.

Key Responsibilities

• Interface Development: Build, test, and deploy HL7 interfaces using Mirth Connect to facilitate data exchange between AngelEye and hospital EHR systems.
• Custom Scripting: Use JavaScript within Mirth to handle complex message transformations, data mapping, and custom logic for non-standard clinical data.
• EHR Integration: Act as the technical lead for integrations with Epic (Bridges), Cerner (Open Engine), and other major EHR providers.
• Clinical Data Workflows: Configure and troubleshoot specific message types, including:
• ADT: Admission, Discharge, and Transfer events.
• Orders: Ensuring clinical orders trigger appropriate platform actions.
• Flowsheets: Capturing data and clinical observations for automated documentation.
• Technical Support: Monitor existing channels, perform root-cause analysis on interface failures, and maintain interface systems.
• Stakeholder Collaboration: Work closely with hospital IT teams, project managers, and clinical staff to ensure technical builds align with clinical workflows.

Technical Qualifications

• Integration Engine: Minimum 3–5 years of hands-on experience with Mirth Connect (NextGen Connect).
• Coding: Proficiency in JavaScript for writing custom transformers, filters, and global scripts.
• Standards: Expert knowledge of HL7 v2.x; familiar with FHIR, JSON, and REST APIs.
• EHR Ecosystems: Direct experience working with Epic and Cerner integration environments.
• Database Skills: Ability to write SQL queries to validate data and troubleshoot backend issues.

Core Competencies (Personal Skills)

• Communication: Ability to translate complex technical jargon into clear language for non-technical hospital staff and internal leadership.
• Problem-Solving: A "PhD-level execution" mindset—you don’t just fix the symptom; you solve the root cause.
• Urgency & Ownership: A strong sense of urgency in resolving issues that impact family-patient connectivity.
• Empathy: A deep alignment with our mission to support families during their most challenging times in the NICU/PICU.

Job Title: Sr Business Systems Analyst

Duration of project: 6 months

Description:

As a Sr. Business Systems Analyst, you will be the 'Data Detective' for our Data Sharing Governance team. You will bridge the gap between our legal contracts (Conga) and our technical execution (ServiceNow). A critical part of this role involves reconstructing project provenance following a system upgrade and maturing our tracking within Collibra to ensure every piece of data shared with external partners (HIEs, Research, etc.) is fully governed, authorized, and documented.

This individual will be responsible for assisting in the roll out of organizational programs and team platforms and discovery work to make informed decisions. The associate in this role will develop processes and workflows and work closely with business stakeholders to move forward with our next phase of Data Sharing Governance maturity.

KEY RESPONSIBILITIES:

Data Reconciliation & Forensic Mapping: Lead the effort to reconcile contract (Conga) to implementation (ServiceNow) by cross-referencing Conga contract metadata, ServiceNow interface extracts, and stakeholder interviews to reconstruct project provenance.

Audit Readiness: Create a "traceability matrix" that links a signed contract ID to a ServiceNow Project ID and a specific technical interface endpoint.

Defines new business processes/functions to support emerging capabilities

Maps and enhances existing business processes/functions and recommends changes required to fit a tightly integrated system

Designs and implements projects requiring systems integration, small teams and multiple technical platforms

Assist in maturing governance process around data sharing platform (Collibra)

Collaborates on driving improvement activities to achieve department and organizational goals

Coordinates with functional team to assure consistency and optimization of overall work product

Maintains current knowledge of industry and business process trends and is able to apply that knowledge to existing business processes

Skills:

Ability to analyze and define complex processes and sub-processes

Demonstrated ability to perform investigative data reconciliation to establish and document data and project provenance across multiple enterprise platforms

Have clear understanding of your assigned functional area and the data being managed, and its implications downstream to other systems, processes, and applications

Knowledge of the business rules for their functional areas

Active listening skills to understand business needs and influence business team to take decision that have business-wide impact

Excellent oral, verbal and written communication skills and ability to build strong relationships with peers & leadership

Strong meeting facilitation skills as well as presentation skills.

Communicate effectively with diverse people at various organization levels with right level of detail and cultural sensitivity

Highly desired software experience:

Logic & Querying: SQL, BigQuery; will need to pull reports from BigQuery to find the "orphaned" data from your ServiceNow upgrade.

Interoperability Standards: Basic understanding of healthcare data exchange (HL7, FHIR, or EDI) to accurately map "Data Elements" mentioned in a contract to actual fields in an API or interface.

Data Governance Frameworks: Familiarity with the concept of Data Provenance—knowing not just where data is, but its origin and the authority by which it is being shared.

ServiceNow, Conga

Qualifications and Experience:

Required: Associate's degree and 4 years of applicable cumulative job specific experience

Preferred: Bachelor’s degree, preferably in Computer Science, Information Technology, Mathematics or other related major and 2 years of applicable cumulative job specific experience

Experience working in a healthcare environment preferred

Experience working in Data Governance preferred

General knowledge of hospital operations, contracting, data sharing (HIEs, registries, etc) the interrelationship of systems, and how technology enables business processes

The Business Systems Support Analyst serves as a liaison between the Accounting team and IT, focusing on the support, maintenance, and improvement of business systems. This role ensures that systems operate effectively, business needs are met, and processes are streamlined for greater efficiency. The Analyst will troubleshoot issues, provide user support, document processes, and partner with stakeholders to implement enhancements that align with LERETA’s goals.

Key Responsibilities:

System Analysis & Support

• Maintain and troubleshoot financial systems (ERP, reporting tools, and related applications)
• Ensure data integrity and compliance with internal controls and regulatory requirements
• Train and assist end-users to ensure they can effectively utilize systems and tool

Business Requirements Gathering:

• Collaborate with Finance stakeholders to understand processes, dependencies, and business rules.
• Document functional and technical specifications for system enhancements

Project Coordination:

• Act as a liaison between Finance and IT teams for system upgrades, integrations, and new implementations
• Work with developers, project managers, and analysts to ensure solutions meet Accounting’s needs and support business goals.
• Participate in testing, validation, and deployment of system changes.
• Evaluate business requirements and translate them into system updates or enhancements.
• Identify opportunities to automate or simplify accounting processes through technology.

Reporting & Analytics:

• Develop and maintain financial reports and dashboards for management
• Provide insights to improve operational efficiency and decision-making

Governance & Documentation:

• Adhere to Data Governance standards for financial systems
• Maintain updated documentation for processes, workflows, and system configurations

Required Qualifications:

• Bachelor’s degree in Accounting, Finance, Information Systems, or related field
• 5+ years of experience in financial systems support or business analysis
• Strong knowledge of ERP systems (e.g., Oracle, SAP, or similar) and reporting tools
• Sage Software
• Sage 100 ERP
• Sage Intelligence
• Sage Paperless Office
• Sage FAS
• Proficient with MS SQL Queries & MS Excel Formulas
• Crystal Reports
• Sage Systems Installations, Configuration and Security
• Adaptive Planning
• Avalara
• SAP Concur Solutions
• Excellent communication and problem-solving skills
• Excellent communication skills to work effectively with both technical and non-technical users
• Ability to document processes and create training materials

Preferred Education & Experience:

• Experience with workflow automation and integration projects
• Familiarity with Data Governance frameworks
• Advanced Excel and financial modeling skills

DEPLOY has been retained to find a Reporting & Data Architect Lead combines advanced reporting development with enterprise-level data governance and architectural leadership. In this role, you will own our client's enterprise reporting platform—designing robust Power BI solutions, managing shared data models, and ensuring the reporting environment remains secure, scalable, and high-performing.

You will also own our client's enterprise reporting standards and governance framework, ensuring reporting across all departments is consistent, trusted, and aligned with best practices. This includes defining reporting conventions, reviewing changes, onboarding departmental report creators, and stewarding enterprise reporting assets such as certified datasets and endorsed reports.

At the enterprise level, you will architect our client's data framework—defining how data is structured, named, documented, and shared across ERP, operational, manufacturing, and corporate systems. You will own the enterprise data dictionary, the centralized semantic model, and key architectural decisions around Microsoft Fabric and other data tooling. This role interacts frequently with executives to align data strategy with organizational growth and reporting needs.

Key Responsibilities

Enterprise Reporting (Hands-On Development)

• Build, optimize, and maintain enterprise-grade Power BI reports, dashboards, datasets, and data models.
• Develop and govern shared semantic models and reusable datasets that power enterprise-wide reporting.
• Use Microsoft Fabric, Dataverse, and related ETL/data management tools to shape and integrate reporting data sources.
• Manage dataset refresh schedules, performance tuning, workspace organization, gateway configuration, and reporting system reliability.
• Implement row-level security (RLS), workspace access patterns, and enterprise reporting permissions—Responsible, with the Director of Technology Accountable.
• Manage reporting governance artifacts including certified datasets, endorsed reports, and enterprise workspace standards.
• Support reporting scalability as our client grows (new factories, new business units, new product lines).

Enterprise Reporting Standards & Governance

• Own our client's enterprise reporting standards framework, covering naming conventions, modeling patterns, documentation practices, lifecycle management, visual design standards, and change control.
• Govern reporting development and deployment across the organization to ensure consistency and prevent duplicate or conflicting models.
• Review and approve reporting change requests, data model modifications, and access requests.
• Lead documentation and enablement for departmental report creators through training, guidance, and structured onboarding.
• Provide strategic direction around reporting maturity, sustainability, and enterprise alignment.

Enterprise Data Architecture

• Design and maintain our client's enterprise data architecture framework across ERP, operational, manufacturing, and corporate systems.
• Own the enterprise data dictionary, defining canonical field names, table structures, business definitions, and version control practices.
• Build and govern the centralized semantic model that powers reporting across the company.
• Advise and strongly influence enterprise-level decisions around Microsoft Fabric, data modeling strategy, and long-term architectural direction—and own the work that follows those decisions.
• Collaborate with engineering and system owners to coordinate schema changes, data integrations, and cross-system alignment.

Leadership & Collaboration

• Partner with C-suite and senior leaders to define reporting roadmaps, enterprise priorities, and data strategy.
• Communicate complex architectural concepts in clear, business-friendly terms.
• Lead cross-functional initiatives that require unified data structures or scalable reporting.
• Apply automation (Power Automate, Fabric pipelines) and AI tools to improve reporting efficiency, data quality, and governance workflows.

Ideal Candidate Profile

• Deep hands-on expertise with Power BI, Microsoft Fabric, data modeling, and cloud data platforms.
• Track record of establishing and enforcing enterprise reporting standards and governance.
• Strong architectural intuition: semantic modeling, master data definition, cross-system alignment, and scalable design.
• Able to operate as both an individual contributor and a strategic leader.
• Experience managing reporting governance artifacts (certified datasets, endorsed reports, workspace strategy).
• Comfortable influencing architectural decisions and guiding technical execution.
• Strong command of foundational tools and languages such as:
• DAX
• Power Query / M
• SQL
• Fabric pipelines / ETL tooling
• Experience with automation and AI-assisted analytics workflows.

Job Title: Jr Data Entry Specialist

Location: Atlanta, GA (ATL preferred)

Schedule: Onsite, 5 days/week

Perks: Free parking

About the Role

We’re seeking a Jr Data Entry Specialist to support property and vendor setup while ensuring accurate and timely commission processing. This role is ideal for someone highly detail-oriented who can follow established processes, work across multiple databases, and handle sensitive financial information with care. It’s a strong opportunity for someone eager to gain exposure to a corporate operations environment.

What You’ll Do

• Enter and maintain new properties in internal systems (supporting 170–190+ properties)
• Set up new vendors and establish vendor IDs in coordination with Accounts Payable
• Review and verify tax documentation to ensure vendors are eligible for compensation in their respective states
• Confirm contract payment terms and validate unit counts eligible for compensation
• Calculate and process commissions using internal systems and Excel-based uploads
• Research unpaid commissions and resolve discrepancies or incorrect payments
• Initiate recoupment for overpayments or invalid payments
• Receive and route returned checks to Accounts Payable
• Work through and resolve an existing ticket backlog (approximately 700 tickets from 2025 to present)
• Pull and reconcile data from multiple internal databases while maintaining accuracy
• Handle private banking and compensation data securely within VPN environments

What We’re Looking For

• High attention to detail and ability to follow defined processes consistently
• Comfort working across multiple systems and accurately transferring information
• Strong Excel skills; experience uploading or reconciling spreadsheet-based data
• Proficiency in Microsoft Outlook and professional internal communication
• Ability to work independently and stay organized in a high-volume environment
• Strong interest in gaining exposure to a corporate operations role

Nice to Have

• Experience working with large datasets or running SQL queries (not required)
• Background in data entry, operations, finance, or administrative roles

Why This Role

• Onsite exposure to a structured corporate environment
• Clear processes, hands-on work, and defined expectations
• Growth opportunity for early-career candidates or those transitioning from service or hospitality roles

Job Title: Cloud Developer

Location: Boston, MA

Only for W2

Job Overview:

We are looking for an experienced AWS Cloud Developer to build and manage cloud-based analytics and dashboards for device and fleet data. The role involves Athena, and AWS visualization tools to create reliable datasets, optimized queries, and operational dashboards.

Key Skills Required:

• 4+ years of AWS cloud development experience
• Strong SQL and Amazon Athena experience
• Hands-on with Amazon S3 analytics workflows
• Experience with QuickSight or CloudWatch dashboards
• TypeScript development experience
• Knowledge of Git, CI/CD, and SDLC practices

The HRIS Sr. Analyst serves as the primary contact for all Human Resources Information Systems (HRIS) needs at semiconductor manufacturing facility (total employee count of 3000). This role is responsible for supporting Human Resources operations at the site, ensuring the accuracy, integrity, and security of Human Resources data, and enabling timely and insightful reporting for the facilities Human Resources functions. The HRIS Sr. Analyst will coordinate closely with corporate HRIS to request system upgrades, enhancements, and configuration changes.

Essential Duties and Responsibilities:

Site HRIS Support & Administration, as primary point of contact for all HRIS-related inquiries and issues at Manufacturing Site.

• Oversee daily operations and maintenance of HRIS platform SAP SuccessFactors
• Ensure data integrity through regular audits, validations, and troubleshooting.
• Manage user access and security roles for factory HRIS users in accordance with corporate policies. Collaborate with corporate HRIS to request system upgrades, enhancements, and configuration Develop and maintain dashboards and reports to support Human Resources decision-making Process Improvement & Automation to identify opportunities to streamline Human Resources processes at the factory through automation and system enhancements.
• Teach and encourage Human Resources staff and end-users to leverage AI tools and features within HRIS and related platforms.

Required Qualifications:

Bachelor's degree in Human Resources, Information Systems, Business Administration, or related field.

• 5+ years of experience in HRIS management or Human Resources systems administration.
• Proficiency in HRIS platform SAP - Success Factors, supporting Employee Central, Recruiting, Performance, or related modules
• Strong analytical skills with attention to detail and data accuracy.
• Excellent communication and project management skills.
• Experience with data privacy and compliance standards (e.g., GDPR, HIPAA) is a plus.

Preferred Qualifications:

Certification in HRIS systems or data analytics is preferred

Experience with SQL or other data query languages is preferred.

Familiarity with HR processes such as talent acquisition, performance management, and compensation is a plus.

Location:

To support both Tempe and Peoria locations.

Segra is searching for a qualified and experienced Billing Transformation Data Analyst to join us in a full-time capacity.

Location Requirement:

This work arrangement for this role is a hybrid position, requiring three (3) days in the office, with flexibility to work remotely two (2) days each week.

Role Overview:

The Billing Transformation Data Analyst will need to be detail-oriented and analytical. The incumbent will be responsible for analyzing billing data, ensuring accuracy in customer invoicing, and supporting revenue assurance initiatives. The incumbent will also assist others on the team who work closely with cross-functional teams, including IT, Finance, and Customer Service—to identify and resolve billing discrepancies, automate reporting processes, and optimize billing system performance.

The Billing Transformation Data Analyst will also assist with ensuring billing is processed accurately, as necessary, supporting the members of the Billing Transformation team. This position will assist others on the team with the design, development, implementation, and execution of processes related to the analysis of all billing.

Required Skills:

• Minimum of 2 years of experience in data analytics, and Telecommunications systems and business practices.
• Bachelor’s degree in business/information systems or another technical/analytical field or equivalent experience required.
• Strong proficiency in SQL for data extraction, manipulation, and reporting is required.
• Ability to understand work with a billing platform or similar system, understand system processes, and query language is required.

Preferred Skills:

• Effective organizational skills.
• Exceptional written and verbal communication skills with a strong ability to communicate with multiple leaders and levels of the business, with strengths in communicating results.
• Strong problem-solving and analytical skills with high attention to detail are essential.
• The ability to meet pressured deadlines and prioritize competing priorities.
• Ability to comprehend technical product structures in various formats.
• Preferred tools include Power BI, Alteryx, Tableau, and MS Access.

About Segra:

Segra is one of the largest independent fiber network companies in the nation, able to offer state-of-the-art communication solutions backed by always-on customer service. We are known for our future-forward infrastructure and state-of-the-art voice and data technology solutions for businesses and the public sector, as well as wholesale transport services to some of the world’s largest carriers. Our network features the latest advances in IP, ethernet, and dark fiber architectures, as well as high performance data centers. Furthermore, our network powers technology solutions such as hosted voice, security, and cloud.

Segra has engineered our entire company operations to put our customers at the very center of everything we do. We invest in the communities we serve by hiring locally and continually upgrading our network infrastructure. Segra has over 1200 employees, 500k+ on-net and near-net buildings, and 44k+ fiber-route miles. We exist purely to help businesses within our footprint be successful.

Benefits Overview:

Segra offers a very robust benefits package to our full-time employees, some of which include:

• Medical, dental, vision insurance
• Life insurance
• 401(k) match
• Flexible Spending/Health Savings Accounts
• Tuition and gym reimbursements
• Vacation/PTO, paid holidays, floating holidays
• Volunteer days, parental leave
• Legal, accidental, hospital indemnity, identify theft, pet insurance

Our Commitment to Equality:

Segra is an equal opportunity employer and prohibits discrimination of any kind. Segra does not discriminate on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factor.

Salary Range: $47,670 - $59,535

Beyond competitive health and retirement benefits with immediate 401(k) vesting, Segra also invests in your total well-being through programs supporting physical, mental, financial, and social wellness.