Mid-Continent Group
, a subsidiary of Great American, based in Tulsa, Oklahoma, specializes in commercial casualty coverages with an emphasis on general liability for the construction, energy, and difficult-to-place business in other industries. Mid-Continent Group provides a broad selection of General Liability, Commercial Auto, Inland Marine and Umbrella products.
Be Here. Be Great. Working for a leader in the insurance industry means opportunity for you. Great American Insurance Group, a Fortune 500 company, combines “small company” culture with “big company” expertise. Here, your ideas will be heard, and you’ll have the support to succeed. With over 35 specialty and property and casualty operations, there are always opportunities to learn and grow.
At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best.
Mid-Continent Group is looking for a Senior Data Engineer to join our Information Technology team. The successful candidate will perform solution development and delivery working both independently and as part of a team. This position will develop ETL’s, Reports, and data pull requests using tools like Informatica, Tableau, SQL Server, and Snowflake environments. This individual will work a hybrid schedule from our downtown Tulsa office.
Essential Job Functions and Responsibilities:
Analyze business requirements and legacy reports to drive new development utilizing 3rd party development tools, SSIS, and SQL Server.
Interface and communicate with business customers and team leads for scope, estimates, requirements, and project deliverables.
Interface with the various information technology groups, as needed, for source-to-target mappings and reporting interfaces.
Work with DBA's, as needed, to manage schema changes.
Create and maintain production support documentation.
Use project management and systems development life cycle methodologies to achieve on time results.
Participate in an on-call rotation to provide system support outside of normal working hours.
Job Requirements:
Candidate must have a bachelor’s degree in an IT related discipline or equivalent experience.
Generally, 6+ years of experience in complete data warehouse lifecycle development process.
Experience with data migration initiatives and data warehouse concepts (cubes, star schemas, etc.), experience with front-end web technologies (HTML, CSS, JavaScript), SQL Server, SSIS, SSRS, Informatica, Tableau, Power BI, Cognos, and other cloud technologies.
Solid analytical skills and ability to examine requirements, re-engineer existing processes, envision new concepts and deliver complete reporting solutions.
Hands-on experience with a modern reporting tool such as Tableau or Power BI working with a backend Microsoft SQL Server (T-SQL) development and/or Snowflake or other cloud solutions.
Strong troubleshooting and problem resolution skills and ability to work with cross-functional teams.
Experience working in an Agile environment and knowledge of Azure DevOps is preferred.
Company:
MCC Mid-Continent Casualty Company
Benefits:
Compensation varies by role, position level, and location. Individual pay is influenced by skills, education, training, certifications, experience, and the role's scope and complexity, along with business needs.
We offer a competitive Total Rewards package, including medical, dental, and vision plans starting on day one, PTO, paid holidays, commuter benefits, an employee stock purchase plan, education reimbursement, paid parental leave/adoption assistance, and a 401(k) plan with company match. These benefits are available to eligible full-time and part-time employees.
Your recruiter can provide more details about our total rewards and specific compensation ranges during the hiring process.
