What are the responsibilities and job description for the Senior Data Engineer position at FrankCrum?
FrankCrum is a Top Workplace!
FrankCrum, voted by its employees as a Top Workplace in Tampa Bay for more than 10 years in a row, is a Professional Employer Organization (PEO) based in Clearwater, Florida. FrankCrum employs approximately 400 people who serve over 4,000 businesses by offering a full range of HR services, including payroll, employee benefits, HR consulting services and workers' compensation insurance. Our PEO is a family culture that encourages people to feel at home, collaborate, and respect each other and we live by our Pillars of Excellence which are Integrity, Prosperity, and Affinity!
The Role You'll Play to Create Success
We are excited to announce our search for a full-time Senior Data Engineer! In this role, you will have the opportunity to impact the FrankCrum business everyday by expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder who enjoys optimizing data systems and building them from the ground up. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. They will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives.
- Create and maintain optimal data pipeline architecture.
- Assemble large, complex data sets to meet functional / non-functional business requirements.
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure technologies.
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business metrics.
- Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
- Manage, monitor, and secure data across boundaries through multiple data centers and Azure regions.
- Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
- Work with data and analytics experts to strive for greater functionality in our data systems.
- Develops store procedures, scripts, and assists with software configuration and testing.
The Attributes We Seek
Keys to success in this position include a BS or MS degree preferred, with three (3) years’ experience in a Microsoft Azure SQL data warehouse and Azure Synapse Analytics. 5 years of experience with data pipeline and workflow management tools. 5 years of experience with developing a data lake, data warehouse, and data marts. Experience with reporting development experience using Tableau, Logi Analytics, or Power BI. Experience with Python is nice to have.
Our Competitive Benefits
Along with this great opportunity, FrankCrum also provides exceptional benefits from top carriers including:
- Health insurance is $0 paycheck cost for employee's coverage and only $150/month for family!
- Dental and vision insurance
- Short Term Disability and Term Life Insurance at no cost to the employee
- Long Term Disability and Voluntary Term Life Insurance
- Supplemental insurance plans such as Accidental, Critical Illness, Hospital Indemnity, Legal Services and Pet Insurance
- 401(k) Retirement Plan where FrankCrum matches 100% of the first 4% the employee contributes and the employee is immediately vested in the employer match
- Employee Assistance Program at no cost to the employee
- Flexible Spending Accounts for Medical and Dependent Care Reimbursement
- Health Savings Account funded by FrankCrum
- Paid time off and holiday pay
- Education reimbursement up to $5,000 per year
- PTO cash out
- Tickets at Work and access to the Corporate America Family Credit Union
- Employee and client referral bonus program
- Paid volunteer time
What's Special About FrankCrum
FrankCrum, a family-owned business-to-business entity since 1981 is made of several companies: FrankCrum Corporate (a professional employer organization), FrankCrum Staffing, Frank Winston Crum Insurance Company, and the FrankCrum Insurance Agency - all based in Clearwater, Florida. This "family of employer solutions" employs approximately 400 people who serve over 4,000 clients throughout the United States. FrankCrum employees are trained to deliver high value through exceptional customer service and treat clients and coworkers like family. By living by our Brand Pillars of Integrity, Affinity, and Prosperity, employees are recognized at quarterly events for exceptional customer service and milestones in tenure.
The FrankCrum headquarters spans 14 acres and includes a cafe, subsidized for employees. Menus include made-to-order breakfast, hot lunch options and even dinners that can be ordered to-go, all at very affordable prices. The cafe also plays host to monthly birthday and anniversary celebrations, eating and costume contests, and yearly holiday parties. Through the input of its own employees, The Tampa Bay Times has recognized FrankCrum as a Top Place to Work for more than 10 years in a row! FrankCrum also supports several community efforts through Trinity Cafe, the Homeless Empowerment Program, and Clearwater Free Clinic!
If you want to play this role to positively impact our clients' day-to-day business, then apply now!
FrankCrum is an Equal Opportunity Employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status, military service and veteran status, physical or mental disability, genetic information, or any other characteristic protected by applicable federal, state or local laws and ordinances.
Salary : $0 - $150
