Microsoft SQL Developer

2 weeks ago

Allentown, United States CrossAmerica Partners Full time

_**This is an in-office position; remote work is not available.**_
- **CrossAmerica Partners LP is a leading U.S. wholesale distributor of motor fuels, operator of convenience stores, and owner/lessee of real estate used in the retail distribution of motor fuels. With a geographic footprint of 34 states, CrossAmerica Partners distributes branded/ unbranded petroleum for motor vehicles to approximately 1,800 locations and owns or leases over 1,100 sites.**_

**Key Responsibilities**:

- Design, develop, and implement ETL (Extract, Transform, Load) processes using SSIS to extract data from various sources, transform it according to business requirements, and load it into target databases
- Develop, create, and maintain data warehouses combining multiple disparate source systems for downstream financial and operational reporting
- Work directly with project leads to understand requirements and propose key analytics solutions to drive effective decision-making and influence business objectives
- Create SSRS reports and dashboards to provide stakeholders with timely and accurate insights into key performance indicators and trends
- Optimize and tune SQL queries, stored procedures, and data transformation workflows to improve performance and scalability
- Conduct thorough testing and debugging of SSIS packages, stored procedures and SSRS/data warehouse reports to ensure accuracy, reliability, and adherence to business requirements
- Document technical specifications, data mappings, and process flows to facilitate knowledge sharing and maintain system documentation
- Provide technical support and troubleshooting assistance to end users for data integration and reporting tools and solutions

**Education/Experience**:

- Bachelor's Degree in Computer Science, Information Systems, or related field
- 3-5 years of professional experience in SQL Server development, including SSIS and SSRS
- Strong proficiency in SQL querying, stored procedures, and database design concepts
- Experience with data warehousing concepts, dimensional modeling, and data mart design
- Hands-on experience with SSIS for building complex ETL processes and data workflows
- Proficiency in designing and developing SSRS reports, including parameterized reports, drill-down reports, and interactive dashboards
- Excellent problem-solving skills and attention to detail with the ability to analyze complex data and business requirements
- Strong communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams
- _Experience working with Salesforce, Microsoft Power BI preferred_
- _Certifications in MS SQL Server, SSIS, SSRS or data warehousing preferred_

**We offer**:

- Health insurance (Medical, Dental, Vision)
- STD/LTD, Life Insurance
- 401k with employer match
- Vacation/Sick time
- Paid holidays
- & More

**At the core of our mission, CrossAmerica is a responsible, people-focused organization, committed to the well-being of our employees, customers and the environment.**

**Benefits**:

- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance

Schedule:

- Monday to Friday

Work Location: In person

  • OpenText Developer

    2 weeks ago

    Allentown, United States Diverse Lynx Full time

    Job Title: OpenText Developer Location: Remote Work or Allentown, PA" and "Louisville, Kentucky Duration: Full-time only Job Description: roles & Responsibilities: • Having OpenText Content Server REST API knowledge. • Proficiency in XML, SOA, SQL Database, SOAP, Rest Web Service • Familiarity with configuration and management of web/application...

  • OpenText Developer

    4 days ago

    Allentown, United States Diverse Lynx Full time

    Job Title: OpenText Developer Location: Remote Work or Allentown, PA" and "Louisville, Kentucky Duration: Full-time only Job Description: roles & Responsibilities: • Having OpenText Content Server REST API knowledge. • Proficiency in XML, SOA, SQL Database, SOAP, Rest Web Service • Familiarity with configuration and management of web/application...

  • Full Stack Java Developer

    2 weeks ago

    Allentown, United States The Social Station Full time

    We are a technology startup based in the Lehigh Valley, PA (Allentown area) with an opening for a Full Stack Java Developer. This is a full-time position based out of the Lehigh Valley.At The Social Station we are building the next generation social media marketing platform for agencies and brands. We develop native mobile applications, web-based tools, and...

  • Full Stack Java Developer

    2 weeks ago

    Allentown, United States The Social Station Full time

    We are a technology startup based in the Lehigh Valley, PA (Allentown area) with an opening for a Full Stack Java Developer. This is a full-time position based out of the Lehigh Valley.At The Social Station we are building the next generation social media marketing platform for agencies and brands. We develop native mobile applications, web-based tools, and...

  • Full Stack Java Developer

    4 weeks ago

    Allentown, United States The Social Station Full time

    Job DescriptionJob DescriptionWe are a technology startup based in the Lehigh Valley, PA (Allentown area) with an opening for a Full Stack Java Developer. This is a full-time position based out of the Lehigh Valley.At The Social Station we are building the next generation social media marketing platform for agencies and brands. We develop native mobile...

  • Organizational Development and Learning Specialist

    1 week ago

    Allentown, United States PPL Full time

    Company Summary Statement : As one of the largest investor-owned utility companies in the United States, PPL Corporation (NYSE: PPL), is committed to creating long-term, sustainable value for our 3.5 million customers, our shareowners and the communities we serve. Our high-performing regulated utilities PPL Electric Utilities, Louisville Gas and Electric,...

  • Full Stack Java Developer

    4 weeks ago

    Allentown, Pennsylvania, United States The Social Station Full time

    We are a technology startup based in the Lehigh Valley, PA (Allentown area) with an opening for a Full Stack Java Developer. This is a full-time position based out of the Lehigh Valley. At The Social Station we are building the next generation social media marketing platform for agencies and brands. We develop native mobile applications, web-based tools,...

  • Senior Land Development Design Manager

    3 weeks ago

    Allentown, United States The Pidcock Company Full time

    The Pidcock Company has particular expertise in civil engineering, land planning, and land surveying and is interviewing for the position below. Our staff of 40 professionals has significant, ongoing experience in providing professional design services for many of the more prominent and successful projects in the Lehigh Valley (Allentown, Bethlehem, and...

  • Senior Land Development Design Manager

    7 days ago

    Allentown, United States The Pidcock Company Full time

    The Pidcock Company has particular expertise in civil engineering, land planning, and land surveying and is interviewing for the position below.Our staff of 40 professionals has significant, ongoing experience in providing professional design services for many of the more prominent and successful projects in the Lehigh Valley (Allentown, Bethlehem, and...

  • Senior Land Development Design Manager

    1 month ago

    Allentown, United States The Pidcock Company Full time

    The Pidcock Company has particular expertise in civil engineering, land planning, and land surveying and is interviewing for the position below.Our staff of 40 professionals has significant, ongoing experience in providing professional design services for many of the more prominent and successful projects in the Lehigh Valley (Allentown, Bethlehem, and...

  • Senior Land Development Design Manager

    4 weeks ago

    Allentown, United States The Pidcock Company Full time

    The Pidcock Company has particular expertise in civil engineering, land planning, and land surveying and is interviewing for the position below.Our staff of 40 professionals has significant, ongoing experience in providing professional design services for many of the more prominent and successful projects in the Lehigh Valley (Allentown, Bethlehem, and...

  • Organizational Development and Learning Specialist

    1 week ago

    Allentown, Pennsylvania, United States PPL Corporation Full time

    Company Summary Statement : As one of the largest investor-owned utility companies in the United States, PPL Corporation (NYSE: PPL), is committed to creating long-term, sustainable value for our 3.5 million customers, our shareowners and the communities we serve. Our high-performing regulated utilities — PPL Electric Utilities, Louisville Gas and...

  • Level One Help Desk Admin- End User Support

    4 weeks ago

    Allentown, United States Contour Data Solutions Full time

    Job DescriptionJob DescriptionLevel 1 Help Desk Admin - End User Support Job Location: Hamilton, New JerseyFull time position Experience- 5+ years Salary: 45-55kJob Description:Contour Data Solutions is looking for a person wanting to make an immediate impact in a rapidly changing, fast paced environment. The position is part of a technology team that has...

  • Capacity Modeling Specialist

    4 days ago

    Allentown, United States Sharp Services Inc Full time

    Capacity Modeling Specialist page is loaded Capacity Modeling Specialist Apply locations Allentown time type Full time posted on Posted 9 Days Ago job requisition id JR29503 SUMMARY: The Capacity Modeling Specialist leads the Supply Chain Capacity Modeling Process, in partnership with cross-functional Operations stakeholders, with responsibility for...

  • AVD/Intune Engineer

    2 weeks ago

    Allentown, United States NR Consulting Full time

    Required Skillsets Broad understanding of Windows 10 and mobile operating systems Deep experience with Azure virtual desktop as well as VDI technologies such as Citrix XenDesktop Experience in designing / building / operating a Windows Virtual desktop environment Deep level experience with design, build and operating Microsoft Intune and device...

  • AVD/Intune Engineer

    4 days ago

    Allentown, United States NR Consulting Full time

    Required Skillsets Broad understanding of Windows 10 and mobile operating systems Deep experience with Azure virtual desktop as well as VDI technologies such as Citrix XenDesktop Experience in designing / building / operating a Windows Virtual desktop environment Deep level experience with design, build and operating Microsoft Intune and device...

  • Capacity Modeling Specialist

    4 days ago

    Allentown, United States Sharp Corporation Full time

    SUMMARY: The Capacity Modeling Specialist leads the Supply Chain Capacity Modeling Process, in partnership with cross-functional Operations stakeholders, with responsibility for supporting feasibility evaluations and strategic analysis. Creates and maintains complex models while ensuring accurate capacity is reflected based on a strong understanding of...

  • Security Engineer

    2 weeks ago

    Allentown, United States Omni Inclusive Full time

    Job Description: Configure, Install and provide technical support for the Endpoint Security Solution for Windows Defender and Symantec Endpoint Protection Install, configure, and provide oversight of Windows Defender Monitor and Analyse security logs to identify potential security breaches, Assesses all Vulnerabilities within environment and then mitigate...

  • Security Engineer

    4 days ago

    Allentown, United States Omni Inclusive Full time

    Job Description: Configure, Install and provide technical support for the Endpoint Security Solution for Windows Defender and Symantec Endpoint Protection Install, configure, and provide oversight of Windows Defender Monitor and Analyse security logs to identify potential security breaches, Assesses all Vulnerabilities within environment and then mitigate...

  • Webmaster

    2 weeks ago

    Allentown, United States Allentown City School District Full time

    Position Type: Administration/Webmaster Date Posted: 5/1/2023 Location: Administration Center - Allentown, PA WebmasterQualifications: Four to five years' experience in Web-based graphic design or web interface design, B.A. or B.S. in graphic design, art or related field or equivalent academic and work experience. Knowledge of software including: Camtasia,...