What are the responsibilities and job description for the Data Engineer position at The Wills Group, Inc?
Job Purpose and Function
The Data Engineer is a key role within the Information and Technology (IT) Team at Wills Group. Reporting to the Director of Integration and Software Solutions, the Data Engineer is responsible for building, managing, and optimizing data pipelines, as well as handling internal analytics and integrations between the company’s systems and third-party tools. The role focuses on operationalizing data and analytics to support the digital business initiatives at Wills Group.
In this position, the Data Engineer works closely with cross-functional teams to ensure the efficient flow of data across systems and to develop reporting solutions that address business challenges. They are expected to actively contribute to the creation and maintenance of data solutions that improve business processes and enhance product offerings. The role requires strong problem-solving skills, a detail-oriented mindset, and the ability to manage multiple tasks in a fast-paced environment.
As part of the IT Team, the Data Engineer also cross-trains with colleagues in other areas of the department to develop a broader understanding of the team’s functions. Since the IT Team is a service-oriented function, the Data Engineer may be called upon to assist with requests outside the specific scope of data-related work, providing support across various technology needs within the organization.
How You’ll Make an Impact
- Maintains and optimizes the data pipelines essential for supporting Wills Group's reporting warehouse, ensuring continuous and reliable data flow.
- Develops and sustains Power BI datasets and reports, providing valuable business insights through effective data visualization.
- Designs, implements, and maintains system integrations using EDI software and Microsoft’s Power Platform to facilitate seamless data exchange between systems.
- Creates and manages SQL Server Reporting Services (SSRS) reports, ensuring accuracy and relevance in the delivery of business-critical information.
- Collaborates with stakeholders across various departments to gather requirements for new reporting solutions and system integrations that align with business needs.
- Designs and implements an efficient data pipeline architecture to support the migration of the on-premise SQL warehouse to Azure, ensuring a smooth transition to the cloud.
- Maintains and enhances advanced algorithms utilizing Azure Machine Learning to drive business insights and improve decision-making processes.
- Develops and maintains thorough documentation for system integrations, ensuring clear communication and efficient troubleshooting for future reference.
- Works closely with IT Team leadership to establish and implement standards for self-service automation and analytics, empowering business units to independently access and analyze data.
- Acts as an escalation point for help desk requests related to reporting and integrations, providing timely resolutions to ensure smooth business operations.
What We’re Looking For
Basic Qualifications
- Bachelor’s Degree in Computer Science, Data Management, or a related field; equivalent relevant progressive experience and a minimum of high school diploma will also be considered.
- A minimum of 3 years of experience in data management disciplines, including data integration, modeling, and optimization.
- At least 3 years of hands-on experience with relational SQL databases, including creating and managing queries, stored procedures, and performance tuning.
- A minimum of 2 years of experience with object-oriented or functional scripting languages such as Python or R.
- At least 1 year of experience working with Microsoft Power Platform, including building integrations and automating processes.
- A team-centric attitude, with the ability to collaborate effectively with colleagues across departments.
- Self-directed with a strong ability to manage tasks independently while maintaining alignment with team goals.
- Strong oral, written, and presentation skills, with the ability to communicate complex technical concepts to both technical and non-technical audiences.
- Authorization to work in the U.S. (visa sponsorship or C2C opportunities not available at this time).
- Willing to submit to a pre-employment background check
An ideal candidate will also have
- Experience with Azure data services such as Azure Data Lake, Azure Data Factory, and Azure Data Pipelines is preferred.
- Experience with ASP.NET and C# programming is a plus.
Key Competencies
- Delivering results and meeting customer expectations
- Working with people
- Adapting and responding to change
- Analyzing
- Applying Expertise and Technology
Availability and Travel
- This hybrid role complies with our company’s hybrid telework schedule. Our operating days and hours are Monday through Friday from 8:00 AM to 4:30 PM, with in-office days being Tuesday through Thursday, reserving Monday and Friday as work-from-home.
- Occasionally, business needs may require periodic work obligations outside of core business hours.
- This role may require occasional travel, including overnight stays for training, conferences, or other events with reimbursement available for approved accommodations and/or expenses.
ADA Compliance
The Wills Group is committed to providing equal employment opportunities and fostering an inclusive workplace for individuals with disabilities. In compliance with the Americans with Disabilities Act (ADA), we ensure that all qualified individuals are given the necessary accommodations to perform the essential functions of their roles.
We encourage open communication and collaboration to identify and implement reasonable accommodations that support the success of our employees while maintaining operational excellence. Reasonable accommodations can be discussed during the hiring process.
Why You Should Join Wills Group
As a thriving, family-owned, $1.5 billion company headquartered in scenic La Plata, Maryland, (a 45-minute commute from Washington, DC), we take pride in our strong presence across the Mid-Atlantic region. Featuring nearly 300 retail locations of our family of brands including Dash In, Splash In ECO Car Wash, and SMO Motor Fuels, we are shaping the future of convenience retailing, fuels marketing, and commercial real estate.
Since 1926, our work-hard, play-hard mentality propels us to serve the communities that have supported us throughout the years. Keeping lives in motion is more than our mission--it's our way of life! We're dedicated to empowering individuals to embrace new possibilities and chart their own paths to success. Discover the fulfillment of working alongside passionate professionals, where your ideas are valued, and your potential is nurtured. Become part of something bigger when you join the Wills Group!
Benefits and Perks
Embark on a rewarding journey where your growth, future, and well-being take center stage! As a certified Great Place to Work™, the Wills Group understands today's professionals desire meaningful careers with a culture that's as authentic as possible. We pride ourselves in fostering an environment that supports your overall development.
Look forward to joining a company that celebrates your wins whether big or small. You can count on us to provide industry-leading total rewards packages that include a range of benefits and perks that contribute to your overall well-being:
- Financial Well-being: Employer 401(k) match (currently at 7%), health savings plan, and financial planning.
- Physical Well-being: Comprehensive health, vision, and dental plans tailored to meet the needs of our people and their families, even their pets!
- Paid Time Off: Vacation, sick, personal, community engagement, and parental leave for new parents.
- Work/Life Balance: Hybrid and flexible work environment, Employee Assistance Program, travel assistance, family life planning.
- Exclusive Discounts: Enjoy discounts on theme parks, Broadway shows, concerts, travel, shopping, dining, and wellness services.
- Education and Development Opportunities: 100% tuition reimbursement to support our team’s education goals, robust development programs, and certificate program assistance (up to 100% employer-paid).
- Competitive Salary: Competitive pay matched to DC Metro area.
Wills Group does not accept unsolicited resumes from recruiters or employment agencies in response to the Wills Group careers page or a Wills Group social media post. Wills Group will not consider or agree to payment of any referral compensation or recruiter fee relating to these unsolicited resumes. Wills Group explicitly reserves the right to hire those candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Wills Group.
Wills Group is an equal opportunity employer. Wills Group does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided based on qualifications, merit, and business need. #HQ
Salary : $96,800 - $121,000
