What are the responsibilities and job description for the Microsoft SQL Developer position at CrossAmerica Partners LP?
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:
- 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
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 individual's 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 mweber@caplp.com.