CrossAmerica Partners is a leading wholesale distributor of motor fuels operator of convenience stores and owner and lessor of real estate used in the retail distribution of motor fuels. We are a top ranked wholesale distributor with eight major fuel brands our seven high quality convenience store brands have 250 locations and we are actively buying selling and leasing sites across the US. With a geographic footprint across 34 states we strive to be an industry leader providing fuel and convenience products essential to keep people moving across America!
Job Description:
We are looking for a skilled SSIS (SQL Server Integration Services) and SQL Data Warehouse Developer who will be responsible for designing developing and maintaining data integration and data warehouse solutions. The ideal candidate will have a strong background in database development ETL processes and data warehousing using Microsoft SQL Server and related technologies.
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
Skills & Qualifications:
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 with other Microsoft BI tools such as Power BI and SQL Server Analysis Services (SSAS).
Knowledge of data visualization best practices and principles.
Certifications in MS SQL Server SSIS SSRS or data warehousing.
Experience working with Salesforce
Education & Experience:
Bachelors degree in Computer Science Information Systems or related field
3-5 years of professional experience in SQL Server development including SSIS and SSRS
Physical Requirements:
This position requires the ability to work in a standard office environment with prolonged periods of sitting at a desk and working on a computer. The SQL Developer must be able to use hands and fingers to operate a keyboard and mouse for extended durations with frequent viewing of computer screens. Occasional standing walking and light lifting of office materials (up to 15 pounds) may be required. The role also involves maintaining focus and visual acuity to analyze data review code and troubleshoot systems.
Equal Employment Opportunity
CrossAmerica Partners (or its subsidiaries and related entities) contract with employment service organizations to provide staffing for its corporate operations. The employment service organizations are equal opportunity employers. For this position the employment service organization is VUC Inc. All qualified applicants will be considered for employment without regard to age race color creed religion sex affectional or sexual orientation national origin ancestry marital status disability military or veteran status or any other classification protected by applicable law.
Accommodations
The employment service organizations with which CrossAmerica Partners contracts including VUC Inc make all employment decisions in accordance with applicable laws and provide reasonable accommodations to qualifying individuals on the basis of any protected characteristic consistent with applicable law. VUC Inc is committed to providing access equal opportunity and reasonable accommodation for individuals with disabilities in employment its services programs and activities. VUC Inc also provides reasonable accommodation to qualified job applicants (and employees) to accommodate the individuals known limitations related to pregnancy childbirth or related medical conditions unless doing so would create undue hardship. If reasonable accommodation is needed to participate in the job application or interview process to perform essential job functions and/or to receive other benefits and privileges of employment please contact
Required Experience:
IC
CrossAmerica Partners is a leading wholesale distributor of motor fuels operator of convenience stores and owner and lessor of real estate used in the retail distribution of motor fuels. We are a top ranked wholesale distributor with eight major fuel brands our seven high quality convenience store b...
CrossAmerica Partners is a leading wholesale distributor of motor fuels operator of convenience stores and owner and lessor of real estate used in the retail distribution of motor fuels. We are a top ranked wholesale distributor with eight major fuel brands our seven high quality convenience store brands have 250 locations and we are actively buying selling and leasing sites across the US. With a geographic footprint across 34 states we strive to be an industry leader providing fuel and convenience products essential to keep people moving across America!
Job Description:
We are looking for a skilled SSIS (SQL Server Integration Services) and SQL Data Warehouse Developer who will be responsible for designing developing and maintaining data integration and data warehouse solutions. The ideal candidate will have a strong background in database development ETL processes and data warehousing using Microsoft SQL Server and related technologies.
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
Skills & Qualifications:
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 with other Microsoft BI tools such as Power BI and SQL Server Analysis Services (SSAS).
Knowledge of data visualization best practices and principles.
Certifications in MS SQL Server SSIS SSRS or data warehousing.
Experience working with Salesforce
Education & Experience:
Bachelors degree in Computer Science Information Systems or related field
3-5 years of professional experience in SQL Server development including SSIS and SSRS
Physical Requirements:
This position requires the ability to work in a standard office environment with prolonged periods of sitting at a desk and working on a computer. The SQL Developer must be able to use hands and fingers to operate a keyboard and mouse for extended durations with frequent viewing of computer screens. Occasional standing walking and light lifting of office materials (up to 15 pounds) may be required. The role also involves maintaining focus and visual acuity to analyze data review code and troubleshoot systems.
Equal Employment Opportunity
CrossAmerica Partners (or its subsidiaries and related entities) contract with employment service organizations to provide staffing for its corporate operations. The employment service organizations are equal opportunity employers. For this position the employment service organization is VUC Inc. All qualified applicants will be considered for employment without regard to age race color creed religion sex affectional or sexual orientation national origin ancestry marital status disability military or veteran status or any other classification protected by applicable law.
Accommodations
The employment service organizations with which CrossAmerica Partners contracts including VUC Inc make all employment decisions in accordance with applicable laws and provide reasonable accommodations to qualifying individuals on the basis of any protected characteristic consistent with applicable law. VUC Inc is committed to providing access equal opportunity and reasonable accommodation for individuals with disabilities in employment its services programs and activities. VUC Inc also provides reasonable accommodation to qualified job applicants (and employees) to accommodate the individuals known limitations related to pregnancy childbirth or related medical conditions unless doing so would create undue hardship. If reasonable accommodation is needed to participate in the job application or interview process to perform essential job functions and/or to receive other benefits and privileges of employment please contact
Job Location:
Monthly Salary:
Posted on:
Vacancies:
