JOB SUMMARY:
Capio, a well-established and expanding healthcare receivables management company based out of Sherman, TX, seeks a Data Engineer. Capio has an increasing number of data integration needs which must be fulfilled by our Enterprise Systems department. As our organization continues to grow, our need to organize, integrate, share, and act upon findings revealed by our data also expands.
In this role, you will be responsible for Capio’s data engineering functions. You will create and maintain ETL, modeling, and data distribution applications. You will facilitate organization-wide data literacy and create a robust data warehouse, empowering our staff with self-service abilities within their BI and decision science toolsets.
Responsibilities
• Extract, analyze, and store data from a variety of sources across the organization in a structured, secure, and efficient manner.
• Create and maintain a new data warehouse using MS SQL server and SSIS.
• Empower our business intelligence, decision science, and other enterprise applications with business-ready datasets.
• Provide administrative technical support for our reporting servers, databases, business intelligence tools, and report delivery portals.
• Maintain permissions, security, and license assignment within our data warehouse and business intelligence environments.
• Create, monitor, and maintain ETL jobs using the JAMS enterprise job scheduler, responding to issues in a timely manner.
• Champion Capio’s data literacy culture, from training our non-technical staff on basic data warehouse utilization to publishing official data diagrams.
• Protect sensitive personal and financial data, adhering to HIPAA and PCI guidelines.
• Other technical duties, as assigned.
Qualifications
• Bachelor’s degree in business intelligence, data analytics, computer science, software engineering, or related field, or 4+ years of relevant experience required.
• 2+ years of experience with SSIS packages and complex SQL queries is required.
• Strong design and presentation skills required.
• Experience in QlikView, Qlik Sense, Tableau, Power BI, or another enterprise-level BI application is highly desired.
• Experience within the receivables management or healthcare industries a strong plus.
• Object oriented programming experience is desired. Preferred languages include C#, Java, Python, and PowerShell.
• Experience with cloud technologies such as Azure or AWS a plus.
• Fluency in written and verbal English is required.
Personal Characteristics
• Accurate and thorough; strong attention to detail.
• Self-sufficient, monitors own work to ensure quality.
• Ability to translate business needs into solutions.
• Collaborative, flexible, and responsive.
• Strong analytical, numerical, and reasoning abilities.
• Well-developed, mature interpersonal skills with diverse personalities.
• Results-oriented.
• Lifetime learner with an eager and open mind, an ever-expanding skillset, and a desire to share knowledge with others.